Reference the below spreadsheet showing the sensitivity analysis of a solved mode. There is a letter on $20$ of the values in the sensitivity report. Choose one of the letters and explain what that number means with respect to the solved model. When you post your solution, please title your response $$Letter $?$ replacing the question mark with the letter you have chosen from the file. Please ensure you do not duplicate a response from a fellow student.

A B C D E F

$1$

$2$ Input Information

$3$ Variable $1$ Variable $2$ Used $($type$)$ Available

$4$ Constraint $12540\mathrm{.}0<=40$

$5$ Constraint $23130\mathrm{.}0<=30$

$6$ Constraint $31113\mathrm{.}1>=12$

$7$

$8$ Profit per Unit $54$

$9$

$10$ Output Information

$11$ Variables $8\mathrm{.}54\mathrm{.}6$

$12$ Total Profit $42\mathrm{.}318\mathrm{.}5$ Total Profit $=60\mathrm{.}8$

A What is the cell formula for B$12$ in the Excel model?

B What is the cell formula for C$12$ in the Excel model?

C What is the cell formula for E$12$ in the Excel model?

D What is the cell formula for D$4$ in the Excel model?

E What is the cell formula for D$5$ in the Excel model?

F What is the cell formula for D$6$ in the Excel model?

G What is the optimal value for x$1$ in the Excel model?

H What is the optimal value for x$2$ in the Excel model?

I What does the value of cell F$4$ represent in the Excel model?

J What does the value of cell B$5$ represent in the Excel model?

K What is the cell C$7$ represent on the sensitivity report?

L What is the cell C$8$ represent on the sensitivity report?

M What is the cell E$7$ represent on the sensitivity report?

N What is the cell E$8$ represent on the sensitivity report?

O What is the cell F$8$ represent on the sensitivity report?

P What is the cell G$7$ represent on the sensitivity report?

Q What is the cell D$13$ represent on the sensitivity report?

R What is the cell D$15$ represent on the sensitivity report?

S What is the cell F$14$ represent on the sensitivity report?

T What is the cell G$15$ represent on the sensitivity report?