**Replacement Theory in Operations Research – An Algorithm using MS-Excel**

The Replacement Theory in Operations Research is used in the decision making process of replacing a used equipment with a substitute; mostly a new equipment of better usage. The replacement might be necessary due to the deteriorating property or failure or breakdown of particular equipment. The ‘Replacement Theory’ is used in the cases like; existing items have out-lived, or it may not be economical anymore to continue with them, or the items might have been destroyed either by accident or otherwise. The above discussed situations can be solved mathematically and categorised on some basis like:

- Items that deteriorate with time e.g. machine tools, vehicles, equipment buildings etc,
- Items becoming out-of-date due to new developments like ordinary weaving looms by automatic, manual accounting by tally etc.
- Items which do not deteriorate but fail completely after certain amount of use like electronic parts, street lights etc
*(Group Replacement)*and - The existing working staff in an organization gradually diminishing due to death, retirement, retrenchment & otherwise
*(Staff Replacement)*.

**Replacement Policy for Equipments which Deteriorate Gradually**

** **Let us see the first case of gradual failure of items with time. Consider the example of a Motor Vehicle; the pattern of failure here is progressive in nature i.e. as the life of vehicle increases; its efficiency decreases. This results in additional expenditure in running or maintaining this vehicle and at the same time its resale value (also called as scrap value) also keeps on decreasing. The above case makes this situation a typical case for applying ‘Replacement Theory’.

**Example****:**

A transport company purchased a motor vehicle for rupees 80000/-. The resale value of the vehicle keeps on decreasing from Rs 70000/- in the first year to Rs 5000/- in the eighth year while, the running cost in maintaining the vehicle keeps on increasing with Rs. 3000/- in the first year till it goes to Rs. 20000/- in the eighth year as shown in the below table. Determine the optimum replacement policy?

The MS-Excel Files of this Algorithm can be downloaded from the links provided further in this post. The cost of the equipment is to be entered in the cell B1 (as shown by the green cell with 80000). Now, enter the scrap values and the running costs as entered in the green columns C5 to C12 and D5 to D12. The algorithm will now automatically calculate the solution which is as shown in the below figure.

The answer can be fetched from the last column. See the pattern; the average total cost (ATC) at first starts dipping from Rs. 13000/- till it reaches Rs. 11850/- in the cell H8. From H9 it again starts increasing. This cost at which the ATC is lowest in a particular year (after which it starts increasing again) gives the optimum replacement period and cost of the vehicle.

**Solution:** The vehicle needs to be replaced **after four years** of its purchase wherein the cost of maintaining that vehicle would be lowest at an average of **Rs 11850/-** per year.

**Clarification on the Methodology **

There are two considerations here. First, the running cost (Rn) is increasing every year at the same time the vehicle is depreciating in its value. This depreciation is ‘(C-S)’ i.e. in the first year the scrap value of the vehicle is Rs. 70000/- which was purchased for Rs. 80000/- . So, the vehicle is depreciated by Rs. 10000/- in year one and so on (see column F).

Thus the total cost in keeping this vehicle is this depreciation and its maintenance. The maintenance is made cumulative by adding previous years running cost to it every successive year. Let’s make this simple!

The depreciation is Rs. 10000/- in the first, 19000/- in the second, 25000/- in the third and so on. See here, the vehicle is depreciated by **Rs. 25000/-** “by” the third year and not “in” the third year. Note that the non-cumulative cost of depreciation “in” the third year would be Rs. 6000/- [Rs. 25000/ minus Rs. 19000/, see the cells F6 and F7]

As, the depreciation in itself is a cumulative function here, we make the running cost cumulative also. That means the cost of maintaining the vehicle “by” the particular years. So, the cost of maintaining the vehicle “by” the third year is **Rs. 11400/-** (D5+D6+ D7 or 3000+3600+4800).

Hence the total cost incurred by the third year would be Rs. 25000 + Rs. 11400 = Rs. 36400 (see cell G7). Finally, the “average cost” of keeping this vehicle for three years would be 36400 divided by 3 years i.e. Rs. 12133.33 as can be seen from cell H7 and so on.

**Notations Used****:**

**C**- (Capital) Cost of Equipment**S**- Scrap (or Resale) Value**Rn**- Running (or Maintenance) Cost**E Rn**- Cumulative Running Cost**(C-S)**- Depreciation**TC**- Total Cost**ATC**- Average Total Cost

**How to Download?**

- 1) Click on the appropriate hyperlinks below
- Replacement Algorithm (Office 2007 Version)
- Replacement Algorithm (Office 97-2003 Compatible Version)
- 2) On the sky-blue status bar of ‘Google Docs’; select “File”
- 3) “Download As” then “Excel”; [Open with MS Excel (default)? Select 'OK']
- 4) Save the File on your PC and work with it. Happy Solving!!!

**Instruction on – How to use the Algorithm Files?**

- Download the Algorithm file and save it to a location like ‘My Documents’ (This is your Master File)
- Create a copy for yourself by using “Save As” command and save the file with a new name maybe into a new location ‘Desktop”
- Do not delete the ‘cell values’ at any point of time during the use; rather; over-write the values. The reason being, once you delete or clear the excel sheet, all the formulae used are lost.

