You have been hired to evaluate the sales people in MIS INC. Above is the sales data for the previous month. The are 4 sales people who can sell their products over 3 sales regions. The company advertises the sales price of a widget at $80, but your salespeople have the option to sell their widgets at whatever price they feel comfortable with. You should prepare spreedsheets to answer the following questions?

1 MIS INC Sales Data for Widgets 2 Salesperson 3 Smith 4 Jones 5 Peterson 6 Peterson 7 Smith 8 Smith 9 Jones 10 Peterson 11 Albert 12 Albert 13 Smith 14 Peterson 15 Albert 16 Jones 17 Peterson 18 District Units Gross Expen ses 50 4000 4200 34 2400 2000 55 5000 4000 32 2500 2300 12 1000 1000 34 2750 2500 4500 4600 78 6000 4000 65 5300 5200 45 3800 4000 45 4000 3800 54 4800 4600 83 6600 6000 38 3200 3000 55 5000 4900 2 56