Share This Article:

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

Abstract Full-Text HTML XML Download Download as PDF (Size:934KB) PP. 205-210
DOI: 10.4236/wjet.2015.34021    2,004 Downloads   2,280 Views   Citations


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.

Conflicts of Interest

The authors declare no conflicts of interest.

Cite this paper

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.


[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.

comments powered by Disqus

Copyright © 2019 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.