Calculations in Excel. Report in Word The table below shows monthly sales of a m
ID: 366770 • Letter: C
Question
Calculations in Excel. Report in Word
The table below shows monthly sales of a motorcycle store during the last two years. The commission for each motorcycle sale is $1,000. The manager wants to estimate how much money he will need for month 25. Submit a report in word answering each question clearly. Explain your answer. Include an excel table with all calculations as an appendix.
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
Forecast motorcycle sales for month 25 using:
Plot your data
Naïve method.
MA3
MA4
ES with best alpha
AES with best beta
Which method is better and why?
Note: Be sure to use all 24 observations in your analysis
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
Explanation / Answer
Solution 1The table below shows monthly sales of a motorcycle store during the last two years. The commission for each motorcycle sale is $1,000. The manager wants to estimate how much money he will need for month 25.
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
Plot and analyze your data.
Forecast motorcycle sales and amount of money needed for month 25 using the Naïve method.
Forecast motorcycle sales and amount of money needed for month 25 using MA3.
Forecast motorcycle sales and amount of money needed for month 25 using MA4.
Forecast motorcycle sales and amount of money needed for month 25 using ES with =0.2.
Forecast motorcycle sales and amount of money needed for month 25 using ES with =0.6.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.