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 | Particulars | Product 1 | Product 2 | Product 3 | ||
| Sales Demand | 500 | 1000 | 2000 | |||
| Selling Price | 90.00 | 80.00 | 50.00 | |||
| Less: Variable Costs | 30.00 | 54.00 | 26.00 | |||
| Contribution Margin | 60.00 | 26.00 | 24.00 | |||
| Machine Hours PU | 5.00 | 2.00 | 1.50 | |||
| Contribution Margin Per MH | 12.00 | 13.00 | 16.00 | |||
| Ranking | III | II | I | |||
| As per Ranking, Utilization of 6000 MH Available: | ||||||
| Particulars | Units | MH | Total MH | |||
| Product 1 | Produce on Resource | 200 | 5.00 | 1000 | (6000-3000-2000)=1000/5=200 | |
| Product 2 | Second Make | 1000 | 2.00 | 2000 | ||
| Product 3 | First Make | 2000 | 1.50 | 3000 | ||
| B | Particulars | Units | Contribution Margin | TotalContribution Margin | ||
| Product 1 | 200 | 60.00 | 12000 | |||
| Product 2 | 1000 | 26.00 | 26000 | |||
| Product 3 | 2000 | 24.00 | 48000 | |||
| Total | 86000 | |||||
| C | Since Product 3 & 2 are completely manufactured, additional resources are needed for Product 1 | |||||
| Total Demand for Product 1 | 500 | |||||
| Less: Manuafctured with Available Resources | 200 | |||||
| To be Manuafactured from additional Resources | 300 | |||||
| Contribution Margin PU | 60.00 | |||||
| Contribution Margin Generated Per Year | 18000 | |||||
| Years | 3 | |||||
| Contribution Margin Generated for 3 Years | 54000 | |||||
| Additional Machine Cost | 55000 | |||||
| Loss | -1000 | |||||
| The Purchase will result in Loss of 1000/- So Company should not purchased | ||||||