MATEC Web Conf.
Volume 97, 2017Engineering Technology International Conference 2016 (ETIC 2016)
|Number of page(s)||8|
|Published online||01 February 2017|
Spreadsheet simulation-based optimization for personnel capacity requirement in breakdown maintenance
Dept. of Manufacturing Engineering Technology, Faculty of Engineering Technology, Universiti Teknikal Malaysia Melaka, Hang Tuah Jaya, 76100, Durian Tunggal, Melaka, Malaysia
* Corresponding author: email@example.com
This study’s objective is to find out the optimum number of personnel in breakdown maintenance activities. Spreadsheet simulation was used for that purpose considered spreadsheet is relatively not an expensive simulation software, familiar to many people, easy to use, yet powerful enough to do the simulation. Input data included in the simulation are time to repair and time between failures which are generated randomly following normal and uniform distribution respectively. The distribution identified by using the histogram and chi-squared test for distribution to find the best-fit distribution. The simulation results show that, the optimum number of personnel obtained when utilization of maintenance personnel is maximized while the number and/or time machines/equipment waiting in queued for maintenance personnel was minimized. In that condition, the cost of breakdown maintenance will be optimum.
© The Authors, published by EDP Sciences, 2017
This is an Open Access article distributed under the terms of the Creative Commons Attribution License 4.0, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.
Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.
Initial download of the metrics may take a while.