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.21 2 5.41 3 4.31 4 14.12 1 10.32 2 6.42 3 5.42 4 16.0Determine 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 companybelieves that the following most recent eight quarters of sales should be representative of next year's sales:YearQuarterSales (millions of dollars)119.2125.4134.31414.1110.36.425.4216.0Determine 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 =

Answered: Image /qna-images/answer/7f970451-58fc-4f6b-86fc-2039b558d109.jpg

Answered: Determine the forecast of next year’s…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.7: Exponential Smoothing Models

Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...

See similar textbooks

Related questions

Question

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 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

Transcribed Image Text: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 1 10.3 6.4 2 5.4 2 16.0 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 =

Expert Solution

Step by step

Solved in 3 steps with 7 images

SEE SOLUTION Check out a sample Q&A here