Managerial Accounting
15th Edition
ISBN: 9781337912020
Author: Carl Warren, Ph.d. Cma William B. Tayler
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 7, Problem 4PA
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:
Instructions
- 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 whole percent to one digit after decimal point.)
- 2. Which salesperson generated the highest contribution margin ratio for the year and why?
- 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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
TotalSales
Variable Costof Goods Sold
VariableSellingExpenses
Case
$610,000
Â
$268,400
Â
$109,800
Â
Dix
603,000
Â
241,200
Â
96,480
Â
Johnson
588,000
Â
305,760
Â
105,840
Â
LaFave
586,000
Â
281,280
Â
123,060
Â
Orcas
616,000
Â
221,760
Â
86,240
Â
Sussman
620,000
Â
310,000
Â
124,000
Â
Willbond
592,000
Â
272,320
Â
88,800
Â
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.
Walthman Industries Inc.
Salespersons' Analysis
For the Year Ended December 31
Salesperson
Contribution Margin
Variable Cost of…
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
$349,000
Â
$115,170
Â
Â
$69,800
Â
Â
Dix
346,000
Â
138,400
Â
Â
55,360
Â
Â
Johnson
588,000
Â
217,560
Â
Â
76,440
Â
Â
LaFave
533,000
Â
202,540
Â
Â
90,610
Â
Â
Orcas
557,000
Â
245,080
Â
Â
72,410
Â
Â
Sussman
344,000
Â
196,080
Â
Â
72,240
Â
Â
Willbond
408,000
Â
159,120
Â
Â
61,200
Â
Â
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
Salesperson…
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
$349,000
Â
$115,170
Â
Â
$69,800
Â
Â
Dix
346,000
Â
138,400
Â
Â
55,360
Â
Â
Johnson
588,000
Â
217,560
Â
Â
76,440
Â
Â
LaFave
533,000
Â
202,540
Â
Â
90,610
Â
Â
Orcas
557,000
Â
245,080
Â
Â
72,410
Â
Â
Sussman
344,000
Â
196,080
Â
Â
72,240
Â
Â
Willbond
408,000
Â
159,120
Â
Â
61,200
Â
Â
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…
Chapter 7 Solutions
Managerial Accounting
Ch. 7 - What types of costs are customarily included in...Ch. 7 - Which type of manufacturing cost (direct...Ch. 7 - Which of the following costs would be included in...Ch. 7 - In the variable costing income statement, how are...Ch. 7 - Prob. 5DQCh. 7 - Prob. 6DQCh. 7 - Discuss how financial data prepared on the basis...Ch. 7 - Prob. 8DQCh. 7 - Explain why rewarding sales personnel on the basis...Ch. 7 - Explain why service companies use different...
Ch. 7 - Variable costing Marley Company has the following...Ch. 7 - Prob. 2BECh. 7 - Variable costingsales exceed production The...Ch. 7 - Prob. 4BECh. 7 - Contribution margin by segment The following...Ch. 7 - At the end of the first year of operations, 21,500...Ch. 7 - Gallatin County Motors Inc. assembles and sells...Ch. 7 - Fresno Industries Inc. manufactures and sells...Ch. 7 - On March 31, the end of the first month of...Ch. 7 - On April 30, the end of the first month of...Ch. 7 - On October 31, the end of the first month of...Ch. 7 - The following data were adapted from a recent...Ch. 7 - Estimated income statements, using absorption and...Ch. 7 - The following data were adapted from a recent...Ch. 7 - Prob. 10ECh. 7 - Explain why service companies use different...Ch. 7 - Galaxy Sports Inc. manufactures and sells two...Ch. 7 - Prob. 13ECh. 7 - Sales territory and salesperson profitability...Ch. 7 - Prob. 15ECh. 7 - Prob. 16ECh. 7 - Variable costing income statement for a service...Ch. 7 - Variable costing income statement for a service...Ch. 7 - Prob. 1PACh. 7 - The demand for solvent, one of numerous products...Ch. 7 - During the first month of operations ended May 31,...Ch. 7 - Salespersons report and analysis Walthman...Ch. 7 - Segment variable costing income statement and...Ch. 7 - Absorption and variable costing income statements...Ch. 7 - Income statements under absorption costing and...Ch. 7 - Absorption and variable costing income statements...Ch. 7 - Prob. 4PBCh. 7 - Variable costing income statement and effect on...Ch. 7 - Prob. 1MADCh. 7 - Prob. 2MADCh. 7 - Prob. 3MADCh. 7 - Segment disclosure by Apple Inc. (AAPL) provides...Ch. 7 - Prob. 1TIFCh. 7 - Inventory effects under absorption costing BendOR,...Ch. 7 - Communication Bon Jager Inc. manufactures and...Ch. 7 - Prob. 1CMACh. 7 - Chassen Company, a cracker and cookie...Ch. 7 - Prob. 3CMACh. 7 - Bethany Company has just completed the first month...
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.Similar questions
- 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: Instructions 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 whole percent to one digit after decimal point.) 2. Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.arrow_forwardUsing the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forward
- Use the following information for Exercises 2-47 through 2-49. Jasper Company provided the following information for last year: Last year, beginning and ending inventories of work in process and finished goods equaled zero. Exercise 2-49 Income Statement Refer to the information for Jasper Company on the previous page. Required: 1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for each line item on the income statement. (Note: Round percentages to the nearest tenth of a percent.) 2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the income statement created for Requirement 1 to better control costs.arrow_forwardWalthman 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: Total Sales Variable Cost of Goods Sold Variable Selling Expenses Salesperson Case $610,000 $268,400 $109,800 Dix 603,000 241,200 96,480 Johnson 588,000 305,760 105,840 LaFave 586,000 281,280 123,060 Orcas 616,000 221,760 86,240 Sussman 620,000 310,000 124,000 Willbond 592,000 272,320 88,800 Instructions 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 whole percent. 2. - Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.arrow_forwardSalespersons' 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…arrow_forward
- 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…arrow_forwardSalespersons' 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…arrow_forwardSalespersons' 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 $581,000 $284,690 $122,010 Dix 576,000 247,680 92,160 Johnson 587,000 246,540 129,140 LaFave 461,000 207,450 96,810 Orcas 525,000 194,250 84,000 Sussman 492,000 241,080 78,720 Willbond 426,000 187,440 55,380 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 Variable Cost of Goods Variable Selling Expenses Contribution Margin Salesperson Contribution…arrow_forward
- 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:arrow_forwardSalespersons' 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 $424,000 $233,200 $80,560      Dix 371,000 178,080 63,070      Johnson 469,000 262,640 75,040      LaFave 586,000 334,020 111,340      Orcas 538,000 199,060 91,460      Sussman 529,000 185,150 116,380      Willbond 569,000 216,220 91,040      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…arrow_forwardSalespersons' 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 $424,000  $233,200   $80,560   Dix 371,000  178,080   63,070   Johnson 469,000  262,640   75,040   LaFave 586,000  334,020   111,340   Orcas 538,000  199,060   91,460   Sussman 529,000  185,150   116,380   Willbond 569,000  216,220   91,040   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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
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
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cost-Volume-Profit (CVP) Analysis and Break-Even Analysis Step-by-Step, by Mike Werner; Author: Accounting Step by Step;https://www.youtube.com/watch?v=D0MOfse9OWk;License: Standard Youtube License