Reference no: EM13880895
The accompanying spreadsheet captures the profit-maximizing decisions of a carmaker facing stricter fuel-efficiency standards as discussed earlier in the chapter. The carmaker in question must decide how much aluminum to use in its trucks and sedans so as to lower their weight and improve their fuel efficiency. Cells C8 and C10 list these decision variables (expressed as percentages in decimal form, so that a value such as .10 means that the proportion of aluminum has increased by 10 percentage points). The company also must determine its mix of trucks and sedans by setting the proportion of trucks (again as a decimal) in cell D8 with cell D10 computed as: = 1 - D8.
Because of aluminum's extra cost, each vehicle's contribution per unit declines as more aluminum is used. Truck contribution (cell E8) is given by the Excel formula: =10 - 80*H8*C8^2. The cost impact of using aluminum depends on the relative cost of aluminum (cell H8) and increases quadratically as more and more aluminum is used. In turn, sedan contribution is given by the Excel formula: =6 - 80*H8*C10^2. These formulas imply that current contribution margins for trucks and sedans (with cells C8 and C10 set to zero) are $10 thousand and $6 thousand, respectively. Each vehicle's fuel efficiency increases directly with its aluminum content. For trucks (cell F8), the Excel formula is: =18 + 60*C8, while for sedans (cell F10), the formula is: 38 + 80*C10. These formulas imply that current fuel efficiency
|
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
2
|
|
IMPROVING FUEL ECONOMY
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
|
|
|
|
4
|
|
|
|
|
|
|
|
|
|
|
5
|
|
|
? Aluminum
|
Fleet Share
|
Contrib/unit
|
Fuel Eff.
|
|
A's relative
|
|
|
6
|
|
|
(%)
|
(%)
|
($ 000)
|
(MPG)
|
|
Cost
|
|
|
7
|
|
|
|
|
|
|
|
|
|
|
8
|
|
Truck
|
0
|
.30
|
10.0
|
18.0
|
|
1.3
|
|
|
9
|
|
|
|
|
|
|
|
|
|
|
10
|
|
Sedan
|
0
|
.70
|
6.0
|
38.0
|
|
|
|
|
11
|
|
|
|
|
|
|
|
|
|
|
12
|
|
|
Fleet Average:
|
7.2
|
32.0
|
|
|
|
|
13
|
|
|
|
|
|
|
|
|
|
|
14
|
|
|
|
|
Requirement:
|
32
|
|
|
|
|
15
|
|
|
|
|
|
|
|
|
|
ratings for trucks and sedans (with cells C8 and C10 set to zero) are 18 miles per gallon and 38 miles per gallon, respectively. Finally, the
fleet averages in row 12 are computed by weighting the vehicle values by the fleet shares in column D.
a. The company seeks to maintain a fleetwide average of 32 miles per gallon. To maximize its fleetwide average contribution (cell E12), how much aluminum should the maker add to each vehicle, and what mix of vehicles should it produce?
b. Re-answer the questions in part (a) if price cuts mean that aluminum is only 10 percent more costly than steel, that is, cell H8 takes the value 1.1.
c. Finally, what is the company's optimal production response if the fuel- efficiency standard is raised to 36 miles per gallon?
|
Incremental interest cost of borrowing the extra money
: A borrower is purchasing a property for $300,000 and can choose between two possible loan alternatives. The first is a 90% loan for 20 years at 6.0% interest and the second is an 80% loan for 20 years at 5.0% interest. Assume the loan will be held to..
|
|
Develop an analysis that could be used to predict error
: Neglecting conduction losses along the thermocouple tube develop an analysis that could be used to predict the error (Tg - Ts) in the temperature measurement.
|
|
About the credit quality of the borrower
: A bank makes a loan of $200,000 and will receive payments of $1,911.30 each month for 15 years. How much (in dollars) would the bank have to charge in points (or, an origination fee) if it were concerned about the credit quality of the borrower and r..
|
|
Was the mumbai event considered an unexpected event
: Describe and discuss how terrorist organizations use technology to further their organizational goals and in light of the available capabilities in modern technologies, such as cell phones, handheld devices, and the Internet, was the Mumbai event c..
|
|
What mix of vehicles should it produce
: The company seeks to maintain a fleetwide average of 32 miles per gallon. To maximize its fleetwide average contribution (cell E12), how much aluminum should the maker add to each vehicle, and what mix of vehicles should it produce?
|
|
Explain the spill response and cleanup problems associated
: Explain the spill response and cleanup problems associated with water-soluble liquids
|
|
Developing accounting measurement rules in united states
: Briefly describe the organization that is responsible for developing accounting measurement rules (generally accepted accounting principles) in the United States.
|
|
Provide recommendations for preventing spills or releases
: Provide recommendations for preventing spills or releases
|
|
Leased office space under a capital lease
: 1.On January 1, 2013, National Insulation Corporation (NIC) leased office space under a capital lease. Lease payments are made annually.
|