Question: Using the table, if the manager's bonus is based on the company achieving it's sales objective and the manager achieving his / her personal sales

Using the table, if the manager's bonus is based on the company achieving it's sales objective and the manager achieving his/her personal sales quota, what formula should be in C8?
\table[[4,A,B,C,D],[1],[2],[3,,Company Sales Objective,$1,000,000,],[41,,Actual Company Sales,$1,113,436,],[5,,Manager Sales Quota,$20,000,],[6,,Manager's Actual Sales,$23,045,],[7,,Bonus Percent of Manager's Actual Sales,1.50%,],[8,,Manager's Bonus,$345.68,],[9,,,,]]
))C4,C5((C6
))C4,C5((C6
))((C5,C6**C7,0
))((C5,C6**C7,0
 Using the table, if the manager's bonus is based on the

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 General Management Questions!