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 $514,000 $246,720 $92,520 Dix 380,000 148,200 68,400 455,000 209,300 86,450 Johnson 297,360 106,200 LaFave 531,000 630,000 226,800 88,200 Orcas 219,520 89,600 Sussman 448,000 198,800 63,900 Willbond 355,000 Required:
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 $514,000 $246,720 $92,520 Dix 380,000 148,200 68,400 455,000 209,300 86,450 Johnson 297,360 106,200 LaFave 531,000 630,000 226,800 88,200 Orcas 219,520 89,600 Sussman 448,000 198,800 63,900 Willbond 355,000 Required:
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

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
Case
$514,000
$246,720
$92,520
Dix
380,000
148,200
68,400
Johnson
455,000
209,300
86,450
LaFave
531,000
297,360
106,200
226,800
88,200
Orcas
630,000
219,520
89,600
Sussman
448,000
355,000
198,800
006
Willbond
Required:

Transcribed Image Text: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
Variable Cost of Goods
Variable Selling Expenses Contribution Margin
Salesperson Contribution Margin
Ratio
Sold as a Percent of Sales
as a Percent of Sales
%
Case
Dix
Johnson
LaFave
Orcas
Sussman
Willbond
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps

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


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