Description
I am looking for assistance with the following assignment.
Assignment 3: Forecasting
- Due Sunday by 11:59pm
- Points 100
- Submitting a file upload
This discussion aligns with Learning Outcome 2.
Directions
Using the Excel Spreadsheet Template at OM6 online (CengageBrain or CengageNow) forecast the demand for the sales of MP3 players at Just Say Music.
Forecasts and actual sales of MP3 players at Just Say Music are as follows:
Month | Forecast | Actual Sales |
March | 150 | 170 |
April | 220 | 229 |
May | 205 | 192 |
June | 256 | 241 |
July | 250 | 238 |
August | 260 | 210 |
September | 270 | 225 |
October | 280 | 179 |
- Plot the data and provide insights about the time series.
- What is the forecast for November, using a two-period moving average?
- What is the forecast for November, using a three-period moving average?
Submission
This assignment requires a file upload submission. After you have reviewed the assignment instructions and rubric, as applicable, complete your submission by selecting the Submit Assignment button next to the assignment title. Browse for your file and remember to select the Submit Assignment button below the file to complete your submission. Review the confirmation annotation that presents after submission.
Explanation & Answer
Please let me know if you need anything to be changed or added I will be happy to carry any changes, just leave me a message and will get back to you as soon as I can Bye for now, but will be here if you need any further help
Carpet City Regression
X - axis
Month
Y - axis
Forecast
Actual Sales
MP3 players
March
April
May
June
July
August
Septembe
r
October
150
220
205
256
250
260
170
229
192
241
238
210
270
225
280
179
300
250
200
150
100
50
0
March
Place regression output here
Y = A + Bx
A=
B=
Forecast...