Salespersons' Report and Analysis

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 $601,000 $276,460 $78,130 Dix 404,000 133,320 84,840 Johnson 356,000 188,680 64,080 LaFave 590,000 295,000 76,700 Orcas 610,000 231,800 91,500 Sussman 459,000 192,780 78,030 Willbond 585,000 251,550 87,750 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 Tantras Tap 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 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 % % % % Orcas Sussman 9 % % Willbond % %