Please show steps and the functions you enter behind the cells. i got an answer for this question but i dont kniw what im supposed to enter into the cells and solver to get the outcomes. thank you!!

2.7 Production Planning for Automobiles: The Auto Company of America (ACA) produces four types of cars: subcompact, compact, intermediate, and luxury. ACA also produces trucks and vans. Vendor capacities limit total production capacity to at most 1,200,000 vehicles per year. Subcompacts and compacts are built together in a facility with a total annual capacity of 620,000 cars. Intermediate and luxury cars are produced in another facility with capacity of 400,000 ; and the truck/van facility has a capacity of 275,000. ACA's marketing strategy requires that subcompacts and compacts must constitute at least half of the product mix for the four car types. Profit margins, market potential, and fuel efficiencies are four car types. Profit margins, market potential, and fuel efficiencies are summarized helow. The Corporate Average Fuel Efficiency (CAFE) standards require an average fleet fuel efficiency of at least 27 MPG. ACA would like to use a linear programming model to understand the implications of government and corporate policies on its production plans. a. What is the optimal annual profit for ACA? b. How much would the annual profit drop if the fuel efficiency requirement were raised to 28MPG