Consider the mathematical model formulation in problem $4-1\mathrm{.}5$ on page $229.$ Then, do the following:

a$)$ Perform the given tasks, provide answers in a Word file and save the file as "YourInitialsWk$3$Hands$-$On$"$

Use graphical analysis to identify all the corner$-$point solutions for this model. State whether each is either feasible or infeasible. Calculate the value of the objective function for each of the CPF solutions. Provide all the information in a table with format given below, add rows as needed.

ENGI $310$

$\backslash$table$[[,$Feasible or infeasible,Objective function value$],[,,]]$

Which CP solution is the optimal solution?

CP solution

b$)$ Develop a complete Excel spreadsheet model for this problem $($Hint: enter the data in the mathematical model into the appropriate cell in an Excel spreadsheet and make modifications where necessary$).$ Save your Excel file as "YourInitials$-$Wk$3$Hands$-$On$".$

c$)$ Use the Solver $($which uses the simplex method$)$ to confirm your answer for the optimal solution in $($a $(2))$

d$)$ Upload the Excel and Word files to the assignment page.