ib 1 Thunder Creek Company spects sales of 18,000 units in January 2018, 24,000 units in February 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 2 Prepare a budget 2018 1 Jan Feb 4 Woden: Sales Budget Mar Q1 Total April May 5 luted units to build 118.000 24.000 30,000 6 sales price per 1 Total 3 The Cruck www to finishech month with 20% of next month'salesin units 10 Prepara production budget. (When entering anwers in the production budget the sales budget for your cell references. Enter all values as positive without a minus sign-in row 18.) 11 Him: Being riventory for the period is equal to the ending inventory of the previous period, 11 2012 2011 14 Wupti Product Dec an Feb Mar Q1 Total 15 Butun to be wild April 16 Plus Dered units ending wertory 11 Tutkinto 1. Unibenin vetor 19 full produced May Thunder Cremant 2 pound ofte for produce cost of 54.00 per unit. The company begins the year with 9.500 pounds of material in Raw Materials 31 Modenandinginary for montanuments 22 Direct Mardwerin the direct but the production bufet for your cellence inter all values at positive without a minus in row 31 lun 2018 Mar Teb Qi Total April 14 s pred 20 od 11 cm 1 Directorio 29 December dietary Cound uuta 3 bingwa 52 des 1 pound Bu geconto director Thunder 10 short product of the labor costs $30 hour Preparator the recorrecto your Direct List San M Q1 K16 x x 0 Increaccompany wore Corto product or product. The porco per nou 12 Prepare a Direct Labor Budget (When entering aner in the direct labor budet Use the direct materiala budent for your cell references 2018 19 Budget: Direct Laber ludgut Feb Mar Bergued units to be produced 31 Direct labor hours per unit Direct labor hours neded for production 11 Direct labor cost per hour 3. Routed direct labor cost 01 Total Thunder Creek Company prepares its Manufacturing Overhead budget. For each direct labor hour, the variable overhead costs are Indirect Material -51.00 per DLH Indirect laber Cast51.30 per DLH: Maintenance $1.20 per LH The Fixed Overhead Coats per month Salaries of $40,000, Depreciation 520,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) U VROUND' Lunction to round the predetermined overhead allocation rate to two decimal places Manufacturing overhead is located using direct labor hours 2018 Jan Feb Mar QI Total 1 BudgetManufacturing Overhead Budget Bured it to be product VOH Coperit Budete VOH budgeted FOH Depreciation Salaries and maintenance Total budgeted FOH Buded manufacturing overhed costs Director how (LH Predetermined overhead allocation rate per LRT Thunder Creek Company then, first-out Firoj inventory costing method. The Beginning Finished Goods invertory is $85.400 consisting of 3,600 units le by calculating the projected cost to produce each unitin 2015 based on projected sales. (Hint: In "Cost per unit table cell references come from Direct Materials, Direct Labor, and Manufacturing Overhead bude WOUND/function to round the feed manufacturing overhead cost per unit to two decimal places Prepare a cost of Goods Sold det inte ta per month calculated using all references to both sales budget and production budget Cost per unit Direct material cost per unit Direct labor cost per Manufacturing overhead cost per unit Total projected manufacturing content Instructions ENTERANSWERS 2018 + D 65 Thunder Creek Chromethed The Beginning bed on 8.400.00 er by calculating the cost 2018 bort och U VROUND on the finger to two deca 9 Press Goods Mahing that was bun red 10 Coupe 71 Direct matco 73 Director content 73 Manufacturing overhead.com 74 Total printed manufacturing copernit 2018 an Feb M 76 7) Budget: Cast of Good Sold Budget 78 Beginning Finished Goodsitory1.600 units. 79 Units produced and sold in 2018 10 Con per unit 81 Units per month 2 Total cost of units produced and sold in 2018 Total budgeted cost of goods sold BO Thunder Creek Company's variable supplies expense per month is $3.00 per unit. The feeling and adverses per month consist of Sale $245.000 8 Advertising: $30,000, and Depreciation: $28.000 16 Prepare a Selling and Administrative Expense Budget. (When entering answers in the sting and administrative budget, use the sales budget for your cellence 87 2013 88 Budget: Selling and Administrative Expense Budget Feb Mar 01 Total 19 Salaries expense 90 Advertising expense 91 Depreciation expertise 92 Supplies expense 3 Total budgeted 5&A expense 5