Flexible Budget for Assembly Department

Cabinaire 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	30 minutes
Supervisor salaries	$117,000 per month
Depreciation	$21,000 per month
Direct labor rate	$15 per hour

Prepare a flexible budget for 9,000, 11,000, and 14,000 filing cabinets for the month of August in the Assembly Department, similar to Exhibit 5.

Cabinaire Inc-Assembly Department
Flexible Production Budget
For the Month Ending August 31 (assumed data)
Units of production	9,000	11,000	14,000
Variable cost:
Direct labor	$fill in the blank 1	$fill in the blank 2	$fill in the blank 3
Fixed cost:
Supervisor salaries	$fill in the blank 4	$fill in the blank 5	$fill in the blank 6
Depreciation	fill in the blank 7	fill in the blank 8	fill in the blank 9
Total fixed cost	$fill in the blank 10	$fill in the blank 11	$fill in the blank 12
Total department cost	$fill in the blank 13	$fill in the blank 14	$fill in the blank 15