Periodicity.: November - December 2019
e-ISSN......: 2236-269X
Cover Image

Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location

Andrew Arthur Tiger, John Loucks, Connor Burns

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.


Keywords


risk pooling; facility location; supply chain modeling; spreadsheet-based simulation

Full Text:

PDF HTML

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.




DOI: http://dx.doi.org/10.14807/ijmp.v10i6.960

Article Metrics

Metrics Loading ...

Metrics powered by PLOS ALM

Refbacks

  • There are currently no refbacks.


Copyright (c) 2019 Andrew Arthur Tiger, John Loucks, Connor Burns

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

LIBRARIES BY

Logo Gaudeamus

Logo INDIANA

Logo CHENG KUNG

Logo UTEP

Logo MOBIUS

Logo UNIVEM

Logo Kennedy

Logo Columbia

Logo UCS

Logo MSG/UFF

Logo OPT

Logo Biblioteca Professor Milton Cabral Moreira

Logo UFL

Logo ULRICHSWEB

Logo UNISA