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	$560,000		$218,400			$84,000
Dix	497,000		288,260			99,400
Johnson	501,000		220,440			110,220
LaFave	332,000		109,560			59,760
Orcas	562,000		179,840			78,680
Sussman	448,000		219,520			58,240
Willbond	539,000		291,060			86,240

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	$	%	%	%
Dix		%	%	%
Johnson		%	%	%
LaFave		%	%	%
Orcas		%	%	%
Sussman		%	%	%
Willbond		%	%	%

Answer 1

Contribution Margin = sales - Variable cost

Contribution MArgin Ratio = contribution MArgin / Sales