A Linear Programming Model in Guitar Production to Maximize Profit: A Case Study of Guitar Manufacturer in Indonesia

摘要

Wira Musica is one of the Small and Medium Enterprises (SMEs) in guitar manufacturing located in Sukoharjo Indonesia which produces various types of guitar, such as electric guitar, bass guitar, acoustic guitar, etc. To meet the demands of various products, Wira Musica faces difficulties in production planning to generate maximum profit. This paper aims to develop a linear programming model to determine the optimal production of the guitars. OptQuest of Oracle Crystal Ball software is used to solve the linear programming model. From the results, the guitar manufacturer can achieve the maximum profit by producing only four of its five products. The fifth product did not give impact to maximize profit. The linear programming model gave a higher benefit than the current production plan of 11.09%. By using a linear programming method, Wira Musica can develop an effective, efficient, and optimal production plan by considering aspects of limited resources such as raw materials, labor, and working hours.