Sec 4 LP examples (Sidneyville, Cookie, Blue Ridge, Candy Counter).xlsx - Objective function coefficients Decision variables Constraints Pine Cedar

# Sec 4 LP examples (Sidneyville, Cookie, Blue Ridge, Candy Counter).xlsx

• 13

This preview shows page 1 - 7 out of 13 pages.

X1 (Rolltop) X2 (Regular) Objective function coefficients 115 90 Total profits Decision variables 12 4 1740 Constraints LHS RHS Pine 10 20 200 200 Cedar 4 16 112 128 Maple 15 10 220 220
Microsoft Excel 16.0 Answer Report Worksheet: [LP examples (sec 4).xlsx]Sheet1 Report Created: 3/11/2020 11:49:54 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegati Objective Cell (Max) Cell Name Original Value Final Value \$E\$4 Decision variables Total profits 500 1740 Variable Cells Cell Name Original Value Final Value Integer \$C\$4 Decision variables X1 (Rolltop) 2 12 Contin \$D\$4 Decision variables X2 (Regular) 3 4 Contin Constraints Cell Name Cell Value Formula Status Slack \$E\$7 Pine LHS 200 \$E\$7<=\$F\$7 Binding 0 \$E\$8 Cedar LHS 112 \$E\$8<=\$F\$8 Not Binding 16 \$E\$9 Maple LHS 220 \$E\$9<=\$F\$9 Binding 0
tive
Objective function coefficients 30 20 Total revenue Decision variables 2 1 80 Constraints: LHS RHS Butter: 2 2 6 6 Sugar: 1 2 4 5 Eggs: 2 3 7 12 Choc chips: 1 0 2 2 Flour: 2 2 6 10 Xc (#batches of choc chip cookie) Xs (#batches of sugar cookie)