Question: please help Question 20 5 Points Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model.
please help
Question 20 5 Points Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. Max Subject to 3X13X2 I - 2X1 - 3X2 s 10 3X32X25 20 X125 (constraint #1) (constraint 12 (constraint 13 non negativity X1 X220 A D E B X X F Number to make Unit Profits Total Profit S3 S3 JOUW 1 2 3 4 5 6 7 8 LHS Constraints 1 2 Slack/ Surplus 2 3 1 3 2 0 RHS 10 20 S Refer to the spreadsheet above. Which equation should be entered in cell Ds to compute the consumption of resource 3 the constraint #312 Refer to the spreadsheet above. Which equation should be entered in cell D8 to compute the consumption of resource 3 (te, constraint #3)? -SUMPRODUCT(B1:C1,88:C8) B =SUMPRODUCT(B2:C2,87:07) SUMPRODUCT(B2:02,88:C8) D-SUMPRODUCT(06:08,06:08) SUMPRODUCT(B2:C2,86:08) Question 19 Use this information to answer the following questions. Consider the following product mix problem and its associated spreadsheet model. 3X1 + 3X2 Max Subject to 2X1 + 3X2 5 10 3X1 + 2X2 s 20 X125 X1 X220 (constraint #1) (constraint #2 (constraint #3) (non-negativity) D E B X X F I Number to make Unit Profits: Total Profit $3 $3 1 2 3 4 5 6 7 8 LHS Slack/ Surplus Constraints 1 2 3 - N00 2 3 1 malo RHS 10 20 5 3 2 0 Refer to the spreadsheet above. Which cell(s) specifies the "changing cells" in Solver? A B1:01 A D E F B X X Old Number to make Unit Profits: Total Profit $3 $3 1 2 3 4 5 6 7 8 LHS Slack/ Surplus Constraints 1 2 3 2 3 1 UN mo 3 2 RHS 10 20 5 Refer to the spreadsheet above. Which cel(s) specifies the "changing cells" in Solver? A B1:01 B 06:08 B3:03 D) D3 E B2:02



Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
