In: Accounting
An existing turning operation in an small parts manufacturing plant is currently generating 25% scrap. The value of the scrap including material, labor and overhead costs is $20.00/unit. The current rate of process is 2000 units / month of both good an bad product. The existing equipment was purchased 5 years ago for $500,000. Current operating costs are $20,000 per year. The equipment's market value currently is $150,000. It has 4 more years of life remaining.
A quality improvement team has determined that the scrap rate can be reduced to 7% if new tooling and major overhaul work could be performed and some of the major components be replaced. The improvements would also reduce the annual operating costs to $15,000 per year.
If the organization requires a 20% IRR what is the maximum that could be spent on the equipment to reduce the scrap rate?
Calculation of Total Cost under both the options | ||||||||
Particulars | Current | After Overhaul | ||||||
Total Units | 2000 | 2000 | ||||||
% of Scrap Units | 25% | 7% | ||||||
No of Scrap Units | 500 | 140 | ||||||
Value of Scrap /Unit | 20 | 20 | ||||||
Value of Scrap /Month | 10000 | 2800 | ||||||
Value of Scrap/Yr | 120000 | 33600 | ||||||
Operating Cost | 20000 | 15000 | ||||||
Total Cost | 140000 | 48600 | ||||||
Benefit/Yr | 140000-48600 | |||||||
91400 | 2.5887 | |||||||
Factor @ 20% | (1/1.2)+(1/1.2)^2+(1/1.2)^3)+(1/1.2)^4)) | 91400 | ||||||
2.5887 | 236607.18 | |||||||
Present Value of Benefit for 4 yrs | ||||||||
91400*2.5887 | ||||||||
$236,607 | ||||||||
So the maximum amount that can be spent on equipment is the amount of benefit we get from the overhaul ie $236607 | ||||||||