I need the excel formulas to answer the following, I know

the answers but I do not know how to do the excel formulas, please help!!!

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. What is the average sales price for a widget?

2. Which salesperson has created the most profit for MIS

INC?

3. If a salesperson earns 33% commision on the profit from

each

sale, If so how much commission did each salesperson make?

4. Does the answer in 3 differ if the sales are totaled and then

the commission calculated instead of a commission earned on each

sale? If so, how much for each salesperson?

5. Construct a pivot table to show how many total units were

sold in the three districts by each of the salespeople.

6. Management is considering offering a bonus for sales made

into Sales Disctrict 3. How much would it cost the company if they

offered an additional 17% commission on the sales made in District

3?

7. Create a chart to show management what percentage of the

Gross Sales was Expenses, what part Commission and

what part profit for MIS INC?