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: Variable Selling Expenses Salesperson Total Sales Variable Cost of Goods Sold Case Dix Johnson LaFave Orcas Sussman Willbond Required: Case Dix $341,000 375,000 571,000 606,000 488,000 627,000 587,000 Johnson LaFave Orcas $115,940 135,000 279,790 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. Sussman Willbond 236,340 283,040 282,150 264,150 Variable Cost of Goods Salesperson Contribution Margin Sold as a Percent of Sales as a Percent of Sales % $51,150 75,000 108,490 84,840 78,080 112,860 105,660 Waltham Industries Inc. Salespersons' Analysis For the Year Ended December 31 1% 11% 1% 1% Variable Selling Expenses Contribution Margin % P %% %% 2. Which salesperson generated the highest contribution margin ratio for the year? Ratio P
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: Variable Selling Expenses Salesperson Total Sales Variable Cost of Goods Sold Case Dix Johnson LaFave Orcas Sussman Willbond Required: Case Dix $341,000 375,000 571,000 606,000 488,000 627,000 587,000 Johnson LaFave Orcas $115,940 135,000 279,790 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. Sussman Willbond 236,340 283,040 282,150 264,150 Variable Cost of Goods Salesperson Contribution Margin Sold as a Percent of Sales as a Percent of Sales % $51,150 75,000 108,490 84,840 78,080 112,860 105,660 Waltham Industries Inc. Salespersons' Analysis For the Year Ended December 31 1% 11% 1% 1% Variable Selling Expenses Contribution Margin % P %% %% 2. Which salesperson generated the highest contribution margin ratio for the year? Ratio P
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
$115,940
135,000
279,790
236,340
283,040
282,150
264,150
Case
Dix
Johnson
LaFave
Orcas
Sussman
Willbond
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.
Salesperson Contribution Margin
Case
Dix
Johnson
LaFave
Orcas
$341,000
375,000
571,000
606,000
488,000
627,000
587,000
Sussman
Willbond
$
$51,150
75,000
108,490
84,840
78,080
112,860
105,660
Waltham Industries Inc.
Salespersons' Analysis
For the Year Ended December 31
Variable Cost of Goods
Sold as a Percent of Sales
%
1%
%
%
1%
1%
1%
Variable Selling Expenses Contribution Margin
as a Percent of Sales
Ratio
%
%
%
1%
1%
%
%
2. Which salesperson generated the highest contribution margin ratio for the year?
1%
%
1%
%
1%
%
%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F034c8dbf-c1e3-4fe7-a5c2-11d6cef5d635%2Ffc4dd0e1-9a1f-4d0f-92fe-e287713420ae%2Fiw2y9qp_processed.png&w=3840&q=75)
Transcribed Image Text: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
$115,940
135,000
279,790
236,340
283,040
282,150
264,150
Case
Dix
Johnson
LaFave
Orcas
Sussman
Willbond
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.
Salesperson Contribution Margin
Case
Dix
Johnson
LaFave
Orcas
$341,000
375,000
571,000
606,000
488,000
627,000
587,000
Sussman
Willbond
$
$51,150
75,000
108,490
84,840
78,080
112,860
105,660
Waltham Industries Inc.
Salespersons' Analysis
For the Year Ended December 31
Variable Cost of Goods
Sold as a Percent of Sales
%
1%
%
%
1%
1%
1%
Variable Selling Expenses Contribution Margin
as a Percent of Sales
Ratio
%
%
%
1%
1%
%
%
2. Which salesperson generated the highest contribution margin ratio for the year?
1%
%
1%
%
1%
%
%
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F034c8dbf-c1e3-4fe7-a5c2-11d6cef5d635%2Ffc4dd0e1-9a1f-4d0f-92fe-e287713420ae%2Fz5lmzac_processed.png&w=3840&q=75)
Transcribed Image Text: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
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education