Question: See the sensitivity report provided below: Variable Cells table [ [ Cell , Name, table [ [ Final ] , [ Value ]

See the sensitivity report provided below:
Variable Cells
\table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$D$6,Television commercials = Number,1.818181818,0,20000,5500,11000],[$D$7,Radio commercials = Number,10,0,12000,1E+30,1000],[$D$8,Newspaper ads = Number,3.181818182,0,9000,1222.222222,3666.666667]]
Constraints
\table[[Cell,Name,\table[[Final],[Value]],\table[[Shadow],[Price]],\table[[Constraint],[R.H. Side]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$H$6,TV commercials Actual,1.818181818,0,4,1E+30,2.181818182],[$H$7,Radio commercials Actual,10,1000,10,3.888888889,4.666666667],[$H$8,Newspaper ads Actual,3.181818182,0,7,1E+30,3.818181818],[$H$9,Total ads and commercials Actual,15,?????,15,2.8,2.333333333],[$H$10,Cost ($) Actual,100000,1,100000,24000,20000]]
What is the unknown shadow price(Yellow box)?
2000
3000
4000
5000
None of the above
 See the sensitivity report provided below: Variable Cells \table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$D$6,Television commercials =

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 General Management Questions!