**Try This Out !**

**Playing with existing Numerical:**Start changing the values in the “Rn” and “S” value columns or better if you change the cost of the vehicle only. For example, in the cell B1; use values lesser than or greater than Rs. 80000/- and observe how the solution changes for different purchase costs.

**To solve a new Numerical:**Start overwriting new values for C, S and Rn in the green cells and get the solutions. If say scrap value is not given then you can over-write all the existing scrap values with ‘zeroes’. If the numerical has data gathered for lesser years / periods (in our case the data gathered was for 8 years); then overwrite the remaining values with ‘zeroes’. Do not save the file or if you want to, then use ‘Save As’.

**PowerPoint Presentation **

Download this PPT - Replacement Theory Models in Operations Research by Dr. Rajesh Timane

**Other Replacement Models**

** ****___________________________________________________________________________**

This would definitely help the students sir. I can ask them now to check the answers of solved and unsolved numericals.

@ Sachin,

Even i did the same few years back.

sir i am research scholar my topic a study of usaing quantitative method to rationalty replacement decision .

we are using exponential function .

did you have any information about that pleace help my if you can

Thank you vry much. Understood very clearly. Many more to come

@ Subha,

That’s Great.

simple and easy to understand!!

@ anjali,

pleased to know that.

Sir,

can we create similar excel sheets for direct answers for sequencing and simulation problems?

@ Sheetal

That is very much possible.

Its good to understand and will surely help .. sir would be looking for some more material on Manufacturing Economics. It will be of great help if u can share some topics.

@ Vineet

Specify any topic in Manufacturing Economics in perticular about which you want theory and or numericals. Pradeep Suryavanshi, a PD student persuing Operations will get in touch with you. You guys can exchange the study material.

The topics I am looking for are as Follows:

Unit 1: Introduction to manufacturing economics

Unit 4: Econometrics

Unit 10 : Modelling and Simulation..

NUMERICALS on Expected topics

In case you get any of the material please upload it…I have spoken to Pradip also regarding the material..

Keep Posting Sir.

thanks a lot sir… u really helped me out to finish a presentation in replacement analysis

I’m needing to understand more on this theory, so please help me as much as you can…..

Thanks and regards

Rakesh Singh

@ Rakesh,

Let me what kind of help you need in specific.

a good example for students.thanks for the pain you have taken .

A neat explanation please upload some more solution

like group replacement policy

@ Raju: Thank You !

@ Nishanthi: Sure !

@ Nishanthi,

Check out the post on Group Replacement; http://www.rajeshtimane.com/359/academics/group-replacement-theory.html

Please visit my blog and look for replacement ppt. I have prepared form your data only. Thank you for sharing the information.

very nice publish, i definitely love this web site, keep on it

Very Useful. It made my presentation.

Rajesh Sir,

We want rules for sequencing along with assumptions in replacement theory and sequencing theory with some illustrations if possible.

Great topic. I needs to spend some time studying much more or understanding more. Thanks for magnificent information.

@ Kasch, Rajesh, Ravi & Tschoep,

Thank you all !

…perfect piece of content.

I agreed with your conclusions and the post been invaluable for myself !

Finally i got what i needed.Thanks!

Searched google 30 mins then got what i needed, appreciated !

@ Mavis, Katrina, Diya & Alfred,

Thank you ALL !!!

this algorithm really helps the students of OR thanks

some genuinely fantastic posts on this website,thanks rajesh for the contribution.

I recommend this web site!

I am happy to search out numerous helpful info right here in the publish, we need develop more strategies in this regard, thanks for sharing . . .

almost i got the material what i need….

THANX.

It helped me a lot. Subject allotted to me is applied operations research, accounts and Quantitative decision making

thankyou sir,for making this helpful site for OR.

THANKS !

Hi my friend! I wish to say that this article is amazing, nice written and include almost all vital infos. I’d like to see more posts like this .

hi,

in your example, let’s say when that machine is 2 years old, another machine which is a new model, is available. the optimal period of replacement of this new machine is 4 years with an average cost of Rs.10,500. should the machine be replaced with the new one and if so, what will be the best period of replacement?

if you can please explain how to work out this problem.

thank you.

I rarely comment, however i did a few searching and wound up here Replacement Theory Algorithm | Rajesh Timane.com.

Thank You All !

Hello, my name is David C.

I just found this post and already love it.

See you soon on others forum topics

thank u for this teaching.

it was useful. thanks.

@ Ruga, Thanish and David’

Thank You ALL !

But How a depreciation value,(C-S), is a monotonic decreasing???

can I get a real life example…like that of a company using this technique?

Hey There. This is a very well written article.

Excellent task..

The vehicle needs to be replaced after four years of its purchase wherein the cost of maintaining that vehicle would be lowest at an average of Rs 11850/- per year. I have copied and pasted your solution. But the optimal replacement policy says that replacement is economical only when the running cost is more than Rs.11850/- That is not the case here. It is Rs.8000/- Could you explain the fallacy?

excellent………description

good quality work is done here!!!!!!!