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 salesper during the year ended December 31 are as follows: Salesperson Total Sales Variable Cost of Goods Sold Variable Selling Expenses Case $568,000 $318,080 $119,280 Dix 493,000 202.130 78,880 Johnson 496,000 287,680 64,480 LaFave 623,000 205,590 137,060 Orcas 452,000 176,280 85,830 Sussman 530,000 222,600 79,500 Willbond 537,000 295,350 96,660 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 contribut margin ratio by salesperson, Round percents to the nearest whole number, inter all amounts as positive numbers Waltham Industries Inc. Salespersons' Analysis For the Year Ended December 31 Salesperson contribution Margin Variable Cost of Goods Variable Selling Expenses Contribution Margin Sold as a Percent of Sales as a Percent of Sales Ratio Case Dix Johnson LaFave 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 at amounts as positive numbers Waltham Industries Inc. Salespersons' Analysis For the Year Ended December 31 Salesperson Contribution Margin Variable Cost of Goods Variable Selling Expenses Contribution Margin Sold as a Percent of Sales as a Percent of Sales Ratio Case Dix Johnson La Fave 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 5. All of the above