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 12 minutes Supervisor salaries $150,000 per month Depreciation $24,500 per month Direct labor rate $22 per hour Prepare a flexible budget for 18,000, 20,000, and 22,000 filing cabinets for the month of August in the Assembly Department, similar to Exhibit 5. Steelcase Inc.-Assembly Department Flexible Production Budget For the Month Ending August 31 (assumed data) Units of production 18,000 20,000 22.000 Variable cost: Direct labor 88,000 X 96,800 X 579,200 X Fixed cost: Supervisor salaries Depreciation Total fixed cost Previous Direct labor rate $22 per hour Prepare a flexible budget for 18,000, 20,000, and 22,000 filing cabinets for the month of August in 5. Steelcase Inc. --Assembly Department Flexible Production Budget For the Month Ending August 31 (assumed data) Units of production 18,000 20,000 22,000 Variable cost: Direct labor 88,000 X $ 96,800 X $ 79,200 X Fixed cost: Supervisor salaries Depreciation Total fixed cost Total department cost Feedback Check My Work For each level of cabinet production, show all variable costs and all fixed costs