GMCO produces three types of cars: compact, medium, and large. The variable cost per car and production capacity (per year) for each type of car are given in the file P09_22.xlsx. The annual demand...

GMCO produces three types of cars: compact, medium, and large. The variable cost per car and production capacity (per year) for each type of car are given in the file P09_22.xlsx. The annual demand for each type of car depends on the prices of the three types of cars, also given in this file. In this latter table, P_C
is the price charged for a compact car (in thousands of dollars). The variables P_M
and P_L
are defined similarly for medium and large cars. Suppose that each compact car gets 30 mpg, each medium car gets 25 mpg, and each large car gets 18 mpg. GMCO wants to keep the planet pollution free, so in addition to maximizing profit, it wants to maximize the average miles per gallon attained by the cars it sells. Construct a trade-off curve between these two objectives.