Question 2:The SCO3001 Company sells a new meal kit with the following demand data:13PeriodDemand2280300310The company tries to forecast the demand with the exponential smoothing method with F₁ = 290 and a = 0.1.Calculate the MAPE for the 3 periods.

Exponential smoothing formula: Next forecast = Previous forecast + alpha (Actual - Previous…

Answered: Question 2: The SCO3001 Company sells a…

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

I just need the last one please (:
Please do not give solution in image format thanku supose that the demand in period 1 was 7 units and the demand in period 2 was 9units . Assume that the forecast for period 1 was for 5 units .If the firm uses exponential smoothing with an alpha value of .20. what should be the forecast for period 3
Jane is trying to forecast demand for her store, using moving average with n=2,Fill in the missing cells with correct values and find average error for first quarter and second quarter of year 2000
Month Demand Forecast Error Abs Error alpha 1 20 2 18 3 21 4 25 5 24 6 27 7 22 8 30 9 23 10 20 11 29 12 22 Mean Bias MAD (mean error) Problem 6: Maverick Jeans' demand manager decided to evaluate exponential smoothing. To maintain com- parability, she used the data from problem 6, copied below. 1 Month 2 3 Demand 20 18 21 25 4 5 24 6 7 8 9 10 11 12 27 22 30 23 20 29 22 Develop forecasts for months 5-12. Calculate the Bias and MAD. Use a starting forecast of 20 for month 4 and an alpha value of 0.2. (Note: Adjust all cell values to two decimal points.)
Sunrise is planning its purchases of ingredients for bread production. If bread demand had been forecast for last week at 22k loaves & only 21k loaves were actually demanded, what would Sunrise’s forecast be for this week using exponential smoothing with α = 0.10?
1. Which of the following is indicative of the season of heaviest demand when seasonality is measured on a quarterly basis? a. Seasonal index = .75 b. Seasonal index = 1.0 c. Seasonal index = 1.25 d. Seasonal index = 3.1 Answer: 2. The forecast calculated at the end of period t for period t+k is always the same for any value of k if the time series has systematic variability. A) True B) False
- Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: 6 10 Week 1 Demand 20 2 3 23 27 4 5 37 26 7 8 9 30 35 22 24 29 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week 1 Demand 20 Forecast 20.0 2 3 23 27 4 37 5 26 6 30 7 35 8 22 9 24 10 29
The following data show the number of liters of gasoline sold by Mackrin's in Colorado for the past 12 weeks. Which forecasting model would you recommend to Mackrin's manager? Why? What demand forecast would you recommend for week 13? Week Actual Demand (1000 liters) Forecasting (1000 liters) FSMA /A-F/ FWMA /A-F/ FES, α=0.3 /A-F/ 1 17 2 21 17 4 3 19 18.2 0.8 4 23 19 4 18.44 4.56 5 18 21 3 20.8 2.8 19.81 1.81 6 16 20 4 20 4 19.3 3.3 7 20 19 1 18.3 2.3 18.31 1.69 8 18 18 0 18.7 0.7 18.82 0.82 9 22 18 4 18.2 4.2 18.6 3.4 10 20 20 0 19.8 0.2 19.62 0.38 11 15 20 5 20.2 5.2 19.73 4.73 12 22 19 3 18.2 3.8 18.3 3.7 13 19 19.5 19.41 MAD 2.67 2.9 2.7 MSE 10.22…
2
Question 1 ) The monthiy sales Of yamizí Battery company are asfollows:- Month Jales 2000 2100 1500 1400 1300 Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1M 3 Month Simple moving averoger Ti) Exponentral smoothing using an a =0:3 cand may forecast of 1600 units.
using minitab
Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Question 2: The SCO3001 Company sells a new meal kit with the following demand data: 2 3 280 310 The company tries to forecast the demand with the exponential smoothing method with F₁ = 290 and a = 0.1. Calculate the MAPE for the 3 periods. Period Demand 1 300