Question: please explain part a,b,c properly step by step using excel. . Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden

please explain part a,b,c properly step by step using excel.

. Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: a. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. b. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer. Assume that last period's forecast for year 1 is 5,000 bags. c. Determine the optimal smoothing constant in part b. Year 1 2 3 4 5 6 7 8 9 10 11 Demand for Fertilizer (1,000s of Bags) 4 6 4 5 10 8 7 9 12 14 15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Find the three year moving average. Year Demand (Bags) 1 4 2 6 3 4 4 5 5...

17,18,19 CHAPTER 5. FORECASTING 5-17 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-year mov- ing average...

Answer A-E with complete work and explanations typed. 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. DEMAND FOR...

1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 4 6 1 2 3 4 5 4 5 6 18. |17:...

YEAR DEMAND FOR FERTILIZER (1000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in...

pls help! will leave a good review! thank you! 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 1 YEAR 1 2 3 00 ON-...

just e pls n ty! e) Which of the developed forecasts (3-year moving averages, weighted moving average exponential smoothing, and trend line) would you use based on each of MAD, MSE, MAPE, and bias?...

2. Time series data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Year Demand for Fertilizer (000s of bags) 1 4 2 6 3 7 4 5...

1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 2 3 4 DEMAND FOR FERTILIZER (1.000S OF BAGS) 7 6 5 7 10 9 13 15...

You are the manager and have to make the production decisions for the next six months. You do this by entering values into the blue-shaded cells. In rows 5 through 6 you indicate how many units need...

(b) Estimate the energy difference between the stable and unstable chair conformations of each of the following tetramethylcyclohexanes. Which is more stable isomer? Me Me (i) (ii) .. Me ..Me Versus...

If Jeff and Shirley leach a 4 0 percent shareholder in an S corporation ) file a revocation on February 1 0 , 2 0 2 3 , to terminate their S corporation's selection , what is the earliest effective...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...