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 hourRequired:Prepare a flexible budget for 70,000, 80,000, and 90,000 filing cabinets for the month ending February 28 in the Assembly Department.

Total department cost of 70,000 units = $856,500

Total department cost of 80,000 units = $940,000

Total department cost of 90,000 units = $1,024,500

Explanation:

Note: See the attached excel file for the flexible budget.

A flexible budget is a budget that changes, flexes or adjusts as the volume, activity or unit of production changes.

For this question, the direct labor cost for each unit can be calculated as follows:

Direct labor time per filing cabinet in minutes = 18

Number of minutes in one hour = 60

Direct labor rate per minute = Direct labor rate per hour / Number minutes in one hour = $28 / 60 = $0.466666666666667

Direct labor cost per filing cabinet = Direct labor time per filing cabinet in minutes * Direct labor rate per minute = 18 * $0.466666666666667 = $8.40

Direct labor cost of a particular units of production = Direct labor cost per filing cabinet * Number of units of production (1)

Using equation (1), the Direct labor cost of different units of production used in the attached excel file is calculated as follows:

Direct labor cost of 70,000 units = $8.40 * 70,000 = $588,000

Direct labor cost of 80,000 units = $8.40 * 80,000 = $672,000

Direct labor cost of 90,000 units = $8.40 * 90,000 = $756,000