Question

Sales Territory and Salesperson Profitability Analysis Havasu Off-Road Inc. manufactures and sells a variety of commercial...

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 $11,600 $15,500 $9,800 $18,800
Variable cost of goods sold $7,424 $8,990 $6,076 $10,528
Commission rate 7% 14% 11% 8%
Units sold 30 24 40 46
Manufacturing margin ratio 36% 42% 38% 44%

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
Sales $ $ $ $
Variable cost of goods sold
Manufacturing margin $ $ $ $
Variable commission expense
Contribution margin $ $ $ $
Contribution margin ratio % % % %

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
Sales $ $
Variable cost of goods sold
Manufacturing margin $ $
Variable commission expense
Contribution margin $ $
Contribution margin ratio % %

b. 2. Interpret the report.

The Southwest Region has $ more sales and $ more contribution margin. In the Southwest Region, the salesperson with the highest sales unit volume, has the highest contribution margin ratio. The Southwest Region has the highest performance, even though it also has the salesperson with the lowest contribution margin and contribution margin ratio. The Northeast Region contribution margin is less than the Southwest Region because of the outstanding performance of Paul .

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Territory and Product Profitability Analysis Coast to Coast Surfboards Inc. manufactures and sells two styles of...
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 $200 $100 Variable cost of goods sold per unit 74 48 Manufacturing margin per unit $126 $52 Variable selling expense per unit 70 26 Contribution margin per unit $56 $26 The sales...
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $619,000 $346,640 $117,610 Dix 409,000 159,510 65,440 Johnson 517,000 258,500 108,570 LaFave 341,000 167,090 54,560 Orcas 555,000 277,500 116,550 Sussman 405,000 206,550 68,850 Willbond 492,000 241,080 83,640 Required: 1. Prepare a table...
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $604,000 $295,960 $114,760 Dix 375,000 131,250 56,250 Johnson 411,000 226,050 65,760 LaFave 450,000 189,000 58,500 Orcas 423,000 241,110 84,600 Sussman 424,000 165,360 93,280 Willbond 588,000 264,600 99,960 Required: 1. Prepare a table...
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $560,000 $218,400 $84,000 Dix 497,000 288,260 99,400 Johnson 501,000 220,440 110,220 LaFave 332,000 109,560 59,760 Orcas 562,000 179,840 78,680 Sussman 448,000 219,520 58,240 Willbond 539,000 291,060 86,240 Required: 1. Prepare a table...
Salespersons' Report and Analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product...
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 $547,000 $213,330 $71,110 Dix 346,000 148,780 44,980 Johnson 615,000 221,400 86,100 LaFave 330,000 148,500 52,800 Orcas 420,000 163,800 54,600 Sussman 370,000 170,200 74,000 Willbond 481,000 278,980 72,150 Required: 1. Prepare a table...
Product Profitability Analysis PowerTrain Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs),...
Product Profitability Analysis PowerTrain 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 Sales price $5,800 $3,400 Variable cost of goods sold 3,650 2,280 Manufacturing margin $2,150 $1,120 Variable selling expenses 990 508 Contribution margin $1,160 $612 Fixed expenses 550 240 Income from operations...
Product Profitability Analysis Galaxy Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs),...
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,000 $4,000 Variable cost of goods sold (3,780) (2,680) Manufacturing margin $2,220 $1,320 Variable selling expenses (1,080) (720) Contribution margin $1,140 $600 Fixed expenses (540) (240) Operating income $600 $360 In addition, the...
Product Profitability Analysis PowerTrain Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs),...
Product Profitability Analysis PowerTrain 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 Sales price $6,600 $4,000 Variable cost of goods sold 4,160 2,680 Manufacturing margin $2,440 $1,320 Variable selling expenses 1,186 560 Contribution margin $1,254 $760 Fixed expenses 590 300 Income from operations...
Skittles Inc. manufactures and sells two styles of candy, Red Chewy and Green Sucker. These candies...
Skittles Inc. manufactures and sells two styles of candy, Red Chewy and Green Sucker. These candies are sold in two regions, East Coast and West Coast. Information about the two surfboards is as follows: Red Chewy Green Sucker Sales price $350 $300 Variable cost of goods sold per unit (130) (138) Manufacturing margin per unit $220 $162 Variable selling expense per unit (150) (90) Contribution margin per unit $70 $72 The sales unit volume for the territories and products for...
Product Profitability Analysis PowerTrain Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs),...
Product Profitability Analysis PowerTrain 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 Sales price $4,800 $2,800 Variable cost of goods sold 3,020 1,880 Manufacturing margin $1,780 $920 Variable selling expenses 964 304 Contribution margin $816 $616 Fixed expenses 380 250 Income from operations...