Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location
Autor(a) principal: | |
---|---|
Data de Publicação: | 2019 |
Outros Autores: | , |
Tipo de documento: | Artigo |
Idioma: | eng |
Título da fonte: | Independent Journal of Management & Production |
Texto Completo: | http://www.ijmp.jor.br/index.php/ijmp/article/view/960 |
Resumo: | 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. |
id |
IJMP_bc14fff923755e4bcc82767d9d2832e6 |
---|---|
oai_identifier_str |
oai:www.ijmp.jor.br:article/960 |
network_acronym_str |
IJMP |
network_name_str |
Independent Journal of Management & Production |
repository_id_str |
|
spelling |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility locationrisk poolingfacility locationsupply chain modelingspreadsheet-based simulationInventory 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.Independent2019-12-01info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdftext/htmlhttp://www.ijmp.jor.br/index.php/ijmp/article/view/96010.14807/ijmp.v10i6.960Independent Journal of Management & Production; Vol. 10 No. 6 (2019): Independent Journal of Management & Production; 1932-19512236-269X2236-269Xreponame:Independent Journal of Management & Productioninstname:Instituto Federal de Educação, Ciência e Tecnologia de São Paulo (IFSP)instacron:IJM&Penghttp://www.ijmp.jor.br/index.php/ijmp/article/view/960/1220http://www.ijmp.jor.br/index.php/ijmp/article/view/960/1221Copyright (c) 2019 Andrew Arthur Tiger, John Loucks, Connor Burnsinfo:eu-repo/semantics/openAccessTiger, Andrew ArthurLoucks, JohnBurns, Connor2020-02-01T02:43:03Zoai:www.ijmp.jor.br:article/960Revistahttp://www.ijmp.jor.br/PUBhttp://www.ijmp.jor.br/index.php/ijmp/oaiijmp@ijmp.jor.br||paulo@paulorodrigues.pro.br||2236-269X2236-269Xopendoar:2020-02-01T02:43:03Independent Journal of Management & Production - Instituto Federal de Educação, Ciência e Tecnologia de São Paulo (IFSP)false |
dc.title.none.fl_str_mv |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
title |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
spellingShingle |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location Tiger, Andrew Arthur risk pooling facility location supply chain modeling spreadsheet-based simulation |
title_short |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
title_full |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
title_fullStr |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
title_full_unstemmed |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
title_sort |
Spreadsheet-based supply chain simulation for teaching risk pooling combined with facility location |
author |
Tiger, Andrew Arthur |
author_facet |
Tiger, Andrew Arthur Loucks, John Burns, Connor |
author_role |
author |
author2 |
Loucks, John Burns, Connor |
author2_role |
author author |
dc.contributor.author.fl_str_mv |
Tiger, Andrew Arthur Loucks, John Burns, Connor |
dc.subject.por.fl_str_mv |
risk pooling facility location supply chain modeling spreadsheet-based simulation |
topic |
risk pooling facility location supply chain modeling spreadsheet-based simulation |
description |
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. |
publishDate |
2019 |
dc.date.none.fl_str_mv |
2019-12-01 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://www.ijmp.jor.br/index.php/ijmp/article/view/960 10.14807/ijmp.v10i6.960 |
url |
http://www.ijmp.jor.br/index.php/ijmp/article/view/960 |
identifier_str_mv |
10.14807/ijmp.v10i6.960 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
http://www.ijmp.jor.br/index.php/ijmp/article/view/960/1220 http://www.ijmp.jor.br/index.php/ijmp/article/view/960/1221 |
dc.rights.driver.fl_str_mv |
Copyright (c) 2019 Andrew Arthur Tiger, John Loucks, Connor Burns info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Copyright (c) 2019 Andrew Arthur Tiger, John Loucks, Connor Burns |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf text/html |
dc.publisher.none.fl_str_mv |
Independent |
publisher.none.fl_str_mv |
Independent |
dc.source.none.fl_str_mv |
Independent Journal of Management & Production; Vol. 10 No. 6 (2019): Independent Journal of Management & Production; 1932-1951 2236-269X 2236-269X reponame:Independent Journal of Management & Production instname:Instituto Federal de Educação, Ciência e Tecnologia de São Paulo (IFSP) instacron:IJM&P |
instname_str |
Instituto Federal de Educação, Ciência e Tecnologia de São Paulo (IFSP) |
instacron_str |
IJM&P |
institution |
IJM&P |
reponame_str |
Independent Journal of Management & Production |
collection |
Independent Journal of Management & Production |
repository.name.fl_str_mv |
Independent Journal of Management & Production - Instituto Federal de Educação, Ciência e Tecnologia de São Paulo (IFSP) |
repository.mail.fl_str_mv |
ijmp@ijmp.jor.br||paulo@paulorodrigues.pro.br|| |
_version_ |
1797220492256477184 |