A.
1.
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.
To calculate: The contribution margin ratio for each salesperson.
A.
1.
Explanation of Solution
The contribution margin ratio for each salesperson is as follows:
C.G
Incorporation RI | |
Contribution margin by salesperson (Northeast) | |
Particulars | C.G ($) |
Sales
|
2,668,000 |
Less: Variable cost
|
|
Manufacturing margin | 1,612,800 |
Less: Variable selling expense
|
322,560 |
Contribution margin (B) | 752,640 |
Contribution margin ratio
|
28.00% |
Table (1)
To.
Incorporation RI | |
Contribution margin by salesperson (Northeast) | |
Particulars | To. ($) |
Sales
|
2,016,000 |
Less: Variable cost
|
806,400 |
Manufacturing margin | 1,209,600 |
Less: Variable selling expense
|
322,560 |
Contribution margin (B) | 887,040 |
Contribution margin ratio
|
44.00% |
Table (2)
T
Incorporation RI | |
Contribution margin by salesperson (Southwest) | |
Particulars | T ($) |
Sales
|
2,592,000 |
Less: Variable cost
|
1,555,200 |
Manufacturing margin | 1,036,800 |
Less: Variable selling expense
|
414,720 |
Contribution margin (B) | 622,080 |
Contribution margin ratio
|
24.00% |
Table (3)
J
Incorporation RI | |
Contribution margin by salesperson (Southwest) | |
Particulars | J ($) |
Sales
|
2,964,000 |
Less: Variable cost
|
1,185,600 |
Manufacturing margin | 1,778,400 |
Less: Variable selling expense
|
355,680 |
Contribution margin (B) | 1,422,720 |
Contribution margin ratio
|
48.00% |
Table (4)
Therefore, contribution margin of C.G is $752,640, To. is $887,040, T is $622,080, and J is $1,422,720.Contribution margin ratio of C.G is 28%, To. is 44%, T is 24%, and J is 48%.
2.
To interpret: The profitability report of the salesperson.
2.
Explanation of Solution
Contribution margin and contribution margin ratio of salesperson J 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 To. has a second-highest total contribution margin of $887,040, and second highest contribution margin ratio of 44%.
B.
1.
To calculate: The contribution margin ratio for each territory.
B.
1.
Explanation of Solution
The contribution margin ratio for each territory is as follows:
Northeast
Incorporation RI | |
Contribution margin by territory | |
Particulars | Northeast |
Sales
|
4,704,000 |
Less: Variable cost
|
2,419,200 |
Manufacturing margin | 2,284,800 |
Less: Variable selling expense
|
645,120 |
Contribution margin (B) | 1,639,680 |
Contribution margin ratio
|
34.86% |
Table (5)
Southwest
Incorporation RI | |
Contribution margin by territory | |
Particulars | Southwest |
Sales
|
5,556,000 |
Less: Variable cost
|
2,740,800 |
Manufacturing margin | 2,815,200 |
Less: Variable selling expense
|
770,400 |
Contribution margin (B) | 2,044,800 |
Contribution margin ratio
|
36.80% |
Table (6)
2.
To State: The advice regarding the relative profitability of two territories.
2.
Explanation of Solution
The southwest region contribution margin and contribution margin ratio are higher than the northeast region because the southwest region has $852,000 more sales and $405,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 20 Solutions
FINANCIAL+MAN.ACCT.-WKPPRS.,V.1-W/CODE
- Salespersons report and analysis Pachec 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 June 30 are as follows: Instructions 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. 2. Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.arrow_forwardCost Classification, Income Statement Gateway Construction Company, run by Jack Gateway, employs 25 to 30 people as subcontractors for laying gas, water, and sewage pipelines. Most of Gateways work comes from contracts with city and state agencies in Nebraska. The companys sales volume averages 3 million, and profits vary between 0 and 10% of sales. Sales and profits have been somewhat below average for the past 3 years due to a recession and intense competition. Because of this competition, Jack constantly reviews the prices that other companies bid for jobs. When a bid is lost, he analyzes the reasons for the differences between his bid and that of his competitors and uses this information to increase the competitiveness of future bids. Jack believes that Gateways current accounting system is deficient. Currently, all expenses are simply deducted from revenues to arrive at operating income. No effort is made to distinguish among the costs of laying pipe, obtaining contracts, and administering the company. Yet all bids are based on the costs of laying pipe. With these thoughts in mind, Jack looked more carefully at the income statement for the previous year (see below). First, he noted that jobs were priced on the basis of equipment hours, with an average price of 165 per equipment hour. However, when it came to classifying and assigning costs, he needed some help. One thing that really puzzled him was how to classify his own 114,000 salary. About half of his time was spent in bidding and securing contracts, and the other half was spent in general administrative matters. Required: 1. Classify the costs in the income statement as (1) costs of laying pipe (production costs), (2) costs of securing contracts (selling costs), or (3) costs of general administration. For production costs, identify direct materials, direct labor, and overhead costs. The company never has significant work in process (most jobs are started and completed within a day). 2. Assume that a significant driver is equipment hours. Identify the expenses that would likely be traced to jobs using this driver. Explain why you feel these costs are traceable using equipment hours. What is the cost per equipment hour for these traceable costs?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 $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 unit volume for the sales territories and products for the period is as follows: East Coast West Coast Atlantic Wave 40,000 25,000 Pacific Pounder 0 25,000 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…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: Line Item Description Atlantic Wave Pacific Pounder Sales price $400 $350 Variable cost of goods sold per unit (148) (165) Manufacturing margin per unit $252 $185 Variable selling expense per unit (180) (101) Contribution margin per unit $72 $84 The sales unit volume for the sales territories and products for the period is as follows: Product East Coast West Coast Atlantic Wave 2,460 1,230 Pacific Pounder 0 1,230 Question Content Area 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.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 $400 $300 Variable cost of goods sold per unit (148) (147) Manufacturing margin per unit $252 $153 Variable selling expense per unit (180) (75) Contribution margin per unit $72 $78 The sales unit volume for the territories and products for the period is as follows: East Coast West Coast Atlantic Wave 2,840 1,420 Pacific Pounder 0 1,420 Question Content Area 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…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 $400 $350 Variable cost of goods sold per unit (148) (168) Manufacturing margin per unit $252 $182 Variable selling expense per unit (172) (84) Contribution margin per unit $80 $98 The sales unit volume for the territories and products for the period is as follows: East Coast West Coast Atlantic Wave 3,360 1,680 Pacific Pounder 0 1,680 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…arrow_forward
- 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) (147) Manufacturing margin per unit $220 $153 Variable selling expense per unit (143) (69) Contribution margin per unit $77 $84 The sales unit volume for the territories and products for the period is as follows: East Coast West Coast Atlantic Wave 3,200 1,600 Pacific Pounder 0 1,600 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_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 $350 $300 Variable cost of goods sold per unit (130) (147) Manufacturing margin per unit $220 $153 Variable selling expense per unit (150) (75) Contribution margin per unit $70 $78 The sales unit volume for the territories and products for the period is as follows: East Coast West Coast Atlantic Wave 2,660 1,330 Pacific Pounder 0 1,330 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.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 $350 $250 Variable cost of goods sold per unit (130) (115) Manufacturing margin per unit $220 $135 Variable selling expense per unit (157) (70) Contribution margin per unit $63 $65 The sales unit volume for the territories and products for the period is as follows: East Coast West coast Atlantic Wave 2,780 1,390 Pacific Pounder 0 1390arrow_forward
- erritory 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 (156) (91) Contribution margin per unit $96 $98 The sales unit volume for the territories and products for the period is as follows: East Coast West Coast Atlantic Wave 3,260 1,630 Pacific Pounder 0 1,630 Question Content Area 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…arrow_forwardProduct 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,200 $4,000 Variable cost of goods sold (3,910) (2,680) Manufacturing margin $2,290 $1,320 Variable selling expenses (1,112) (680) Contribution margin $1,178 $640 Fixed expenses (550) (260) Operating income $628 $380 In addition, the following sales unit volume information for the period is as follows: Conquistador Hurricane Sales unit volume 1,900 1,400 a. Prepare a contribution margin by product report. Compute the contribution margin ratio for each product as a whole percent. Galaxy Sports Inc. Contribution Margin by Product Conquistador Hurricane…arrow_forwardProduct 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,200 $4,000 Variable cost of goods sold (3,910) (2,680) Manufacturing margin $2,290 $1,320 Variable selling expenses (1,112) (680) Contribution margin $1,178 $640 Fixed expenses (550) (260) Operating income $628 $380 In addition, the following sales unit volume information for the period is as follows: Conquistador Hurricane Sales unit volume 3,500 2,600 Question Content Area a. Prepare a contribution margin by product report. Compute the contribution margin ratio for each product as a whole percent. Galaxy Sports Inc.Contribution Margin by Productblank…arrow_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,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning