Question: Using your spreadsheet from Part 2 Graph your results by week on one axis and revenue on the other axisIn an additional column apply a

Using your spreadsheet from Part 2Graph your results by week on one axis and revenue on the other axisIn an additional column apply a 9 week moving average to the revenue forecastAdd one more column and apply exponential smoothing using an a=0.20 to the revenue forecastTo calculate your actual demand when calculating exponential smoothing.For the first 26 weeks, assume actual demand was 5% lower than your forecastFor the remaining weeks, assume actual demand is 10% higher than your forecast.The easiest way to modify your forecast is to add another column for Actual DemandGraph #2 and #3 and compare the results to #1Explain the differences between your three different forecasts and draw a conclusion
 Using your spreadsheet from Part 2Graph your results by week on

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!