Sign up Calendar Latest Topics Donate
 
 
 


Reply
  Author   Comment  
Maichineman

Member
Registered:
Posts: 3
Reply with quote  #1 
Hi All
I am looking for a spreadsheet or some form of cost saving analysis layout that someone is happy to let me use to do a year calculation of how successful our CBM programme has been. The boss wants us to put some numbers on our work. I just did not want to start from scratch. 
I do realise that it need costs, downtime etc and I have all this information but there is always the people out there that will say your downtime is to much or  replacement costs are too much so the figures are not realist but if anyone has had good results with a format and they don't mind passing on the knowledge I hope to present something worthwhile.

I know there are load of factors to take into account and this has likely been discussed many times but I have searched the forum with no result, so if someone can point me in the right direction it would be greatly appreciated 

It has been sometime since my last post as I have been sick but it is good to be back, in fact it has been about 5 years and it was so long my old login did not work?
Ian Pomfret
MarkL

Avatar / Picture

Sr. Member
Registered:
Posts: 1,121
Reply with quote  #2 
This sites about 3 years old, so not sure if you came back to the right site?
As for the info you seek, a lot may not be happy to share that kinda stuff is confidential and proprietary to they're organisations/customers etc.
John from PA

Sr. Member
Registered:
Posts: 963
Reply with quote  #3 
Do a Google search on the terms "machine downtime analysis report spreadsheet" (without the quotes)and you will get some hits that include usable spreadsheets that you could perhaps modify.
Maichineman

Member
Registered:
Posts: 3
Reply with quote  #4 
Hi Mark This site is a revamp of a site that has been around for about 20 years. I may be wrong but I am sure ElectoPete could confirm. I did realise that some work would be confidential but myself and a few other people have in the past worked on different versions of this to just make our live easier as contractor to give some feedback to our customers and these were not confidential they were just good tools to use open source. I have just lost my old copies since I was sick and thought someone would have an open source one I could use as a base and change to suit me. I wrote most of the originals it just took some time to work out the formuals and I was trying to save some time.
Thankyou so much for taking the time to get back to me.

Thanks John 
I found some I may be able to convert but not the ones I was looking for so the search will continue, if not I will just suck it up and write a new one.

It is so great to see such a strong community
John from PA

Sr. Member
Registered:
Posts: 963
Reply with quote  #5 
Quote:
Originally Posted by Maichineman
Hi Mark This site is a revamp of a site that has been around for about 20 years.


This site is relatively new, perhaps 3 years.  As far as the previous site, I think you are referring to the site at https://www.maintenance.org/forum-directory
MJ

Member
Registered:
Posts: 5
Reply with quote  #6 
Machineman, when the boss asks for cost savings generated by CBM efforts, I think what is needed should be termed "cost avoidance". I have had success calculating CA by comparing costs of an overhaul or complete replacement with the cost of a relatively simple repair. For example your CBM program diagnoses significant pump bearing wear, and the bearings are replaced before failure. Had the bearings been left to go to failure, pump replacement or overhaul would likely have been necessary. The delta cost (Over haul-Repair) is the CA for that pump. When you consider every repair for every machine in your plant, the costs add up quickly. Hope that helps.
Robert U

Member
Registered:
Posts: 28
Reply with quote  #7 
Here is a file from IRD.  Not sure if this is what your looking for.

 
Attached Files
xls JUSTIFY5.xls (24.00 KB, 14 views)

Danny Harvey

Sr. Member / Moderator / Supporter
Registered:
Posts: 1,402
Reply with quote  #8 
Machineman,

You might be thinking about the Reliability Magazine forum where many of us met.  We made this one about 3 years ago when the site that bought http://www.reliability-magazine.com from Joe Peterson became a bit unwelcoming of certain methods of practicing our trade.

Welcome.

Be careful when stating savings because the methods of attributing costs and savings are highly subjective and therefore as easily disputed by anyone with an agenda against a program as they are in favor.

I've got a few programs but the first was likely a copy of the IRD file and any others were free on the internet.  The best use for them might be for tracking changes in savings as opposed to savings themselves.
Maichineman

Member
Registered:
Posts: 3
Reply with quote  #9 
Thanks for all your help guys
MJ
Yes Cost Avoidance is the correct term that I am looking for and this formula is the one I had used in the past.

Robert U 
Thanks for the speadsheet it helps I just need to make it for multiple units and over a year period 

Danny Harvey
Yes that looks like the one and I do remember the change over after it was purchased but I did not realise it became such an issue. Great to see a new home with alot of the old heads still active. If you can send me anything you think might help let me know happy to give you my email or whatever is easier?
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.