Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
rakesh_mane
Active Contributor


Hello All,

 

I would Like share with you all below Next Plan Date Calculation Logic For Multiple Counter Plan.

 

It will help to understand Basics of Multiple counter Plan..

 

Formula for calculating the Start date of Maintenance Counter plan is based on below formula
[(Cycle Length-Current Counter Reading) / Annual Estimate x 365 Days] + Date on which the measurement reading or counter reading was taken



For example :
Annual Estimate  = 600 Hrs (A)
Cycle Length       = 100 Hrs (B)
Initial Counter Reading = 0 Hrs     (C)


Reading taken on 25.03.2013
Plan Date of Maintenance plan = (100-0)/600*365 + Date of counter reading taken   = 60 Days + 25.03.2013 = 25.05.2013
------------------------------------------------------------------------------------------------------------------------------------------------
When measurement is entered as 120 from initial reading 0, the call will generate today as it passed 100. Remaining 20 is not considered for calculation of new planned date.
Now here the starting of counter reading will be considered as 120 and next plan counter reading will be 220 as Cycle is 100.
So if we enter the counter reading as 160, in formula the difference of counter reading to be taken as 220-160=60 Hrs
Next plan date will be calculated on the basis difference of counter reading as 60 Hrs.
So from current date it will calculate the next plan date for 40 Hrs (100-60)

 

 

Br

Rakesh

8 Comments
Labels in this area