Question

Flexible Budget for Assembly Department Steelcase Inc. 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 15 minutes Supervisor salaries $200,000 per month Depreciation $30,000 per month Direct labor rate $25 per hour Prepare a flexible budget for 25,000, 40,000, and 55,000 filing cabinets for the month of March in the Assembly Department, similar to Exhibit 5. Steelcase Inc. Assembly Department Budget For the Month Ending March 31 (assumed data)

Answer 1

See below

Step-by-step explanation:

Steel Case Inc.

Assembly department

Flexible budget for thee month of

Unit of production per unit

Number of filling cabinet

18,000 20,000 22,000

Variable cost

Direct labor cost 7.5

135,000 150,000 165,000

Total variable cost A

135,000 150,000 165,000

Fixed cost

Supervisor's salaries

200,000 200,000 200,000

Depreciation

30,000 30,000 30,000

Total fixed cost B

230,000 230,000 230,000

Total departmental cost A+B

365,000 380,000 395,000