Question: SuperCoolApp Inc. Rating bonus system from 1 - 5 Inputs and ConstantsLowest level performer gets no bonusToday:Highest level performer gets $ 1 0 , 0

SuperCoolApp Inc. Rating bonus system from 1-5Inputs and ConstantsLowest level performer gets no bonusToday:Highest level performer gets $10,000 bonusYears Threshold:3(Employees get high rate of raise if employed for at least this long)Level 2 gets $1000High Rate:7.50%Level 3 gets $2500Low Rate:3.00%Level 4 gets $5000Employee nameDate HiredCurrent SalaryRating ScoreYears EmployedRating Bonus ($)Raise ($)Total compensation ($)Nicki Mirage4/1/2150,0004Saylor Drift10/31/2375,2504Brake8/18/1967,2505Oblivia Rodrigo9/12/2255,9803Lustin' Jeeber1/8/2158,7501Glizzo9/18/2061,0004Bardi C.7/14/2381,5005Katie Prairie8/19/2275,5002Kenwick Babar11/11/2059,2504Abele9/19/1865,0003Beggin the Scallion2/14/2262,7505Libby Iwish 10/31/2169,50041) Complete the table by filling in the yellow boxes with appropriate functions2)Which of your employees costs you the most?3)Assuming SuperCoolApp has one million dollars of cash on hand, how much will be left after it covers payroll?Please show your work in the spreadsheet.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!