Question

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 Assembly. Assume the following information for the Assembly Department:Steel per filing cabinet ............................................. 55 poundsDirect labor per filing cabinet ...................................... 20 minutesSupervisor salaries ................................................ $180,000 per monthDepreciation ...................................................... $28,000 per monthDirect labor rate................................................... $21 per hourSteel cost ......................................................... $0.40 per poundRequired:Prepare a flexible budget for 12,000, 15,000, and 18,000 filing cabinets for the month of August 2014.

Answer 1

Total Flexible Budgets for 12,000, 15,000, and 18,000 units is $ 556,000 $ 643,000 and $830,000

Step-by-step explanation:

Steelcase Inc.

Assembly 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

Steelcase Inc.

Flexible budget

For the month of August 2014.

Units: 12000 15000 18000

Steel for filing cabinet 660,000 825000 990,000 pounds

Steel cost $264,000 330,000 $ 396,000

Direct labor Hrs 4,000 5,000 6,000

Direct labor Cost $84,000 $105,000 $ 126,000

Supervisor salaries $180,000 $180,000 $180,000

Depreciation $28,000 $28,000 $28,000

Total $ 556,000 $ 643,000 $830,000

First we find the Steel for filing cabinets in pounds . Then we multiply with the rate to find the steel cost.

Similarly we find the direct labor hours and then the direct labor cost.

We assume that the supervisor salaries and depreciation are fixed.