Thunder Creek Company prepares its Manufacturing Overhead Budget. For each direct labor hour, the variable overhead costs are Indirect Materials $1.00 per DLH Indirect Labor Cost $1.30 per DLH, Maintenance $1.20 per DLH The Fixed Overhead Costs per month are Salaries of $40,000, Depreciation $20,000 and Maintenance-$10,000. Prepare a Manufacturing Overhead Budget. (When entering answers in the manufacturing overhead budget, use the direct labor budget for your cell references.) Use-ROUND function to round the predetermined overhead allocation rate to two decimal places. Manufacturing overhead is allocated using direct labor hours Budget #5: Manufacturing Overhead Budget Budgeted units to be produced 2018 Jan Feb Mar Q1 Total VOH cost per unit Budgeted VDH Budgeted FOH Depreciation Salaries and maintenance Total budgeted FOH Budgeted manufacturing overhead costs Direct labor hours (DLH) Predetermined overhead allocation rate per DLH Thunder Creek Company uses the first in, first-out (FIFO) inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units Begin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Labor, and Manufacturing Overhead budgets.) Use ROUND function to round the fixed manufacturing overhead cost per unit to two decimal places Prepare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget.) Direct material cost per unit Direct labor cost per unit Manufacturing overhead cost per unit Total projected manufacturing cost per unit Cost per unit 2018 Budget : Cost of Goods Sold Budget Jan Feb Mar Q1 Total Beginning Finished Goods Inventory, 3,600 units Units produced and sold in 2018 Cost per unit Units per month Total cost of units produced and sold in 2018 Total budgeted cost of goods sold Thunder Creek Company's variable supplies expense per month is $3.00 per unit. The fixed seling and administrative expenses per month consist of Salaries: $245,000; Advertising $30,000; and Depreciation: $28,000 Prepam a Seling and Administrative Expense Budget. (When entering answers in the seting and administrative budget, use the sales budget for your cell references.) Budget 87: Selling and Administrative Expense Budget Salaries expense Advertising expense Depreciation expense Supplies expense Total budgeted S&A expense Jan 2018 Feb Mar Q1 Total