Question: D Question 10 10 pts Quality Bike Maps has produced four map designs for the local area. A limited amount of time (in minutes) is


D Question 10 10 pts Quality Bike Maps has produced four map designs for the local area. A limited amount of time (in minutes) is allocated to the printing, cutting and folding of each map. Additionally, at least one thousand of map designs A, B, and C must be printed. The profit per map is $1 for A and B and $2 for C and D. Use the Report below and assume the current objective function value is $10,166.67, to determine the new objective function value if the profit for Map D increases by $1. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB$ 18 Map A 1500 O 0 3333 SC$ 18 Map B 1000 0 33333 18+30 SDS18 Map C 1000 O 2 0.33333 1E+30 SE$18 Map D 2833 33 ON 2 05 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SBS24 Print 5000 0.5 15000 1000 5666.6667 SB$25 Cut 16500 20000 18+ 30 3500 SBS26 Fold 20000 0. 16667 20000 7000 1000 SBS27 PrintA 1500 1000 500 E+30 SB$28 PrintB 1000 -0 33333 1000 1750 1000 SBS29 PrintC 1000 -0 33333 1000 500 1000 11,666.67 O W would 73.F Clear ~Cell Name Value most CoefficientIncrease Decrease $B$18: Map A 1500 0.3333 SC$18 Map B 1000 0 33333 18+ 30 SD$18: Map C 1000 0.33333 18+ 30 SE$18: Map D 2833.33 05 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$24: Print 15000 0.5 15000 1000 5666.6667 $B$25 Cut 6500 0 20000 18+30 3500 SB$26 Fold 20000 0 16667 20000 7000 1000 SB$27: PrintA 1500 O 1000 500 16+30 SB$28 PrintB 1000 -0 33333 1000 1750 1000 SB$29 Printc 000 0.33333 1000 500 1000 11,666.67 13,666.67 Exceeds the range of optimality. 13,000.00 8666.67 Previous arch O 73"F Clear
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
