Chapter 21 Homework eBook Pri tem Salespersons' Report and Analysis Walthman Industries 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 December 31 are as follows: Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses Case $402,000 $201,000 $76,380 Dix 362,000 195,480 54,300 Johnson 586,000 187,520 76,180 LaFave 577,000 219,260 99,090 Orcas 512,000 168,960 102,400 Sussman 610,000 305,000 91,500 Willbond 471,000 188.400 75,360 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. Waltham Industries Inc. Salespersons' Analysis For the Year Ended December 31 Variable Cost of Goods Salesperson contribution Margin Sold as a Percent of Sales as a Percent of Sales Variable Selling Expenses Contribution Margin Ratio Case Chapter 21 Homework ebook Print item 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. Waltham Industries Inc. Salespersons' Analysis For the Year Ended December 31 Salesperson contribution Margin Sold as a Percent of Sales as a Percent of Sales Variable Cost of Goods Variable Selling Expenses contribution Margin Ratio Case DIX Johnson Lafave Orcas % Sussman Willbond 2. Which salesperson generated the highest contribution margin ratio for the year? 3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons. 1. Rate of growth in sales for the current year compared with past years 2. Years of experience for salespersons 3. Size of sales territory 4. Actual sales compared with budgeted sales