Question

Factory Overhead Cost Budget

Sweet Tooth Candy Company budgeted the following costs for anticipated production for August:

Advertising expenses	$282,920
Manufacturing supplies	15,510
Power and light	46,250
Sales commissions	312,690
Factory insurance	26,930
Production supervisor wages	136,020
Production control wages	35,370
Executive officer salaries	288,360
Materials management wages	38,890
Factory depreciation	22,040

Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory insurance and depreciation are the only fixed factory costs.

Sweet Tooth Candy Company
Factory Overhead Cost Budget
For the Month Ending August 31
Variable factory overhead costs:
	$
Total variable factory overhead costs		$
Fixed factory overhead costs:
	$
Total fixed factory overhead costs
Total factory overhead costs		$

Answer 1

Prepare the factory overhead costs budget for the calculation of total factory overhead costs result get from the below table is:

Hence, the total factory overhead costs is $321,010.

Working note:

To prepare the factory overhead cost budget by using excel formula is: