SU Forecasts & Actual Sales of MP3 Players at Just Say Music Excel Worksheet

User Generated

GvlnTenl

Business Finance

Strayer Univeristy

Description

I am looking for assistance with the following assignment.

Assignment 3: Forecasting

Submit Assignment

  • 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:

MonthForecastActual Sales
March150170
April220229
May205192
June256241
July250238
August260210
September270225
October280179
  1. Plot the data and provide insights about the time series.
  2. What is the forecast for November, using a two-period moving average?
  3. 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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags