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. Below is the solution and sensitivity report is

Below is the solution and sensitivity report is

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 130

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!