The monthly market shares of General Electric Company for 12 consecutive months follow. A. Construct a time series plot. What type of pattern exists in the data? B. Develop three-month and four-month moving averages for this time series. Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain your reasoning. C. Using your results in (B), compute MAD, MAPE, and Tracking Signal (TS). Which method provides better forecast? Explain your reasoning. Assume TS limit of ±4. D. Apply exponential smoothing to the data. Compute MSE, MAPE, MAD, and TS. Use a = 0.3. How does exponential smoothing compare with four-month moving average? Assume TS limit of ±4. Month 1 2 3 4 5 6 7 8 9 10 11 12 Market Shares 23.39 23.56 23.02 23.03 23.60 23.37 23.21 23.40 23.31 23.94 23.39 23.50

The monthly market shares of General Electric Company for 12 consecutive months follow. A. Construct a time series plot. What type of pattern exists in the data? B. Develop three-month and four-month moving averages for this time series. Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain your reasoning. C. Using your results in (B), compute MAD, MAPE, and Tracking Signal (TS). Which method provides better forecast? Explain your reasoning. Assume TS limit of ±4. D. Apply exponential smoothing to the data. Compute MSE, MAPE, MAD, and TS. Use a = 0.3. How does exponential smoothing compare with four-month moving average? Assume TS limit of ±4. Month 1 2 3 4 5 6 7 8 9 10 11 12 Market Shares 23.39 23.56 23.02 23.03 23.60 23.37 23.21 23.40 23.31 23.94 23.39 23.50

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

Hiring a New Day Care Director could you write down your idea?
I need help with these questions
I need fast i give thumb up
What are the benefits of drafting? Provide 5 real life examples.
What is audio-visual based training? Under what circumstances is audio visual based training especially effective?
Example of how to do it is on the 2nd picture.
Hello tutor can you please elaborate more the how question?
As part of your new staffing-recruiting plan for Pinxteryou decide to hire a Staffing ManagerConduct a job analysis to determine the scope of the new position and then write a job description for the Staffing Manager. In your assignment, you should address all of the following elements for this job, including a description for each: Position Description Title -Grade Exempt or non-exempt status Who the position reports to Responsibilities of the position Essential functions of the job Attributes required
I badly need help for this one. Please please. Thank you so much.
I need 5 paragraphs on; 1. What will be the K-12 graduates in the future workforce.
Need both parts. ..
the details are all in the photo, please help me