Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location
Article Sidebar
Main Article Content
Abstract
Inventory risk pooling is the use of centralized inventory to maintain lower overall inventory and safety stock. Generally, in a decentralized system with no risk pooling, a retailer maintaining its own inventory and safety stock requires higher levels of inventory than would be if the inventory was pooled at a centralized location. Most pedagogy relies on algebraic formula-based examples, which has two issues: (1) student struggle visualizing variability concepts and algebraic notation and (2) the location of the centralized inventory location and its effect on lead times are often ignored or assumed to be negligible. To address these issues, the spreadsheet-based simulation offers visual cues of the inventory reduction benefits, as well as demonstrating the impact of the facility location. The simulation was developed using MS Excel, and has a simple, easy-to-use interface, as well as easy-to-understand graphical and statistical output. Both undergraduate and MBA students respond favorably to the simulation because it helps them understand the math concepts, and it strengthens their spreadsheet skills.
The inventory policy is an order-up-to-level with a weekly periodic review system. Backorders must be filled. Inputs include the number of customers, desired service level, weekly customer standard deviation of demand, lead times and inventory order-up-to levels. Outputs include weekly and annual inventory and service levels for both the decentralized and centralized (risk pooling) systems.
Downloads
Article Details
1. Proposal of Policy for Free Access Periodics
Authors whom publish in this magazine should agree to the following terms:
a. Authors should keep the copyrights and grant to the magazine the right of the first publication, with the work simultaneously permitted under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 that allows the sharing of the work with recognition of the authorship of the work and initial publication in this magazine.
b. Authors should have authorization for assuming additional contracts separately, for non-exclusive distribution of the version of the work published in this magazine (e.g.: to publish in an institutional repository or as book chapter), with recognition of authorship and initial publication in this magazine.
c. Authors should have permission and should be stimulated to publish and to distribute its work online (e.g.: in institutional repositories or its personal page) to any point before or during the publishing process, since this can generate productive alterations, as well as increasing the impact and the citation of the published work (See The Effect of Free Access).
Proposal of Policy for Periodic that offer Postponed Free Access
Authors whom publish in this magazine should agree to the following terms:
a. Authors should keep the copyrights and grant to the magazine the right of the first publication, with the work simultaneously permitted under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 [SPECIFY TIME HERE] after the publication, allowing the sharing of the work with recognition of the authorship of the work and initial publication in this magazine.
b. Authors should have authorization for assuming additional contracts separately, for non-exclusive distribution of the version of the work published in this magazine (e.g.: to publish in institutional repository or as book chapter), with recognition of authorship and initial publication in this magazine.
c. Authors should have permission and should be stimulated to publish and to distribute its work online (e.g.: in institutional repositories or its personal page) to any point before or during the publishing process, since this can generate productive alterations, as well as increasing the impact and the citation of the published work (See The Effect of Free Access).
d. They allow some kind of open dissemination. Authors can disseminate their articles in open access, but with specific conditions imposed by the editor that are related to:
Version of the article that can be deposited in the repository:
Pre-print: before being reviewed by pairs.
Post-print: once reviewed by pairs, which can be:
The version of the author that has been accepted for publication.
The editor's version, that is, the article published in the magazine.
At which point the article can be made accessible in an open manner: before it is published in the magazine, immediately afterwards or if a period of seizure is required, which can range from six months to several years.
Where to leave open: on the author's personal web page, only departmental websites, the repository of the institution, the file of the research funding agency, among others.
References
ANDERSON, E. G. J.; MORRICE, D. J. (2000) A simulation game for teaching service-oriented supply chain management: does information sharing help managers with service capacity decisions? Production and Operations Management, March, v. 9, n. 1, p. 40-55.
ANON. (2000) Inventory management and risk pooling. Available: https://www.slideshare.net/pirama2000/3-inventory-management-and-risk-pooling. Access: 14/02/2019.
ANON. (2016) Supply Chain Risk Pooling: Definition & Purpose - Video & Lesson. Available: https://study.com/academy/lesson/supply-chain-risk-pooling-definition-purpose.html. Access: 14/02/2019.
ANON. (2018) @RISK: Risk Analysis using Monte Carlo Simulation in Excel and Project - Palisade – Palisade. Available: https://www.palisade.com/risk/. Access: 14/02/2019.
BOUTE, R. N.; LAMBRECHT, M. R. (2009) Exploring the bullwhip effect by means of spreadsheet simulation. INFORMS Transactions on Education, September, v. 10, n. 1, p. 1-9.
FORRESTER, J. W. (1958) Industrial dynamics: a major breakthrough for decision makers. Harvard Business Review, v. 36, p. 37-66.
HOPP, W. J. (2008) Supply chain science. 1 ed. Boston: McGraw-Hill/Irwin.
KUMAR, S. K.; TIWARI, M. (2013) Supply chain system design integrated with risk pooling. Computers & Industrial Engineering, February, v. 64, n. 2, p. 580-588.
MANRIQUE, E. D. (2018) The risk pool game: gameplay. Available: https://www.youtube.com/watch?v=pCAeHWIDX3M. Access: 14/02/2019.
MARQUEZ, A. (2018) Risk pooling 1. Available: https://www.youtube.com/watch?v=Y79qRqq4HhE. Access: 14/02/2019.
MILLAR, D. H. (2018) Inventory Management and Risk Pooling in the Supply Chain Part 1. Available: https://www.youtube.com/watch?v=jDI9MAV_pyw. Access: 14/02/2019.
OESER, G. (2010) Methods of Risk Pooling in Business Logistics and Their Application. Dissertation. Frankfurt: Europa-Universitat Viadrina Frankfurt (Oder).
OZSEN, L.; COULLARD, C. R.; DASKIN, M. (2008) Capacitated warehouse location model with risk pooling. Naval Research Logistics, June, v. 55, n. 4, p. 295-312.
SCHMITT, A. J.; SUN, A.; SNYDER, L. V.; SHEN, Z.J. M. (2015) Centralization versus decentralization: risk pooling, risk diversification, and supply chain disruptions. Omega, April, v. 52, p. 201-212.
SCHUSTER PUGA, M.; TANCREZ, J. S. (2017) A heuristic algorithm for solving large location–inventory problems with demand uncertainty. European Journal of Operational Research, June, v. 259, p. 413-423.
SIMCHI-LEVI, D.; KAMINSKY, P.; SIMCHI-LEVI, E. (2008) Designing and managing the supply chain, 3 ed. New York: McGraw-Hill.
SNYDER, L.; DASKIN, M. S.; TEO, C.P. (2007) The stochastic location model with risk pooling. European Journal of Operational Research, v. 179 n. 3, p. 1221-1238.
TIGER, A. A.; BENCO, D. C.; FOGLE, C. (2006) Teaching the importance of information, supply chain management, and modeling: the spreadsheet beer-like game. Issues in Information Systems, v. 7, n. 1, p. 108-113.
TZIMERMAN, A.; HERER, Y.; SHTUB, A. (2013) In: APMS: IFIP INTERNATIONAL CONFERENCE ON ADVANCES IN PRODUCTION MANAGEMENT SYSTEMS. Berlin, Proceedings …: Berlin: 2013.
W.P. CAREY SCHOOL OF BUSINESS (2018) Module 1: What is supply chain management? Available: https://www.youtube.com/watch?v=Mi1QBxVjZAw. Access: 14/02/2019.
YANG, H.; SCHRAGE, L. (2009) Conditions that cause risk pooling to increase inventory. European Journal of Operational Research, February, v. 192, n. 3, p. 837-851.
ZHANG, Y.; SNYDER, L. V.; QI, M.; ZHANG, Y. (2016) A heterogeneous reliable location model with risk pooling under supply disruptions. Transportation Research: Part B., January, V. 83, p. 151-178.