Prepare a Budget for Manufacturing Costs for Nacelle Manufacturing for the Month

Prepare a budget for manufacturing costs for Nacelle Manufacturing for the month of July 2013 from the following information. Direct materials are estimated to be $480,000 for the year and direct labor is estimated to be $96,000. The direct labor per hour average is $13 and the budgeted level of activity for the month is 1,200 hours. $\begin{array}{c}\begin{array}{lll}\\\\ \text {Factory Supervisor salary}\\ \text {Janitorial/Maintenance labor }\\ \text {Payroll taxes and fringe benefits}\\ \text {Insurance}\\ \text {Supplies}\\ \text {Equipment Depreciation}\\ \text {Property Taxes}\\ \text {Total} \end{array}\begin{array}{c} \text {Fixed Costs}\\ \text {per Month}\\\$ 4,500 \\ 500 \\ 1,000 \\ 300 \\ 125 \\ 2,500 \\ \underline{750} \\ \underline{ 9,675} \end{array}\begin{array}{c} \text {Variable Costs per}\\ \text {Direct Labor Hour}\\\$ 0.00 \\ 1.50 \\ 2.00 \\ 0.00 \\ 0.25 \\ 0.00 \\ \underline{0.00 }\\\underline{ 3.75 }\end{array}\end{array}$