Consider the following product mix problem and its associated spreadsheet model. Max3X1+3X2 Subject to: 2X1+3X2103X1+2X220X15X1,X20(constraint=1)(constraint=2)(constraintH3)(noo-negativity) 1) Refer to the spreadsheet above. What formula should be entered in cell D3 to compute total profitability? A) -SUMPRODUCT(B1 (Cl,B3,CI) B) = SUM(B3. C3) 4) Refer to the spreadsheet above. Which equation should be entered ia cell D8 to compute the consumption of resource 3 (i.e, constraint *3)? A) -SUMPRODUCT(BI:CI,B8.C8) B) =SUMPRODUCT(B2,C2,B7;C7) C) -SUMPRODUCT(B2,C2,B8.C8) D) =SUMPRODUCT(D6:D8,E6:ES) QUESTION 5 5) Refe to the spreadaheet above. Which equation should be entered in cell F6 to compote the unaied terources of constraint 81? A) 82 - E6 B) D6 - E6 C) EG-D6 D) E6 - B2 Question 6 6) Refer to the rpecadeheet above. Which equation uhould be entered in cell F8 to computo the amount by which the minimal requirement of constraint 83 has been exceeded? A) - SUMPRODUCT(B2, C2,D3:D3) B) DB=B8 C)ES-DB D) FK=EB