Designing Large-Scale Supply-Chain Linear Programs in Spreadsheets

Communications of the ACM 50(8), 59-64 (2007)

14 Pages Posted: 1 Feb 2008 Last revised: 23 Nov 2012

See all articles by Larry J. LeBlanc

Larry J. LeBlanc

Vanderbilt University - Operations Management

Michael Galbreth

University of Tennessee, Knoxville - Haslam College of Business

Date Written: October 2, 2012

Abstract

Abstract A supply chain is a network of facilities for activities such as raw materials procurement, finished goods manufacturing, and distribution of products to customers. Because of competitive pressures, many organizations have expanded their supply chains to include international sites for cheaper production and/or increased sales. The result has been increasingly complex supply chain management problems. One approach to dealing with such complexities is the use of a linear program (LP), a type of optimization model for applications such as minimizing costs or maximizing profits. Unfortunately, in the past LPs were explained in algebraic terms, which was confusing to many non-specialists. Recently, however, the awareness of LPs by non-technical senior managers has greatly increased because they can be explained more intuitively using spreadsheets. Given the advent of spreadsheets for LP, more managers are approving the use of the now-familiar linear programming approach for minimizing supply chain costs. As a result, supply chain LP models have become one of the most common LPs being solved.

Suggested Citation

LeBlanc, Larry and Galbreth, Michael, Designing Large-Scale Supply-Chain Linear Programs in Spreadsheets (October 2, 2012). Communications of the ACM 50(8), 59-64 (2007), Available at SSRN: https://ssrn.com/abstract=1088443

Larry LeBlanc (Contact Author)

Vanderbilt University - Operations Management ( email )

Nashville, TN 37203
United States

Michael Galbreth

University of Tennessee, Knoxville - Haslam College of Business ( email )

453 Haslam Business Building
Knoxville, TN 37996-4140
United States

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
394
Abstract Views
2,200
Rank
137,540
PlumX Metrics