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
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 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!