This is a calculation assignment. You'll use the tab labeled “U6 Assignment (CLO3)” in the spreadsheet. Answer all sections of the attached spreadsheet (questions a through h)Complete the calculations...

W6 Assignment (CLO3)
        Mike's Exhaust Works produces efficient exhaust systems used on custom motorcycles. They sell their systems to other manufacturers, who build customized bikes to clients. Kari is the sales manager, and she has created the following projected demand schedule for Tom, the production manager.
            Jan    Feb    Mar    Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec
        Projected Demand    15000    19000    20500    21000    22000    21000    21000    19500    18000    16200    15000    15000    -->    223200
        Mike's Exhaust Currently has 50 tradesmen who each work 20 days a week, and can each produce 15 exhaust systems per day.
        a) Assuming that the company is only concerned with aggregate yearly demand, should the labor force be changed?
            Jan    Feb    Mar    Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec
        Projected Demand    15000    19000    20500    21000    22000    21000    21000    19500    18000    16200    15000    15000
        Workers    62    62    62    62    62    62    62    62    62    62    62    62
        Work days    20    20    20    20    20    20    20    20    20    20    20    20
        Units/Worker day    15    15    15    15    15    15    15    15    15    15    15    15
            18600    18600    18600    18600    18600    18600    18600    18600    18600    18600    18600    18600    -->    223200
        b) Assuming that the company is concerned with aggregate monthly demand, how should the labor force be changed? (round to the nearest whole employee - exact monthly demand must me met, no over or underproduction allowed).
        0    Jan    Feb    Mar    Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec
        Projected Demand    15000    19000    20500    21000    22000    21000    21000    19500    18000    16200    15000    15000
        Workers    50    64    69    70    74    70    70    65    60    54    50    50
        Work...