Can anyone help me with this please? Thanks The Excelsior Company has three sale

Question

Can anyone help me with this please? Thanks

The Excelsior Company has three salespersons. Average sales price per unit sold, average variable manufacturing costs per unit, and number of units sold for each salesperson is shown below Commissions are according to the following schedule: Total Sales Percentage $0 to 49,999 6% $50,000 to $52,999 796 over $53,000 8% lohn A Salesperson Mar Q Susan B $50.00 Avg. selling price per unit $65.00 $45.00 Avg. var, mfg. costs per unit 30.00 25.00 35.00 Number of units sold 750 1,200 1,000 Hide Prepare a contribution margin by salesperson report. Excelsior Company Contribution Margin by Salesperson For the Month Ended XXIXXDXXX Mary Q Salesperson John A. Susan B Total sales Variable mfg. cost Manufacturing margin Commissions Contribution margin per salesperson

Explanation / Answer

Sales Person Mary Q John A Sushan B Total Sales 50000 48750 54000 Variable Manufacturing Cost 25000 22500 42000 Manufacturing Margin 25000 26250 12000 Commission 3500 2925 4320 Contribution Margin per sales person 21500 23325 7680

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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