Share
Explore BrainMass

Victor Anderson, the owner of Anderson Belts, Inc.: Determine a typical seasonal index for each of the four quarters.

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
Year I II III IV
2001 4 10 7 3
2002 5 12 9 4
2003 6 16 12 4

Determine a typical seasonal index for each of the four quarters.

Solution Preview

Please see the attached file.

To calculate the seasonality index do ...

Solution Summary

Tutorial is in excel to assist you.

$2.19