CAFE COMPLIANCE IN THE AUTO INDUSTRY
This case is based on the Management Science in Action, Pricing for Environmental Compliance in the Auto Industry. In this case we build a model similar to the one built for General Motors. The CAFE requirement on fleet miles per gallon is based on an average. The harmonic average is used to calculate the CAFE requirement on average miles per gallon.
In order to understand the harmonic average, assume that there is a passenger car and a light truck. The passenger car gets 30 miles per gallon (MPG) and the light truck gets 20 miles per gallon (MPG). Assume each vehicle is driven exactly one mile. Then the passenger car consumes 1/30 gallon of gasoline in driving one mile and the light truck consumes 1/20 gallon of gasoline in driving one mile. The amount of gasoline consumed in total is
Gas consumption = (1/30) + (1/20) = (5/60) = (1/12) gallon
The average MPG of the two vehicles calculated the “normal way” is (30 + 20)/2 = 25 MPG. If both vehicles are “average,” and each vehicle is driven exactly one miles, then the total gasoline consumption is
Gas consumption = (1/25) + (1/25) = (2/25) gallon
Because (2/25) is not equal to (5/60), the total gas consumption of two “average vehicles” driving exactly one mile is not equal to the total gas consumption of each of the original vehicles driving exactly one mile. This is unfortunate. In order to make it easy for the government to impose and enforce MPG constraints on the auto companies, it would be nice to have a single target value MPG that every company in the auto industry must meet. As just illustrated, there is a problem with requiring an average MPG on the industry because it will incorrectly estimate the gas mileage consumption of the fleet. Fortunately, there is a statistic called the harmonic average so that total gas consumption by harmonic average vehicles is equal to gas consumption of the actual vehicles.
For simplicity, first assume that there are two types of vehicles in the fleet, passenger cars and light trucks. If there is one passenger car getting 30 miles per gallon and there is one light trucks getting 20 miles per gallon, the harmonic average of these two vehicles is
If each vehicle were to drive exactly one mile, each vehicle would consume 1/24 gallon of gasoline for a total of 2/24 = 1/12 gallon of gasoline. In this case each “average” vehicle driving exactly one mile results in total gas consumption equal to the total gas consumption of each vehicle with a different MPG rating driving exactly one mile.
If there are three passenger vehicles and two light trucks, the harmonic average is given by
In general, when calculating the harmonic average, the numerator is the total number of vehicles. The denominator is the sum of two terms. Each term is the ratio of the number of vehicles in that class to the MPG of cars in that class. For example, the first ratio in the denominator is 3/30 because there are 3 cars (the numerator) each getting 30 MPG (the denominator). These calculations are illustrated in Figure 8.17.
Based on Figure 8.17, if each of the 5 cars is average and drives exactly one mile, (5/25) = (1/5) gallon of gas is consumed. If three cars getting 30 MPG drive exactly one mile each and two cars getting 20 MPG drive exactly mile, then (3/30) + (2/20) = (2/10) = (1/5) gallon is consumed. Thus, the average cars exactly duplicate the gas consumption of the fleet with varying MPG.
Now assume that the demand function for passenger cars is
where P_C is the price of a passenger car. Similarly, the demand function for light trucks is
Demand=830- P_T (8.25)
Where P_T is the price of a light truck.
Using the formulas given in (8.24) and (8.25), develop an expression for the total profit contribution as a function of the price of cars and the price of light trucks.
Using Excel Solver or LINGO, find the price for each car so that the total profit contribution is maximized.
Given the prices determined in Question 2, calculate the number of passenger cars sold and the number of light trucks sold.
Duplicate the spreadsheet in Figure 8.17.
MPGNumber of VehiclesCafe Weight
Your spreadsheet should have formulas in cells D3:D5 and B7 and be able to calculate the harmonic (CAFE) average for any MPG rating and any number of vehicles in each category.
Again, assume that passenger cars get 30 MPG and light trucks get 20 MPG; calculate the CAFE average for the fleet size from part (3).
If you do the calculation in part (5) correctly, the CAFE average of the fleet is 23.57. Add a constraint that the fleet average must be 25 MPG and resolve the model to get the maximum total profit contribution subject to meeting the CAFE constraint.
I don't even know where to start. Can some one please help me?