EX 22-4 Flexible budget for Fabrication Department

Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it produces filing cabinets in two departments: Fabrication and Trim Assembly. Assume the following information for the Fabrication Department:


Steel per filing cabinet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 pounds
Direct labor per filing cabinet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 minutes
Supervisor salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $180,000 per month
Depreciation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $28,000 per month
Direct labor rate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $21 per hour
Steel cost . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $0.40 per pound


Prepare a flexible budget for 12,000, 15,000, and 18,000 filing cabinets for the month of August 2014, similar to Exhibit 5, assuming that inventories are not significant.


Answer:


STEELCASE INC.—FABRICATION DEPARTMENT
Flexible Production Budget
August 2014
(assumed data)
Units of production 12,000 15,000 18,000
Variable cost:
Direct labor $ 84,000 1 $105,000 2 $126,000 3
Direct materials 264,000 4 330,000 5 396,000 6
Total variable cost $348,000 $435,000 $522,000
Fixed cost:
Supervisor salaries $180,000 $180,000 $180,000
Depreciation 28,000 28,000 28,000
Total fixed cost $208,000 $208,000 $208,000
Total department cost $556,000 $643,000 $730,000
1 12,000 × 20/60 min. × $21
2 15,000 × 20/60 min. × $21
3 18,000 × 20/60 min. × $21
4 12,000 × 55 lbs. × $0.40
5 15,000 × 55 lbs. × $0.40
6 18,000 × 55 lbs. × $0.40