its a 2 part question

Instructions Complete the calculations for each of the following questions using the steps outlined in this week's lecture slides. For full credit, please type in your work for each step in the space provided (similar to what you saw In the practice question answer key). Also, it is possible to receive partial credit for your answers even if the final answer is incorrect, as long as the logic for the calculation in each step is shown clearly and correctly. This assignment should only be completed ofter attempting the practice questions. Directions: Calculate the total cost of absenteelsm per employee using the following information: Total number of employees: 1,750 Total working weeks of the year: 48 weeks Total hours of absence: 39,680 Average % of Absenteeism 0.65 Occupational Group Blue collar Clerical Management & Professional 0.15 0.20 Average Hourly Wage $28.75 $13.50 $39.90 Cost of benefits is about 39% of hourly wage Number of supervisors who deal with absence problems: 34 Supervisory hours lost per day: 2 hours Average hourly supervisor salary: $37.65 Yearly cost of substitute employees: $395,540 Yearly cost of reduced quality/quantity: $1,380,000 Costs of Absenteeism Worksheet Imatruction in the analysis preperation section on the left, enter the correct was based on company records You may need to convert some values too.number of working wees to number of working days wing you have working days a week in the costs of absenteeism calculator on the right, EXCEL FUNCTIONS Infiling out all the yellow cells when conducting the anal You will not be both the formula Bandit card Analysis Preperation Section Costs of Absentem Cakulator Occupational Group Enter the job categories based on company records) Average of Absenteeiam Average Heurly Wage Step Description Values D Values Company Data Total number of employee Total number of working weeks of the year Total number of working days of the years Total hours of Cost of the percentage Supervisory hours tout per day Total number of supervisors who deal with bene problem Average hourly supervisory Yearly cost of substitutenploye Yearly cost of reduced quality out Step: Step 2 Step Step Steps Step Step 7 Step Step Step 10 Step 11 Step 12 Total employed his Weerd verge hourly wage per absent employee Average cost of het per hour! Totalcompetition reployee pehov Total.com for an employees Tolberovisory hours foto Total competition Tocal competent on Yearly cost ofte Estimated yearly rent Total of super Totalcom a