Salespersons' Report and Analysis

Tavaris Instruments Company employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows:

Salesperson Ainge Brohm Total Sales $466,000 334,000 364,000 352,000 439,000 560,000 615,000 Variable Cost of Goods Sold Variable Selling Expenses Harrell Losman Null Skelton $223,680 173,680 163,800 116,160 210,720 319,200 319,800 $97,860 66,800 80,080 52,800 70,240 123,200 110,700 Required 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 al amounts as positive numbers Tavaris Instruments Company Salespersons' Analysis For the Year Ended December 31 Salesperson Ainge Brohm Carr Harrell Losman Null Skelton Contribution Margin Variable Cost of Goods Sold as a Percent of Sales Variable Selling Expenses as a Percent of Sales Contribution Margin Ratio