Title: Spreadsheet analysis to show effect to customer service level on inventory

Authors: Pradheep Lakshmanaswamy, Malini Natarajarathinam, Brijesh Rao

Addresses: Dept. of Industrial and Systems Engineering, Texas A&M University, College Station, TX 77843, USA. ' Dept. of Engineering Technology and Industrial Distribution, Texas A&M University, College Station, TX 77843, USA. ' Bayer Business and Technology Services LLC, Supply Chain and Logistics, Baytown, TX 77520, USA

Abstract: This paper describes the use of a spreadsheet for simulating inventory replenishment systems for a multi-echelon supply chain model. A spreadsheet model was built using Excel VBA Macro to explore the replenishment policies and inventory carrying units of the branches and the distribution centre of a multi-echelon model by considering a demand that is normally distributed. Managing inventory and keeping stock at optimum levels are two of the foremost considerations in this paper. This paper shows how the customer service levels vary according to the replenishment policies given the specific capacity restrictions and demand patterns in a multi-echelon supply chain. As such, the spreadsheet can be used as a tool to gain a clear insight into the use of inventory control policies and demand patterns in relation to the customer service.

Keywords: inventory policies; customer service levels; demand patterns; distribution centres; spreadsheet simulation; inventory replenishment; multi-echelon supply chains; supply chain management; SCM; inventory management; stock levels; inventory control.

DOI: 10.1504/IJBPSCM.2009.033747

International Journal of Business Performance and Supply Chain Modelling, 2009 Vol.1 No.4, pp.307 - 318

Published online: 30 Jun 2010 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article