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:
Northeast | Southwest | |||||||
Rene | Steve | Colleen | Paul | |||||
Average per unit: | ||||||||
Sales price | $12,400 | $15,200 | $9,600 | $18,100 | ||||
Variable cost of goods sold | $7,440 | $9,120 | $6,144 | $7,240 | ||||
Commission rate | 8% | 12% | 11% | 9% | ||||
Units sold | 33 | 24 | 36 | 42 | ||||
Manufacturing margin ratio | 40% | 40% | 36% | 60% |
a. 1. Prepare a contribution margin by salesperson report. Calculate the contribution margin ratio for each salesperson. If required, round contribution margin ratio to one decimal place.
Havasu Off-Road Inc. | ||||
Contribution Margin by Salesperson | ||||
Rene | Steve | Colleen | Paul | |
$ | $ | $ | $ | |
$ | $ | $ | $ | |
$ | $ | $ | $ | |
Contribution margin ratio | % | % | % | % |
a. 2. Interpret the report.
Paul earns the contribution margin and has the contribution margin ratio. This is because he sells the units, has a commission rate, and sells a product mix with a manufacturing margin. Steve also sells products with a average manufacturing margin but at a commission rate. Colleen has the contribution margin ratio among the four salespersons. Although Rene has a high variable cost of goods sold and also sells products with a average sales price per unit, she has the second total contribution margin.
b. 1. Prepare a contribution margin by territory report. Calculate the contribution margin for each territory as a percent, rounded to one decimal place.
Havasu Off-Road Inc. | ||
Contribution Margin by Territory | ||
Northeast | Southwest | |
$ | $ | |
$ | $ | |
$ | $ | |
Contribution margin ratio | % | % |
b. 2. Interpret the report.
b. 2. Interpret the report.
The Southwest Region has $ ____more sales and $ _____ more contribution margin.
Ans-a-1-Havasu Off-road Inc.
Contribution Margin by Salesperson
Rene | Steve | Colleen | Paul | |
Sales |
$409,200 ($12,400 *33) |
$364,800 ($15,200* 24) |
$345,600 ($9,600 *36) |
$760,200 ($18,100*42) |
Less: Variable cost of goods sold |
245,520 ($7,440 *33) |
218,880 ($91,20 * 24) |
221,184 ($6,144 *36) |
304,080 ($7,240 *42) |
Manufacturing Margin | 163,680 | 145,920 | 124,416 | 456,120 |
Less: Variable commission expenses |
32,736 ($409,200*8%) |
43,776 ($364,800 *12%) |
38,016 ($345,600* 11%) |
68,418 ($760,200*9%) |
Contribution Margin | 130,944 | 102,144 | 86,400 | 387,702 |
Contribution Margin Ratio (Contribution / Sales * 100) |
32% | 28% | 25% | 51% |
a-2- Interpret the report :-
Paul earns the highest contribution margin and has the highest contribution margin ratio. This is because he sells the most units, has a low commission rate, and sells a product mix with a high manufacturing margin. Steve also sells products with a high average manufacturing margin but at a high commission rate. Colleen has the poorest contribution margin ratio among the four salespersons. Although Rene has a high variable cost of goods sold and also sells products with a low average sales price per unit, she has the second highest total contribution margin.
b-1-
Havasu Off-Road Inc. | ||
Contribution Margin by Territory | ||
Northeast | Southwest | |
Sales | $774,000 | $1,105,800 |
Less:Variable cost of good sold | 464,400 | 525,264 |
Manufacturing Margin | $309,600 | $580,536 |
Less: Variable commission expenses | 76,512 | 106,434 |
Contribution Margin | $233,088 | $474,102 |
Contribution margin ratio (Contribution / Sales *100) | 30.11% | 42.87% |
b-2-The Southwest Region has $ 331,800 ($1,105,800-$774,000) more sales and $241,014 ($474,102-$233,088) more contribution margin.
Sales Territory and Salesperson Profitability Analysis Havasu Off-Road Inc. manufactures and sells a variety of commercial...
eBook Calculator Territory 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 $400 $350 Variable cost of goods sold per unit (148) (161) Manufacturing margin per unit $252 $189 Variable selling expense per unit (172) (91) Contribution margin per unit $80 $98...
Territory 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) (192) Manufacturing margin per unit $283 $208 Variable selling expense per unit (202) (104) Contribution margin per unit $81 $104 The sales...
Territory 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 $267 $189 Variable cost of goods sold per unit 105 105 Manufacturing margin per unit $162 $84 Variable selling expense per unit 144 72 Contribution margin per unit $18 $12 The sales...
Please do show work thank you! Territory 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 Sales price $400 (148) Pacific Pounder $350 (165) Variable cost of goods sold per unit $252 $185 Manufacturing margin per unit Variable selling expense per unit (172) (101) Contribution margin...
Salespersons Report and Analysis Walthman Industries Inc. ample salesperson to sell and distribute its product throughout the state. Data taken from reported from the salesperson during the year anded December 31 are as follow Salesperson Total Sales Variable cost of Goods Sold Variable Selling Expenses Casa 5595,000 $333,200 5124,950 DE 463,000 157,420 97,230 429,000 171,600 Lave 518,000 202,020 77,700 625,000 300,480 125,200 Suman 395,000 158,000 82,950 Witband 522,000 229,60 114,840 Required: . Prepare al Labile indicating contribution margin, variable cost...
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 $502,000 $225,900 $105,420 Dix 569,000 244,670 91,040 Johnson 599,000 227,620 95,840 LaFave 614,000 251,740 92,100 Orcas 442,000 176,800 83,980 Sussman 602,000 343,140 102,340 Willbond 560,000 229,600 84,000 Required: 1. Prepare a table...
5. Product Profitability Analysis Galaxy Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Conquistador and Hurricane, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: Conquistador Hurricane Sales price $6,400 $4,200 Variable cost of goods sold (4,030) (2,810) Manufacturing margin $2,370 $1,390 Variable selling expenses (1,026) (676) Contribution margin $1,344 $714 Fixed expenses (630) (290) Operating income $714 $424 In addition,...
Yower Train Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Mountain Monster and Desert Dragon, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is ivailable for the two products: Mountain Monster Desert Dragon Sales price $5,200.00 $5,300.00 Variable cost of goods sold 3,240.00 3,450.00 Manufacturing margin $1,850.00 $1,960.00 712.00 Variable selling expenses 1.108.00 Contribution margin $1,248.00 $742.00 Fixed expenses 470.00 320.00 Income from operations $778.00 $422.00...
Power Train Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATV), the Mountain Monster and Desert Dragon, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: Mountain Monster Desert Dragon Sales price $5,325.00 Variable cost of goods sold Manufacturing margin $5,400.00 3,275.00 $2,125.00 937.00 $1,188.00 475.00 $713.00 3,200.00 $2,125.00 1,273.00 $852.00 Variable selling expenses Contribution margin Fixed expenses 310.00 Income from operations $542.00...
Instructions Power Train Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Mountain Monster and Desert Dragon, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: Mountain Monster Desert Dragon 2 Sales price $5,200.00 $5,300.00 3 Variable cost of goods sold 3,240.00 3,450.00 4 Manufacturing margin $1,960.00 $1,850.00 5 Variable selling expenses 712.00 1,108.00 Instructions Mountain Desert Dragon Monster 2 Sales price...