#9 Quarter 2005 117.0 2006 118.6 2007 114.0 2008 120.7 2009 25.2 Year Winter Spr

Question

#9

Quarter 2005 117.0 2006 118.6 2007 114.0 2008 120.7 2009 25.2 Year Winter Spring Summer Fall 80.7 82.5 84.3 79.6 80.2 129.6 121.4 119.9 130.7 127.6 76.1 77.0 75.0 69.6 2.0 Develop the typical seasonal pattern for Teton Village using the ratio-to-moving-average method (a) (b) Explain the typical index for the winter season Exercises 9. Victor Anderson, the owner of Anderson Belts, Inc., is studying absenteeism among his employees. His workforce is small, consisting of only five employees. For the last three years he recorded the following number of employee absences, in days, for each quarter Quarter IV Year 2006 2007 2008 12 12 Determine a typical seasonal index for each of the four quarters 10. Appliance Center sells a variety of electronic equipment and home appliances. For the last four vears the following quarterly sales (in S millions) were reported

Explanation / Answer

Q.9

Here for seasonal index calculation , there is very simple method. Steps are:

Step I: First we will take average absentees for each year. That is given below in the table.

Step : II

Now we will express the raw data as a proportion of the cycle average. That means we will divide the individul data with the yearly average.

like for qtr. 1 and year 2006, proportion = 4/6 = 0.6667

Step : III

Now we will take average of these three years proportions. That would be the seasonal index for that quaarter.

LIke for quarter 1 seasonal index = (0.6667 + 0.6667 + 0.6316)/3 = 0.6550

for quarter 2 seasonal index = (1.6667 + 1.6 + 1.6842)/3 = 1.6503

for quarter 3 = 1.2099

for quarter 4 = 0.4848

Year QT.1 Qt.II Qt. III Qt. IV Average 2006 4 10 7 3 6 2007 5 12 9 4 7.5 2008 6 16 12 4 9.5

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.