Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!