In$-$Class Assignment $5($ICA$5)$

Question $1.$ Electronic Company

Let's assume that you have a problem which is already formulated as below:

Decision: How many of each of $4$ products to make?

Objective: Maximize profit

Decision Variables:

$V=$ number of $VCR\text{'}$s

$S=$ number of stereos

$T=$ number of $T{V}^{\text{'}}s$

$D=$ number of DVD players

Max $Z=29V+32S+72T+54D,($in $ of profit$)$

Subject to the constraints:

$3V+4S+4T+3D4700(elec.$ components$)$

$2V+2S+4T+3D4500(nonelec.$ components$)$

$V+S+3T+2D,2500(assembly$ hours$)$

$V,S,T,D0(nonnegativity)$

Please solve the above problem using excel solver and answer the following questions by looking at Answer's report and Sensitivity Report which are provided by Excel.

Part $1.$ What happens if the supply of electrical components

Increased by $400($to $5100)?$

Increased by $4000($to $8700)?$

Part $2.$ What if we could buy an additional $400$ elec. components for $$1$ per unit? Would we want to buy them?