Flexible overhead budget

Wiki Wiki Company has determined that the variable overhead rate is $$3\mathrm{.}20$ per direct labor hour in the Fabrication Department. The normal production capacity for the Fabrication Department is $11,000$ hours for the month. Fixed costs are budgeted at $$49,500$ for the month.

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

Open spreadsheet

a$.$ Prepare a monthly factory overhead flexible budget for $10,000,11,000,$ and $12,000$ hours of production.

Wiki Wiki Company

Monthly Factory Overhead Cost Budget $-$ Fabrication Department

$\backslash$table$[[$Direct labor hours,$$,11,000,12,000],[$Variable factory overhead cost,,$$,],[$Fixed factory overhead cost,$$,$$$,$$