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 XYear 3 Forecasts:Quarter 1 = Million dollarsQuarter 2 = Million dollarsQuarter 3 = Million dollarsQuarter 4 = Million dollars 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)19.215.4134.31414.110.36.4235.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 =Year 3 Forecasts:Quarter 1 =Million dollarsQuarter 2 =Million dollarsQuarter 3 =Million dollarsQuarter 4 =Million dollars

The seasonal data needs to be determined.

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 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...

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

Year 3 Forecasts:

Quarter 1 = Million dollars

Quarter 2 = Million dollars

Quarter 3 = Million dollars

Quarter 4 = Million dollars

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 9.2 1 5.4 1 3 4.3 1 4 14.1 10.3 6.4 2 3 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 = Year 3 Forecasts: Quarter 1 = Million dollars Quarter 2 = Million dollars Quarter 3 = Million dollars Quarter 4 = Million dollars

Expert Solution

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here