Depends on the amount of each type of coal burned
Course:- Financial Management
Reference No.:- EM13974613

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Financial Management

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.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Financial Management) Materials
A land development company is considering the purchase of earth moving equipment. The equipment will have a first cost of $190,000 and a salvage value of $70,000 when the comp
From a human resource standpoint, in which country do you think a U.S. corporation would face the biggest challenge in terms of opening up an overseas division? Consider cultu
You are considering the purchase of a BMW M5. You will borrow the money from BMW Financial Services. The terms of the deal are outlined? below: BMW M5 ?RWD, 500hp,? 0-100 in 4
Romo Enterprises needs someone to supply it with 126,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to
Nielson expects to generate net income of $20 million over the next year. Currently Nielson has 8 million shares outstanding and its stock is trading at $20.00 per share. Niel
Clifford, Inc., has a target debt-equity ratio of .71. Its WACC is 8.5 percent, and the tax rate is 34 percent. If the company's cost of equity is 11.1 percent, what is its pr
You own a two-bond portfolio. Each has a par value of $1,000. Bond A matures in five years, has a coupon rate of 8 percent, and has an annual yield to maturity of 9.20 percent
Afirms dividends have grown over the last several years. 6years ago the firm paid a dividend of $1. Yesterday it paid a dividend of $7. What is the average annual growth of di