Cheong, Lai Kean (2015) Integer programming model for staff rostering problem: a case study on karaoke business in Seremban. Universiti Malaysia Sabah. (Unpublished)
|
Text
Integer programming model.pdf Download (11MB) | Preview |
Abstract
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 |
|---|---|
| Keyword: | integer programming model, karaoke service industry, schedule, Excel, OpenSolver |
| Subjects: | Q Science > QA Mathematics |
| Department: | FACULTY > Faculty of Science and Natural Resources |
| Depositing User: | MUNIRA BINTI MARASAN - |
| Date Deposited: | 29 Jan 2018 22:59 |
| Last Modified: | 29 Jan 2018 22:59 |
| URI: | https://eprints.ums.edu.my/id/eprint/18523 |
Actions (login required)
 |
View Item |