su sure y Prepare a Manufacturing Overhead Budget (33 pts) 1. 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 2. The Fixed Overhead Costs per month are: Salaries of $40,000, Depreciation -$20,000 and Maintenance $10,000. 3. ROUND the predetermined overhead allocation rate to two decimal places. Manufacturing overhead is allocated using direct labor hours. (Always use cell references and formulas where 44 Budged direct labor cost 45 50 51 Thunder Creek Company prepares its Manufacturing Overhead Bulget. For each direct laber hout, the variable overhead costs are indirect Materials $1.00 per DH, indirect cabor Cost $1.30 per DU Maintenance $1.20 per CH 33 Budget: Manufacturing Overhead Budget 53 Budgeted units to be produced 4 47 The Fixed Overhead Costs per month are: Salaries of $40,000 Depreciation $20.000 and Maintenance $10,000 48 Prepare a Manufacturing Overhead Budget. (When entering answers in the manufacturing overhead budget, use the direct labor budget for your call references) 49UROUND function to round the predetermined overhead allocation rate to two decimal places Manufacturing overhead is allocated using direct labor hour 54VOH cont per unit 55 Budgeted VON 56 Budgeted FO 57 58 Depreciation Salanes and maintenance 59 Total budget FO 60 Budgmed manufacturing overhead costs 192,000 $ 62 Director hours (DL) 61 Predetermined overhead allocation rate per D 64 65 Thunder Creek Company uses the first-in, first out (FFO) inventory costing method 16 The Beginning Finished Goods inventory is $86,400 consisting of 3,600 units 252,000 Jan 19.200 Feb 2018 30,000 $ 752.000 11.200 Mar 30,800 Tal 75.300 egin by calculating the projected cost to produce each unit in 2018 Based on projected sales in "Cost per une table, celi references come from Direct Maria D 68 Use ROUND function to round the fixed manufacturing overhead cont per unit to two decimal places Prepare a Cost of Goods Soid Budget, pint: Units per month calculated using cell references to both sales budget and productan budget) Cost per unit