The following time-series data set represents Wingreen Humidor\'s sales of humid

Question

The following time-series data set represents Wingreen Humidor's sales of humidors in thousands of dollars. Mr. Wingreen has asked you, the sales manager, to make a three-month forecast based on the given data. He instructs you to construct projections based on: moving average, weighted moving average (with weights of 0.55, 0.33 and 0.12 applied to the months in sequence starting with the most recent month), and linear regression. Use Excel and show your work.

Month Sales 1              30 2              69 3              76.5 4              63 5              46.5 6              42 7              54 8              70.5 9              93 10             87 11             61.5 12             51 13             57 14             78 15           105 16           106.5 17             82.5 18             67.5 19             69 20           103.5 21           100.5 22             84 23             63 24             60

Explanation / Answer

SUMMARY OUTPUT

Month Sales 1 30 weighted average moving average linear regression 2 69 3 76.5 4 63 68.445 58.5 60.42869565 5 46.5 68.175 69.5 61.75326087 6 42 55.545 62 63.07782609 7 54 46.005 50.5 64.4023913 8 70.5 49.14 47.5 65.72695652 9 93 61.635 55.5 67.05152174 10 87 80.895 72.5 68.37608696 11 61.5 87 83.5 69.70065217 12 51 73.695 80.5 71.02521739 13 57 58.785 66.5 72.34978261 14 78 55.56 56.5 73.67434783 15 105 67.83 62 74.99891304 16 106.5 90.33 80 76.32347826 17 82.5 102.585 96.5 77.64804348 18 67.5 93.12 98 78.9726087 19 69 77.13 85.5 80.29717391 20 103.5 70.125 73 81.62173913 21 100.5 87.795 80 82.94630435 22 84 97.71 91 84.27086957 23 63 91.785 96 85.59543478 24 60 74.43 82.5 86.92 25 63.87 69 88.24456522 26 89.56913043 27 90.89369565

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.