Please solve according to instructions for a positive rating. Thank you :)

- Problem 1 must be solved using graphical method. Make sure to identify the feasible set, show all work in finding the optimal solution, and be sure to report the values of all variables. - For every problem except (1a), you must specify the complete IP or GP model in the space provided (add more sheets if necessary) - be sure to label and define all variables of the problem; specify the objective function and all constraints. Use Excel Solver or QM to find solutions. Use one workbook for all such problems and label each worksheet appropriately. Submit the Excel workbook along with the completed assignment. 1. (a) Solve the following goal programming model graphically. MinimizeSubjecttoP1d1++P2d2+P3d3++P3d44X1+8X2+d1d1+=458X1+24X2+d2d2+=100X1+2X2+d3d3+=10X1+d4d4+=6 (b) Repeat the above problem with the objective to minimize P1d1+P2d2+P3d3++P3d4