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

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)
Microsoft Excel 16.0 Answer Report

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture