1.Objective: What is the optimal value you determined for your objective?

2.Shadow prices: You've underestimated the need for Product 10 and need to increase your order by 3000 units. Using your current model and the resulting sensitivity report, how much will your costs increase as a result of this change?

3.Bid negotiation (reduced cost from supplier): A sales representative for supplier 1 has contacted you about your choice not to accept their Bid #6 for Product 5. The sales representative wants to know at what unit cost would he be able to earn your business.

D 8000 2000 10000 2000 7000 9000 0 0 2000 0 0 3000 3000 5000 0 0 0 booboo boo 5000 oboobooboo oboo boo boo aboobboob abb 5000 5000 2000 7000 11000 0 0 2000 0 2000 obo oo 1000 0 1000 5800 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease W $Y$30 PRODUCT 1 10000 0.2 10000 4000 2000 SY$31 PRODUCT 2 9000 0.4 9000 5000 2000 SY$32 PRODUCT 3 2000 0.2 2000 5000 2000 SY$33 PRODUCT 4 3000 0 3000 4000 3000 $Y$34 PRODUCT 5 5000 0.1 5000 4000 5000 00 SY$35 PRODUCT 6 5000 0 5000 4000 5000 $Y$36 PRODUCT 7 11000 0.2 11000 1000 2000 SY$37 PRODUCT 8 2000 0.1 2000 0 2000 $Y$38 PRODUCT 9 0 0 0 8000 0 $Y$39 PRODUCT 10 1000 0.1 1000 8000 1000 WN