Can anyone help me with this? I really do not understand I do not need the answe

Question

Can anyone help me with this? I really do not understand

I do not need the answers, but I need a step by step on how would I go about getting the answers... thanks so much!

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,     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 each of    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.

Explanation / Answer

1.Total units sold 736 Total sales $60,850 Average sale price per unit=60850/736 $82.67 sales made by each person Smith Jones Peterson Albert units sales cost Smith 50 4000 4200 12 1000 1000 34 2750 2500 45 4000 3800 141 11750 $11,500 $250 Jones 34 2400 2000 56 4500 4600 38 3200 3000 128 $10,100 $9,600 $500 peterson 55 $5,000 4000 32 $2,500 2300 78 $6,000 4000 54 $4,800 4600 55 $5,000 4900 274 $23,300 $19,800 $3,500 Albert 65 $5,300 5200 45 $3,800 4000 83 $6,600 6000 193 $15,700 15200 $500 Peterson has created the most profit 3 Smith jones peterson Albert sales 11750 10100 23300 15700 cost 11500 9600 19800 15200 profit 250 500 3500 500 commission 33% sales $3,878 $3,383.50 $7,689 5181 4.& 5 units sales cost Smith 50 4000 4200 12 1000 1000 34 2750 2500 45 4000 3800 141 11750 $11,500 $250 Jones 34 2400 2000 56 4500 4600 38 3200 3000 128 $10,100 $9,600 $500 peterson 55 $5,000 4000 32 $2,500 2300 78 $6,000 4000 54 $4,800 4600 55 $5,000 4900 274 $23,300 $19,800 $3,500 Albert 65 $5,300 5200 45 $3,800 4000 83 $6,600 6000 193 $15,700 15200 $500 6 district 3 units sales 55 $5,000 34 $2,750 54 $4,800 55 $5,000 158 $17,550 17% commission on sale of District 3 sale 17550*17% $2,983.50 units sales cost profit Smith 141 11750 $11,500 $250 3878 Jpnes 128 $10,100 $9,600 $500 $3,383 Albert 193 $15,700 15200 $500 7689 peterson 274 $23,300 $19,800 $3,500 $5,181 `

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.