Welcome to the InfoSci Platform
Reference Hub10
Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets

Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets

Kenneth David Strang
Copyright: © 2012 |Volume: 3 |Issue: 4 |Pages: 14
ISSN: 1947-9573|EISSN: 1947-9581|EISBN13: 9781466610828|DOI: 10.4018/jal.2012100101
Cite Article Cite Article

MLA

Strang, Kenneth David. "Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets." IJAL vol.3, no.4 2012: pp.1-14. http://doi.org/10.4018/jal.2012100101

APA

Strang, K. D. (2012). Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets. International Journal of Applied Logistics (IJAL), 3(4), 1-14. http://doi.org/10.4018/jal.2012100101

Chicago

Strang, Kenneth David. "Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets," International Journal of Applied Logistics (IJAL) 3, no.4: 1-14. http://doi.org/10.4018/jal.2012100101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

This is a case study of a coal mining company to demonstrate how algebra principles and nonlinear goal programming can be applied for logistics planning using spreadsheet software. The paper asserts that mathematical programming techniques are not well-accepted by managers because the models are difficult to understand due to abstract notational conventions yet alternative commercial software is inflexible (and sometimes inaccurate). The relevant operations research literature was reviewed, highlighting techniques applicable for analyzing quantitative and qualitative logistics data. A practical supply-demand transportation logistics model was built which included determinist constraints and stochastic costing theories, while applying both linear and nonlinear calculus slope principles. The formulae were explained in algebraic standard form (citing corresponding spreadsheet functions). The logistics problem was optimized, illustrating how 6 mining sites could supply 4 countries with sufficient coal to meet different electricity demand levels, surpassing the break-even goal and projecting annual revenue of over $34 billion.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.