QTN 561: Exercise Question about Seasonal Index
princess_92073
qtn-_561_-_ex_18.docx|
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 |
|
|
|
