Question

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	$342,000		$181,260			$58,140
Dix	571,000		211,270			125,620
Johnson	360,000		136,800			75,600
LaFave	435,000		143,550			65,250
Orcas	557,000		256,220			105,830
Sussman	452,000		153,680			85,880
Willbond	469,000		272,020			93,800

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
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	$fill in the blank 50f122f9dfa3040_1	fill in the blank 50f122f9dfa3040_2%	fill in the blank 50f122f9dfa3040_3%	fill in the blank 50f122f9dfa3040_4%
Dix	fill in the blank 50f122f9dfa3040_5	fill in the blank 50f122f9dfa3040_6%	fill in the blank 50f122f9dfa3040_7%	fill in the blank 50f122f9dfa3040_8%
Johnson	fill in the blank 50f122f9dfa3040_9	fill in the blank 50f122f9dfa3040_10%	fill in the blank 50f122f9dfa3040_11%	fill in the blank 50f122f9dfa3040_12%
LaFave	fill in the blank 50f122f9dfa3040_13	fill in the blank 50f122f9dfa3040_14%	fill in the blank 50f122f9dfa3040_15%	fill in the blank 50f122f9dfa3040_16%
Orcas	fill in the blank 50f122f9dfa3040_17	fill in the blank 50f122f9dfa3040_18%	fill in the blank 50f122f9dfa3040_19%	fill in the blank 50f122f9dfa3040_20%
Sussman	fill in the blank 50f122f9dfa3040_21	fill in the blank 50f122f9dfa3040_22%	fill in the blank 50f122f9dfa3040_23%	fill in the blank 50f122f9dfa3040_24%
Willbond	fill in the blank 50f122f9dfa3040_25	fill in the blank 50f122f9dfa3040_26%	fill in the blank 50f122f9dfa3040_27%	fill in the blank 50f122f9dfa3040_28%

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

Answer 1