{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:48:40Z","timestamp":1781110120868,"version":"3.54.1"},"reference-count":39,"publisher":"IGI Global Scientific Publishing","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2012,10,1]]},"abstract":"<p>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.<\/p>","DOI":"10.4018\/jal.2012100101","type":"journal-article","created":{"date-parts":[[2013,1,29]],"date-time":"2013-01-29T15:47:33Z","timestamp":1359474453000},"page":"1-14","source":"Crossref","is-referenced-by-count":10,"title":["Logistic Planning with Nonlinear Goal Programming Models in Spreadsheets"],"prefix":"10.4018","volume":"3","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-4333-4399","authenticated-orcid":true,"given":"Kenneth David","family":"Strang","sequence":"first","affiliation":[{"name":"Department of Business and Supply Chain Management, State University of New York, Plattsburgh, NY, USA, & APPC Research, Sydney, NSW, Australia"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"jal.2012100101-0","unstructured":"Argus. (2011). Argus coal daily international. London, UK: Argus Media."},{"key":"jal.2012100101-1","year":"2009","journal-title":"The Australian coal industry facts and regulations"},{"key":"jal.2012100101-2","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2008.11.050"},{"key":"jal.2012100101-3","year":"2011","journal-title":"BP review of US statistical energy"},{"key":"jal.2012100101-4","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2007.10.040"},{"key":"jal.2012100101-5","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2006.06.033"},{"key":"jal.2012100101-6","doi-asserted-by":"crossref","DOI":"10.1002\/9780470400531","volume":"Vol. 8","author":"J. J.Cochran","year":"2011","journal-title":"Wiley encyclopedia of operations research and management science"},{"key":"jal.2012100101-7","doi-asserted-by":"publisher","DOI":"10.1177\/1558689807306132"},{"key":"jal.2012100101-8","doi-asserted-by":"publisher","DOI":"10.1016\/S0377-2217(95)00380-0"},{"issue":"2","key":"jal.2012100101-9","first-page":"93","article-title":"The use of the case study method in logistics research.","volume":"17","author":"L. M.Ellram","year":"1996","journal-title":"Journal of Business Logistics"},{"key":"jal.2012100101-10","doi-asserted-by":"publisher","DOI":"10.1016\/0377-2217(92)90123-Q"},{"key":"jal.2012100101-11","year":"2010","journal-title":"Key world energy statistics"},{"key":"jal.2012100101-12","doi-asserted-by":"publisher","DOI":"10.1016\/0377-2217(94)00016-6"},{"key":"jal.2012100101-13","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2009.05.002"},{"key":"jal.2012100101-14","doi-asserted-by":"publisher","DOI":"10.1016\/S0377-2217(98)00392-0"},{"key":"jal.2012100101-15","doi-asserted-by":"publisher","DOI":"10.3905\/JPM.2009.35.2.050"},{"key":"jal.2012100101-16","doi-asserted-by":"publisher","DOI":"10.1287\/opre.9.3.383"},{"key":"jal.2012100101-17","doi-asserted-by":"publisher","DOI":"10.1287\/mnsc.1040.0267"},{"key":"jal.2012100101-18","doi-asserted-by":"publisher","DOI":"10.1108\/09600030410552258"},{"issue":"1","key":"jal.2012100101-19","first-page":"77","article-title":"Portfolio selection.","volume":"7","author":"H.Markowitz","year":"1952","journal-title":"The Journal of Finance"},{"key":"jal.2012100101-20","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2011.01.046"},{"key":"jal.2012100101-21","doi-asserted-by":"publisher","DOI":"10.1016\/0377-2217(77)90043-1"},{"key":"jal.2012100101-22","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2006.12.006"},{"key":"jal.2012100101-23","doi-asserted-by":"publisher","DOI":"10.1016\/S0377-2217(98)00273-2"},{"key":"jal.2012100101-24","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2005.06.062"},{"key":"jal.2012100101-25","doi-asserted-by":"publisher","DOI":"10.1016\/0377-2217(79)90224-8"},{"key":"jal.2012100101-26","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2010.05.031"},{"key":"jal.2012100101-27","doi-asserted-by":"publisher","DOI":"10.1016\/0377-2217(92)90054-D"},{"issue":"3","key":"jal.2012100101-28","first-page":"1","article-title":"Using recursive regression to explore nonlinear relationships and interactions: A tutorial applied to a multicultural education study.","volume":"14","author":"K. D.Strang","year":"2009","journal-title":"Practical Assessment, Research & Evaluation"},{"issue":"3","key":"jal.2012100101-29","first-page":"94","article-title":"Radiology manufacturing projects and politics: scientist and politician normalized risk decision processes.","volume":"11","author":"K. D.Strang","year":"2010","journal-title":"International Journal of Management and Decision Making"},{"issue":"2","key":"jal.2012100101-30","doi-asserted-by":"crossref","first-page":"81","DOI":"10.1002\/pmj.20212","article-title":"Portfolio selection methodology for a nuclear project.","volume":"42","author":"K. D.Strang","year":"2011","journal-title":"Project Management Journal"},{"key":"jal.2012100101-31","doi-asserted-by":"publisher","DOI":"10.4018\/jeei.2010010102"},{"issue":"1","key":"jal.2012100101-32","first-page":"59","article-title":"A nonpreemptive goal programming approach to truck dispatching in open pit mines.","volume":"7","author":"V. A.Temeng","year":"1998","journal-title":"Internal Civil Engineering Abstracts"},{"key":"jal.2012100101-33","doi-asserted-by":"publisher","DOI":"10.4018\/jal.2010040102"},{"key":"jal.2012100101-34","doi-asserted-by":"publisher","DOI":"10.1057\/jors.2008.178"},{"issue":"3","key":"jal.2012100101-35","first-page":"285","article-title":"Equity portfolio management within the MCDM frame: A literature review. International Journal of Banking","volume":"1","author":"P.Xidonas","year":"2009","journal-title":"Accounting and Finance"},{"key":"jal.2012100101-36","doi-asserted-by":"publisher","DOI":"10.1016\/S0377-2217(96)00077-X"},{"key":"jal.2012100101-37","author":"R. K.Yin","year":"2003","journal-title":"Case study research: Design and methods"},{"key":"jal.2012100101-38","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2009.01.043"}],"container-title":["International Journal of Applied Logistics"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=74728","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,5,5]],"date-time":"2024-05-05T04:20:03Z","timestamp":1714882803000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jal.2012100101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2012,10,1]]},"references-count":39,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2012,10]]}},"URL":"https:\/\/doi.org\/10.4018\/jal.2012100101","relation":{},"ISSN":["1947-9573","1947-9581"],"issn-type":[{"value":"1947-9573","type":"print"},{"value":"1947-9581","type":"electronic"}],"subject":[],"published":{"date-parts":[[2012,10,1]]}}}