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

Answer:

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

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.