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	$495,000		$242,550			$79,200
Dix	473,000		170,280			75,680
Johnson	554,000		310,240			116,340
LaFave	623,000		249,200			99,680
Orcas	615,000		344,400			116,850
Sussman	424,000		220,480			55,120
Willbond	441,000		233,730			70,560

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

Waltham Industries Inc.
Salespersons' Analysis
For the Year Ended December 31
	A	B	C	D
Salesperson	Total Sales $	Variable Cost of Goods Sold $	Variable Selling Expenses $	Contribution Margin $	Variable Cost of Goods	Variable Selling Expenses	Contribution Margin
				(A - B- C )	Sold as a Percent of Sales	as a Percent of Sales	Ratio
					B/A	C/A	D/A
Case	495,000	242,550	79,200	173,250	49%	16%	35%
Dix	473,000	170,280	75,680	227,040	36%	16%	48%
Johnson	554,000	310,240	116,340	127,420	56%	21%	23%
LaFave	623,000	249,200	99,680	274,120	40%	16%	44%
Orcas	615,000	344,400	116,850	153,750	56%	19%	25%
Sussman	424,000	220,480	55,120	148,400	52%	13%	35%
Willbond	441,000	233,730	70,560	136,710	53%	16%	31%