Salespersons' Report and Analysis 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 ended June 30 are as follows: Variable Total Variable Cost Selling Salesperson Sales of Goods Sold Expenses Asarenka 437,500 $196,875 $83,125 228,000 91,200 310,500 141,750 246,750 123,375 215,250 126,000 587,500 246,750 99,875 253,000 115,000 Crowell 570,000 Dempster 675,000 587,500 525,000 MacLean Ortiz Sullivan Williams 575,000 Required: 1. 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 percents to the nearest whole number. Enter all amounts as positive numbers. Pachec Inc. Salespersons' Analysis For the Year Ended June 30 Variable Cost of Goods Sold Variable Selling Expenses as a Percent of Sales Contribution Margin Ratio Contribution Salesperson Margin Asarenka Crowell Dempster Maclean Ortiz Sullivan as a Percent of Sales /o 0 Williams 0 2. Which salesperson generated the highest contribution margin ratio for the year