Use This Information to Answer the Following Questions -Refer to the Spreadsheet Above

Multiple Choice

Use this information to answer the following questions.
Consider the following product mix problem and its associated spreadsheet model.
$$\begin{array} { l l l } \operatorname { Max } & 3 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } & \\\text { Subject to: } & \\& 2 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \leq 10 & \text { (constraint \#1) } \\& 3 \mathrm { X } _ { 1 } + 2 \mathrm { X } _ { 2 } \leq 20 & \text { (constraint \#2) } \\&\mathrm { X } _ { 1 } \geq 5 & \text { (constraint \#3) } \\&\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0 & \text { (non-negativity) }\end{array}$$

-Refer to the spreadsheet above.Which equation should be entered in cell F8 to compute the amount by which the minimal requirement of constraint #3 has been exceeded?

A) =SUMPRODUCT(B2:C2,D3:E3)
B) D8 - E8
C) E8 - D8
D) F8 - E8
E) E8 - F8