Cafe compliance in the auto industry

Assignment Help Business Management

Reference no: EM13827226

CAFE COMPLIANCE IN THE AUTO INDUSTRY

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

2/(1/30+1/20)=2/(5/60)=120/5=24

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

5/(3/30+2/20)=5/(0.1+0.1)=5/0.2=25

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

Demand=750-P_C (8.24)

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.

Managerial Report

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

Passenger Car3030.1000

Light Trucks2020.1000

50.2000

Cafe Average25

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.

Reference no: EM13827226

Questions Cloud

Problem on financial problems and crises of new ventures : What special problems and crises can new ventures expect as they grow? Why do these occur?

Couple paragraphs explaining boole''s inequality : Looking for a couple paragraphs explaining Boole's inequality. please state references

Compute the annual depreciation : In 1987, Herman Moore Company completed the construction of a building at a cost of $2,660,000 and first occupied it in January 1988. It was estimated that the building will have a useful life of 40 years and a salvage value of $79,800 at the end of ..

Rate of depreciation-plant assets under composite method : Compute the rate of depreciation per year to be applied to the plant assets under the composite method. Prepare the adjusting entry necessary at the end of the year to record depreciation for the year. Prepare the entry to record the sale of asset D ..

Cafe compliance in the auto industry : 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 ave..

An increase in accounts receivable : A positive effect could also be thought of as a source of cash, an increase in cash, or a positive amount on the cash flow statement. A negative effect could also be thought of as a use of cash, a decrease in cash, or a negative amount on the cash fl..

Entirley reasonable for a goverment to undertake efforts : it seems entirley reasonable for a goverment to undertake efforts to protect a new or recently establisshed- often called "infant"----- industry why then might international trade professionals argue against govermental efforts to protect a new or re..

Sum-of-years-digits method-double-declining-balance method : Muggsy Bogues Company purchased equipment for $280,115 on October 1, 2014. It is estimated that the equipment will have a useful life of 8 years and a salvage value of $12,120. Compute depreciation expense under each of the following methods. Bogues ..

A research paper on ceo pay packages with john : A research paper on CEO Pay packages with John Deere and Caterpillar. Below is the information needed for the assignment. Any assistance would be appreciated. Target Audience: As a Compensation Consultant, you have been hired by the National Associat..

User Account

All Pages