1.3 Ratios With More Than Two Quantities

In some business situations, it is desirable to examine the relative sizes of a number of quantities. In such cases, ratios of the quantities are used.

Consider, for example, the expenses of a merchandising company. These expenses can be usefully broken down into two major components:

When analyzing merchandising companies, it is customary to first deduct the cost of goods sold from sales revenue, and to call the result the gross profit.

[latex]Sales - COGS = Gross \; Profit[/latex]

Operating expenses are then deducted from the gross profit to get net profit.

SALES
– COGS
GROSS PROFIT
– OPERATING EXPENSES
NET PROFIT

All of these quantities are commonly compared with the sales revenue as the base.

Example 1.3.1

Suppose that in our opening example, in which the company had sales of $32,000 in a period, the cost of these goods was $20,000 and operating expenses were $4,000. You would arrange the analysis as follows:

$ % Sales
  Sales $32,000 100.00
– COGS 20,000 62.5
  Gross Profit 12,000 37.5
– Operating Expenses 4,000 12.5
  Net Profit 8,000 25.0

This has the format of a (very) simple Income Statement.

 

When gross profit is compared with sales it is called percent gross margin. Net profit compared with sales is called percent net margin.

Key Takeaways

Gross profit compared with sales is called percent gross margin; Net profit compared with sales is called percent net margin.

Suppose now that a similar company was expected to perform with the same ratios but to have sales of $50,000 in a period. Then each of the other entries could be calculated by using the above ratios. For example:

[latex]\frac{COGS}{Sales} = \frac{COGS}{\$50,000}=\frac{62.5}{100}= 0.625[/latex]

So

[latex]COGS = Sales \times 0.625 =\$ 50,000 \times 0.625 = \$ 31,250[/latex]

Notice that while the ratio was stated as a percent, it was necessary to replace it with the decimal equivalent in order to do the calculations. You should check that the other quantities come out, as in the following table:

% Sales  
Sales $50,000 100.0
COGS 31,250 62.5
Gross Profit 18,750 37.5
Operating Expenses 6,250 12.5
Net Profit 12,500 25.0

Another use of ratios is to allocate resources according to some measure of need or performance in an organization. For example, bonuses may be given as a percent of sales; budgeted expenses may be a percent of the previous year’s expenses.

Knowledge Check 1.3

A merchandising company finds that its COGS is 65% of sales and its monthly operating expenses are $14,000.

What would be the COGS and the gross and net profits on sales of $90,000 in a month?

What would be its percent gross margin and percent net margin?

Answers at the end of chapter.

Your Own Notes

  • Are there any notes you want to take from this section? Is there anything you’d like to copy and paste below?
  • These notes are for you only (they will not be stored anywhere)
  • Make sure to download them at the end to use as a reference
definition

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

Business Mathematics Copyright © 2020 by BCIT is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book