A B C D E

$1$

$2$ Input Information

$3$ x$1$ x$2($type$)$ Avail.

$4$ Constraint $125<42$

$5$ Constraint $231<34$

$6$ Constraint $311>13$

$7$

$8$ Profit $45$

$9$

$10$ Output Information

$11$ Variables

$12$ Profit $=$ Total

$13$

$14$ Resources Used Slack$/$Surplus

$15$ Constraint $1$

$16$ Constraint $2$

$17$ Constraint $3$

$18$

$19$

Sensitivity Report

Variable Cells

Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease

$B$$11$ Variables x$19\mathrm{.}84615384604112$

$C$$11$ Variables x$24\mathrm{.}4615384620553\mathrm{.}666666667$

Constraints

Cell Name Final Value Shadow Price Constraint R$.$H$.$ Side Allowable Increase Allowable Decrease

$B$$15$ Constraint $1$ Used $420\mathrm{.}8461538462421288\mathrm{.}5$

$B$$16$ Constraint $2$ Used $340\mathrm{.}769230769234295\mathrm{.}666666667$

$B$$17$ Constraint $3$ Used $14\mathrm{.}307692310131\mathrm{.}3076923081$E$+30$

Use the spreadsheet and