Based on the provided information, the LP formulation is given below:

Max $2$X $+3\mathrm{.}2$Y $+4\mathrm{.}1$Z

Subject To

X $+$ Y $+$ Z $12$Number of stores constraint$$

$4\mathrm{.}5$X $+9$Y $+15$Z $90$Construction budget constraint$$

$10$X $+15$Y $+50$Z $200$Staffing constraint$$

X$,$ Y$,$ Z $^30$

Setup an Excel spreadsheet to solve the above LP$,$ upload a completed, Solver executable Excel spreadsheet which includes an Answer Report.

a$.$ What is the optimal solution in terms of number of convenience stores to be built, number of standard stores to be built, and number of extended services to be built? State the values explicitly in your Word file. $($Hint: Although we have only done two$-$variable problems for solving LPs using Excel Solver, doing this for a three$-$variable problem is exactly the same.$)$

b$.$ What is the optimal profit value for the optimal solution? State the values explicitly

c$.$ Given the optimal solution, the company should be prepared to hire how many

employees? State the values explicitly