Given the LP model of the Galaxy Industries Production problem, find the optimal

production volume for Space Ray and Zapper using Excel Solver. You need to create the

Answer Report and Sensitivity Report from Solver.

Max $8$X$1+5$X$2($Weekly profit$)$

subject to

$2$X$1+1$X$2<=1000($Plastic$)$

$3$X$1+4$X$2<=2400($Production Time$)$

X$1+$ X$2<=700($Total production$)$

X$1-$ X$2<=350($Mix$)$

Xi$>=0,$ i $=1,2($Nonnegativity