Depends on the amount of each type of coal burned

Assignment Help Financial Management

Reference no: EM13974613

Excel Assignment: What and Where Decisions The Big U operates a coal-fired power plant that burns 4,300 tons of coal per year. Coals from four regions of the country can be burned in the plant. The amount of pollution produced depends on the amount of each type of coal burned. The details are in the table below, where the pounds of the various pollutants that are in each ton of coal that is burned are specified for each type of coal. Coal source (pounds of pollution/ton of coal burned) Illinois Kentucky Pennsylvania Wyoming Fly ash 2.6 1.3 1.7 0.9 Sulfur 1.2 0.9 0.8 0.7 Nitrogen oxide 0.8 0.3 0.6 0.4 Cost ($/ton) 37 33 31 44 By federal law, the plant can emit at most 9,000, 6,000, and 2,500 pounds per year of fly ash, sulfur, and nitrogen oxide, respectively. Also, the state legislature requires that at least half of the coal burned come from Illinois.

1. In worksheet 2 of your excel file, formulate your excel model and solve it with Solver. Please provide necessary comments and remarks to make your excel model readable and understandable. (See my excel file for Captain Wise’s Problem as an example)

Hint: this problem is a simpler version of Captain Wise example. Here the decision is only one dimensional: how many tons of coal to buy from each state.

Reference no: EM13974613

Questions Cloud

Basic source of funds for the firm : The greatest number of businesses in the United States are corporations. Which of the following is a basic source of funds for the firm?

Determine the total amount of delivery service costs : Determine the total amount of (a) delivery service (product) costs and (b) period costs. Determine the variable cost components using the high-low method.

Describe forward-futures and options foreign currency market : Describe forward, futures and options foreign currency markets, and discuss how they demonstrate arbitrage problems in international finance. Use a minimum of three resources to support your discussion.

One part of managing short-term cash needs : Estimating ______ is one part of managing short-term cash needs. The second part is estimating _______.

Depends on the amount of each type of coal burned : Excel Assignment: What and Where Decisions The Big U operates a coal-fired power plant that burns 4,300 tons of coal per year. Coals from four regions of the country can be burned in the plant. The amount of pollution produced depends on the amount o..

A clause is a group of words containing a subject and a verb : What is the subordinating conjunction in the following sentence? James stood on his tiptoes so that he could reach the top shelf.

Calculate the initial investment for the replacement : Edwards manufacturing company is considering replacing one machine with another. The old machine was purchased 3 years ago for an installed cost of $10,000. The firm is depreciating the machine under MARCS, using a 5-year recover period. The new mach..

What was its charge for depreciation and amortization : Talbot Enterprises recently reported an EBITDA of $7.0 million and net income of $2.45 million. It had $2.59 million of interest expense, and its corporate tax rate was 30%. What was its charge for depreciation and amortization?

What is the cash dividend yield on the common stock : Select a major industrial or commercial company based in the United States and listed on one of the major stock exchanges in the United States. Each student should select a different company. What is the company’s current actual beta? What is the ca..

User Account

All Pages