爰此，本研究透過最佳化理論，運用數學整數線性規劃方法建構貼合實務之數學模型，將其加以編譯轉換為LINGO 17.0 套裝軟體建模語言，藉由電腦快速計算能力執行最佳化運算，並將運算結果匯出至Excel 2016軟體執行統計、輸出及製表，其結果除可大幅縮短勤務排班所需時間外，並可避免人工排班造成之不公平現象，幫助管理者更為妥適的運用有限人力，使服勤人員間彼此更加勞逸均衡，可有效改善服勤品質並提升團隊向心力。本研究最後透過調整重要參數數值進行敏感度分析，再次確認本研究模式之穩定性及準確性，能確實達到準確、排班省時及同職別人員間公平之目的，其分析結果並可供決策者做為實務排班運用、未來人力配置及勤務規劃方向之參考。;According to Article 2-1 of Narcotics Hazard Prevention Act, the municipal and county (city) government shall establish Drugs Abuse Prevention centers and set up case managerial personnel, aiming at drugs users in individual cases to provide various services such as psychological counseling, caring visit, social assistance, legal aids, referrals for students and employment, and medical treatment, etc., as well as drugs abuse prevention and control counseling for the general public, application for community prevention propaganda activities and other drugs control-related services, case managers have quite heavy workload. At present, the shift scheduling is manually arranged by a special assigned person based on the previous experience, which is inefficient and susceptible to the personal subjective consciousness as well as likes and dislikes, so the fairness of the shift scheduling cannot be guaranteed. It is difficult to meet the practical needs, so a systematic shift scheduling module is urgently needed.
Therefore, this study applied mathematics integer linear programming method through the optimization theory to build a mathematical model that fits the practice, and thus compile them into a LINGO 17.0 software packages modeling language with optimal operation performed by computer fast computing power, the result of which will be exported to Excel 2016 software for the performance of statistics, output and tabulation. In addition to significantly reducing the time required for duty shift scheduling, such results can also avoid the unfair phenomenon caused by manual shift scheduling, help managers to properly use the limited manpower, make the service personnel more balance between work and rest, effectively improve service quality and improve team cohesion. Finally, this study that reconfirms the stability and accuracy of this research model through the adjustment of important parameters for sensitivity analysis can really achieve accurate, time-saving scheduling and fairness among staff of the same rank; the analysis results can be used as a direction reference for decision makers in practical shift scheduling, future manpower allocation and duty planning.