Get 20M+ Full-Text Papers For Less Than $1.50/day. Start a 14-Day Trial for You or Your Team.

Learn More →

Spreadsheet analysis to show effect to customer service level on inventory

Spreadsheet analysis to show effect to customer service level on inventory 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. http://www.deepdyve.com/assets/images/DeepDyve-Logo-lg.png International Journal of Business Performance and Supply Chain Modelling Inderscience Publishers

Loading next page...
 
/lp/inderscience-publishers/spreadsheet-analysis-to-show-effect-to-customer-service-level-on-d4rB1OeY1r
Publisher
Inderscience Publishers
Copyright
Copyright © Inderscience Enterprises Ltd. All rights reserved
ISSN
1758-9401
eISSN
1758-941X
DOI
10.1504/IJBPSCM.2009.033747
Publisher site
See Article on Publisher Site

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.

Journal

International Journal of Business Performance and Supply Chain ModellingInderscience Publishers

Published: Jan 1, 2009

There are no references for this article.