Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets

Kenneth David Strang
Additional contact information
Kenneth David Strang: Department of Business and Supply Chain Management, State University of New York, Plattsburgh, NY, USA, & APPC Research, Sydney, NSW, Australia

International Journal of Applied Logistics (IJAL), 2012, vol. 3, issue 4, 1-14

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.

Date: 2012
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... .4018/jal.2012100101 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jal000:v:3:y:2012:i:4:p:1-14

Access Statistics for this article

International Journal of Applied Logistics (IJAL) is currently edited by Lincoln C. Wood

More articles in International Journal of Applied Logistics (IJAL) from IGI Global
Bibliographic data for series maintained by Journal Editor ().