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