Allocating shared costs, and preparing performance reports for responsibility centers.
Musical Notes, Inc., manufactures and sells two different types of guitars: Blaster and Cool Blues. The two product lines share physical plant resource costs of $7,000 of which $1,000 is not traceable to either product line.
Budget and actual data for each of the two product lines are as follows:
Blaster caster Cool Blues
Budgeted number of units sold 3,000 2,000
Actual number of units sold 3,400 2,100
Budgeted average sales price per unit $400 $600
Actual average sales price per unit $390 $560
Actual standard variable cost per unit $250 $300
Budgeted traceable physical plant costs $3,000 $3,000
Actual number of repair orders 20 10
Actual hours on repair jobs 150 250
Budgeted variable cost per unit were the same as actual for the month. The company is considering two methods of allocating the physical plant resource costs: number of repair orders or number of hours on job. Both guitar line managers report to the CEO of musical notes, Inc.
1. Prepare a report allocating the traceable shared cost to each product line using the number of repair orders as the allocation base.
2. Prepare a report allocating the traceable shared cost to each product line using the number of hours on the job as the allocation base.
3. Prepare a performance report that shows the performance of the Blaster-caster Guitar division to the company as a whole, using the allocation bases prepared in requirements 2 of shared costs. Be sure to deduct the untraceable portion of the physical plant from the company total.
The solution allocates shared costs and prepares performance reports for Musical Notes, Inc
Assistance with this assignment
Performance Reports: below is a performance report that compares budgeted and actual profit in the sporting goods department of Maxwell's department store for the month of December.
Maxwell's department store
Budget Actual Difference
Sales $600, 000 $675,000 $75,000
Cost of merchandise $300,000 $375,000 $75,000
Salaries of sales staff $60,000 $68,000 $8,000
Controllable profit $240,000 $232,000 $8,000
A. Evaluate the department in terms of its increases in sales and expenses. Do you believe it would be useful to investigate either or both of the increase in expenses?
B. Consider storewide electricity cost. Would this cost be a controllable or noncontrollable cost for the manager sporting goods? Would it be useful to include a share of storewide electricity cost on the performance report for sporting goods?
Problem 1-5. Performance report: At the end of 2008. Cyril Fedako, CFO for Fedako products, received a report comparing budgeted and actual production costs for the company's plant in forest lake, Minnesota:
Forest lake plant
Budget versus actual 2008
Budget Actual Difference
Materials $3,000,000 $3,300,000 $300,000
Direct labor 2,100,000 2,300,000 200,000
Supervisory salaries 375,000 400,000 25,000
Utilities 75,000 85,000 25,000
Machine maintenance 250,000 280,000 10,000
Depreciation of building 50,000 50,000 -0-
Depreciation of equipment 200,000 205,000 5,000
Janitorial 120,000 135,000 15,000
Total $6,170,000 6,755,000 585,000
His first thought was that costs must be out of control since actual costs exceed the budget by $585,000. However, he quickly recalled that the budget was set assuming a production level of $50,000 units. The forest lake plant actually produced $55,000 units in 2008.
A. Given that production was greater than planned, should Cyril expect that all actual costs will be greater than budgeted? Which costs would you expect to increase, and which costs would you expect to remain relatively constant?
B. Cyril is extremely busy-the company has six other plants. Therefore, he cannot spend time investigation every department from the budget. With this in mind, which costs should Cyril concentrate on his investigation of budget differences?