Question: Please help me to know how to solve using excel 4. (10 points) Sally and Jim are newly hired salespersons at Gypsy Train Systems. The
Please help me to know how to solve using excel
4. (10 points) Sally and Jim are newly hired salespersons at Gypsy Train Systems. The average salesperson at Gypsy Train had sales of $1,000,000. Sales are normally distributed with a standard deviation of 289,500. Bonuses and firings are based on relative performance. Anyone who has sales in the top 15 percent gets a bonus, while anyone in the bottom 5 percent of sales is fired. a. Sally is hoping for a bonus. What is the minimum level of sales she must achieve to earn a bonus? $1,300,047.47 b. Jim is worried he will get fired. He had sales of $575,000. Will he be fired? Explain No. Those with sales below $ 523,814.88 will be fired
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
