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	20 minutes
Supervisor salaries	$117,000 per month
Depreciation	$29,000 per month
Direct labor rate	$18 per hour

Prepare a flexible budget for 11,000, 14,000, and 17,000 filing cabinets for the month ending February 28 in the Assembly Department similar to Exhibit 5. Round your final answers to the whole dollar, if required.

Cabinaire Inc. Assembly Department Budget For the Month Ending February 28 (assumed data)

Units of production	11,000	14,000	17,000
Variable cost:
DepreciationDirect laborSupervisor salariesRentUtilities	$- Select -	$- Select -	$- Select -
Total variable cost	$fill in the blank 5	$fill in the blank 6	$fill in the blank 7
Fixed cost:
Direct laborElectric powerRentSupervisor salariesWages	$- Select -	$- Select -	$- Select -
DepreciationDirect laborInsuranceUtilitiesWages	- Select -	- Select -	- Select -
Total fixed cost	$fill in the blank 16	$fill in the blank 17	$fill in the blank 18
Total department costs	$fill in the blank 19	$fill in the blank 20	$fill in the blank 21