Copy of LP Excel Examples

# Copy of LP Excel Examples - A K T Consumed Relationships...

This preview shows pages 1–4. Sign up to view the full content.

Sample Problem #1 Minimize Artesha Minor Left Hand Side X1 X2 X3 Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 0 0 0 Constraints Labor Hours 5 6 4 0 >= 210 210 Materials Pounds 10 8 5 0 >= 200 200 Machine Minutes 4 2 5 0 >= 170 170 Objective Minimize 15 20 14 0

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Maximize B.14 Artesha Minor X1 X2 X3 Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 0 0 0 0 Constraints Labor Hours 1 7 4 0 <= 100 100 Materials Pounds 2 1 7 0 <= 110 110 Machine Minutes 8 4 1 0 <= 100 100 Objective Maximize 4 4 7 0 X1 X2 X3 Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 0 0 0 0 Constraints Labor Hours 1 7 5 0 <= 100 100 Materials Pounds 2 1 7 0 <= 110 110 Machine Minutes 8 4 1 0 <= 100 100 Objective Maximize 4 4 7 0 X1 X2 X3 Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 0 0 0 0 Constraints Labor Hours 1 7 4 0 <= 100 100 Materials Pounds 2 1 7 10 <= 110 100 Machine Minutes 8 4 1 0 <= 100 100 Objective Maximize 4 4 7 0 B.23 A K T Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 0 0 0 0 Constraints Labor Hours 480 1440 960 0 <= 240 240 Materials Pounds 260 130 390 0 <= 130 130 Objective Maximize \$9 \$7 \$15 0
Sample Problem #2 MSOM 3101 Left Hand Side A K T Consumed

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A K T Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 Constraints packing time 2 6 4 <= 210 210 packing pounds 2 1 3 <= 289 289 Av. Each week 130 130 130 <= 327 327 Av. Each week 4 2 5 <= 170 170 Minimum Quantities 240 240 240 Objective Maximize 9 7 15 A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Sample Problem #2 MSOM 3101 Left Hand Side X1 X2 X3 Consumed Relationships RHS - Fixed Slack Variables X1, X2, X3 >= 0 Constraints Labor Hours 5 6 4 <= 210 210 Brass Pounds 10 8 5 <= 289 289 Bronze Pounds 9 13 11 <= 327 327 Machine Minutes 4 2 5 <= 170 170 Minimum Quantities 2 4 7 Maximum Quantities 9 16 18 Objective Maximize 15 16 14 A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...
View Full Document

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern