Spreadsheet Heuristic for Stochastic Demand Environments to Solve the Joint Replenishment Problem

Turkay B., ALPTEKİN S. E.

World Congress on Engineering (WCE 2013), London, Canada, 3 - 05 July 2013, pp.506-507 identifier identifier

  • Publication Type: Conference Paper / Full Text
  • City: London
  • Country: Canada
  • Page Numbers: pp.506-507
  • Galatasaray University Affiliated: Yes


In this paper, a new adaptation of spreadsheet heuristic for stochastic demand environment is presented. The simplicity of application of spreadsheet method and its efficiency enable us to consider its modified version for the joint replenishment problem under stochastic demand. The principle of the procedure is to find a balance between the replenishment and holding costs for jointly replenished items. The heuristic performance is tested on real business data and we found out that it performs well in comparison with well known RAND heuristic. Owing to the simplicity and effectiveness of the proposed algorithm, we believe that it can be applicable in retail industry.