Question: Using the table below, if total annual demand for Year 3 is 2000. Calculate the average seasonal index for Quarter 3 ( labeled A ),

Using the table below, if total annual demand for Year 3 is 2000.

Calculate the average seasonal index for Quarter 3 ( labeled "A" ), round to 2 decimal places.

Calculate the forecast for Year 3 - Quarter 3 (labeled "B" ), round to next whole value.

Year

Quarter

Sales

Seasonal Index

Quarter

Avg. Seasonal Index

Year 3 Forecast

1

1

500

1.44

1

2

435

1.26

2

3

250

0.72

3

A

B

4

200

0.58

4

Average:

346

Total Demand:

2000

2

1

487

1.44

2

401

1.19

3

298

0.88

4

167

0.49

Average:

338

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Using the table below, if total annual demand for Year 3 is 2000. Calculate the average seasonal index for Quarter 3 ( labeled "A" ), round to 2 decimal places. Calculate the forecast for Year 3 -...

Q:

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

Q:

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

Q:

CHAPTER 17TIME SERIES ANALYSIS AND FORECASTING MULTIPLE CHOICE 1. Which of the following is not present in a time series? a. seasonality b. operational variations c. trend d. cycles ANS: B PTS: 1...

Q:

Problem 4 Finally, you have a data set for the number of sales for 5 years. The number of sales varies over the seasons because of demand shocks such as holiday sales during Christmas. The company...

Q:

i will rate your answer up Time Series Models: Seasonal Indexes Bain & Company hired you as a Marketing Analyst and ask you to look at the following data and see what insight you can derived from it...

Q:

PART A The following table shows quarterly sales (in thousand units) for a product over 5 years. The overall sales average for the entire 5 years is 91.15 (thousand units). Fill in the missing values...

Q:

PART A The following table shows quarterly sales (in thousand units) for a product over 5 years. The overall sales average for the entire 5 years is 120.65 (thousand units). Fill in the missing...

Q:

he following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units). Fill in the missing values...

Q:

No any other information was given, so your demand forecast for the fourth quarter of the next year is: (Hint: when computing the missing seasonal factor, please keep two decimal places after the dot...

Q:

The following is a sample of nine mortgage companies interest rates for 30-year home mortgages, assuming 5% down. 7.625 7.500 6.625 7.625 6.625 6.875 7.375 5.375 7.500 (a) Find the mean and standard...

Q:

A tennis player uses a racket to bounce a ball up and down with a constant period. Is this a simple harmonic motion? Explain.

Q:

Stoolitrokers often believe that their own expertise will enable them to select stocks that will oufperform the makert average. This herlief best ilurstrmes the avalubility heuristic. a firation. the...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...