Question

Flexible Budget for Assembly Department Steelcase Inc. (SCS) is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 18 minutes Supervisor salaries $250,000 per month Depreciation $18,500 per month Direct labor rate $28 per hour Prepare a flexible budget for 70,000, 80,000, and 90,000 filing cabinets for the month ending February 28 in the Assembly Department, similar to Exhibit 5.

Answer 1

Results are below.

Step-by-step explanation:

Giving the following formula:

Direct labor per filing cabinet= 18/60= 0.3

Direct labor rate $28 per hour

The supervisor salary and depreciation will remain constant, we will not take them into account.

70,000 units:

Direct labor hours= (0.3*70,000)= 21,000

Direct labor cost= 21,000*28= $588,000

80,000 units:

Direct labor hours= (0.3*80,000)= 24,000

Direct labor cost= 24,000*28= $672,000

90,000 units:

Direct labor hours= (0.3*90,000)= 27,000

Direct labor cost= 27,000*28= $756,000