if you know how to use excel can you state the cell reference.

Autosova Garza Miller-Noblen Be-12e-Using Excel Ch22 Start Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body 11 A A General ch Paste Wrap Tout Marge Center a.Ar $ % Conditions Forma Formatting as tablete Once Update To keep up-to-date with security updates, foces, and improvements, choose Check for Updates Xfx M8 c D 1 Thunder Creek Company expect sales of 18,000 units in auary 2018, 24,000 units in February, 20,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit 2 Prepare a sales budget 2 2018 4 Budget 21 Sales Budget lan Feb Mar 91 Toe April 5. Budgeted units to be sold May 6 Sales priceperunt 7 Total Sales 9 Thunder Creek wants to finish each month with 20% of not month's sales in units 19 Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references Enteral values positive without a minussiin row 18) 11 Hint: Meginning inventory for the period is equal to the ending inventory of the previous period 13 2017 2011 14 Budget 2 Production Budget Dec Feb Mar Q1 Total April t5 Budgeted units to be sold May 16 Plus Desired unitsin ending inventory 17 Total units needed 18 Les Units in beginning inventory 19 Budgeted units to be produced 20 Thunder Creek Company uses 2 pounds of direct materials for exch unit it produces at a cost of 54.00 per pound. The company begins the year with 3.500 pounds of material in Raw Material 21 Inventory Management des endingintary of 25% of next month materials requirements 2 Prepare a Direct Materials Budget (When entering answers in the direct materialsbudpetuse the production budget for your cell references. Enter all values us positive without a min-now) 2018 Mar lan Feb Q1 Total April 24 2 Budget 3: Direct Materials Buget 74 Buted units to be produced 27 Direct material pounda perunit 18 Direct materials anded for production 2 Plus Desired direct materials in ending inventory pounds) 10 Total materials anded 11 Les Direct materials in being inventory pound Bodited purchase of direct materials 11 Direct mata per pound 1 Dvdprte cost of direct materials purchases