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 $380,000 $129,200 $68,400
Dix 603,000 241,200 96,480
Johnson
588,000
305,760
105,840
LaFave
586,000
281,280
123,060
Orcas
616,000
221,760
86,240
Sussman
620,000
310,000
124,000
Willbond
592,000
272,320
88,800
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 all amounts as positive numbers.
Walthman Industries Inc.
Salespersons' Analysis
For the Year Ended December 31
Salesperson
Contribution Margin
Variable Cost of Goods Sold as a Percent of Sales
Variable Selling Expenses as a Percent of Sales
Contribution Margin Ratio
Case
$
%
%
%
Dix
%
%
%
Johnson
%
%
%
LaFave
%
%
%
Orcas
%
%
%
Sussman
%
%
%
Willbond
%
%
%