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

Erik Prada; Alena Pešková; Michael Valášek

doi:10.4236/wjet.2015.34021

Home > Journals > Chemistry & Materials Science | Engineering > WJET

World Journal of Engineering and Technology > Vol.3 No.4, November 2015

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 PDF HTML XML 2,091 Downloads 2,421 Views Citations

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

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.

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