The quarterly sales (in millions of dollars) of corp, are given below. Quarter 2
ID: 3047549 • Letter: T
Question
The quarterly sales (in millions of dollars) of corp, are given below.
Quarter
2015
2016
2017
1
678
845
328
2
150
186
300
3
130
150
350
4
225
245
400
a. Compute the four seasonal factors (Seasonal Indexes) and write their values below. (5 points
b. The above data is organized by quarters and are shown below. Determine the trend equation and write it below. (5 points)
Year
Quarter
Sales
2015
1
678
2
150
3
130
4
225
2016
1
845
2
186
3
150
4
245
2017
1
328
2
300
3
350
4
400
c. Using the trend and the seasonal indexes that you have determined, forecast sales for the four quarters of 2018. Write your answers below. (5 points)
2018 Quarters
Your forecasted sales
1
2
3
4
Quarter
2015
2016
2017
1
678
845
328
2
150
186
300
3
130
150
350
4
225
245
400
Explanation / Answer
a)
Excel formulation
b)
Excel forumation
c)
excel formulation
Quarter 2015 2016 2017 seasonal index 1 678 845 328 1851 1.857035365 2 150 186 300 636 0.63807374 3 130 150 350 630 0.632054176 4 225 245 400 870 0.872836719 1183 1426 1378 3987Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.