The table below describes the staffing, capacity, demand, and utilization for Sorel Insurance.The table assumes an 8 hour work day, 5 day work week and 13 week quarter.These calculations will be the baseline for the following questions.You may want to create your own spreadsheet to help you answer the questions.

Simple Applications Junior Senior Staff Junior Staff Staff Senior Staff Average Process Requested Implied Count Capacity Count Capacity Capacity Capacity Utilization people Japps/person- people Japps/person- day day apps/day apps/day Data Entry 4 36 144 116.4 81% Initial 3 Review 20 30 150 184.3 123% Underwriting 10 12 3 18 174 165.87 95% Print and Mail 2 88 176 132.696 75% Complex Applications Junior |Junior Staff Senior Staff Staff Senior Staff Average Process Requested Implied Count Capacity Count Capacity Capacity Capacity Utilization people Japps/person- apps/person- day (people day apps/day apps/day Data Entry 1 16 16 7.8 49% Initial Review 2 6 12 13 108% Underwriting 5 3.04 15.2 12.35 81% Print and Mail 0.5 30 15 6.175 41%