USE EXCEL TO PRODUCE SENSITIVITY ANALYSIS REPORT THEN ANSWER QUESTION!!

$5$ Radioco manufactures two types of radios. The only scarce resource that is needed to produce radios is labor. At present, the company has two laborers. Laborer $1$ is willing to work up to $40$ hours per week and is paid $$5$ per hour. Laborer $2$ will work up to $50$ hours per week for $$6$ per hour. The price as well as the resources required to build each type of radio are given in Table $1.$

Letting $x_i$ be the number of Type i radios produced each week, Radioco should solve the following LP:

maxz$=3x_1+2x_2$

$s.t.$

$x_1+2x_{2}40$

$2x_1+x_{2}50$

$x_1,x_{2}0$

a For what values of the price of a Type $1$ radio would the current basis remain optimal?

b For what values of the price of a Type $2$ radio would the current basis remain optimal?

TABLE $1$

$\backslash$table$[[$Radio $1,$Radio $2],[$Price $($$$),\backslash$table$[[$Resource$],[$Required$]],$Price $($$$),\backslash$table$[[$Resource$],[$Required$]]],[25,\backslash$table$[[$Laborer $1$:$],[1$ hour$],[$Laborer $2$:$],[2$ hours$],[$Raw material$],[$cost: $$5$