Flexible overhead budget

Wiki Wiki Company has determined that the variable overhead rate is $2.90 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 $68,800 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

Prepare a monthly factory overhead flexible budget for 15,000, 16,000, and 17,000 hours of production.

Wiki Wiki Company
Monthly Factory Overhead Cost Budget - Fabrication Department
Direct labor hours		15,000		16,000		17,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

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

$fill in the blank 11