Question

In: Accounting

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 $300 $250
Variable cost of goods sold per unit (111) (123)
Manufacturing margin per unit $189 $127
Variable selling expense per unit (135) (57)
Contribution margin per unit $54 $70

The sales unit volume for the territories and products for the period is as follows:

East Coast West Coast
Atlantic Wave 2,820 1,410
Pacific Pounder 0 1,410

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 Territory
East Coast West Coast
Sales $ $
Variable cost of goods sold
Manufacturing margin $ $
Variable selling expenses
Contribution margin $ $
Contribution margin ratio % %

Solutions

Expert Solution

Contribution margin report
For East coast
Particulars Atlantic wave ($) Pacific Pounder ($)
A Sales in units                  2,820                       -  
B Sale value ($300/unit * A)            8,46,000                       -  
C Variable cost of goods sold ($111/unit * A)            3,13,020                       -  
D Manufacturing margin (B-C)            5,32,980                       -  
E Variable selling expenses/unit (135/unit * A)            3,80,700                       -  
F Contribution margin/Unit (D-E)            1,52,280                       -  
Contribution margin (%) = (E/B)*100 18.00%                       -  
For WEST coast
Particulars Atlantic wave ($) Pacific Pounder ($)
A Sales in units                  1,410                1,410
B Sale value ($300/unit * A)- Atlantic wave            4,23,000                       -  
Sale value ($250/unit * A)- Pacific pounder          3,52,500
C variable cost of goods sold ($111/unit * A)-Atlantic wave            1,56,510                       -  
Variable cost of goods sold ($123/unit * A)-Pacific pounder          1,73,430
D Manufacturing margin (B-C)            2,66,490          1,79,070
E Variable selling expenses/unit (135/unit * A)-Atlantic Wave            1,90,350                       -  
Variable selling expenses/unit ($57/unit * A)-Pacific pound              80,370
F Contribution margin/Unit (D-E)                76,140              98,700
Contribution margin (%) = (E/B)*100 18.00% 28.00%

Related Solutions

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 Waves Pacific Pounder Sales price $200 $120 Variable cost of goods sold per unit 150 90 Manufacturing margin per unit $50 $30 Variable selling expense per unit 34 16 Contribution margin per unit $16 $14 The sales...
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 $223 $158 Variable cost of goods sold per unit 88 88 Manufacturing margin per unit $135 $70 Variable selling expense per unit 120 60 Contribution margin per unit $15 $10 The sales...
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 $350 $300 Variable cost of goods sold per unit (130) (138) Manufacturing margin per unit $220 $162 Variable selling expense per unit (157) (84) Contribution margin per unit $63 $78 The sales...
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 $300 $200 Variable cost of goods sold per unit 111 98 Manufacturing margin per unit $189 $102 Variable selling expense per unit 117 62 Contribution margin per unit $72 $40 The sales...
Territory and Product Profitability Analysis Zen Skateboards, Inc., manufactures and sells two styles of skateboards, Street...
Territory and Product Profitability Analysis Zen Skateboards, Inc., manufactures and sells two styles of skateboards, Street Machine and Winter Warrior. These skateboards are sold in two regions, Southern Coast and Northern Coast. Information about the two skateboards is as follows: Street Machine Winter Warrior Sales price $400 $350 Variable cost of goods sold per unit 148 161 Manufacturing margin per unit $252 $189 Variable selling expense per unit 156 105 Contribution margin per unit $96 $84 The sales unit volume...
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 $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...
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 $14,000 $16,000 $8,900 $18,300 Variable cost of goods sold $8,400 $8,960 $5,696 $8,052 Commission rate 7% 14% 12% 9% Units...
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 $13,900 $15,300 $8,500 $18,400 Variable cost of goods sold $8,340 $8,262 $5,270 $8,096 Commission rate 7% 14% 12% 9% Units...
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 $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...
Ducet Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Monster and...
Ducet Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Monster and 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 Monster Dragon 2 Sales price $5,400.00 $5,300.00 3 Variable cost of goods sold 3,255.00 3,400.00 4 Manufacturing margin $2,145.00 $1,900.00 5 Variable selling expenses 1,065.00 946.00 6 Contribution margin $1,080.00 $954.00 7 Fixed expenses 485.00 305.00 8 Income from...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT