can you please do the (cost per unit in requirement 5, 6-7)

Thunder creek company expects sales of 19,000 units in January 2018, 25,000 units in February, 31,000 units in March, 35,000 in April, and 37,000 in May. The sales price is $65 per unit

Up Wiap lext General BTU - AAEEE Mergea Center Y $ - % 28 et Delete Format Sort board 5 Font Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first weed to close some Conditional Formatas Cell Formatting the Styles Styles Number Update now X D Thunder Creek Company expects sales of 19,000 units in January 2018, 25,000 units in February 31,000 units in March 35,000 in April, and 37,000 in May. The sales price is $45 per unit Prepare a sales budget. 2013 Budget #1: Sales Budget San Feb Man 01 Total April May Budgeted units to be sold 19,000 25.000 31,000 75,000 35,000 37.000 Sales price per unit 65 65 65 65 Total Sales $ 1.235,000 1,625,000 S 2.015.000 S 4.875,000 5 2,275,000 3,405,000 Thunder Creek wants to finish each month with 20% of next month's sales in units. Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references. Enter all values as positive-- without amous senin row 19.) Hint: Beginning inventory for the period is equal to the ending inventory of the previous period. 2017 Dec May 27,000 Budget #2: Production Budget Budgeted units to be sold Plus: Desired unitsin ending inventory Total units needed Less: Units in beginning inventory Budgeted units to be produced lan 15,000 5.000 24.000 3,800 20,200 Feb 25,000 6.200 31 200 5.000 26,200 2018 Mar Q.1 Total 31,000 25.000 2.000 7.000 38.000 82.000 6.200 3.500 31,300 2.200 April 35,000 7,400 42.400 7,000 35.400 USDCHF Thunder Creek Company uses 3 pounds of direct materials for each unit it produces at a cost of $5.00 per pound. The company begins the war with so II 2 Type here to search Chapter 22 Excel Template 221- File Home Insert Page Layout Formulas A Jedien Orenda Data Review View Help Calibri - 11 Comments B TV- 29 Weert E Merge Center - - - A 29 0 KON 1- Genel S - % Conditional Formats Cell Formatting Table Styles Number Update now Insert De forma Sora Clipboard Font 14 Anment UPDATES AVAILABLE Updates fotody to be intelistened to com - Malar Die 5 CH H63 > H A Thunder Creek Company uses 3 pounds of direct materials for each unit it produces, at a cost of $5.00 per pound. The company begins the year with 10.500 pounds of G 21 material in Raw Materials inventory Management desires an ending inventory of 25% of next month's materials requirements 22 Prepare a Direct Materials Budget. (When entering answers in the direct materials budget, use the production budget for your cell references inter all values as positiew-without a minus sp. in row It) 23 24 25 Budget #3: Direct Materials Budget 2011 lan Feb Mar 26 Budgeted units to be produced 1 Total April 27 Direct materials (pounds) per unit 20,200 26.200 11,800 78,200 35,000 3.00 3.00 3.00 100 3.00 20 Direct materials needed for production 50,500 2.600 55,400 230,000 29 Plus: Desired direct materials in ending inventory (pounds) 104,200 19,650 23,650 26,550 26.550 30 Total direct materials needed 30,250 102.450 121.950 201,150 31 Less Direct materials in beginning inventory (pounds) 10.500 19,650 23.850 32 Budgeted purchase of direct materials 69.250 2.300 100 250.650 33 Direct material cost per pound 5.00 5.00 5.00 3.00 34 Budgeted cost of direct materials purchases $ 348,750 $ 414,000 5 190.500 1.231.250 35 36 Thunder Creek Company's workers require 30 minutes of labor to produce each unit of product. The labor cost $22 per hout 37 Prepare a Direct Labor Budget. (When entering answers in the direct inbor budget use the direct material buget for your cell references 38 2018 lan Feli Mar di Total 3 Budget : Direct Labor Budget 20 200 36,200 40 Budeeted units to be produced BE USDC164 Type here to search 10.500 General 23 Wrap Test Pante b- BT- 2-9-A-Merge Center Clipboard Font 5 Alignment UPDATES AVAILABLE Updates for Officers to be installed besteedte som 122 $ - % 9 21 Inuent Drie Conditional Format Cel Formatting The Styles Styles 5 C Update now H63 X 36 Thunder Creek Company's workers require 30 minutes of labor to produce each unit of product. The labor cost is $22 per hour D E F 37 Prepare a Direct Labor Budget. (When entering answers in the direct labor budget, use the direct materials budget for your cell references 38 39 Budget #4: Direct Labor Budget 2018 lan 40 Budgeted units to be produced Feb Mar 01 Total 20,200 41 Direct labor hours per unit 36,200 31,800 78,200 0.50 0.50 42 Direct labor hours needed for production 0.50 0.50 10.100 13.100 15,500 43 Direct labor cost per hour 39.100 22 22 22 22 44 Budgeted direct labor cost $ 222,200 $ 288,200 $ 349,800 $ 860,200 45 1. Thunder Creek Company prepares its Manufacturing Overhead Budget. For each direct labor hour, the variable overhead costs are: 46 Indirect Materials - $2.00 per DLH; Indirect Labor Cost $2.30 per DLH; Maintenance $2,20 per DLH 47 2. The Fixed Overhead Costs per month are: Salaries of $50,000, Depreciation $30,000 and Maintenance $20.000 48 Prepare a Manufacturing Overhead Budget. (When entering answers in the manufacturing overhead budget, use the direct labor budget for your cell aferences 49 Use 'ROUND' function to round the predetermined overhead allocation rate to two decimal places. Manufacturing overhead allocated using tect labor hours SO 2018 51 Jan Feb Mar Q1 Total 52 Budget #5: Manufacturing Overhead Budget 10,100 13.100 15,900 53 Budgeted units to be produced 6.50 6,50 650 6.50 54 VOH cost per unit $ 65,650S 85,150 $ 103.350 254150 55 Budgeted VOH 3 Type here to search 39.100 USECHE o 11 GX terve 18 Chapter 22 acel Temere 221- file Home mert Page Layout Fus Data Re V XA Help dos de Call - 11-AA -- 15 Pole BTW- -A-Mergere Clipboard Pent 1 O UPORTES AVAILABLE O... DO $ -% Colom HO Dee H63 6.se A 52 Budget: Manufacturing Overhead Budget C D E 33 Budgeted units to be produced Man Feb Mar Total 54VOH cost per unit 10,100 13.100 15.500 33,500 55 budgeted VOH 6.50 630 350 s 65.6505 56 Budgeted FOH 15. 1505 102 105 156,150 57 Depreciation 30.000 30,000 30.000 59 90.000 Salaries and maintenance 20.000 70,000 20.000 210.000 59 Total budgeted FOH 40,000 40,000 40,000 120.000 60 Budgeted manufacturing overhead costs S 105,905 125,150 141,505 774150 61 62 Direct labor hours (DLI) 10,100 1,100 15 900 39,100 Predetermined overhead allocation rate per DHL 64 65 Thunder Creek Company uses the first in, forst-out (FFO) inventory costing method. 66 The Beginning Finished Goods inventory is $136,800 consisting of 2.00 unit. 67 Begin by calculating the projected cost to produce each unit in 2018 based on projected sales in Cost per unit table, cell references come from DealsDead More 68 Use 'ROUND function to round the fixed manufacturing overhead cost per unit to two decimal places 62 Prepare a cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget Cost per unit 70 7 Direct material cost per unit rect later 775 Sony A4 Type here to search aute Save 12 Home mert Chapter 22 Template 221 Formulas Data Review Page Layout Help A Grande w Ged Calhes -11-AA 13 Welt 8 T- -- A - Meyer Coboard Font Alge O UPDATES AVAILABLE for Obstett fast .. $ - %94 WA 29 Shy Lyd HO x 60 A 65 Thunder Creek Company uses the first intust out (onventory conting method D The Beginning Finished Goods Inventory is $136,800 consisting of units. 67 Begin by calculating the projected cost to produce each unit in 2013 based on projected sales. In "Cod per un tot carefrences come from Direct Metal Deredaran Mantra Use ROUND' function to round the fixed manufacturing overhead cost per unit to two decimal places 69 Prepare a cost of Goods Sold Budget. Mint Units per month calculated using coll references to both sales budget and production et 70 Cost per unit 71 Direct material cost per unit 72 Direct labor cost per unit 7 Manufacturing overhead cost per unit 74 Total projected manufacturing cost per unit 75 -76 2018 77 Budget a cost of Goods Sold Budget lan Feb Mar 01 Total 73 Beginning Finished Goods inventory 1.300 units. 79 Units produced and sold in 2018 00 Cost per unit Units per month 02 Total cost of units produced and sold in 2018 33 Total budgeted cost of goods sold 34 my A O Type here to search 07 words WO Chapter 22sce miere221- Fle Home Incert Page Lampu Terms Data View Help X - 11 A D- 1. Wag 15 3 ---A- Merge Center Clipboard 5 Font Aligt UPDATES AVAILABLE Updates for installed betweento H63 2 Gene 5 - % Condition 2 D A 76 77 Budget : Cost of Goods Sold Budget 2018 78 Beginning Finished Goods Inventory. 3.800 units Lan Te Mar 1 Total 79 Units produced and sold in 2018 80 Cost per unit 81 Units per month 82 Total cost of units produced and sold in 2018 83 Total budgeted cost of goods sold 84 Thunder Creek Company's variable suppies expense per month is 5400 petunt The feeling and expens permet constatas 85 $255,000. Advertising $35 000 and Depreciation $38.000 86 Prepare a Selling and Administrative Expense Budget (When entering in the selling and ministratie budget. we the sales budget for your careers 87 2018 88 Budget 7: Selling and Administrative Expense Budget Jan Feb Mar 01. Total 89 salaries expense 90 Advertising expense 9 Depreciation expense 92 Supplies expense 93 Total budgeted S&A expense 94 DS HA Type here to search O RE 735 Sunny