Objective function: MAX: $1\mathrm{.}48$W $+1\mathrm{.}33$R $+2\mathrm{.}28$F

Subject to:

Constraints:

C$1($Use at least $36\%$ white wine$)$: $0\mathrm{.}64$W $0\mathrm{.}36$R $0\mathrm{.}36$F $>=0$

C$2($Use at least $18\%$ rose wine$)$: $-0\mathrm{.}18$W $+0\mathrm{.}82$R $0\mathrm{.}18$F $>=0$

C$3($Use no more than $33\%$ fruit juice$)$: $-0\mathrm{.}33$W $0\mathrm{.}33$R $+0\mathrm{.}67$F $<=0$

C$4($Max$.$ available white$)$: $1$W $<=10,500$

C$5($Max$.$ available rose$)$: $1$R $<=12,999$

C$6($Max$.$ available fruit juice$)$: $1$F $<=7,251$

C$7($Non$-$negativity$)$: W$,$ R$,$ F $>=0$

Instructions:

$1.$ Use an existing spreadsheet posted on Canvas and revise it to create a Solver model and to generate a sensitivity report.

$2.$ Answer the questions below in your Excel spreadsheet.

$3.$ Submit your Excel spreadsheet with your answers to the Canvas Assignment.

Part a$)$ How many of each ingredient should be purchased, and what is the value of the objective function $($Total Profit$)?$ List $$Part a$$ by your answers. $4$ points

Note: You must answer all Sensitivity Analysis questions below in the upper right hand part of your spreadsheet $($as shown in all Sensitivity examples posted on Canvas$).$

Part b$)$ Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the Net Profit per gallon of F to $$2\mathrm{.}20.$ Label your answers,