In: Accounting
Short Inc has 6,000 machine hours available each month. The
following information on the company's three products is
available:
| 
 Product 1  | 
 Product 2  | 
 Product 3  | 
|||||||||
| 
 Selling price  | 
 $  | 
 90.00  | 
 80.00  | 
 50.00  | 
|||||||
| 
 Variable cost per unit  | 
 30.00  | 
 54.00  | 
 $  | 
 26.00  | 
|||||||
| 
 Machine hours per unit  | 
 5  | 
 2  | 
 1.5  | 
||||||||
| 
 Sales demand in units  | 
 500  | 
 1,000  | 
 2,000  | 
||||||||
Required:
a. What production schedule will maximize the company's
profits?
b. What will be the maximum possible contribution margin?
c. The company has an option of buying an additional machine for $55,000 to increase the total machine hours to 8,000. Assuming that this machine will last for 3 years and have no resale value at the end of its life, should the company buy this machine?
a.
| Product 1 | Product 2 | Product 3 | |
| Selling Price per Unit | $ 90 | $ 80 | $ 50 | 
| Variable Cost per Unit | 30 | 54 | 26 | 
| Contribution Margin per Unit | $ 60 | $ 26 | $ 24 | 
| Machine Hours per Unit | 5 | 2 | 1.5 | 
| Contribution Margin per Machine Hour | $ 12 | $ 13 | $ 16 | 
| Rank | 3 | 2 | 1 | 
Production Schedule:
| Total Machine Hours | 6,000 | 
| Less : Utilized for total sales demand of Product 3 ( 2,000 x 1.5) | (3,000) | 
| Less: Utilized for total sales demand of Product 2 ( 1,000 x 2) | (2,000) | 
| Remaining Machine Hours for Product 1 | 1,000 | 
| Number of units of Product 1 than can be produced ( 1,000 MH / 5 MH per unit) | 200 | 
Product 1 : 200 units, Product 2 : 1,000 units, Product 3 : 2,000 units.
b. Maximum possible contribution margin per month = 2,000 x $ 24 + 1,000 x $ 26 + 200 x $ 60 = $ 86,000.
c. Contribution margin per month after enhanced capacity = 2,000 x $ 24 + 1,000 x $ 26 + 500 x $ 60 = $ 104,000.
Increase in contribution margin per month = $ 104,000 - $ 86,000 = $ 18,000.
Additional fixed cost ( depreciation on new equipment) = $ 55,000 / 36 months = $ 1,528.
Increase in operating income after purchase of equipment = $ 18,000 - $ 1,528 = $ 16,472 per month.
Therefore, the company should buy the machine, as that would result in increased operating income of $ 16,472 per month. Moreover, it would ensure that the company isable to cater to the total demand for each of its products, as the resource constraint ( Machine Hours) will be taken care of .