Sales territory and salesperson profitability analysis
Havasu Off-Road Inc. manufactures and sells a variety of commercial vehicles in the Northeast and Southwest regions. There are two salespersons assigned to each territory. Higher commission rates go to the most experienced salespersons. The following sales statistics are available for each salesperson:
- a. 1. Prepare a contribution margin by salesperson report. Compute the contribution margin ratio for each salesperson.
2. Interpret the report.
- b. 1. Prepare a contribution margin by territory report. Compute the contribution margin for each territory as a percent, rounded to one decimal place.
2. Interpret the report.
A.1.
![Check Mark](/static/check-mark.png)
Calculate the contribution margin ratio for each salesperson.
Explanation of Solution
Variable Costing
Managers frequently use variable costing for internal purposes for taking decision making. The cost of goods manufactured includes direct materials, direct labor, and variable factory overhead. Fixed factory overhead treated as period (fixed) expense.
Contribution Margin
Contribution margin is the excess of manufacturing margin above selling and administrative expenses. Contribution margin is calculated by deducting the variable cost from sales or deducting variable selling and administrative expenses from manufacturing margin.
The contribution margin ratio for each salesperson is as follows:
Rene
HO Incorporation | |
Contribution margin by salesperson (Northeast) | |
Particulars | Rene ($) |
Sales | 558,000 |
Less: Variable cost | 334,800 |
Manufacturing margin | 223,200 |
Less: Variable selling expense | 44,640 |
Contribution margin (B) | 178,560 |
Contribution margin ratio | 32.00% |
Table (1)
Steve
HO Incorporation | |
Contribution margin by salesperson (Northeast) | |
Particulars | Steve($) |
Sales | 384,000 |
Less: Variable cost | 192,000 |
Manufacturing margin | 192,000 |
Less: Variable selling expense | 46,080 |
Contribution margin (B) | 145,920 |
Contribution margin ratio | 38.00% |
Table (2)
Colleen
HO Incorporation | |
Contribution margin by salesperson (Southwest) | |
Particulars | Colleen($) |
Sales | 560,000 |
Less: Variable cost | 336,000 |
Manufacturing margin | 224,000 |
Less: Variable selling expense | 56,000 |
Contribution margin (B) | 168,000 |
Contribution margin ratio | 30.00% |
Table (3)
Paul
HO Incorporation | |
Contribution margin by salesperson (Southwest) | |
Particulars | Paul($) |
Sales | 1,080,000 |
Less: Variable cost | 540,000 |
Manufacturing margin | 540,000 |
Less: Variable selling expense | 86,400 |
Contribution margin (B) | 453,600 |
Contribution margin ratio | 42.00% |
Table (4)
Therefore, contribution margin of Rene is $178,560, Steve is $145,920, Colleen is $168,000, and Paul is $453,600. Contribution margin ratio of Rene is 32%, Steve is 38%, Colleen is 30%, and Paul is 42%.
A.2.
![Check Mark](/static/check-mark.png)
Interpret the profitability report of the salesperson.
Explanation of Solution
Contribution margin and contribution margin ratio of salesperson Paul is higher than the other three salespeople because he sells the more units than others, has a low commission rate, and product mix with high manufacturing margin ratio. Salesperson Rene has a second-highest total contribution margin of $178,560, and Steve has second highest contribution margin ratio of 38%.
B.1.
![Check Mark](/static/check-mark.png)
Calculate the contribution margin ratio for each territory.
Explanation of Solution
The contribution margin ratio for each territory is as follows:
Northeast
HO Incorporation | |
Contribution margin by territory | |
Particulars | Northeast |
Sales | 942,000 |
Less: Variable cost | 526,800 |
Manufacturing margin | 415,200 |
Less: Variable selling expense | 90,720 |
Contribution margin (B) | 324,480 |
Contribution margin ratio | 34.45% |
Table (5)
Southwest
HO Incorporation | |
Contribution margin by territory | |
Particulars | Southwest |
Sales | 1,640,000 |
Less: Variable cost | 876,000 |
Manufacturing margin | 764,000 |
Less: Variable selling expense | 142,400 |
Contribution margin (B) | 621,600 |
Contribution margin ratio | 37.90% |
Table (6)
B. 2.
![Check Mark](/static/check-mark.png)
State the advice regarding the relative profitability of two territories.
Explanation of Solution
The southwest region contribution margin and contribution margin ratio are higher than the northeast region because the southwest region has $698,000 more sales and $297,120 more contribution margin. In addition, the salesperson in the southwest region has the highest unit sold, highest sales price and lowest commission margin. In the northeast region, salespersons are performed very poor than others, and they are trying to improve their sales performance.
Want to see more full solutions like this?
Chapter 7 Solutions
Managerial Accounting
- Sales Territory and Salesperson Profitability Analysis Havasu Off-Road Inc. manufactures and sells a variety of commercial vehicles in the Northeast and Southwest regions. There are two salespersons assigned to each territory. Higher commission rates go to the most experienced salespersons. The following sales statistics are available for each salesperson: Line Item Description NortheastRene NortheastSteve SouthwestColleen SouthwestPaul Average per unit: Sales price $15,500 $16,000 $14,000 $18,000 Variable cost of goods sold $9,300 $8,000 $8,400 $9,000 Commission rate 8% 12% 10% 8% Units sold 36 24 40 60 Manufacturing margin ratio 40% 50% 40% 50% Question Content Area a. 1. Prepare a contribution margin by salesperson report. Compute the contribution margin ratio for each salesperson. Havasu Off-Road Inc.Contribution Margin by Salesperson Line Item Description Rene Steve Colleen Paul…arrow_forwardSales Territory and Salesperson Profitability Analysis Havasu Off-Road Inc. manufactures and sells a variety of commercial vehicles in the Northeast and Southwest regions. There are two salespersons assigned to each territory. Higher commission rates go to the most experienced salespersons. The following sales statistics are available for each salesperson: Northeast Southwest Rene Steve Colleen Paul Average per unit: Sales price $15,500 $16,000 $14,000 $18,000 Variable cost of goods sold $9,300 $8,000 $8,400 $9,000 Commission rate 8% 12% 10% 8% Units sold 36 24 40 60 Manufacturing margin ratio 40% 50% 40% 50% a. 1. Prepare a contribution margin by salesperson report. Compute the contribution margin ratio for each salesperson. Havasu Off-Road Inc. Contribution Margin by Salesperson Rene Steve Colleen Paul $ $ $ $ $ $ $ $ $ $ $ $ Contribution margin ratio % %…arrow_forwardHow to calculate profitability analysis?arrow_forward
- Dogarrow_forwardPlease help me with all answers thankuarrow_forwardTerritory and Product Profitability Analysis Pipeline Surfboards Inc. manufactures and sells two styles of surfboards, Atlantic Wave and Pacific Pounder. These surfboards are sold in two regions, East Coast and West Coast. Information about the two surfboards is as follows: Atlantic Wave Pacific Pounder Sales price Variable cost of goods sold per unit Manufacturing margin per unit Variable selling expense per unit Contribution margin per unit The sales unit volume for the sales territories and products for the period is as follows: East Coast West Coast 2,960 Line Item Description Sales Variable cost of goods sold Manufacturing margin Variable selling expenses Contribution margin 0 Pipeline Surfboards Inc. Contribution Margin by Territory Contribution margin ratio 1,480 1,480 Atlantic Wave a. Prepare a contribution margin by sales territory report. Compute the contribution margin ratio for each territory. Round contribution margin ratio answers to two decimal places. $ $300 (111) $189…arrow_forward
- Territory and Product Profitability Analysis Pipeline Surfboards Inc. manufactures and sells two styles of surfboards, Atlantic Wave and Pacific Pounder. These surfboards are sold in two regions, East Coast and West Coast. Information about the two surfboards is as follows: Atlantic Wave Pacific Pounder Sales price Variable cost of goods sold per unit Manufacturing margin per unit Variable selling expense per unit Contribution margin per unit) The sales unit volume for the sales territories and products for the period is as follows: East Coast West Coast 2,460 1,230 1,230 Atlantic Wave Pacific Pounder 0 Pipeline Surfboards Inc. Contribution Margin by Territory Line Item Description Salee $450 (167) $283 (184) $99 a. Prepare a contribution margin by sales territory report. Compute the contribution margin ratio for each territory. Round contribution margin ratio answers to two decimal places. $400 (188) $212 (100) $112 East Coast West Coastarrow_forwardTennair Corporation manufactures cooling system components. The company has gathered the following information about two of its customers: Evans Equipment and Rogers Refrigeration. Evans Equipment Sales revenue Rogers Refrigeration $ 160,000 61,000 Cost of goods sold General selling costs $ 229,000 102,000 37,000 23,800 28,500 General administrative costs 17,850 Cost-driver data used by the firm and traceable to Evans and Rogers are: Customer Activity Sales activity Order taking Special handling Special shipping Customer Activity Sales activity Order taking Special handling Special shipping Cost Driver Sales visits Sales orders Units handled Shipments Evans Equipment 12 visits 31 orders 460 units. 33 shipments Pool Rate $ 970 278 44 460 Rogers Refrigeration 9 visits 36 orders 410 units 44 shipments Required: A. Perform a customer profitability analysis for Tennair. Compute the gross margin and operating income on transactions related to Evans Equipment and Rogers Refrigeration.arrow_forwardAnalyzing profitability Father Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow: Father Furniture has three sales representatives: Adam, Ben, and Caleb. Adam sold 100 tables With 6 chairs each. Ben sold 110 tables With 4 chairs each. Caleb sold 80 tables with 8 chairs each. Requirements Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimal places). Which sales representative has the highest contribution margin ratio? Explain Whyarrow_forward
- APPLY THE CONCEPTS: Target income (sales revenue) Another useful method for figuring out the type of performance your company will need to reach a target income is by using sales revenue. Rather than using the number of units, this method uses total sales revenue. In companies for which the total set of goods produced and sold is more varied, this would be the preferred method, as opposed to a business in which only one product is sold. Assume a company has pricing and cost information as follows: Price and Cost Information Amount Selling Price per Unit $30 Variable Cost per Unit $15 Total Fixed Cost $15,000 For the upcoming period, the company wishes to generate operating income of $40,000. Given the cost and pricing structure for the company’s product, how much sales revenue must it generate to attain its target income? Step 1: Calculate the contribution margin ratio: The contribution margin ratio is the contribution margin in proportion to the selling price on a…arrow_forwardAnalyzing profitability Relative Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow: Relative Furniture has three sales representatives: Abe, Brett, and Corrin. Abe sold 50 tables With 4 Chairs each. Brett sold 110 tables With 6 chairs each. Corrin sold 90 tables with 8 chairs each. Requirements Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimal places). Which sales representative has the highest contribution margin ratio? Explain why.arrow_forwardTerritory and Product Profitability Analysis Coast to Coast Surfboards Inc. manufactures and sells two styles of surfboards, Atlantic Wave and Pacific Pounder. These surfboards are sold in two regions, East Coast and West Coast. Information about the two surfboards is as follows: Atlantic Wave Pacific Pounder Sales price $450 $400 Variable cost of goods sold per unit (167) (196) Manufacturing margin per unit $283 $204 Variable selling expense per unit (202) (92) Contribution margin per unit $81 $112 The sales unit volume for the territories and products for the period is as follows: East Coast West Coast Atlantic Wave 3,600 1,800 Pacific Pounder 1,800 a. Prepare a contribution margin by sales territory report. Compute the contribution margin ratio for each territory as a whole percent, rounded to two decimal places, if required. Coast to Coast Surfboards Inc. Contribution Margin by Territoryarrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)