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 $429,000 $184,470 $90,090 Dix 417,000 212,670 58,380 Johnson 465,000 195,300 102,300 LaFave 585,000 204,750 87,750 Orcas 418,000 229,900 66,880 Sussman 407,000 215,710 85,470 Willbond 580,000 191,400 127,600
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 $429,000 $184,470 $90,090 Dix 417,000 212,670 58,380 Johnson 465,000 195,300 102,300 LaFave 585,000 204,750 87,750 Orcas 418,000 229,900 66,880 Sussman 407,000 215,710 85,470 Willbond 580,000 191,400 127,600
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 | |||||
Case | $429,000 | $184,470 | $90,090 | |||||
Dix | 417,000 | 212,670 | 58,380 | |||||
Johnson | 465,000 | 195,300 | 102,300 | |||||
LaFave | 585,000 | 204,750 | 87,750 | |||||
Orcas | 418,000 | 229,900 | 66,880 | |||||
Sussman | 407,000 | 215,710 | 85,470 | |||||
Willbond | 580,000 | 191,400 | 127,600 |
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 |
Expert Solution
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 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education