Determine the forecast of next year’s quarterly sales revenue for this line of laptops. NOTE: For your workings, Seasonal Indexes must have four decimal points, the trend equation must have three decimal points, and the forecasts must have two decimal points. Fill in the answers in the appropriate spaces below. Trend Equation: Y = Answer + Answer X
The manager of YTL Computers wants to develop next year’s quarterly forecasts of sales revenue for its brand laptops. The sales are seasonal and the company believes that the following most recent eight quarters of sales should be representative of next year’s sales:
Year Quarter Sales (millions of dollars)
1 1 9.2
1 2 5.4
1 3 4.3
1 4 14.1
2 1 10.3
2 2 6.4
2 3 5.4
2 4 16.0
Determine the
Trend Equation: Y = Answer + Answer X
Step by step
Solved in 3 steps with 7 images