PLEASE show the formulas used!

please fill out the first chart in the first photo where blank spaces are and then fill in the info into the spot where the highlighted area is! thank you!

the instructions are listed below of any missing information needed!

just figure out the FY22 incentives (individual) please

Pavgrade Differential merit pay rate \begin{tabular}{|ll|} \hline Performance level & Rate \\ \hline Excellent & 3.0% \\ Above average & 2.0% \\ Average & 1.0% \\ Below average & 0.0% \\ Poor & 0.0% \\ \hline \end{tabular} In this assignment, you will conduct an HR analytic activity. You are an HR manager of a local car dealership. As the end of fiscal year come closer, you are to estimate overall compensation for 20 employees, including their base salary and incentives. Here is a list of jobs in your dealership: Executive manager General manager Sales representatives Mechanics Detailers Office staffs Janitors Here is a compensation policy of your dealership: Paygrade is divided in 1 to 8 level, where level 1 to level 3 is weekly-wage basis, and level 4 - level 8 is salary-base. One year has 52 weeks. Standard work hour is 8 hours per day, 40 hours per week. Differential merit pay incentive plan is applied for salary-based employees given the level of individual performance in the current year. Sales representatives get $330 commission per each car sale over the base pay. Differential piece-rate is $20 per each case exceeding the target quota over the base pay. Standard hour rate is $20/ hour. Next year, everyone gets 2% of regular increase in their base pay. The list of employees, their title, and performance appraisal is provided in an attached excel file. Your task - Complete the compensation report for this year, and estimate the following year's compensation budget for each employee (green columns in the "compensation total" tab). - Fill out the yellow cells in "summary" tab of the excel file (use formulas). FY22 Total Compensation FY22 Base pay 1075240 FY22 Incentive pay (Individual) FY23 Estimated Compensation (Base pay only) Increment from FY22