Flexible overhead budget

Wiki Wiki Company has determined that the variable overhead rate is $4.00 per direct labor hour in the Fabrication Department. The normal production capacity for the Fabrication Department is 16,000 hours for the month. Fixed costs are budgeted at $102,400 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

1. Prepare a monthly factory overhead flexible budget for 14,000, 16,000, and 18,000 hours of production.

   Wiki Wiki Company
   Monthly Factory Overhead Cost Budget - Fabrication Department
   Direct labor hours		14,000		16,000		18,000
   Variable factory overhead cost		$fill in the blank 2		$fill in the blank 3		$fill in the blank 4
   Fixed factory overhead cost		fill in the blank 5		fill in the blank 6		fill in the blank 7
   Total factory overhead cost		$fill in the blank 8		$fill in the blank 9		$fill in the blank 10

2. How much overhead would be applied to production if 14,000 hours were used in the department during the month? Round your answer to the nearest dollar.

   $fill in the blank 11