Question: Based on the Answer and Sensitivity reports, what is the objective function? Objective Cell ( Min ) table [ [ Cell , Name,Original Value,Final

Based on the Answer and Sensitivity reports, what is the objective function?
Objective Cell (Min)
\table[[Cell,Name,Original Value,Final Value],[SB$18 Cost =,2693333.33,2693333.33,]]
Variable Cells
\table[[Cell,Name,Original Value,Final Value,Integer],[SBS15,,70.00,70.00 Contin],[SBS16,,120.00,120.00 Contin],[$B$17,,53.33,53.33,Contin]]
Constraints
\table[[Cell,Name,Cell Value,Formula,Status,Slack],[SHS10, Usage,70,$H$10$G$10,Not Binding,50],[SHS11, Usage,120,$HS11=$G$11,Binding,0],[SHS12, Usage,53.33,SHS12=$GS12,Not Binding,66.6666667],[$GS6," #NAME?,2,500,000,$G$6=$H$6,Binding,0],[SHS7, Usage,,SH$7>=$G$ 7,Binding,0],[SHS8, Usage,120,SHS8>=$G$8,Not Binding,70],[$HS9, Usage,53.33,SH$9>=$G$9,Not Binding,3.33]]
Variable Cells
\table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$BS151,70,,0,12000,1E+30,1259.259259],[$B$162,120,,0,9000,666.6666667,1E+30
 Based on the Answer and Sensitivity reports, what is the objective

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!