Model of Maintenance Planning Based on Trend of Machines Failures with Two Priorities


In this article we are discussing the suggestion of planning maintenance in such situation that we have failures in database of failures and maintenance registered also according to type of failure— priority or non-priority. We are assuming that maintenance must be mainly oriented on avoiding major failures of machines. The effect of maintenance manifests with delay and is dependent on development of failures. We express this problem as linear programming task that is solvable with Solver-extension of application Excel. We demonstrate the suggested solution on example of failures of machines between years 2010 and 2012.

Share and Cite:

Prada, E. , Pešková, A. and Valášek, M. (2015) Model of Maintenance Planning Based on Trend of Machines Failures with Two Priorities. World Journal of Engineering and Technology, 3, 205-210. doi: 10.4236/wjet.2015.34021.

Conflicts of Interest

The authors declare no conflicts of interest.


[1] Pesková, A. (2013) Linear Model of Maintenance Planning Based on Failure Trend of Equipments in Excel. Trends and Innovative Approaches in Business Processes: 16. International Scientific Conference, Technical University of Kosice, Kosice, 7-8 November 2013, 1-6.
[2] Harmon, M. (2013) Step-By-Step Optimization with Excel Solver—The Excel Statistical Master. Excel Master Series, Kindle Edition, Amazon Digital Services.
[3] Ragsdale, T.C. (2011) Spreadsheet Modeling and Decision Analysis. 6th Edition, Cengage Learning, South-Western.
[4] Dantzig, G.B. (1963) Linear Programming and Extensions. Princeton University Press, Princeton.
[5] Chandrakantha, L. (2012) Using Excel Solver In Optimization Problems. John Jay College of Criminal Justice of CUNY, New York.
[6] Meissner, J. and Nguyen, T. (2008) An Introduction to Spreadsheet Optimization Using Excel Solver. Lancaster University, Lancaster.
[7] Gmiterko, A., Prada, E., Virgala, I., Surovec, R. and Vacková, M. (2011) Comparison of Neural Networks Learning Algorithms for Simulation of Rectilinear Snake Locomotion. Modelling of Mechanical and Mechatronic Systems 2011.
[8] Prada, E., Virgala, I., Granosik, G., Gmiterko, A. and Mrkva, S. (2014) Simulation Analysis of Pneumatic Rubber Bellows for Segment of Hyper-Redundant Robotic Mechanism. Applied Mechanics and Materials, 611, 10-21.
[9] Lipták, T., Gmiterko, A., Kelemen, M., Virgala, I., Prada, E. and Menda, F. (2014) The Use of Geometric Mechanics Concept at Kinematic Modeling in Mobile Robotics. Procedia Engineering, 96, 273-280.

Copyright © 2023 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.