Scribd
Upload
4 views2 pages

Linear Programming Setup Guide

This spreadsheet document provides an example of linear programming to maximize an objective function subject to constraints. It shows the setup of the problem with variables for labor hours and materials pounds, with corresponding coefficients and inequality constraints. The results section lists the optimal objective value and variables when solved using a linear programming solver tool.

Uploaded by

vanessa
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
4 views2 pages

Linear Programming Setup Guide

This spreadsheet document provides an example of linear programming to maximize an objective function subject to constraints. It shows the setup of the problem with variables for labor hours and materials pounds, with corresponding coefficients and inequality constraints. The results section lists the optimal objective value and variables when solved using a linear programming solver tool.

Uploaded by

vanessa
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

LP_max

Example This spreadsheet was created by either POM, QM or POM-QM for Windows, V3. Then g
TOOLS, SOLVER, SOLVE on the menu bar at the top.
Linear, Integer or Mixed Integer Programming

Signs
< less than or equal to
= equals (You need to enter an apostrophe first.)
> greater than or equal to

Data Results Problem setup area


x y LHS Slack/Surplus
Objective 3 3 < 1 0 < constraints
labor hours 3 4 < 14 0 14 0
material (pound 6 4 < 15 0 15 0

Results
Variables
Objective 0

Page 1
LP_max

QM
QM for
for Windows,
Windows, V3.
V3. Then
Then go
go to
to

Problem setup area

< constraints > constraints


14 0 0
15 0 0

Page 2

You might also like