what would be the formula for security bonus% column and. cash bonus

Senior management has told you to stop all voluntary turnover going forward. They have told you that all specialized employees are to receive one-time extra "retention" bonuses outlined as follows: A) Cash Value of Common Shares Each emplovee who has either Level 1 or Level 2 security clearance, will receive $8000 of company stock issued as common shares. B) Acash bonus paid immediately based on the employee's performance rating from the previous year and their tenure (years of service). NOTE: This will be paid ONLY to Level 2 security clearance employees based on the table below. Bonus for Level 2 Security Clearance Employees ONLY 1. Bring together all the data from different divisions into the "All Divisions" sheet using VSTACK. 2. Once done, in this "All Divisions" sheet, create a new column and use VLOOKUP() to identify employees that are Level 1, Level 2 or neither from the "Lvl 1 and 2 Employee List" sheet. 3. Create a new column to retrieve the Security Bonus \%. 4. Create a new column at the end of the existing data with the label, "Issued Stock". 5. Besides the "Issued Stock" column, create a new column at the end of the existing data with the label, "Cash Bonus". This Cash Bonus is the Security Bonus \% multiplied by yearly salary. 6. And finally, included a Total Payout column which includes the Issued Stock and Cash Bonus. DO NOT include salary - remember management only wants to know the incremental cost of retaining these employees. 7. Use the formulas indicated above (or others you know of) to fill in the data for the two new columns. NOTE: You must use formulas for these columns that are applied to all employees. For example, the formula used for the first employee must be used for all employees in each column. If you use filters to sort the data and input numbers or use inconsistent formulas, you will receive a grade of zero (0) for this entire