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

Erik Prada¹, Alena Pešková², Michael Valášek³

¹Vehicle Center of Sustainable Mobility, Faculty of Mechanical Engineering, Czech Technical University in Prague, Prague, Czech Republic.
²Department of Production Systems, Faculty of Mechanical Engineering, Technical University of Kosice, Kosice, Slovakia.
³Faculty of Mechanical Engineering, Czech Technical University in Prague, Prague, Czech Republic.

DOI: 10.4236/wjet.2015.34021                

Abstract

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.

Keywords

Microsoft Excel, Supplement Solver, Maintenance Planning, Priority and Non-Priority Failures, Linear Programming

Conflicts of Interest

The authors declare no conflicts of interest.

References

[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. http://dx.doi.org/10.1016/j.proeng.2014.12.154