What mix of vehicles should it produce

Assignment Help Microeconomics
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?

Reference no: EM13880895

Questions Cloud

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.

Reviews

Write a Review

 

Microeconomics Questions & Answers

  Governments collected tax revenues

How changing the price elasticity of demand from elastic to inelastic affects the consumer's economic burden of a tax and the government's collected tax revenues?

  Identify instance where price control is used in our markets

Identify an instance where a price control is used in our markets. Why do you think this price control exists? Also discuss the possible negative effects it may have on the market

  Decreasing or constant returns to scale

Decreasing or constant returns to scale

  Externalities concerning optimal levels of pollution

Analyze the externalities concerning optimal levels of pollution and make at least one recommendation for the most economically viable way to proceed over the next 20 years. Explain your rationale.

  Suggestst hat give up is optimal for rich as long as

The discussionin Section3 .7 suggestst hat Give up is optimal for Rich as long as (i) Kelly is very likely to win the immunity challenge once Rich gives up and

  Should governments outlaw monopolistic competition

a. Explain the relationship between the law of diminishing marginal returns and the shape of a firm's marginal cost curve b. The long-run equilibrium for a perfectly competitive industry occurs when the firms are earning economic profits of zero.

  Information about equilibrium quantity

Recent health reports indicate that calcium is asorbed better in natural forms as milk, and at the same time, the cost of milking equipment rises. Examine the probable effects on the market.

  Dscribe how market system gives strong incentive for

explain how the market system provides a strong incentive for technological advance and creative destruction. within

  Discuss the new equilibrium price and quantity

Discuss the new equilibrium price and quantity that result from these changes. Can you demonstrate some of these changes graphically?

  1 using a prisoners dilemma game such as the wedding game

1. using a prisoners dilemma game such as the wedding game. explain how a positional arms race can occur. in your

  Visit a museum or gallery exhibition

Visit a museum or gallery exhibition or attend a theater, dance, or musical performance

  Calculate the equilibrium value of n in the long run

Assume that the marginal cost curve of an individual firm is MC = q/15 and the minimum average cost is 10. Derive the short run industry supply curve assuming there are N vegetable oil producers (Hint: Set MC=P, solve for q and then multiply the resu..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd