1. The problem statement, all variables and given/known dataA manager of an automobile dealership must decide how many cars to order for the new model year in order to maximize his profit. There are two types of cars: midsize cars and compact cars. The selling price and costs are listed in the following table: Car type -- Selling price -- Cost Midsize -- 25,000−−18,178 Compact -- 18,000−−12,000 No more than $790,000 can be invested. The manager wants at least 10 of each type, but no more than 50 of the midsize cars and no more than 60 of the compact cars. (The manager assumes that as long as he meets these quantity limits, he will be able to sell all the cars that he orders.) 1.Formulate a linear programming model for this problem. That is, write out an algebraic statement of the model. 2.Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution and resulting profit? 3.The selling price of the midsize car might be as low as 22,000 or as high as 27,000. How does your solution found in #2 change with these prices? 2. Relevant equations max: z = (25000 - 18178)x + (18000 - 12000)y = 6822x+6000y 18178x + 12000y <= 790000 x>=10 x<=50 y>=10 Y<=60 x,y>=0 3. The attempt at a solution I tired to set up the equation already. However, I spent a whole day to figure out the Constraints' part in the Excel. Can someone help?