There are three warehouses at different cities: Detroit, Pittsburgh
and Buffalo. They have 250, 130 and 235 tons of paper accordingly. There are four
publishers in Boston, New York, Chicago and Indianapolis. They ordered 75, 230,
240 and 70 tons of paper to publish new books.
There are the following costs in dollars of transportation of one ton of paper:
|From \ To||Boston (BS)||New York (NY)||Chicago (CH)||Indianapolis (IN)|
We denote the cost of transportation from one city to another by C_ prefix, for example cost from Buffalo to Chicago is C_BF_CH.
We have to find a plan that all orders will be performed and the transportation
costs will be minimized. The decision variables are amounts of tons transported
from one city to another denoted by prefix X_:
X_DT_BS= tons from Detroit to Boston,
X_PT_BS= tons from Pittsburgh to Boston,
X_BF_NY= tons from Buffalo to New York and etc.
The objective function is sum of multiplications of transported tons
and their costs:
F = C_DT_BS*X_DT_BS + C_DT_NY*C_DT_NY + C_DT_CH*C_DT_CH + …
The constraints are defined in terms of the transported paper amount from one warehouse or to one publisher.
Amount transported from Detroit cannot be more than 250 tons:
X_DT_BS + X_DT_NY + X_DT_CH + X_DT_IN <= 250
The problem has been solved successfully with the following plan:
|From \ To||Boston||New York||Chicago||Indianapolis||Sent|
The Total Cost of Transportation is $7780
linear programming GIPALS Start
Linear programming examples
There are several examples of linear programming intended to make the users of GIPALS familiar with it. These examples are included in GIPALS installation and can be found in ..\GIPALS\Examples folder.
See Screen Shots: Variables Page | Calculation Process | Constraint Page (Compact view) | Matrix Palette Dialog | Result Page | Debug Options Dialog
GIPALS Linear Programming $197.95 - 15000 Constraints & Variables | $297.00 - Unlimited Number of Constraints & Variables
Special ! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates