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 $372,000 $197,160 $70,680 Dix 566,000 277,340 113,200 Johnson 594,000 308,880 118,800 LaFave 344,000 172,000 51,600 Orcas 346,000 110,720 58,820 Sussman 559,000 318,630 72,670 Willbond 395,000 134,300 75,050 Required:
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 $372,000 $197,160 $70,680 Dix 566,000 277,340 113,200 Johnson 594,000 308,880 118,800 LaFave 344,000 172,000 51,600 Orcas 346,000 110,720 58,820 Sussman 559,000 318,630 72,670 Willbond 395,000 134,300 75,050 Required:
Financial And Managerial Accounting
15th Edition
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:WARREN, Carl S.
Chapter21: Variable Costing For Management
analysis
Section: Chapter Questions
Problem 4PA: Salespersons report and analysis Walthman Industries Inc. employs seven salespersons to sell and...
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 | $372,000 | $197,160 | $70,680 | |||||
Dix | 566,000 | 277,340 | 113,200 | |||||
Johnson | 594,000 | 308,880 | 118,800 | |||||
LaFave | 344,000 | 172,000 | 51,600 | |||||
Orcas | 346,000 | 110,720 | 58,820 | |||||
Sussman | 559,000 | 318,630 | 72,670 | |||||
Willbond | 395,000 | 134,300 | 75,050 |
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 | ||||
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.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
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 And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning