Case 14-63 Drop a Product Line (LO 14-4, 14-5) 9 1.2. points Alberta Gauge Company, Ltd., a small manufacturing company in Calgary, Alberta, manufactures three types of electrical gauges used In a variety of machinery. For many years the company has been profitable and has operated at capacity. However, in the last two years, prices on all gauges were reduced and selling expenses Increased to meet competition and keep the plant operating at capacity. Second-quarter results for the current year, which follow, typify recent experience. ALBERTA GAUGE COMPANY, LTD. eBook Income Statement Second Quarter (in thousands) Q-Gauge $1,800 1,088 $ 712 380 $ 332 Sales Cost of goods sold Gross margin Selling and administrative expenses Income before taxes References E-Gauge $1,150 820 $ 339 445 $ (115) R-Gauge $1,100 1,150 $ (50) 235 $ (285) Total $4,50 3,058 $ 992 1,260 $ (68) Alice Carlo, the company's president, is concerned about the results of the pricing, selling, and production prices. After reviewing the second-quarter results, she asked her management staff to consider the following three suggestions: Discontinue the R-gauge line immediately. R-gauges would not be returned to the product line unless the problems with the gauge can be identified and resolved. Increase quarterly sales promotion by $125,000 on the Q-gauge product line in order to increase sales volume by O percent. Cut production on the E-gauge line by O percent, and cut the traceable advertising and promotion for this line to $30,000 each quarter. Jason Sperry, the controller, suggested a more careful study of the financial relationships to determine the possible effects on the company's operating results of the president's proposed course of action. The president agreed and assigned JoAnn Brower, the assistant controller, to prepare an analysis. Brower has gathered the following information. All three gauges are manufactured with common equipment and facilities. The selling and administrative expense is allocated to the three gauge lines based on average sales volume over the past three years. Special selling expenses (primarily advertising, promotion, and shipping) are incurred for each gauge as follows: Q-gauge E-gauge R-gauge Quarterly Advertising and Promotion $235,000 125,000 140,000 Shipping Expenses $20 per unit 14 per unit 20 per unit . The unit manufacturing costs for the three products are as follows: Direct material Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total Q-Gauge $31.00 40.00 45.00 2 , $136.00 E-Gauge $17.00 20.ee 30.me 15.00 $82.ee R-Gauge $ 60.00 70.00 70.00 30.00 $230.00 The unit sales prices for the three products are as follows: Q-gauge E-gauge R-gauge $225 115 220 . The company is manufacturing at capacity and is selling all the gauges It produces. Required: 2. Use the operating data presented for Alberta Gauge Company and assume that the president's proposed course of action had been Implemented at the beginning of the second quarter. a. Calculate the net Impact on Income before taxes for each of the three suggestions. b-1. Calculate contribution margin for R-gauge. b-2. Was the president correct in proposing that the R-gauge line be eliminated? c-1. Calculate the contribution per direct-labor dollar for Q-gauge and E-gauge. c-2. Was the president correct in promoting the Q-gauge line rather than the E-gauge line? Complete this question by entering your answers in the tabs below. Req 2A Req 281 Req 2B2 Req 201 Req 202 Calculate the net impact on income before taxes for each of the three suggestions. E-Gauge Q-Gauge R-Gauge Increase (decrease) in segment contribution Reg 2A Reg 2B1 Reg 2B2 Reg 201 Reg 202 Calculate contribution margin for R-gauge. Contribution margin Reg 2A Reg 2B1 Reg 2B2 Reg 2C1 Reg 202 Was the president correct in proposing that the R-gauge line be eliminated? Yes No Reg 2A Reg 2B1 Reg 2B2 Reg 2C1 Req 202 Calculate the contribution per direct-labor dollar for Q-gauge and E-gauge. (Round your answers to 2 decimal places.) E-Gauge Q-Gauge Contribution per direct-labor dollar Reg 2A Reg 2B1 Reg 2B2 Reg 201 Reg 202 Was the president correct in promoting the Q-gauge line rather than the E-gauge line? Ores ONO Case 14-63 Drop a Product Line (LO 14-4, 14-5) 9 1.2. points Alberta Gauge Company, Ltd., a small manufacturing company in Calgary, Alberta, manufactures three types of electrical gauges used In a variety of machinery. For many years the company has been profitable and has operated at capacity. However, in the last two years, prices on all gauges were reduced and selling expenses Increased to meet competition and keep the plant operating at capacity. Second-quarter results for the current year, which follow, typify recent experience. ALBERTA GAUGE COMPANY, LTD. eBook Income Statement Second Quarter (in thousands) Q-Gauge $1,800 1,088 $ 712 380 $ 332 Sales Cost of goods sold Gross margin Selling and administrative expenses Income before taxes References E-Gauge $1,150 820 $ 339 445 $ (115) R-Gauge $1,100 1,150 $ (50) 235 $ (285) Total $4,50 3,058 $ 992 1,260 $ (68) Alice Carlo, the company's president, is concerned about the results of the pricing, selling, and production prices. After reviewing the second-quarter results, she asked her management staff to consider the following three suggestions: Discontinue the R-gauge line immediately. R-gauges would not be returned to the product line unless the problems with the gauge can be identified and resolved. Increase quarterly sales promotion by $125,000 on the Q-gauge product line in order to increase sales volume by O percent. Cut production on the E-gauge line by O percent, and cut the traceable advertising and promotion for this line to $30,000 each quarter. Jason Sperry, the controller, suggested a more careful study of the financial relationships to determine the possible effects on the company's operating results of the president's proposed course of action. The president agreed and assigned JoAnn Brower, the assistant controller, to prepare an analysis. Brower has gathered the following information. All three gauges are manufactured with common equipment and facilities. The selling and administrative expense is allocated to the three gauge lines based on average sales volume over the past three years. Special selling expenses (primarily advertising, promotion, and shipping) are incurred for each gauge as follows: Q-gauge E-gauge R-gauge Quarterly Advertising and Promotion $235,000 125,000 140,000 Shipping Expenses $20 per unit 14 per unit 20 per unit . The unit manufacturing costs for the three products are as follows: Direct material Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total Q-Gauge $31.00 40.00 45.00 2 , $136.00 E-Gauge $17.00 20.ee 30.me 15.00 $82.ee R-Gauge $ 60.00 70.00 70.00 30.00 $230.00 The unit sales prices for the three products are as follows: Q-gauge E-gauge R-gauge $225 115 220 . The company is manufacturing at capacity and is selling all the gauges It produces. Required: 2. Use the operating data presented for Alberta Gauge Company and assume that the president's proposed course of action had been Implemented at the beginning of the second quarter. a. Calculate the net Impact on Income before taxes for each of the three suggestions. b-1. Calculate contribution margin for R-gauge. b-2. Was the president correct in proposing that the R-gauge line be eliminated? c-1. Calculate the contribution per direct-labor dollar for Q-gauge and E-gauge. c-2. Was the president correct in promoting the Q-gauge line rather than the E-gauge line? Complete this question by entering your answers in the tabs below. Req 2A Req 281 Req 2B2 Req 201 Req 202 Calculate the net impact on income before taxes for each of the three suggestions. E-Gauge Q-Gauge R-Gauge Increase (decrease) in segment contribution Reg 2A Reg 2B1 Reg 2B2 Reg 201 Reg 202 Calculate contribution margin for R-gauge. Contribution margin Reg 2A Reg 2B1 Reg 2B2 Reg 2C1 Reg 202 Was the president correct in proposing that the R-gauge line be eliminated? Yes No Reg 2A Reg 2B1 Reg 2B2 Reg 2C1 Req 202 Calculate the contribution per direct-labor dollar for Q-gauge and E-gauge. (Round your answers to 2 decimal places.) E-Gauge Q-Gauge Contribution per direct-labor dollar Reg 2A Reg 2B1 Reg 2B2 Reg 201 Reg 202 Was the president correct in promoting the Q-gauge line rather than the E-gauge line? Ores ONO