Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following Excel Sensitivity report, concerning the manufacturing of Products 1 , 2 , and 3 with respect to four constraints. Sensitivity Report Variable

image text in transcribed

Consider the following Excel Sensitivity report, concerning the manufacturing of Products 1 , 2 , and 3 with respect to four constraints. Sensitivity Report Variable Cells \begin{tabular}{ccrrrrrr} \hline Cell & Name & Final Value & Reduced Cost & Objective Coefficient & Allowable Increase & Allowable Decrease \hline$\$ B \$ 4$ & Product 1 & 20 & 0 & 8 & 16 & $1 \mathrm{E} +30$ \hline$\$ \mathrm{CS4}$ & Product 2 & 60 & 0 & 12 & $1 \mathrm{E}+30$ & 6 \hline SDS4 & Product 3 & 0 & $-15$ & 15 & 15 & $1 \mathrm{E}+30$ \hline \end{tabular) Constraints \begin{tabular}{lrrrrrr) \hline Cell & Name & Final Value & Shadow Price & Constraint R.H. Side & Allowable Increase & Allowable Decrease \hline$\$ E \$ 7$ & Constraint 1 & 120 & 0 & 200 & $1 \mathrm{E}+30$ & 80 \hline SES8 & Constraint 2 & 20 & $-16$ & 20 & 30 & 20 W \hline SES9 & Constraint 3 & 280 & 0 & 500 & $1 \mathrm{E}+30$ & 220 W \hline ($E$10 & Constraint 4 & 200 & 6 & 200 & 110 & 120 W \hline \end{tabular) a) What is the optimal objective function value? b) Suppose that the objective function coefficient for Product 2 can be increased to 18 . What impact will this have on the current optimal objective function value? c) What would be the impact on the current optimal objective function value if the right-hand-side of Constraint 2 were changed to 25 ? CS.VS. 939

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Distributed Relational Database Architecture Connectivity Guide

Authors: Teresa Hopper

4th Edition

0133983064, 978-0133983067

More Books

Students also viewed these Databases questions

Question

3. Who would the members be?

Answered: 1 week ago