please use the information that has been given down below because there are similar questions with different information.

(can you also show the formulas)

can you please do requirements

1-2?

1.prepare a sales budget

2.Prepare a production budget

the question is above requirement 1 it gives you the information

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

H MASTER UDGETS M 0 2 Using Excel to prepare an operating budget manilacturing company] 1 4 Thunder Creek Company is preparing budgets for the first quarter of 2018. All relevant information is presented on the remplate 5 Use the blue shadedress on the ENTER ANSWERS tab for input 6 Always use cell references and formulas where appropriate to receive all you copy/paste from the time tab you will be made wenn 7 8 Requirements TO 1. Prepare a Sales Budget 11 2. Prepare a Production fudget 12 1. Prepare a Direct Materials Budget 13 4. Prepare a Direct Labor Budget 14 5. Prepare a Manufacturing Overhead Budget 15 6. Prepare a cost of Goods Sold Budget 7. Prepare a Selling and Administrative pense Budget 17 10 19 Excel Skills 20 1. Create formulas with cell references Use the HOUND function D c Thunder Creek Company expects sales of 19,000 units in January 2018, 25,000 units in February 31,000 units in March, 25.000 in April, and 37,000 in May. The salespea pe 2 Prepare a sales budget 2 2018 4 Budgetin: Sales Budget lan Feb Mar a Total 5 Budgeted units to be sold April May 8 Sales price per unit 7 Total Sales 9 Thunder Creek wants to finish each month with 20% of next month's sales in units. 10 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 a munus in row 11 11 Hint: Beginning inventory for the period is equal to the ending inventory of the previous period. 12 13 2017 2018 14 Budget 2: Production Budget Dec lan Feb Mar 01 Total April May 15 Budgeted units to be sold 16 Plus: Desired units in ending inventory 17 Total units needed 10 Less: Units in beginning inventory 19 Budgeted units to be produced 20 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 21 material in Raw Materials inventory Management desires an ending inventory of 25% of next month'i materials requirements 22 Prepare a Direct Materials Budget. When entering answers in the direct materials budget, use the production budget for your cell references. Enter all values as positive Without a mis CH2 Master B5 2002 AutoSave w Chapter 22Escal Template 21 - Protected PO File Home insert Page Layout Formulas Dita wew View Help O PROTECTED VIEW Beclean the consentonced UPDATES AVAILABLE Updates for Office A3 fo A 8 C G H 0 17 Total units needed 18 Less: Units in beginning inventory 19 Budgeted units to be produced 20 Thunder Creek Company uses 3 pounds of direct materials for each unit it produces at a cost of $5.00 per pound. The company begin the year with 20.500 pounds of 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. Enter all values as positive out amous 23 24 2018 25 Budget 3: Direct Materials Budget lan Feb Mar 26 Budgeted units to be produced 01 Total April 27 Direct materials (pounds) per unit 28 Direct materials needed for production 29 Plus: Desired direct materials in ending inventory (pounds 30 Total direct materials needed 31 Less: Direct materials in beginning inventory (pounds) 32 Budgeted purchase of direct materials 33 Direct material cost per pound 34 Budgeted cost of direct materials purchases 35 36 Thunder Creek Company's workers require Bo minutes of labor to produce each unit of product. The labor cost is 522 per hour 37 Prepare a Direct Labor Budget. (When entering answers in the direct labor budet use the direct materiais des for your cell references) 2013 30 an Feb Mar 39 Budget 34: Direct Labor Budget D struction ENTERANSWERS 91 Total 70F Sunny A6 UMUR Type here to search have Chapter 22 Template 321 Protected View File Home sert Page Layout Formas Duta View O PROTECTED VIEW lectromecas.Den ettete O UPDATES ANILABLE VOPSEA dy to be interentre de H C1 - fo 3 D MASTER UDGETS G 1 M N 2. Using Excel to prepare an operating budget manufacturing company Thunder Creek Company is preparing budgets for the first quarter of 2018. All relevant information presented on the Excel template 5 Use the blue shaded areas on the ENTER ANSWERS tab for inputs 6 Always use cell references and formulas where appropriate to received if you copy/paste from the time you will be marked for almost 2 8 9 Requirements 10 1. Prepare a Sales Budget 11 2. Prepare a Production Budget 12 3. Prepare a Direct Materials Budget 13 4. Prepare a Direct Labor Budget 5. Prepare a Manufacturing Overhead ludget 15 6. Prepare a cost of Goods Sold Budget 16 7. Prepare a Selling and Administrative Expense Budget 17 TB 19 Excel Skills 20 1. Create formulas with cell references 21 2. Use the ROUND function 32 23 24 Saving & Submitting Chapter Excel Assignments Instructions ENTERANSWERS 701 SABA EH Type here to search 14 2. O to CH2 Master det 2012 AutoSave Chapter 22 Excel Template 221 - Protected View File Home Insert Page Layout Formulas View Help O PROTECTED VIEW Be care the remains you need to stay in die UPDATES AVAILABLE Updates footbalist werde.com Duta Back Orade . A3 D A 1 Thunder Creek Company expects sales of 19,000 units in January 2018, 25.000 units in February 31,000 units in March 15,000 in Apel, und 37,000 in Mey. The sales prices as per un 2 Prepare a sales budget. 1 4 Budgetin: Sales Budget 2013 lan 5 Budgeted units to be sold Feb Mar 1 Total April May 6 Sales price per unit 7 Total Sales 8 9 Thunder Creek wants to finish each month with 20% of next month's sales in units 10. Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references. Enter all values as poutive without minus sign-1) 11 Hint: Beginning inventory for the period is equal to the ending inventory of the previous period. 12 13 2017 2018 14 Budget 2: Production Budget Dec lan Feb Mar 01 Total April May 15 Budgeted units to be sold 16 Plus: Desired units in ending inventory 17 Total units needed 18 Less: Units in beginning inventory 19 Budgeted units to be produced 20 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 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 inaterials budget, use the production budget for your cell references, Enteral values as positive without a minus 23 Instruction ENTERANSWERS 70F Sunny Ri 3 Type here to search CH2 Master B5 2002 AutoSave w Chapter 22Escal Template 21 - Protected PO File Home insert Page Layout Formulas Dita wew View Help O PROTECTED VIEW Beclean the consentonced UPDATES AVAILABLE Updates for Office A3 fo A 8 C G H 0 17 Total units needed 18 Less: Units in beginning inventory 19 Budgeted units to be produced 20 Thunder Creek Company uses 3 pounds of direct materials for each unit it produces at a cost of $5.00 per pound. The company begin the year with 20.500 pounds of 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. Enter all values as positive out amous 23 24 2018 25 Budget 3: Direct Materials Budget lan Feb Mar 26 Budgeted units to be produced 01 Total April 27 Direct materials (pounds) per unit 28 Direct materials needed for production 29 Plus: Desired direct materials in ending inventory (pounds 30 Total direct materials needed 31 Less: Direct materials in beginning inventory (pounds) 32 Budgeted purchase of direct materials 33 Direct material cost per pound 34 Budgeted cost of direct materials purchases 35 36 Thunder Creek Company's workers require Bo minutes of labor to produce each unit of product. The labor cost is 522 per hour 37 Prepare a Direct Labor Budget. (When entering answers in the direct labor budet use the direct materiais des for your cell references) 2013 30 an Feb Mar 39 Budget 34: Direct Labor Budget D struction ENTERANSWERS 91 Total 70F Sunny A6 UMUR Type here to search D 1 MASTER UDGETS 2 Using Excel to prepare an operating budget manufacturing company . 3 4 Thunder Creek Company is preparing budgets for the first quarter of 2011. All relevant formation is presented on the complete 5. Use the blue shaded areas on the ENTER ANSWERS tob for inputs 6 Always use cell references and formulas where appropriate to receive full and you copypaste the time you will be made 7 8 9 Requirements 10 1. Prepare a Sales Budget. 11 2. Prepare a Production Budget. 12 2. Prepare a Direct Materials Budget 13 4. Prepare a Direct Labor Budget 14 5. Prepare a Manufacturing Overhead Budget 15 6. Prepare a cost of Goods Sold Budget 16 7. Prepare a Selling and Administrative Expense Budget 17 18 19 Excel Skills 20 1. Create formulas with cell references. 21 2. Use the ROUND function, 22 23 34 Saving & Submitting Chapter Excel Assignments Instructions ENTERANSWERS