In: Finance
TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are used in the chemical industry. One of the company’s products is a heavy-duty corrosion-resistant metal drum, called the WVD drum, used to store toxic wastes. Production is constrained by the capacity of an automated welding machine that is used to make precision welds. A total of 2,200 hours of welding time is available annually on the machine. Because each drum requires 0.8 hours of welding machine time, annual production is limited to 2,750 drums. At present, the welding machine is used exclusively to make the WVD drums. The accounting department has provided the following financial data concerning the WVD drums:
|
Since, there are multiple parts to the question and Part 3 has multiple subparts. I have answered the first three parts.
_____
Part 1)
No, I wouldn't be comfortable with the financial data provided by the accounting department for making decisions related to the WVD drums and bike frames. Information on product margins is provided after adjustments for fixed costs which are not relevant to decision making in the given case. Adjustments for fixed costs would have resulted in lower product margins which infact is not true. Further, the profitability has not been determined with reference to the constrained resource. Applicability of constraints would determine the actual profitability/margins that may be derived with the use of constrained resource.
_____
Part 2)
The contribution margin per unit is determined as below:
Purchased WVD Drums | Manufactured WVD Drums | Manufactured Bike Frames | |
Selling Price | 176.00 | 176.00 | 77.00 |
Variable Costs: | |||
Direct Materials | 150.00 | 46.40 | 19.40 |
Variable Manufacturing Overhead | 0.00 | 1.24 | 2.50 |
Variable Selling and Administrative | 1.04 | 1.04 | 2.30 |
Total Variable Cost | 151.04 | 48.68 | 24.20 |
Contribution Margin Per Unit | $24.96 | $127.32 | $52.80 |
_____
Tabular Representation as Required in Question:
Contribution Margin | |||
a. | Purchased WVD Drums | $24.96 | per unit |
b. | Manufactured WVD Drums | $127.32 | per unit |
c. | Manufactured Bike Frames | $52.80 | per unit |
_____
Part 3)
a)
The contribution margin per welding hour is calculated as below:
Manufactured WVD Drums | Manufactured Bike Frames | |
Contribution Margin Per Unit (A) | 127.32 | 52.80 |
Welding Hours Per Unit (B) | 0.80 | 0.20 |
Contribution Margin Per Welding Hour (A/B) | $159.15 | $264.00 |
_____
Tabular Representation as Required in Question:
Contribution Margin | ||
Manufactured WVD Drums | $159.15 | per hour |
Manufactured Bike Frames | $264.00 | per hour |
_____
b)
As the contribution margin of bike frames is higher, the company should manufacture as many bike frames it can sell with the use of available hours. The remaining hours (after production of bike frames) should be used to manufacture WVD drums. The number of bike frames and WVD drums to be purchased and manufactured are calculated as below:
Total Bike Frames to be Produced = Number of Bike Frames that Can be Sold = 3,700 units (as company has sufficient hours to produce the number of bike frames required)
Total Bike Frames to be Purchased = 0 units
Total WVD Drums to be Produced = Hours Left after Producing Bike Frames/Time Required Per WVD Drum = (2,200 - 3,700*.20)/.80 = 1,825 units
Total WVD Drums to be Purchased = Total WVD Drums that Can be Sold - Total WVD Drums to be Produced = 3,250 - 1,825 = 1,425 units
_____
Tabular Representation as Required in Question:
Purchased | Manufactured | |
WVD Drums | 1,425 | 1,825 |
Bike Frames | 0 | 3,700 |
_____
c)
The net increase in operating income is calculated as below:
Quantity (C) | Contribution Margin Per Unit (D) | Total Contribution (C*D) | |
Bike Frames to be Produced | 3,700 | 52.80 | 195,360.00 |
WVD Drums - Make | 1,825 | 127.32 | 232,359.00 |
WVD Drums - Buy | 1,425 | 24.96 | 35,568.00 |
Total Contribution | 463,287.00 | ||
Less Contribution Margin from Current Operations | 2,750 | 127.32 | 350,130.00 |
Increase in Net Operating Income | $113,157.00 |