TotalapplicantsTotalhiredTotalMinorityapplicantsTotalMinoritieshiredTotalMajorityapplicantsMajorityhiredNumber ofwomenemployeeswith org.havingspecifiedskill set(e.g., StoreManagers)TotalNumber ofemployeeswith org.havingspecifiedskill set(e.g., StoreManagers)Number ofwomen inlaborforce withspecifiedskill set(e.g., StoreManagers)TotalNumber ofindividualsin laborforce withspecifiedskill set(e.g., StoreManagers)6,600 4,825 1,800 850 4,700 3,700 4,300 22,500 1,097,000 6,500,000Using the information in table above, calculate the following statistics:1. a). Workforce Utilization Analysis: Calculate the number of women with the StoreManager specified skill set within the organization as compared to the labor force.b). Are women being effectively utilized?2. a). Flow Statistic: Calculate 4/5th Rule using the data above.b). Does discrimination exist?c). What should the organization do in response to your analysis of the utilization ofwomen and the hiring of minorities?****************************************************************************************************************Assume that you work for Mr. Green on a part-time basis helping him with office work atYesterYears Antiques. He is interested in getting your opinion on his turnover and absenteeismdata. He hands you the Spreadsheet shown on page 2. The data includes all 3 locationscombined for his Houston, Miami, and Mobile stores.3. Calculate the following statistics and place them on Mr. Green’s spreadsheet: (a) TotalTurnover %; (b) Avoidable Turnover %; (c) Absenteeism Rate %. Include your responses to thespreadsheet in your assignment. Please make sure that your results are carried out to at least 1decimal place.4. Interpret the turnover and absenteeism rates for Yesteryears. In other words, what would you tellMr. Green about his turnover and absenteeism trends? What suggestions would you make toMr. Green based on the results of the reports?Yesteryears Antique Stores Employee Statistics – All Locations;January – June 2016January February March April May JuneTurnoverHeadcount (mid-month) 92 94 92 98 94 90Avoidable Separations (AS) 5 7 3 1 11 11Unavoidable Separations (US) 5 3 1 2 8 8Total Separations (TS) 10 10 4 3 20 18Total Turnover (%)Avoidable Turnover (%)AbsencesNumber of Workdays 23 20 22 21 23 21Number of Worker-days Lost 41 22 20 23 53 62Average Number of Employees 92 94 92 98 84 90