After reviewing the forecasting demonstration and looking over the slides, complete the following case activity and transfer your answers to the appropriate questions in the Canvas activity quiz. You have been hired as a demand planning intern for Hawaiian Island Creations (HIC). They want you to de- velop a forecast for their HIC Papanui style of sun- glasses. The goal is to determine how many pair they will produce to meet retailer demand in July 2021. During your first meeting, you were handed some data to work with and the product team talked about the company's upcoming promotional blitz to support Summer Break '21 in major vacation destinations. Month Forecast Demand January 2021 4,000 3,300 February 2021 4.200 3,900 March 2021 4 500 4,300 April 2021 4.800 4,200 May 2021 5,000 5.400

After reviewing the forecasting demonstration and looking over the slides, complete the following case activity and transfer your answers to the appropriate questions in the Canvas activity quiz. You have been hired as a demand planning intern for Hawaiian Island Creations (HIC). They want you to de- velop a forecast for their HIC Papanui style of sun- glasses. The goal is to determine how many pair they will produce to meet retailer demand in July 2021. During your first meeting, you were handed some data to work with and the product team talked about the company's upcoming promotional blitz to support Summer Break '21 in major vacation destinations. Month Forecast Demand January 2021 4,000 3,300 February 2021 4.200 3,900 March 2021 4 500 4,300 April 2021 4.800 4,200 May 2021 5,000 5.400

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

From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why?
The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000
I need an excel sheet or how to produce any forecasting model for each product on the attached file
How can organizations use forecasting and trend analysis to inform their planning processes? What are some common pitfalls to avoid when using these techniques?
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…
What are the advantages and disadvantages of aggregating deman from a forecasting view? Are there other things that should be considered when going from multiple DC (Distribution Centers) to a DC?
How many steps are there in collaborative planning, forecasting, and replenishment (CPFR)?
The manager of travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: a. Compute MAD for the 5th period b. Compute MAPE for the 3rd period Period 1 2 3 4 5 6 7 8 9 10 Demand 19 94 56 91 85 32 26 26 95 49 Predicted 24 60 50 94 80 40 28 24 70 50
Given the following demand data, compute a simple exponential smoothing forecast for alpha values of 0.3 and 0.5. Use the actual value in Period 1 as your starting forecast in Period 2. (Round all your calculations to two decimal points.) Period Actual Demand 34 35 36 37 37 38 35 36 33 30 10 11 Answer is complete but not entirely correct. a- 0.3 a = 0.5 Period Forecast Forocast 1. 59.00 O 51.50 8 46.55 8 2 59.00 8 59.00 8 55.25 Answer is complete but not entirely correct. a = 0.3 a = 0.5 Period Forecast Forecast 1 2 59.00 59.00 X 3 51.50 X 59.00 X 4 46.55 X 55.25 X 42.78 50.90 X 40.75 8 46.84 X 39.62 43.79 X 8 38.84 X 41.71 X 38.58 40.27 X 10 37.51 X 39.43 X 11 37.06 X 38.47 X 12 35.84 37.76 8 S462 785 63
1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Week Auto Demand Weights1 9 0.12 11 0.33 8 0.64 125 106 137 78 12a Develop a 3-week moving average forecast for Weeks 4 through 9b Develop a 3-week weighted average forecast…