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 unit volume for the territories and products for the period is as follows:
East Coast | West Coast | ||||
Atlantic Wave | 30,000 | 20,000 | |||
Pacific Pounder | 0 | 20,000 |
a. Prepare a contribution margin by sales territory report. Calculate 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 Territory | ||
East Coast | West Coast | |
$ | $ | |
$ | $ | |
$ | $ | |
Contribution margin ratio | % | % |
b. What advice would you give to the management of Coast to Coast Surfboards regarding the relative profitability of the two territories?
The East Coast's total contribution margin is and the contribution margin ratio is when compared to the West Coast. This, in part, is explained by the single board style for the East Coast as compared to the two styles available in the West Coast. Taking a closer look, the Atlantic Wave's manufacturing margin per unit is $ while the Pacific Pounder's is $. And the Atlantic Wave's variable selling expense per unit is $ while the Pacific Pounder's is $.
With an eye on improving profitability, modifying the product mix within the two territories would be . Additionally, the company should review the . The could shed light on manufacturing inefficiencies. Also, a review of variable selling expense per unit could also help with profitability.
Coast to Coast surfboards Inc | ||||||||||
Answer | Contribution Margin by Territory | |||||||||
Details | East Coast | West Coast | ||||||||
Units | Rate | Total | Units | Rate | Total | |||||
Sales | ||||||||||
Atlantic Wave | 30000 | $ 267 | 80,10,000 | 20000 | $ 267 | $ 53,40,000 | ||||
Pacific Pounder | 20000 | $ 189 | $ 37,80,000 | |||||||
Total Sales | 30000 | 80,10,000 | 40000 | $ 91,20,000 | ||||||
Variable Cost | ||||||||||
Atlantic Wave | 30000 | $ 105 | 31,50,000 | 20000 | $ 105 | $ 21,00,000 | ||||
Pacific Pounder | 20000 | $ 105 | $ 21,00,000 | |||||||
Total Variable cost | 30000 | 31,50,000 | 40000 | $ 42,00,000 | ||||||
Contribution Margin | 30000 | $ 162 | 48,60,000 | 40000 | $ 123 | $ 49,20,000 | ||||
Contribution Margin Ratio | 60.67% | 53.95% | ||||||||
(Contribution/Sales) | ||||||||||
East Coast Contribution is lower and the contribution margin ratio is higher when compared to West Coast. | ||||||||||
This is in part ,is explained by the single board style for East Coast as compared to the two styles available in west coast. | ||||||||||
Taking a closer look Atlantic wave manufacturing margin is $162 while Pacific Pounder is $84. | ||||||||||
And the Atlantic Wave's variable selling expense is $144 while the Pacific Pounder is $72. | ||||||||||
With an eye on improving the profitability ,modifying the product mix within the two territories would be ineffective. | ||||||||||
Additionally the company should review the Variable costs. | ||||||||||
The variable costs of goods sold could shed light on the manufacturing inefficiencies. | ||||||||||
Also a review of Atlantic's variable selling expenses per unit could also help the profitability. | ||||||||||
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 $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...
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...
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...
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,...
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...
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 $5,000 $3,400 Variable cost of goods sold (3,150) (2,280) Manufacturing margin $1,850 $1,120 Variable selling expenses (750) (576) Contribution margin $1,100 $544 Fixed expenses (520) (220) Operating income $580 $324 In addition, the following sales unit...
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: 1 Mountain Monster Desert Dragon 2 Sales price $5,400.00 $5,225.00 3 Variable cost of goods sold 3,290.00 3,500.00 4 Manufacturing margin $2,110.00 $1,725.00 5 Variable selling expenses 1,030.00 889.00 6 Contribution margin $1,080.00 $836.00 7 Fixed expenses 475.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...
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: Amount Descriptions Contribution margin Contribution margin ratio Cost of goods sold Fixed expenses Gross profit Manufacturing margin Revenues Variable cost of goods sold Variable selling expenses 1 Mountain Monster Desert Dragon 2 Sales price $5,200.00 $5,300.00 3 Variable...
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...