| Summary: | Appointment scheduling is very popular in healthcare where long waiting times for treatment in the outpatient department of internal medicine; followed by short consultations has long been a complaint of patients. This issue is becoming increasingly important with the progressively aging society. The same thing goes for vehicle appointment scheduling. Here, we present two parts of major scopes where analysis in spreadsheet is performed first then followed by simulation of service scheduling using one of popular package for simulation, ProModel 7. For the first part of this paper, we describe the analytical work being done using spreadsheet where the data analysis is a series of steps to extract the data collected where we introduced waiting time to avoid clash between vehicles. In this study, both quantitative and qualitative data were used. Previous studies proved that large amounts of qualitative work have usually been prerequisite to fruitful quantification in the physical sciences. The continuity of the analysis and modeling then presented as the verification part of the analysis using simulation technique. At the end of this paper, we compare and discuss the hypothesis and result obtained from the spreadsheet and simulation for this scope of study.
|
|---|