Assignment $2$a $-$ Sales Management Problem: Optimizing

Sales Team Performance

A sales manager is analyzing historical sales data to set new

performance targets and determine eligibility for a bonus.

Average units sold per quarter: $480$ units

Standard deviation: $60$ units

The company wants to reward the top $10\%$ performers with a

bonus.

Question: What sales threshold should be set for the bonus?

Assignment $2$b $-$ Sales Performance Data for $5$ Salespersons

The following table shows the historical sales data $($mean and

standard deviation$)$ for five salespersons:

Question: Which of these salespersons are most likely to exceed

the bonus threshold of $557$ units? What are the actionable insights

for the sales manager?

Show the workings in detail in an Excel file for Assignments $2$ a and

$2$ b and create a PowerPoint presentation highlighting the problem,

solution approach, solution, and actionable insights for the sales

manager.