I need to calculate the variable costs, DLH, Fixed costs and the manufacturing overhead rate per direct labor hour for each quarter and year-end. I've done some calculation but I believe I am missing something in the variable costs calculations with the indirect materials, indirect labor hours and maintenance. I have been multiplying the indirect costs by DLH, but some of my instructions indicate I am supposed to divide it. Not sure if I am misinterpreting or just missing a calculation altogether.

Wells Company is preparing its Master Budget for 2016 and Evan has asked you to create the Manufacturing Overhead Budget for the Sporting Goods Division. Once you have reviewed the Project resources and the below data, prepare the Manufacturing Overhead Budget for 2017, showing quarterly data. Be sure to properly express each figure in terms of units, dollars or direct labor hours (DLH).

Sporting Goods Units to be produced (by Quarter):

Q1: 70,000

Q2: 60,000

Q3: 50,000

Q4: 80,000

Direct labor: 1 hour of direct labor is required to produce one unit

Variable overhead costs per direct labor hour:

Indirect materials	$0.80
Indirect labor	$1.20
Maintenance	$0.50

Fixed overhead costs per Quarter:

Supervisory salaries	$42,000
Depreciation	$16,000
Maintenance	$12,000