1. Which of the following is indicative of the season of heaviest demand when seasonality ismeasured on a quarterly basis?a. Seasonal index = .75b. Seasonal index = 1.0c. Seasonal index = 1.25d. Seasonal index = 3.1Answer:2. The forecast calculated at the end of period t for period t+k is always the same for any valueof k if the time series has systematic variability.A) TrueB) False

The seasonal index of 1.25 indicates the season of heaviest demand because this is 125% that shows…

Answered: 1. Which of the following is indicative…

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

Help Saved Mary, Susan, and Sarah are running a beach boutique on the board walk of Ocean City. Their favorite product is a red lifeguard hoody. Mary believes it will sell 318 times next season. Susan forecasts sales of 518, and Sarah forecasts 199. What would be the result of a simple forecast combination? (Round to two decimal places)
In October a bike dealer pridicted November demand for 150 hero bikes, actual demand was 161 bikes. Now using a smoothing constant chosen by the organisation of alpha 0.21, the dealer wants to forecast decemdemand using the exponential smoothing model ?
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows Year Mileage 1 3,100 2 4,000 3 3,450 4 3,850 5 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 108.3 miles (round your response to one decimal place). (Hint. You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = miles (round your response to the nearest whole number)
Use simple exponential smoothing with a=0.6 to forecast chargers sales for February through May. Assume that the forecast for January was 24 chargers. *** Month January Charger Sales 42 February 33 March 28 April 59 May ? a) What will be the forecast for May? b) Calculate the MSE.
Using exponential smoothing with alpha = .2, and assuming the forecast for period 11 was 80, what would the forecast for period 14 be?
In August a tractor dealer pridicted september demand for 201 tractors , actual demand was 259 tractors. Now using a smoothing constant chosen by the organisation of alpha 0.21, the dealer wants to forecast October demand using the exponential smoothing model ?
A forecasting method has produced the following over the past five months. What is the mean absolute percentage error (MAPE)? Actual 11 OA. 0.00% B. 31.87% 5178 11 13 Forecast 13 10 30668 $7
d) Using exponential smoothing with α = 0.40 and the forecast for year 1 being 3,000, the forecast for year 6 = ? miles (round your response to the nearest whole number).
In a retail store, the actual sales of a particular product (in thousands of units) over the past few months are as follows: Month Sales 1 16 2 22 3 18 4 20 5 23 Using exponential smoothing method with α (smoothing constant) of 0.75 and the given forecast for month 1 equal to 10, what is the forecast for month 6?
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?
Problem 5 You are trying to determine what forecast method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MAY JUNE MONTH JANUARY FEBRUARY MARCH APRIL DEMAND 62 65 67 68 71 73 MONTH JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER DEMAND 76 78 78 80 84 85 a. Calculate the simple three-month moving average for periods 4 to 12. b. Calculate the weighted three-month moving average for periods 4 to 12. Use weights of 0.50, 0.30, and 0.20 for the most recent, second most recent, and third most recent periods, respectively. c. Calculate the single exponential smoothing forecast for periods 2 to 12 using an initial forecast (F₁) of 61 and a of 0.30. d. Calculate the exponential smoothing with trend component forecast for periods 2 to 12 using an initial trend forecast (T₁) of 1.8, and initial exponential smoothing forecast (F₁) of 60, an a of 0.30 and ō of 0.30. e. Calculate the MAD for the forecasts made by each…
*** Can you please demonstrate how to do parts d, e, f? Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?

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

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