Explore BrainMass

Explore BrainMass

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

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:01 pm ad1c9bdddf
    https://brainmass.com/business/business-management/121174

    Solution Preview

    Please see the attached file.

    To calculate the seasonality index do ...

    Solution Summary

    Tutorial is in excel to assist you.

    $2.19

    ADVERTISEMENT