Question

Pachec Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year Salespersons' report and analysis ended June 30 are as follows: Variable Selling Expenses Variable Cost of Goods Sold Total Sales Salesperson $ 83,125 91,200 141,750 Asarenka $437,500 $196,875 Crowell 228,000 570,000 Dempster 310,500 675,000 123,375 MacLean 587,500 246,750 126,000 99,875 115,000 Ortiz 525,000 215,250 Sullivan 587,500 246,750 Williams 575,000 253,000 Instructions Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. (Round whole percent to one digit after decimal point.)

Answer 1

Salesperson	Contribution margin	Variable cost of goods sold percentage	Variable selling expenses percentage	Contribution margin ratio
Asarenka	$157500	(196875*100/437500)= 45%	(83125*100/437500)= 19%	(157500*100/437500)= 36%
Crowell	$250800	(228000*100/570000)= 40%	(91200*100/570000)= 16%	(250800*100/570000)= 44%
Dempster	$222750	(310500*100/675000)= 46%	(141750*100/675000)= 21%	(222750*100/675000)= 33%
MacLean	$217375	(246750*100/587500)= 42%	(123375*100/587500)= 21%	(217375*100/587500)= 37%
Ortiz	$183750	(215250*100/525000)= 41%	(126000*100/525000)= 24%	(183750*100/525000)= 35%
Sullivan	$240875	(246750*100/587500)= 42%	(99875*100/587500)= 17%	(240875*100/587500)= 41%
Williams	$207000	(253000*100/575000)= 44%	(115000*100/575000)= 20%	(207000*100/575000)= 36%

Contribution margin= Sales-Variable cost of goods sold-Variable selling expenses

Asarenka= $437500-196875-83125= $157500

Crowell= $570000-228000-91200= $250800

Dempster= $675000-310500-141750= $222750

MacLean= $587500-246750-123375= $217375

Ortiz= $525000-215250-126000= $183750

Sullivan= $587500-246750-99875= $240875

Williams= $575000-253000-115000= $207000