A SPREADSHEET OPTIMIZATION SYSTEM FOR LIBRARY STAFF SCHEDULING

被引:6
作者
ASHLEY, DW
机构
[1] Bloch School, University of Missouri, Kansas City, Kansas City, MO 64110-2499
关键词
D O I
10.1016/0305-0548(94)00041-6
中图分类号
TP39 [计算机的应用];
学科分类号
081203 ; 0835 ;
摘要
Lotus 123 with a linear programming add-in provides weekly schedules for staffing a reference and circulation desk at a university library. Times of availability for personnel vary widely. The system, which is flexible and easy to use, solves a noncyclical tour scheduling problem for a work pattern of several single periods, each requiring a recovery time of at least one period.
引用
收藏
页码:615 / 624
页数:10
相关论文
共 15 条
[1]   INTEGRATED DAYS OFF AND SHIFT PERSONNEL SCHEDULING [J].
BAILEY, J .
COMPUTERS & INDUSTRIAL ENGINEERING, 1985, 9 (04) :395-404
[2]   WORKFORCE SCHEDULING WITH CYCLIC DEMANDS AND DAY-OFF CONSTRAINTS [J].
BAKER, KR ;
MAGAZINE, MJ .
MANAGEMENT SCIENCE, 1977, 24 (02) :161-167
[3]  
Bergmann C, 1988, Nurs Manage, V19, P28
[4]  
CARLSON D, 1991, LIBRARY SOFTWARE JAN, P41
[5]  
GLOVER F, 1986, COMP OPERATIONS RES, V13, P565
[6]  
HALLORAN TJ, 1986, INTERFACES, V16, P39
[7]   HEURISTIC METHODS FOR TELEPHONE OPERATOR SHIFT SCHEDULING - EXPERIMENTAL-ANALYSIS [J].
HENDERSON, WB ;
BERRY, WL .
MANAGEMENT SCIENCE, 1976, 22 (12) :1372-1380
[8]   TOUR SCHEDULING AND TASK ASSIGNMENT OF A HETEROGENEOUS WORK FORCE - A HEURISTIC APPROACH [J].
LOUCKS, JS ;
JACOBS, FR .
DECISION SCIENCES, 1991, 22 (04) :719-738
[9]   MANAGEMENT SCIENCE IMPROVES FAST-FOOD OPERATIONS [J].
LOVE, RR ;
HOEY, JM .
INTERFACES, 1990, 20 (02) :21-29
[10]   SIMPLE APPROACHES TO SHIFT, DAYS-OFF AND TOUR SCHEDULING PROBLEMS [J].
MORRIS, JG ;
SHOWALTER, MJ .
MANAGEMENT SCIENCE, 1983, 29 (08) :942-950