In: Accounting
1.
High-Low Method for a Service Company
Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved.
| Transportation Costs | Gross-Ton Miles | |||
| January | $854,100 | 325,000 | ||
| February | 952,200 | 363,000 | ||
| March | 673,000 | 235,000 | ||
| April | 913,000 | 351,000 | ||
| May | 765,700 | 283,000 | ||
| June | 981,700 | 382,000 | ||
Determine the variable cost per gross-ton mile and the fixed cost.
| Variable cost (Round to two decimal places.) | $ per gross-ton mile |
| Total fixed cost | $ |
2.
Contribution Margin and Contribution Margin Ratio
For a recent year, Wicker Company-owned restaurants had the following sales and expenses (in millions):
| Sales | $26,100 |
| Food and packaging | $9,106 |
| Payroll | 6,600 |
| Occupancy (rent, depreciation, etc.) | 5,814 |
| General, selling, and administrative expenses | 3,800 |
| $25,320 | |
| Income from operations | $780 |
Assume that the variable costs consist of food and packaging, payroll, and 40% of the general, selling, and administrative expenses.
a. What is Wicker Company's contribution
margin? Round to the nearest million. (Give answer in millions of
dollars.)
$ million
b. What is Wicker Company's contribution margin
ratio? Round to one decimal place.
%
c. How much would income from operations
increase if same-store sales increased by $1,600 million for the
coming year, with no change in the contribution margin ratio or
fixed costs? Round your answer to the closest million.
$ million
3.
Sales Mix and Break-Even Sales
Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs are $522,000, and the sales mix is 30% bats and 70% gloves. The unit selling price and the unit variable cost for each product are as follows:
| Products | Unit Selling Price | Unit Variable Cost | ||
| Bats | $60 | $50 | ||
| Gloves | 150 | 90 | ||
a. Compute the break-even sales (units) for
both products combined.
units
b. How many units of each product, baseball bats and baseball gloves, would be sold at break-even point?
| Baseball bats | units |
| Baseball gloves | units |
| 1 | ||
| Transportation Costs | Gross-Ton Miles | |
| High level | 981700 | 382000 |
| Low level | 673000 | 235000 |
| Change | 308700 | 147000 |
| Variable cost | 2.10 | =308700/147000 |
| Total fixed cost | 179500 | =981700-(382000*2.10) |
| 2 | ||
| a | ||
| Sales | 26100 | |
| Less: Variable costs | ||
| Food and packaging | 9106 | |
| Payroll | 6600 | |
| General, selling, and administrative expenses | 1520 | =3800*40% |
| Total Variable costs | 17226 | |
| Contribution margin | 8874 | million |
| b | ||
| Contribution margin | 8874 | |
| Divide by sales | 26100 | |
| Contribution margin ratio | 34.0% | |
| c | ||
| Income from operations increase | 544 million | =1600*34% |
| 3 | ||
| a | ||
| Fixed costs | 522000 | |
| /Weighted average unit contribution margin | 45 | =(60-50)*30%+(150-90)*70% |
| Break-even sales (units) | 11600 | |
| b | ||
| Baseball bats | 3480 | =11600*30% |
| Baseball gloves | 8120 | =11600*70% |