Question: please explain this properly a,b ,c step by step Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are

please explain this properly a,b ,c step by step

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!

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....

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...

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:...

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...

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...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 1. To develop a 3-year moving average to fo forecast sales, complete the...

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?...

Refer to the information in E1913. In E Opsco Corp. provides the following information about its non-pension, post-retirement benefit plan for the year 2011: Service cost ..................$ 202,500...

Imagine two vector instructions are executing when the first (earlier) instruction causes an exception late in its execution. Describe two different ways in which precise exceptions could be...

Exercise 1 7 - 2 5 ( Algo ) Prorating Direct Materials Cost Variances ( LO 1 7 - 1 ) 1 0 points The cost analyst for Sheffer Systems collected the following data concernirig direct materials: Strow \...

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...