Question: Below is the solution and sensitivity report is given as the I.P. problem for a jeweler that uses gold, silver, and platinum to make custom
Below is the solution and sensitivity report is given as the I.P. problem for a jeweler that uses gold, silver, and platinum to make custom chains and rings. The output tells the optimal number of chains and rings to produce to maximize profit.
Each chain uses .2 ounces of gold, 0.3 ounces of silver. Profit per chain is $550
Each ring uses 0.15 ounces of gold, 0.05 ounces of silver, and 0.05 ounces of platinum. Profit per ring is $400
The jeweler has 4.1 ounces of gold, 3 ounces of silver, and 1.2 ounces of platinum. 

based on the output above can you tell how much the jeweler would be willing to pay if another full ounce of gold were available? explain and show all work
DE 02 3 Pla 0 0.05 550 . 3 Variable Cells Reduced Cost Cell Name SES14 Chain $F$14 Ring Final Value 7 18 Objective Allowable Allowable Coefficient increase Decrease 550 1650 16.66666667 12533333333 400 Constraints Cell Name SE$17 Gold LHS SE Silver LHS $E$19 Platinum Final Shadow Value Price 4.1 2642.85710 371.4285710 0.9 Constraint Allowable Allowable RH Side Increase Decrease 41 07 2.1 3 315 LOS 12 130Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
