Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer the following question using the output below . Keeping within the confines of the problem , the profit on Map D has increased by
Answer the following question using the output below . Keeping within the confines of the problem , the profit on Map D has increased by one dollar . Determine the new objective function value . Variable Cells Cell $ 18 $ C $ 18 D $ 18 E $ 18 AllowableDecrease 0 .3333 Name Map A Map B Map C Map D Final Reduced Objective Allowable Value Cost Coefficient Increase 1500 1 1000 0.33333 1000 0.33333 2833.33 1E + 301E + 30 0.5 Constraints Cell SB $ 24 $ B $ 25 $ B 26 SB $ 27 $ B $ 28 $ B $ 29 Name Print Cut Fold PrintA PrintB Final Value 15000 16500 20000 1500 1000 1000 Shadow Constraint Allowable Allowable Price Side Increase Decrease 0.5 15000 1000 5666.6667 + 303500 0.16667 20000 7000 1000 1000 500 -0.33333 1000 1750 1000 -0.33333 1000 500 1000 1E + 30 11, 666.67 12,566.67 11,166.67 11,500.67 13,000.00 Answer the following question using the output below. Keeping within the confines of the problem, the profit on Map D has increased by one dollar. Determine the new objective function value. Variable Cells Cell Name $B$18 Map A $C$18 Map B SDS18 Map C SES18 Map D Final Value 1500 1000 1000 2833.33 Reduced Objective Allowable Cost Coefficient Increase 0 1 1 0 1: 0.33333 0 2 0.33333 0 2 1 Allowable Decrease 0.3333 1E+30 1E+30 0.5 Constraints Cell Name $B$24 Print $B$25 Cut $B$26 Fold $B$27 PrintA $B$28: PrintB $B$29 Print Final Value 15000 16500 20000 1500 1000 1000 Shadow Constraint Allowable : Allowable Price R.H. Side Increase Decrease 0.5 15000 1000 5666.6667 0 20000 1E+30 3500 0.16667 20000 7000 1000 1000 500 1E+30 -0.33333 1000 1750 1000 -0.33333 1000 500 1000 11,666.67 12,566.67 O 11,166.67 11,500.67 13,000.00
Answer the following question using the output below . Keeping within the confines of the problem , the profit on Map D has increased by one dollar . Determine the new objective function value . Variable Cells Cell $ 18 $ C $ 18 D $ 18 E $ 18 AllowableDecrease 0 .3333 Name Map A Map B Map C Map D Final Reduced Objective Allowable Value Cost Coefficient Increase 1500 1 1000 0.33333 1000 0.33333 2833.33 1E + 301E + 30 0.5 Constraints Cell SB $ 24 $ B $ 25 $ B 26 SB $ 27 $ B $ 28 $ B $ 29 Name Print Cut Fold PrintA PrintB Final Value 15000 16500 20000 1500 1000 1000 Shadow Constraint Allowable Allowable Price Side Increase Decrease 0.5 15000 1000 5666.6667 + 303500 0.16667 20000 7000 1000 1000 500 -0.33333 1000 1750 1000 -0.33333 1000 500 1000 1E + 30 11, 666.67 12,566.67 11,166.67 11,500.67 13,000.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started