Integer programming model for staff rostering problem: a case study on karaoke business in Seremban

Cheong, Lai Kean (2015) Integer programming model for staff rostering problem: a case study on karaoke business in Seremban. Universiti Malaysia Sabah. (Unpublished)

Integer programming model.pdf

Download (11MB) | Preview


In this study, an integer programming model is imposed on a karaoke service industry in Seremban. The model formulation is used to determine an optimal weekly shift schedule for the karaoke outlet's employees whom mainly consist of floor captain, service crew, receptionist cashier, chef and cleaner while satisfying several constraints. The integer programming model is implemented on Excel add-in solver routine and OpenSolver. The model enables the case study company's personnel management to develop a fair personnel schedule as needed and to effectively utilize personnel resources while satisfying several technical, legal and economic requirements. By using the OpenSolver, it enables to decrease the amount of time to create schedules from approximately 3 hours of manual work to less than 1 second. These encouraging achievements make the community optimistic about the advantages as other organizations can amass by introducing the operational research approaches in their management planning and decision making systems.

Item Type: Academic Exercise
Uncontrolled Keywords: integer programming model, karaoke service industry, schedule, Excel, OpenSolver
Subjects: Q Science > QA Mathematics
Divisions: FACULTY > Faculty of Science and Natural Resources
Depositing User: Munira
Date Deposited: 29 Jan 2018 14:59
Last Modified: 29 Jan 2018 14:59

Actions (login required)

View Item View Item

Browse Repository
   UMS News
Quick Search

   Latest Repository

Link to other Malaysia University Institutional Repository

Malaysia University Institutional Repository