 Spreadsheet analysis to show effect to customer service level on inventoryPradheep Lakshmanaswamy, Malini Natarajarathinam and Brijesh Rao International Journal of Business Performance and Supply Chain Modelling, 2009, vol. 1, issue 4, 307-318 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. (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:ids:ijbpsc:v:1:y:2009:i:4:p:307-318 Access Statistics for this article More articles in International Journal of Business Performance and Supply Chain Modelling from Inderscience Enterprises Ltd |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.