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 are shown below.

Commissions are earned according to the following schedule:

Total Sales		Percentage
$0 to 49,999		6%
$50,000 to $52,999		7%
Over $53,000		8%

Salesperson		Mary Q.		John A.		Susan B.
Avg. selling price per unit		$50.00		$65.00		$45.00
Avg. var. mfg. costs per unit		25.00		30.00		35.00
Number of units sold		1,000		750		1,200

Prepare a contribution by salesperson report.

Excelsior Company Contribution Margin by Salesperson For the Month Ended XX/XX/XXXX

Salesperson	Mary Q.	John A.	Susan B.
Total sales	$fill in the blank 1	$fill in the blank 2	$fill in the blank 3
Variable mfg. cost	fill in the blank 4	fill in the blank 5	fill in the blank 6
Manufacturing margin	$fill in the blank 7	$fill in the blank 8	$fill in the blank 9
Commissions	fill in the blank 10	fill in the blank 11	fill in the blank 12
Contribution margin per salesperson	$fill in the blank 13	$fill in the blank 14	$fill in the blank 15