Consider the following formulation variable Definition Let X be the gallons of wine i to produce per year, where it Max 6x +1212.20X1+30X4 0:2X1+03+0.33 0.5x4 $ 12000 labor in hours OS KI+0.5X1.5X 12000 Warehouse capacity amit in botti X1 X2 X3 X4 Max. production in gallons per week) 11/5) XIX3X313334 55000 Meginventory in alione per day OY INon negative Part 1. Solve the problem usng Lingo. You must submit images of the Lingo formulation and Lingo's solution window as evidence of your work. To receive credit in thus problem. the questions must be answered below and the images must be submitted The value of the stack or surplus (Lingo output) of Flow A is frounded to bio significant decimaleht Part A2. Antwer the following questione regarding the optimal solution found on Pat A1. A2.1 How many gations of wine 2 must be produced per year rounded to two significant decima? A22 How many cations of wine 3 muit be produced per year rounded to two significant decimals? nis implemented rounded to two significant decimals? A.23 How many bottles we in the warehouse if the optimal solution is A 24 How many hours in labot are used the optimal solution in implemented rounded to two significant decima? Part A3, Verity the solution found on A.1. by solving using MS Excel. Submit the fuel file as evidence Label the sheet in Excel as Verification Consider the following formulation variable Definition Let X be the gallons of wine i to produce per year, where it Max 6x +1212.20X1+30X4 0:2X1+03+0.33 0.5x4 $ 12000 labor in hours OS KI+0.5X1.5X 12000 Warehouse capacity amit in botti X1 X2 X3 X4 Max. production in gallons per week) 11/5) XIX3X313334 55000 Meginventory in alione per day OY INon negative Part 1. Solve the problem usng Lingo. You must submit images of the Lingo formulation and Lingo's solution window as evidence of your work. To receive credit in thus problem. the questions must be answered below and the images must be submitted The value of the stack or surplus (Lingo output) of Flow A is frounded to bio significant decimaleht Part A2. Antwer the following questione regarding the optimal solution found on Pat A1. A2.1 How many gations of wine 2 must be produced per year rounded to two significant decima? A22 How many cations of wine 3 muit be produced per year rounded to two significant decimals? nis implemented rounded to two significant decimals? A.23 How many bottles we in the warehouse if the optimal solution is A 24 How many hours in labot are used the optimal solution in implemented rounded to two significant decima? Part A3, Verity the solution found on A.1. by solving using MS Excel. Submit the fuel file as evidence Label the sheet in Excel as Verification