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?
1What specialized skills will the future HRIS professional need in order toeffectively manage an organization’s virtual human resource function? 2 What is manpower planning? How does it relate to other human resourcemanagement activities?
Give a short summary of 20 words about the topic "Part time job".
What are the Prerequisites to Success Preparation? List down the details and give definition.
1. Write a short essay on Recruitment and selwction with examples to show its practical implications. (Word count: 500 max and 350 minimum)
2
What are the benefits of drafting? Provide 5 real life examples.
What challenges areoften experienced in a course and how can students overcome these challenges?
10. Developing and retaining existing employees is a part of . human capital talent management physical capital all of the above
column of the table below. In the green middle column, write a sentence or two in each box, summarizing what happens in the corresponding section as if you BELIEVE each character. Next, in the blue right column, write a sentence or two in each box, summarizing what happens in the corresponding section as if you DOUBT each character. Complete both columns for any 10 of the 28 sections for a complete submission. As an example, I demonstrated the activity at the top of the chart using the nursery rhyme of "Jack and Jill." Copilot Summary of # George Saunders' "Puppy" section, with Summarize this section as a BELIEVER Summarize this section as a E Jack and Jill went up x the hill To fetch a pail of water. Jack fell down and broke his crown, And Jill came tumbling after. Then up got Jack and said to Jill, As in his arms he took her, "Brush off that dirt for you're not hurt, Let's fetch that pail of water." So Jack and Jill went up the hill To fetch the pail of water, And took it home to…
I need 5 paragraphs on; 1. What will be the K-12 graduates in the future workforce.
how effective is the placement strategy to food truck businesses?