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 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. Which method do you think is better?

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 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. Which method do you think is better?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Can you please assist me with the steps and solution to this problem?
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts b, c, and d. Part 2 b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Part 3 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Part 4 d) Mean absolute deviation for the forecast developed…
A ski resort has recorded its recent sales as follows (in $$). Season 2 years ago Last year This year Spring 700 950 900 Summer 450 500 400 Fall 1,150 1,100 1,350 Winter 1,400 1,500 1,600 The resort estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall? Answer: _______
Cadbury started an in-depth study to forecast customer demand based on data it previously recorded. Management at the global brand started recording sales data in two forms: yearly, & quarterly. The following tables show the recorded data for the past five years: Year Actual Demand 2017 128 2018 148 2019 161 2020 149 2021 137 Quarter 2017 2018 2019 2020 2021 1 30 39 42 36 33 2 42 41 47 34 45 31 33 41 42 31 25 35 31 37 28 The forecasted demand for the 2nd Quarter of year 2022 is * 18.25 43.45 25.18 目目

14. The demand for Krispee Crunchies is experiencing a decline. The company wants to monitor demand for this product closely as it nears the end of its life cycle. The following table shows the actual sales history for January to October. Generate forecasts for November to December, using the trend projection with regression method. Looking at the accuracy of its forecasts in the Trend Projection Worksheet, as well as the other statistics provided, how confident are you in these forecasts for November to December? Month January February March April May June Sales 890,000 800,000 825,000 840,000 730,000 780,000 Month July August September October November December Sales 710,000 730,000 680,000 670,000
The following table shows the actual demand observed over the last 11 years: Year 1 Demand 8 2 9 3 5 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year Forecast 4 5 4 10 6 5 13 7 6 7 8 7 11 9 8 14 10 9 8 11 10 13 12 11 8
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 9 13 8 11 14 9 13 7 Part 2 Using exponential smoothing with α = 0.40 and a forecast for year 1 of 5.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). Year 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 5.0 5.45.4 6.46.4 5.55.5 6.96.9 9.39.3 8.88.8 9.79.7 11.411.4 10.410.4 11.511.5 9.79.7 Part 3 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers). Year 2 3 4 5 6 7 8 9 10 11 12 Forecast enter your response here enter your response here enter your response here enter your…
please solve it using excel and show the equations and pugging the numbers
Elna inc is a microwave manufacturing and distribution company based in Jakarta. The company needs to estimate production demand using the historical sales data of the last 24 months (periods).A logistics manager of the company then uses the moving average, exponential smoothing, and simple linear regression methods to determine sales forecasts for the next 12 months (Graphically illustrate the results). Provide an analysis and the results of bias, MAPE, MSE, and MAD for the forecasting decisions.Moving average is 4 month, and alfa is 0.05
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
Practice examples. Please show solution. Thank you.