Budget Project

Flexible budget for assembly departmer

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:

$\backslash$table$[[$Direct labor per filing cabinet,$30$ minutes$],[$Supervisor salaries,$$135,000$ per month$],[$Depreciation$,$$$19,000$ per month$],[$Direct labor rate,$$15$ per hour$]]$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

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

Cabinaire Inc.

Assembly Department Budget

For the Month Ending February $28($assumed data$)$

$\backslash$table$[[$Units of production,$9,000,11,000,14,000]]$

Variable cost:

Direct labor grad

Total variable cost

Fixed cost:

Depreciation $$

Total fixed cost

Total department costs