90.2K

Verified Solution

Link Copied!

betalt Meded Ohjet e Alle VA Cell Nam 03 Dec Vans . 23 1300 Shaw Name Vale Game Allwe Ino De 10000 2011 1000 097 Dono SES Control 10 1. We Ww The thing wrogram Care FY Adjustable Cells Cell Name $C$3 Decision Variables $D$3 Decision Variables B Final Value 500 1200 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 3 7 0.5 o 5 1 Constraints Final Value Shadow Price Constraint Allowable R.H. Side Increase Allowable Decrease Cell Name SE$6 Constraint 1 Total SESConstraint 2 Total SES& Constraint 3 Total 80000 800 700 0.093 0 1.3) 80000 1000 700 60000 1E30 75 15000 200 300 Note: All of the constraints are eas than or equal to constraints. The objective was to maxime 14. What is the objective function value (profit) at the optimal solution? 15. What is the optimal solution to the new program? 16. What can the protit per unit of B fall to without affecting the optimal solution? 17. By how much can the profit of increase without affecting the optimal solution? Use the solved linear program in Excel and the med en report to the below Total Decision Variables Contribution 1000 25 Constraint1 Constraint 2 Constraints 30000 800 700 1.000 Formula You Enter Controm Adjustable Cells Cell Name $C$3 Decision Variables $D$3 Decision Variables B Final Value 800 1200 Reduced Cost 0 0 Objective Allowable Coefficient Increase 3 7 5 1 Allowable Decrease OS 3.5 Constraints Final Value Shadow Price Cell Constraint Allowable R.H. Side Increase Allowable Decrease Name 80000 $E$6 Constraint 1 Total $E$7 Constraint 2 Total $E$8 Constraint 3 Total 0.093 o 1.33 800 30000 1000 700 60000 1E+30 15000 200 300 700 Note: All of the constraints are less than or equal to constraints. The objective was to maximin 14. What is the objective function value (profit) at the optimal solution 15. What to the optimal solution to the Inwar program? 16 What can the prodit per unit of fail to without affecting the optimal solution? TOO Use the soldier program in Excel and the noted sensitive report to wwer the questions below Total 1200 Decision Vrabes Contribution 30000 Con Cow Cow Formu Adjustable Cells Cell Name $C$ Decision Variables $D$3 Decision Variables Final Value 800 1200 Reduced Cost 0 0 Objective Allowable Allowable Coefficient Increase Decrease 3 7 0.5 5 3.5 Constraints Final Value Shadow Constraint Allowable Price RH Side Increase Allowable Decrease Cell Name SES6 Constraint 1 Total SE$T Constraint 2 Total SES Constraint Total 30000 300 700 0.093 0 1.33 SOOD 1000 700 50000 1E30 75 15000 200 300 Note: All of the constraints are than or equal to constraints. The shjective was to maximize 14. What is the objective function value (profit) at the optimal solution? 15. What is the optimal solution to the near programy 16. What can the profit per unit of tall to, without affecting the optimal tokution? 17. By how much can the profit of increase without affecting the optimal solution? Sharat Al Al C SO 000 OD 1000 0 Se Constituta SEST Contit Tutal Contraint Total restha Theme Whave function value their 15. With into the prog? 16. What can the profit per una oftalte without in the optimal 17. By how much can the profit of increase without acting the mastion 1. Which contrary.heveslek Will out the correct linear programs for the following business scenario Do not solve. Just who he prog betalt Meded Ohjet e Alle VA Cell Nam 03 Dec Vans . 23 1300 Shaw Name Vale Game Allwe Ino De 10000 2011 1000 097 Dono SES Control 10 1. We Ww The thing wrogram Care FY Adjustable Cells Cell Name $C$3 Decision Variables $D$3 Decision Variables B Final Value 500 1200 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 3 7 0.5 o 5 1 Constraints Final Value Shadow Price Constraint Allowable R.H. Side Increase Allowable Decrease Cell Name SE$6 Constraint 1 Total SESConstraint 2 Total SES& Constraint 3 Total 80000 800 700 0.093 0 1.3) 80000 1000 700 60000 1E30 75 15000 200 300 Note: All of the constraints are eas than or equal to constraints. The objective was to maxime 14. What is the objective function value (profit) at the optimal solution? 15. What is the optimal solution to the new program? 16. What can the protit per unit of B fall to without affecting the optimal solution? 17. By how much can the profit of increase without affecting the optimal solution? Use the solved linear program in Excel and the med en report to the below Total Decision Variables Contribution 1000 25 Constraint1 Constraint 2 Constraints 30000 800 700 1.000 Formula You Enter Controm Adjustable Cells Cell Name $C$3 Decision Variables $D$3 Decision Variables B Final Value 800 1200 Reduced Cost 0 0 Objective Allowable Coefficient Increase 3 7 5 1 Allowable Decrease OS 3.5 Constraints Final Value Shadow Price Cell Constraint Allowable R.H. Side Increase Allowable Decrease Name 80000 $E$6 Constraint 1 Total $E$7 Constraint 2 Total $E$8 Constraint 3 Total 0.093 o 1.33 800 30000 1000 700 60000 1E+30 15000 200 300 700 Note: All of the constraints are less than or equal to constraints. The objective was to maximin 14. What is the objective function value (profit) at the optimal solution 15. What to the optimal solution to the Inwar program? 16 What can the prodit per unit of fail to without affecting the optimal solution? TOO Use the soldier program in Excel and the noted sensitive report to wwer the questions below Total 1200 Decision Vrabes Contribution 30000 Con Cow Cow Formu Adjustable Cells Cell Name $C$ Decision Variables $D$3 Decision Variables Final Value 800 1200 Reduced Cost 0 0 Objective Allowable Allowable Coefficient Increase Decrease 3 7 0.5 5 3.5 Constraints Final Value Shadow Constraint Allowable Price RH Side Increase Allowable Decrease Cell Name SES6 Constraint 1 Total SE$T Constraint 2 Total SES Constraint Total 30000 300 700 0.093 0 1.33 SOOD 1000 700 50000 1E30 75 15000 200 300 Note: All of the constraints are than or equal to constraints. The shjective was to maximize 14. What is the objective function value (profit) at the optimal solution? 15. What is the optimal solution to the near programy 16. What can the profit per unit of tall to, without affecting the optimal tokution? 17. By how much can the profit of increase without affecting the optimal solution? Sharat Al Al C SO 000 OD 1000 0 Se Constituta SEST Contit Tutal Contraint Total restha Theme Whave function value their 15. With into the prog? 16. What can the profit per una oftalte without in the optimal 17. By how much can the profit of increase without acting the mastion 1. Which contrary.heveslek Will out the correct linear programs for the following business scenario Do not solve. Just who he prog

Answer & Explanation Solved by verified expert

See Answer