OVERCOMING SPREADSHEET RISK IN SUPPLY CHAIN MODELING

Journal of Business Logistics

Volumn 31, Issue 2, 2010, Pages 21-33

  Galbreth, Michael R ^a   LeBlanc, Larry J ^b  

^a UNIVERSITY OF SOUTH CAROLINA   (United States)

^b VANDERBILT UNIVERSITY   (United States)

Author keywords

Modeling; Optimization; Risk; Spreadsheets; Supply chain

Indexed keywords

EID: 84055180703     PISSN: 07353766     EISSN: 21581592     Source Type: Journal    
DOI: 10.1002/j.2158-1592.2010.tb00141.x     Document Type: Article

References (21)

1. Bixby, Robert (2007), “The Evolution of Optimization in Business,” Omega Rho Distinguished Lecture, INFORMS Annual Meeting, Seattle, 11/7/07 (quoted with permission).
2. Botter, Rene and Leonard Fortuin (2000), “Stocking Strategy for Service Parts—A Case Study,” International Journal of Operations and Production Management, Vol. 20, No. 6, pp. 656–674.
3. Cummings, John (2008a), “Getting to Grips with Spreadsheet Risk,” published on Business Finance (http:businessfinancemag.com), accessed on August 19, 2008.
4. Cummings, John (2008b), “Spreadsheet Risk Management: A Guide for the Perplexed,” published on Business Finance [http:businessfinancemag.com], accessed on July 10, 2008.
5. Fourer, Robert (2007), “Software Survey: Linear Programming,” OR/MS Today, Vol. 34, No. 3, pp. 42–51.
6. Glickman, Theodore (1991), “An Expeditious Risk Assessment of the Highway Transportation of Flammable Liquids in Bulk,” Transportation Science, Vol. 25, No. 2, pp. 115–123.
7. Guinipero, Larry, Robert Handfield, and D. L. Johansen (2008), “Beyond Buying,” MIT Sloan Management Review: Business Insight, posted on March 10, 2008; [http:sloanreview.mit.eduwsjinsightoperations20080310], accessed August 25, 2008.
8. Jacobs, David, John Peck, and J. Steve Davis (2000), “A Simple Heuristic for Maximizing Service of Carousel Storage,” Computers & Operations Research, Vol. 27, pp. 1351–1356.
9. Jafry, Yusuf, Christopher Marrison, and Ulrike Umkehrer-Neudeck (2008), “Hypo International Strengthens their Risk Management with a Large-Scale Secure Spreadsheet Management Framework,” Interfaces, Vol. 38, No. 4, pp. 281–288.
10. Kreie, Jennifer, Timothy Cronan, John Pendley, and Janet Renwick (2000), “Application Development by End-Users: Can Quality Be Improved? Decision Support Systems, Vol. 29, pp. 143–152.
11. Kugel, Robert (2007), “New Tools Enhance Excel,” published on Business Finance [http:businessfinancemag.com], accessed on April 1, 2007.
12. Kugel, Robert (2008), “Quick Fixes for Your Spreadsheet Snags,” published on Business Finance [http:businessfinancemag.com], accessed on November 11, 2008.
13. LeBlanc, Larry and Michael Galbreth (2007), “Designing Large-Scale Supply Chain Linear Programs in Spreadsheets,” Communications of the ACM, Vol. 50, No. 8, pp. 59–64.
14. LeBlanc, Larry, James Hill, Gregory Greenwell, and Alexander Czesnat (2004), “Nu-kote's Spreadsheet Linear Programming Models for Optimizing Transportation,” Interfaces, Vol. 34, No. 2, pp. 139–146.
15. Lipman, Timothy and Mark Delucchi (2006), “A Retail and Lifecycle Cost Analysis of Hybrid Electric Vehicles,” Transportation Research: Part D, Vol. 11, pp. 115–132.
16. Panko, Raymond and Ralph Sprague, Jr. (1999), “Hitting the Wall: Errors in Developing and Code Inspecting a ‘Simple’ Spreadsheet Model,” Decision Support Systems, Vol. 22, No. 4, pp. 337–353.
17. Schuster, Edmund, Stuart Allen, and Michael D'Itri (2000), “Capacitated Materials Requirements Planning and its Application in the Process Industries,” Journal of Business Logistics, Vol. 21, No. 1, pp. 169–189.
18. Smith, Gary (2003), “Using Integrated Spreadsheet Modeling for Supply Chain Analysis,” Supply Chain Management: An International Journal, Vol. 8, No. 4, pp. 285–290.
19. Soudhi, ManMohan (2003), “How to do Strategic Supply-Chain Planning,” MIT Sloan Management Review, Vol. 45, No. 1, pp. 69–75.
20. United States Environmental Protection Agency in the Matter of Vemco, Inc. (2008), [http:www.epa.govoaljordersvemco-pad.pdf], accessed on August 25, 2008.
21. United States Securities and Exchange Commission in the Matter of California Amplifier, Inc. (2008), [http:www.sec.govlitigationadmin34-49630.htm], accessed on August 25, 2008.