Open AccessSolving Transportation Models With Spreadsheet Software
Author(s) -
Steven C. Ross,
Richard L. Schwaller
Publication year - 2011
Publication title -
journal of applied business research
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.149
H-Index - 22
eISSN - 2157-8834
pISSN - 0892-7626
DOI - 10.19030/jabr.v6i3.6291
Subject(s) - computer science , software , simple (philosophy) , software engineering , industrial engineering , operations research , programming language , engineering , philosophy , epistemology
This paper describes the solution of transportation models on personal computers (PCs) using spreadsheet and other readily-available software. We choose PCs because of their commonness in university colleges of business and in organizations of all size. The models discussed include a simple transportation model and more complex models involving quantity discounts and multiple brands. The techniques are applicable to other linear programming situations. To facilitate their use, detailed descriptions of both model formulation and the use of the optimizing software are provided.