Replacement Reserve Spreadsheet Instructions

To make the spreadsheet calculate correctly, you must score the ratings for the useful life of the each Item from 0 to 5, corresponding to the amount of life expired for the Item: 0 = 0% expired (new) 1 = 20% expired. 2 = 40% expired. 3 = 60% expired. 4 = 80% expired. 5 = 100% expired (needs immediate replacement) Hint: While the expired useful ... ................
................