Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show what formula to use to get the 1)Sum of Red Team Sales divide by Sum of Blue Team Sales? 2) Percent bonus of
Please show what formula to use to get the
1)Sum of Red Team Sales divide by Sum of Blue Team Sales?
2) Percent bonus of all Red Team compared to Total Bonus?
Please take a look at the worksheet and show calculations.
Thank you
4 up as Basics Lecture. EMPLOYEE SALES BONUS TEAM BONUS $ Alfonso $ 250,000 5% RED Devin $ 96,500 2% RED This is item 6 Seher S 64,500 3% BLUE Michayla $ 124,000 6% RED Lim S 97,600 2% BLUE Tan S 37,500 0% BLUE TOTAL $ 670,100 Sum of Red Team Sales divided by Sum of Blue team Sales This is item 5 This is item Percent bonus of all Red team compared to Total Bonus 5 Find the Sum of Red Team sales then divided by Sum of Blue team sales to get the percentage of Red to Blue Sales. 6 Calculate the Bonus $ column for each employee as Sales * Bonus%. Sum the column. This is column F. 7 Find the Percent bonus of all Red team compared to Total Bonus 8 Resave the FILE again with the same name. EMPLOYEE SALES BONUS TEAM Alfonso $250.000 5% RED Devin $96,500 2% RED Seher $64.500 3% BLUE Michayla $124,000 6% RED Lim $97,600 2% BLUE Tan $37,500 0% BLUE TOTAL $670,100 Sum of Red Team Sales divide by Sum of Blue Team Sales Red $470,500 Blue $199,600 BONUS $ $12,500 $1,930 $1,935 $7.440 $1,952 $0 $25,757 ???? Percent bonus of all Red team compared to Total Bonus Red 13%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started