(a)Incorporate this model into a spreadsheet using the picture below as a guide for the Excel spreadsheet you develop: (the unit profit cells have…

(a)   Incorporate this model into a spreadsheet using the picture below as a guide for the Excel spreadsheet you develop: (the unit profit cells have been filled in for you to give you a start). Hint: There are SUMPRODUCT functions in the two “Resource Used” cells, and another SUMPRODUCT function in the “Total Profit” cell.

Hint: to answer questions parts c, d, and e, substitute each X1 and X2 values in parts c, d, and e below into the constraints on resources 1 and 2 given above.

(c ) Is (X1, X2) = (2,1) a feasible solution?

(d) Is (X1, X2) = (2,3) a feasible solution?

NOTE: ONLY SEEKING ANSWER FOR F

(e) Is (X1,X2) = (0, 5) a feasible solution?

(f) Use Solver to solve this model (to get the yellow decision cells and the orange total profit cell) by creating your Excel linear programming model with the information above and running Excel’s Solver (Data tab > Solver)