AutoSave on File Home Insert Draw Chapter 22 Excel Template rev221 (2) Search (Alt-Q) Page Layout Formulas Data Review View Help X Cut Copy Calibri Format Painter Clipboard 1 Fort 121 11AA Wrap Text General BIU-Merge & Center $ % 898 Conditional Format as Formatting Table Styles Cell Alignment Number Styles Insert Delete Format: Ces B H 1 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. Prepare a sales budget. 2 3 4 Budget #1: Sales Budget 2018 Jan Feb Mar Q1 Total April May 5 Budgeted units to be sold 6 Sales price per unit 7 Total Sales B 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 minus sign-in row 18.) Hint: Beginning inventory for the period is equal to the ending inventory of the previous period 11 12 13 14 Budget #2: Production Budget 15 Budgeted units to be sold 16 Plus: Desired units in ending inventory 17 Total units needed 2017 2018 Dec Jan Feb Mar Q1 Total April May 18 Less: Units in beginning inventory 19 Budgeted units to be produced i 20 14 Mail 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 material in Raw 21 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-without a minus s 23 24 25 Budget #3: Direct Materials Budget 26 Budgeted units to be produced 27 Direct materials (pounds) per unit 28 Direct materials needed for production Instructions ENTERANSWERS Hesty ty Good to ge Type here to search o Jan Feb 2018 Mar Q1 Total April a RE Set 2 77 hp