eBookProblem 6-05Consider the following time series data.316Week 1Week2Value 18 13a. Choose the correct time series plot(1)€(!!!)Time Series ValueTime Series Value28642986420284H2G8642014112{B}2TH3Week (t)Week (t)56€(iv)Time Series ValueTime Series Value28642 NO28642 NO12243₁Week (t)Week (t)56 d. Compare the three-week moving average forecast with the exponential smoothing forecast using a 0.2. Which appears to provide the better forecast based on MSE?Explain.The input in the box below will not be graded, but may be reviewed and considered by your instructor.e. Use trial and error to find a value of the exponential smoothing coefficient a that results in a smaller MSE than what you calculated for a = 0.2.

Answered: Problem 6-05 Consider the following…

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

Please solve this
The K&R Camera shop sells all the latest cameras and accessories. To meet customer demand, the manager must forecast demand for items she sells. Lately the XR-42S zoom lens has been very popular. Recent monthly demand for this item has been as shown: Number of Lenses Month Sold 1 12 17 2 3 4 15 20 18 23 6.
Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
Please solve this question...
Using exponential smoothing with alpha = .2, and assuming the forecast for period 11 was 80, what would the forecast for period 14 be?
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
8. Block Commodities has gathered the following information concerning rock salt deliveries to its clients, which it believes are highly seasonal: Дусгаge Monthly 83.5 Year 1 Year 2 Year 3 Year 4 January February 84 78 80 70 100 65 50 80 68.25 March 66 70 50 50 59 April May June July August September 50 October November 200 December 15 25 20 30 22.5 10 15 20 10 13.75 13.75 13.75 20 10 10 15 10 15 20 10 20 180 50 10 30 40 60 170 190 210 150 200 120 110 180 172.5 150 200 180 120 200 150 170 Total Annual 923 955 950 920 a. Suppose Block Commodities calculated a set of seasonal relatives to express this monthly variation in rock salt deliveries, using this set of data. What would be the value of the seasonal relative for the month of July? What would be the value of the seasonal relative for the month of December? b. Block Commodities believes that this year will be a busy year for rock salt deliveries, forecasting a total of 1,200 tons to be delivered during the year. Using this annual…
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
Problem 3
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6 weeks: a) Forecast the dema nd for the week of October 12 using a3-week moving average.b) Use a 3-week weighted moving average, with weights of .I , .3,and .6, using .6 for the most recent week. Forecast demand forthe week of October 12.c) Compute the forecast for the week of October 12using exponentialsmoothing with a forecast for August 31 of 360 and a = .2
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…

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

Problem 6-05 Consider the following time series data. Week Value (1) 18 € a. Choose the correct time series plot. Time Series Value Time Series Value 20 13 20 16 M 11 2 3 5 17 14 64 5 9 € € Time Series Value Time Series Value 284H2G86420 313 Week (t)