Quantitative methods
Complete assignment instructions in document
MGMT 6108
Forecasting Assignment II
Excel is the best tool for calculations
Answer the questions in this document
Attach tables with calculations as appendixes
Be sure to know how to do the problems by hand also. In the Final test you will be solving small but similar versions of this problem.
Name
- The table below shows monthly sales of a motorcycle store during the last two years.
Month Sales Month Sales
1 195 13 155
2 210 14 120
3 190 15 135
4 170 16 110
5 180 17 122
6 156 18 97
7 134 19 85
8 155 20 110
9 145 21 85
10 165 22 78
11 128 23 66
12 135 24 45
Compute an exponential smoothing and an adjusted exponential smoothing for the data using:
a = 0.2 and fl = 0.6
- Calculate MSE for Ft and Aft
- Identify the best method to forecast the motorcycle sales using MSE.
- Table below shows monthly beer sales at Gordonís Liquor Store in 2017.
Month Sales
Jan 900
Feb 725
Mar 1000
Apr 800
May 750
Jun 1200
Jul 1000
Aug 1100
Sep 1250
Oct 1050
Nov 1400
Dec 1600
Jan
We can write this or a similar paper for you! Simply fill the order form!