Marvelous Motors is a small motor supply outlet that sells motors to companies that make various small motorized appliances. The fixed operating costs of the company are $300,000 per year
The controlling shareholder, interested in product profitability and pricing, wants all costs allocated to the motors and wants to review the company status on a quarterly basis. The shareholder is trying to determine whether the costs should be allocated each quarter based on the 25% of the annual fixed operating costs ($75,000) or by using an annual forecast budget to allocate the costs. The following information is provided for the operations of the company:
Forecast Actual
Sales for First Quarter 5,000 4,850
Sales for Second Quarter 8,000 7,900
Sales for Third Quarter 8,000 8,125
Sales for Fourth Quarter 3,000 3,125
Required:
a. What amount of fixed operating costs are assigned to each motor by quarter when actual sales are used as the allocation base and $75,000 is allocated?
b. How much fixed cost is recovered each quarter under requirement a.?
c. What amount of fixed operating costs are assigned to each motor by quarter when forecast sales are used as the allocation base and the rate is calculated annually as part of the budgetary process?
d. How much fixed cost is recovered each quarter under requirement c.?
e. Which method seems more appropriate in this case? Explain.
Answer:
a. Rate per unit using Actual Sales by Quarter:
Q1 $75,000 / 4,850 = $15.46 per motor
Q2 $75,000 / 7,900 = $ 9.49 per motor
Q3 $75,000 / 8,125 = $ 9.23 per motor
Q4 $75,000 / 3,125 = $24.00 per motor
b. $75,000 cost is recovered each quarter => $300,000 cost recovered over the year.
c. Quarterly Cost Recovery using Annual Forecast of Sales:
Forecast Sales for the year = 5,000 + 8,000 + 8,000 + 3,000= 24,000
Rate per motor = $300,000 / 24,000 = $12.50 per motor
d. Quarterly Cost Recovery using Annual Forecast of Sales as the allocation basis:
Q1 4,850 × $12.50 = $ 60,625
Q2 7,900 × $12.50 = $ 98,750
Q3 8,125 × $12.50 = $101,563
Q4 3,125 × $12.50 = $ 39,062 => $300,000 cost recovered over the year
e. The budgeted rate based on an annualized forecast of sales is more appropriate to use. The fluctuation in sales was predictable and using actual quantities per quarter to calculate the cost recovery rates would distort the objective of assigning appropriate costs to the units. There would be uncertainty in interpretation of why one quarter has a very high rate per unit and another quarter has a very low rate per unit if the actual quarters fixed costs were spread to the actual units sold each quarter.