Question: Problem 1 . GameStop ( Tampa ) is forecasting sales for the Playstation 5 in week 6 , below are the sales figures for the

Problem 1. GameStop (Tampa) is forecasting sales for the Playstation 5 in week 6, below are the sales figures for the last 5 weeks:
\table[[time t,Week,Sold],[1,5 Weeks ago:,700],[2,4 Weeks ago:,725],[3,3 Weeks ago:,750],[4,2 Weeks ago:,780],[5,1 Week ago:,795]]
Provide the equation (formula) and the forecast for week 6 sales using the specified method. You may type or handwrite your answers in the space provided but you must stay within the text box for each question. Round your final answers to the nearest whole number.
1.1 Forecast using the Nave Approach (5 points)
1.2 Equation and forecast using a three-week moving average. Use the numeric values in your equation shown here, not Excel cell locations.(10 points)
1.3 Equation and forecast using a weighted average using ,75 for last week (time t=5),15 for 2 weeks ago (time t=4) and .10 for 3 weeks ago (time t=3). Use the numeric values in your equation, shown here, not Excel cell locations. (15 points)
1.4 Equation and forecast using Exponential Smoothing with a smoothing constant equal to 40. To start, use a forecast of 700 for time t=2. Show only the numeric values used to calculate the final week and round your final answer to the nearest whole number (20 points)
PLEASE PROVIDE THE EQUATION (FORMULA) AND THE FORECAST FOR WEEK 6 USING THE SPECIFIED METHOD :)!
 Problem 1. GameStop (Tampa) is forecasting sales for the Playstation 5

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!