QTN 561: Exercise Problem (one only)

Appliance Center sells a variety of electronic equipment and home appliances. For the last 4 years, 2010 through 2013, the following quarterly sales (in $ millions) were reported.

Quarter

Year

I

II

III

IV

2010

5.3

4.1

6.8

6.7

2011

4.8

3.8

5.6

6.8

2012

4.3

3.8

5.7

6.0

2013

5.6

4.6

6.4

5.9

“SEE THE ATTACHED EXCEL SPREADSHETT”

Determine a typical seasonal index (adjusted) for each of the four quarters. (Round your answers to 4 decimal places.)

Seasonal

Quarter

Index

1

2

3

4