In excel please show formula of how you got the answer and equation.

You have the responsibility for making a report to help the company administrators to implement new employee's career plan, providing data to the investment/budget committee. So, you are managing the employee's payroll data from the new division of Data Research, created two years ago to provide the company departments (Marketing, Sales and Operations) with collection/analyze/update/report of real time market information, by making the calculation of their pay checks shown below. As the division's head, you want to demonstrate alternatives to justify the maintenance of 5.5% salary raise police to the administrators debate regarding the company's employees career plan, justifying the inclusion of Data Research division employees in the salary raise police. You have been asked to prepare a spreadsheet to put together the payroll data and summarizing the impacts of the actual salaries to the career plan in order to demonstrate the amount spent with the division, analyzing how the degradation of the salaries might impact in the retention of the division's employees and demonstrating to the board reasons to support/justify the improvement in the employee's compensations by include them the percent of the salary raise. The values shown are the total hours of each worker in the month and the value of the hour work for each one in the department and the total/average monthly values spent which department's workers, put your name in the indicated cell; a. Create a spreadsheet illustrating each employee's incomings/discounts data in the month. To do this, you will first enter the data shown in the figure below. Then compute the values of each columns/lines, for the monthly values as indicated below: 1 PAYROLL PAVOLL YOUR NAME & CLASS SECTION 3 LAST FIRST HOURS PAY GROSS TIME GROS 5 DeGlass Phil 6 Endime Nicole 7 Graw Marty 8 Daire Sunny 42 $13.50 35 12.50 50 13.25 32 16.75 Total 11 Average Salary Raise Request Analysis REG GROSS - the employee incoming the value is calculated using a logic function, multiplying the maximum of monthly hours (today is 40) by the value of each employee's pay. OVER TIME - the value is calculated using a logic function, where 1.5 additional will be applied to the original hour pay, all employees will be assessed but only who made more hours than the monthly maximum (40), so calculate the number of hours exceed, than to this value multiply to 1.5x addition to the original employee's pay value. ADJ GROSS - the employee incoming, which the calculation is based on the incoming columns OVER TIME and REG GROSS FICA- calculation of the discount value to be apply in the employee's incoming regarding the FICA percent contribution, the discount percent should be used is expressed in the spreadsheet on top of the column label (in past month is 7.65%) NET - the final employee's incoming earned, based in the values of ADJ GROSS and FICA Total and Average, compute the respective formula regarding each columns REG GROSS, OVER TIME, ADJ GROSS, FICA, NET; b. Apply conditional format in cells in the column OVER TIME using a formula: highlight in yellow only the cells that holds values (if the employee does not have OVER TIME earns, the cell must stay plain, not highlighted); C. Create a three-dimensional bar graph illustrating the averages by employees regarding Total and Average in a new sheet. d. A committee has been formed to discuss the employee's career plan and the alternatives to alignment to maintenance the police of 5.5% salary raise with the budget decisions of the company's investment. Inset a text box titled Salary Raise Request Analysis you should describe brief arguments to support the salary raise request, based in the analysis of the payroll data, how it might impact not only the company budget but the company future profit, using the spreadsheet data and the graphic to illustrate your findings. Present a summary of your conclusions with arguments to explain the potential degradation of the employee's compensations and highlight the justification to support the salary raise request; e. Use professional design in labels, formatting, and backgrounds to present the spreadsheet data