$[$You DO NOT need to use Excel solver for this question$]$ The Candid Camera Company formulates the following linear program to determine the optimal number of cameras of each type to produce in order to maximize its profit. The contribution margins for Cub, Quikiematic, and VIP are $ $30,$ $ $90,$ and $ $250,$ respectively. Decision Variables C: # of Cub cameras produced Q: # of Quikiematic cameras produced V: # of VIP cameras produced Linear Programming Formulation Maximize $30$ C$+90$ Q$+250$V $($$ profits$)$ Subject to constraints:

$[0\mathrm{.}1$ C$+0\mathrm{.}2$ Q$+0\mathrm{.}7$V$<=250($manufacturing time$)$; $0\mathrm{.}2$ C$+0\mathrm{.}35$ Q$+0\mathrm{.}1$V$<=350($assembly time$)$; $0\mathrm{.}1$ C$+0\mathrm{.}2$ Q$+0\mathrm{.}3$V$<=150($test & package time$)$; C $>=250($Demand for Cub$)$; Q $>=375($Demand for Quickiematic$)$; V$>=150($Demand for VIP $)$; C$,$ Q$,$ V $>=0]$

The Sensitivity Analysis report obtained by running this program in Solver is shown below. Some cells in the Solver report have been shaded in$,$ but you DO NOT need to worry about it for this problem. Using this partial report, answer the questions that follow.a$)$ Given this solution, what is the optimal profit that Candid Camera will make? A$.$ $ $791\mathrm{.}67$ B$.$ $ $82,917\mathrm{.}50$ C$.$ $ $892$ D$.$ $ $89,244\mathrm{.}36$ E$.$ None of the above b$)$ Interpret the negative shadow price for the demand constraint for Quickiematic cameras. A$.$ The shadow price cannot be interpreted correctly because there is an error in this linear program. B$.$ The company should produce $76$ more Quickiematic cameras. C$.$ The company should produce fewer Quickiematic cameras to increase its profit. D$.$ The company should produce more Quickiematic cameras to increase its profit. E$.$ None of the above. c$)$ The availability of manufacturing time decreases from $250$ hours to $230$ hours due to one worker falling sick. Identify the effect of this change on the optimal solution. $($Hint: see the manufacturing time constraint$)$ A$.$ The optimal solution changes. B$.$ Effect cannot be determined. C$.$ The optimal solution does not change.