bags.xls

# bags.xls - 800 66.6666666667 866.6667 VIOLATION...

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

SHELL Page 1 Equipment Bag Problem -- First Example LP Regular Deluxe Available Cut/Dye 0.7 1 630 Sew 0.5 0.833 600 Finish 1 0.667 708 Inspect/Pack 0.1 0.25 135 Profit \$10.00 \$9.00 Regular Deluxe Profit Make Resource Usage Total Cut/Dye OK Sew OK Finish OK Inspect/Pack OK Variable x Variable x2 Objective Function Variable R Variable D R= number of regular bags D= number of deluxe bags Max 10 R + 9 D S.T. 0.7 R + D ≤ 630 0.5 R + 0.833 D ≤ 600 R + 0.677 D ≤ 708 0.1 R + 0.25 D ≤ 135 R, D ≥ 0

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

View Full Document
BAGS.XLS VALUES Equipment Bag Problem -- First Example LP Regular Deluxe Available Cut/Dye 0.7 1 630 Sew 0.5 0.833 600 Finish 1 0.667 708 Inspect/Pack 0.1 0.25 135 Profit \$10.00 \$9.00 Regular Deluxe Profit Make 800 100 \$8,900.00 Resource Usage Total Cut/Dye 560 100 660 VIOLATION <= 630 Sew 400 83.3333333333 483.3333 OK <= 600 Finish
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 800 66.6666666667 866.6667 VIOLATION &lt;= 708 Inspect/Pack 80 25 105 OK &lt;= 135 Variable R Variable D Objective Function A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BAGS.XLS FORMULAS Equipment Bag Problem -- First Example LP RegularDeluxeailable Cut/Dye 0.7 1 630 Sew 0.5 0.833 600 Finish 1 0.667 708 Inspect/Pa 0.1 0.25 135 Objective, Maximize Profit ### ### Changing cells, &gt;= 0 RegularDeluxe Profit Make 539 252 \$7,658.00 Resource Usage Total Cut/Dye 377.3 252 629.3 OK Sew 269.5 210 479.5 OK Finish 539 168 707 OK Inspect/Pa 53.9 63 116.9 OK Constrained &lt;= D4:D7 A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
View Full Document

## This note was uploaded on 11/21/2011 for the course STAT 385 taught by Professor Szatrowski during the Spring '08 term at Rutgers.

### Page1 / 3

bags.xls - 800 66.6666666667 866.6667 VIOLATION...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online