Vandelay Industries manufactures sailboats. Actual demand for their sailboats for each season over the past four years was as follows:
|
YEAR
|
|
SEASON
|
1
|
2
|
3
|
4
|
|
Winter
|
1,400
|
1,200
|
1,000
|
900
|
|
Spring
|
1,500
|
1,400
|
1,600
|
1,500
|
|
Summer
|
1,000
|
2,100
|
2,000
|
1,900
|
|
Fall
|
600
|
750
|
650
|
500
|
Complete all parts of this problem in Excel. Clearly identify the responses to each part of the question.
a. Enter the necessary data and formulas for this problem into a spreadsheet.
b. Use Excel Solver to find the best estimates for the linear trend line and the seasonal indices for this data. Provide a screenshot (or Snipping Tool capture) of the Solver Dialog Box.
c. Use your estimates of the linear trend line and the seasonal factors to determine a forecast for sailboat demand for every season of the next year (Year 5).