A microcomputer cashier scheduling system for supermarket stores

Emerald - Tập 25 Số 1 - Trang 34-50 - 1995
EmanuelMelachrinoudis1, MichaelOlafsson2
1Northeastern University, Boston, Massachusetts, USA
2Exxon Company USA, Greenbelt, Maryland, USA.

Tóm tắt

Labour scheduling in supermarkets is a difficult task since most employees work various shift lengths instead of standard eight‐hour shifts. With front‐end cashiers, it is even more difficult, since the number of needed cashiers is based on customer volume, which is constantly fluctuating. To create an accurate schedule, a supermarket manager must spend a good deal of time trying to match cashier shifts to customer demand. Presents a shift selection integer linear programming model which has been implemented in stores of a supermarket chain in north‐east USA. The model runs on a personal computer within an electronic spreadsheet environment, making it user‐friendly for managers. The POS data, routinely collected by registers and scanners are used for forecasting cashiers′ demand. The goal in this scheduling system is to maintain an acceptable customer service at the checkout for customer satisfaction and retention.

Từ khóa


Tài liệu tham khảo

1. Anderson, E.W., Fornell, C. and Lehmann, D.R., “Customer satisfaction, market share, and profitability: findings from Sweden”, Journal of Marketing, Vol. 58, July 1994, pp. 53‐66.

2. “60th Annual Report of the grocery industry”, Progressive Grocer, April 1993, pp. 88‐104.

3. Scotland, R., “Customer service: a waiting game”, Marketing, 11 March 1991, pp. 1‐3.

4. Katz, K., Larson, B. and Larson, R., “Prescription for the waiting in line blues: entertain, enlighten and engage”, Sloan Mathematical Review, Winter 1991, pp. 44‐53.

5. Taylor, S., “Waiting for service: the relationship between delays and evaluations of service”, Journal of Marketing, Vol. 58, April 1994, pp. 56‐9.

6. Holloran, T.J. and Byrn, J.E., “United airlines station manpower planning system”, Interfaces, Vol. 16 No. 1, January 1986, pp. 39‐50.

7. Maier‐Rothe, C. and Wolfe, P.C., “Cyclical scheduling and allocation of nursing staff”, Socio‐Economic Planning Sciences, Vol. 7 No. 5, October 1973, pp. 471‐87.

8. Blau, R.G., “Multishift personnel scheduling with a microcomputer”, Personnel Administrator, July 1985, pp. 43‐66.

9. Ignall, E., Kalesar, P. and Walker, W., “Linear programming models of crew assignments for refuse collections”, IEEE Transactions on Systems, Man, and Cybernetics, Vol. 2 No. 5, November 1972.

10. Henderson, W. and Berry, W., “Heuristic methods for telephone operator shift scheduling: an experimental analysis”, Management Science, Vol. 22 No. 12, August 1976, pp. 1372‐80.

11. Walsh, D.S., “Computerized labour scheduling: supermarkets jumping on the bandwagon”, 25th Annual Conference and Convention of the AIIE, May 1974, pp. 319‐29.

12. Ferguson, W.E., “Scheduling a supermarket front‐end to optimize productivity and customer service”, Proceedings of the Fall IIE Conference, Autumn 1986, pp. 464‐70.

13. Rust, R.T. and Zahorik, A.J., “Customer satisfaction, customer retention, and market share”, Journal of Retailing, Vol. 69 No. 2, Summer 1993, pp. 193‐215.

14. Savage, S.L., The ABCs of Optimization Using What′s Best, Holden Day, Inc., Oakland, CA, 1986.

15. Buzzel, R.D. and Gale, B.T., The PIMS Principles, The Free Press, New York, NY, 1987.

16. Parasuraman, A., Zeithaml, V.A. and Berry, L.L., “A conceptual model of service quality and its implications for further research”, Journal of Marketing, Vol. 49, February 1985, pp. 41‐50.

17. Richard, M.D. and Allaway, A.W., “Service quality attributes and choice behavior”, Journal of Services Marketing, Vol. 7 No. 1, 1993, pp. 59‐68.

18. Gross, D. and Harris, C.M., Fundamentals of Queueing Theory, 2nd ed., John Wiley & Sons, New York, NY, 1985.

19. Larson, R.C., “The queue inference engine: deducing queue statistics from transactional data”, Management Science, Vol. 36 No. 5, May 1990, pp. 585‐601 .