D G 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 5 Budgeted units to be sold 6 Sales price per unit 7 Total Sales 2018 Jan Feb Mar Q1 Total April May 8 9 Thunder Creek wants to finish each month with 20% of next month's sales in units 11 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. 12 13 2017 2018 Dec Jan Feb Mar Q1 Total April May 14 Budget #2: Production Budget 15 Budgeted units to be sold 16 Plus: Desired units in ending inventory 17 Total units needed 18 Less: Units in beginning inventory 10 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 material in few 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 sign-in row 31.) 23 25 Budget #3: Direct Materials Budget Jan Feb 2018 Mar Q1 Total April 26 Budgeted units to be produced 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 Instructions ENTERANSWERS Ready Accessibility Good to go