- For problem 1, copy-paste the applied LP models and results from Lingo Software to the first Excel Sheet. - Forproblem 2, complete the sheet and apply Excel Solver - Rename the Excel file using your name and identification number. - Upload in Blackboand system only the final Excel file. Problem 1: (10 pts) The Assil Company, a distributor of exercise equipment, wants to decide on how many units to order from two of the most popular models. The company has developed the following linear program to maximize its profits, but found out that it is infeasible. X : Number of units to be ordered from model 1 , and Y : Number of units to be ordered from model 2 \begin{tabular}{|l|} \hline Max 4X+3Y \\ S.T. \\ 2X+Y15 (Storage constraint) \\ 2X+3Y25 (Budget constraint) \\ X+Y12 (demand constraint) \\ X,Y0, integers \end{tabular} In revision, the company drops the original objective and establishes the following three goals in order of their priority: Goal 1: The company would like to achieve a satisfactory profit level of 30 Goal 2: Don't exceed 25 in the budget constraint (less than 25) Geal 3: Don't fall short of 12 in the demand constraint (more than 12) 1.1) Formulate this problem using Goal programming (using the same decision variables)