Mell Industries is a national manufacturing firm that specializes in textiles based out of Chicago. Starting out as a small factory in Warrenville, Illinois, the firm experienced a period of steady growth over the past twenty-four years. Steadily opening new warehouses and factories in the surrounding areas in Michigan and Indianapolis until eventually moving their base of operations to Chicago. Due to this expansion, Mell Industries is at the height of its production and hopes to avoid any interferences or deceleration of growth. In recent years, the firm has been under heavy media scrutiny for supposedly compensating its female staff unfairly lower compared to male counterparts. This was initiated when a disgruntled employee leaked the company payroll allegedly showcasing an unjust gap of income between the female employee and her male counterpart. This type of gender pay gap is highly criticized and as a precaution, Mell Industries has hired Cal Poly Pomona to conduct research to determine the validity of these claims. Mell Industries has provided Cal Poly Pomona with a data set of a sample population of747 employees. Mell Industries has also offered Cal Poly Pomona compensation for any promising information gathered. Mell Industries may use information gathered from this project in future employee compensation decisions. The initial dataset has been given to you in the form of an excel spreadsheet titledCase_dataset. xlsx consisting of 12 columns labeledA- Employee IDB- GenderC - Date of BirthD - Date of HireE - Termination DateF - OccupationG - SalaryH - Employee Evaluation MetricsIn addition, Mell Industries provided the latest annual employee performance review evaluation results rating each employee in various performance categories. They have turned over this information separately and as a consultant, it is your task to provide Mell Industries with the most accurate and relevant information in a digestible form. Furthermore, using excel skills learned during the course, you will manipulate and analyze the data set in order to make appropriate managerial decisions. You will utilize excel functions highlighted in this project as well as a pivot table and chart to form a decision support system in order to answer the critical thinking questions. Project ObjectiveThe purpose of this project is to perform a methodical data analysis to assist the company make an informed decision. This could also serve as a basis for implementing critical adjustments to certain business aspects if necessary. Illustrate the business process by condensing a large set of data, to present relevant information with data visualization. We will be utilizing Microsoft Excel 2016 to complete this project. TASKSTask 1. Identify the IssueIdentify the issue by reading the project background thoroughly, and have a clear objective in order to provide the client with a meaningful service.