Question: table [ [ Cell , Name,Original Value,Finalvalue,, ] , [ SB$ 5 , Max Profit, 0 , , , ] , [ , ,

\table[[Cell,Name,Original Value,Finalvalue,,],[SB$5,Max Profit,0,,,],[,,,,,],[Variable Cells],[Cell,Name,Original Value,Final Value,Integer,],[$B$1,x1 Ham and cheese sandwiches (H&C),0,,Contin,],[$B$2,x2 Bologna sandwiches (B),0,,Contin,],[$B$3,X3 Chicken Salad Sandwiches (CS),0,,Contin,],[Cell,Name,Cell Value,Formula,Status,Slack],[SBS11,C1(storage size, units),,SBS 11 SD $11,,0],[SB$12,C2(Production mix, units),,$B$12=$D$12,,0],[SB$7,C3(labor time, minutes),,SBS7= SDS7,,82],[SBS8,C4(H&C production, units),,$B$8$D$8,,800],[SBS9,C5(B production, units),,$B$9$D$9,,600],[SB$10,C6(CS production, units),,SB$10$DS10,,0]]
\table[[Variable Cells (Sensitivity report),Objective,Allowable,Allowable],[Cell,Name,Final Value,Reduced Cost,Coefficient,Increase,Decrease],[$BS1,x1 Ham and cheese sandwiches (H&C),1000,,035,1E+30,0.77],[$B$2,x2 Bologna sandwiches (B),800,,0.42,1E+30,0.05],[$B$3,X3 Chicken Salad Sandwiches (CS),200,,0.37,0.05,1E+30
 \table[[Cell,Name,Original Value,Finalvalue,,],[SB$5,Max Profit,0,,,],[,,,,,],[Variable Cells],[Cell,Name,Original Value,Final Value,Integer,],[$B$1,x1 Ham and cheese sandwiches (H&C),0,,Contin,],[$B$2,x2

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!