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 $612,000 $336,600 $85,680 Dix 384,000 215,040 84,480 Johnson 461,000 225,890 101,420 LaFave 460,000 147,200 101,200 Orcas 399,000 131,670 51,870 Sussman 427,000 217,770 59,780 Willbond 439,000 184,380 70,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' AnalysisFor 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 6cb470f50021fbc_1 fill in the blank 6cb470f50021fbc_2% fill in the blank 6cb470f50021fbc_3% fill in the blank 6cb470f50021fbc_4% Dix fill in the blank 6cb470f50021fbc_5 fill in the blank 6cb470f50021fbc_6% fill in the blank 6cb470f50021fbc_7% fill in the blank 6cb470f50021fbc_8% Johnson fill in the blank 6cb470f50021fbc_9 fill in the blank 6cb470f50021fbc_10% fill in the blank 6cb470f50021fbc_11% fill in the blank 6cb470f50021fbc_12% LaFave fill in the blank 6cb470f50021fbc_13 fill in the blank 6cb470f50021fbc_14% fill in the blank 6cb470f50021fbc_15% fill in the blank 6cb470f50021fbc_16% Orcas fill in the blank 6cb470f50021fbc_17 fill in the blank 6cb470f50021fbc_18% fill in the blank 6cb470f50021fbc_19% fill in the blank 6cb470f50021fbc_20% Sussman fill in the blank 6cb470f50021fbc_21 fill in the blank 6cb470f50021fbc_22% fill in the blank 6cb470f50021fbc_23% fill in the blank 6cb470f50021fbc_24% Willbond fill in the blank 6cb470f50021fbc_25 fill in the blank 6cb470f50021fbc_26% fill in the blank 6cb470f50021fbc_27% fill in the blank 6cb470f50021fbc_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. Rate of growth in sales for the current year compared with past years Years of experience for salespersons Size of sales territory Actual sales compared with budgeted sales All of the above

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 $612,000 $336,600 $85,680 Dix 384,000 215,040 84,480 Johnson 461,000 225,890 101,420 LaFave 460,000 147,200 101,200 Orcas 399,000 131,670 51,870 Sussman 427,000 217,770 59,780 Willbond 439,000 184,380 70,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' AnalysisFor 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 6cb470f50021fbc_1 fill in the blank 6cb470f50021fbc_2% fill in the blank 6cb470f50021fbc_3% fill in the blank 6cb470f50021fbc_4% Dix fill in the blank 6cb470f50021fbc_5 fill in the blank 6cb470f50021fbc_6% fill in the blank 6cb470f50021fbc_7% fill in the blank 6cb470f50021fbc_8% Johnson fill in the blank 6cb470f50021fbc_9 fill in the blank 6cb470f50021fbc_10% fill in the blank 6cb470f50021fbc_11% fill in the blank 6cb470f50021fbc_12% LaFave fill in the blank 6cb470f50021fbc_13 fill in the blank 6cb470f50021fbc_14% fill in the blank 6cb470f50021fbc_15% fill in the blank 6cb470f50021fbc_16% Orcas fill in the blank 6cb470f50021fbc_17 fill in the blank 6cb470f50021fbc_18% fill in the blank 6cb470f50021fbc_19% fill in the blank 6cb470f50021fbc_20% Sussman fill in the blank 6cb470f50021fbc_21 fill in the blank 6cb470f50021fbc_22% fill in the blank 6cb470f50021fbc_23% fill in the blank 6cb470f50021fbc_24% Willbond fill in the blank 6cb470f50021fbc_25 fill in the blank 6cb470f50021fbc_26% fill in the blank 6cb470f50021fbc_27% fill in the blank 6cb470f50021fbc_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. Rate of growth in sales for the current year compared with past years Years of experience for salespersons Size of sales territory Actual sales compared with budgeted sales All of the above

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

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	$612,000		$336,600	$85,680
Dix	384,000		215,040	84,480
Johnson	461,000		225,890	101,420
LaFave	460,000		147,200	101,200
Orcas	399,000		131,670	51,870
Sussman	427,000		217,770	59,780
Willbond	439,000		184,380	70,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' AnalysisFor 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 6cb470f50021fbc_1	fill in the blank 6cb470f50021fbc_2%	fill in the blank 6cb470f50021fbc_3%	fill in the blank 6cb470f50021fbc_4%
Dix	fill in the blank 6cb470f50021fbc_5	fill in the blank 6cb470f50021fbc_6%	fill in the blank 6cb470f50021fbc_7%	fill in the blank 6cb470f50021fbc_8%
Johnson	fill in the blank 6cb470f50021fbc_9	fill in the blank 6cb470f50021fbc_10%	fill in the blank 6cb470f50021fbc_11%	fill in the blank 6cb470f50021fbc_12%
LaFave	fill in the blank 6cb470f50021fbc_13	fill in the blank 6cb470f50021fbc_14%	fill in the blank 6cb470f50021fbc_15%	fill in the blank 6cb470f50021fbc_16%
Orcas	fill in the blank 6cb470f50021fbc_17	fill in the blank 6cb470f50021fbc_18%	fill in the blank 6cb470f50021fbc_19%	fill in the blank 6cb470f50021fbc_20%
Sussman	fill in the blank 6cb470f50021fbc_21	fill in the blank 6cb470f50021fbc_22%	fill in the blank 6cb470f50021fbc_23%	fill in the blank 6cb470f50021fbc_24%
Willbond	fill in the blank 6cb470f50021fbc_25	fill in the blank 6cb470f50021fbc_26%	fill in the blank 6cb470f50021fbc_27%	fill in the blank 6cb470f50021fbc_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.

Rate of growth in sales for the current year compared with past years
Years of experience for salespersons
Size of sales territory
Actual sales compared with budgeted sales
All of the above

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.