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
Ashley borrowed $2,000 from her bank to buy a new bedroom set. Interest on the loan totals $120, and the total of $2,120 is to be paid in 12 equal installments of $176.67. Acc
Suppose you know that a company’s stock currently sells for $65.30 per share and the required return on the stock is 9 percent. You also know that the total return on the stoc
The price of a condominium is $180,000.The bank requires a 5% down payment and one point at the time of closing.The cost of the condominium is financed with a 30 years fixed r
Two companies have the same cost of equity and after tax cost of debt. What needs to be true regarding the cost of debt as compared to cost of equity for the WACC of the highe
Explain the following statements and is true statment? Duration tools have significant limitations in managing interest rate risk. Asset/Liability managers will prefer that as
Muncy, Inc., is looking to add a new machine at a cost of $4,133,250. The company expects this equipment will lead to cash flows of $818,822, $863,275, $937,250, $1,018,110, $
Estes Park Corp. pays a constant $8.60 dividend on its stock. The company will maintain this dividend for the next 11 years and will then cease paying dividends forever. If th
You have $200,000 to invest in a portfolio containing Stock X and Stock Y. Your goal is to create a portfolio that has an expected return of 11.65 percent. Stock X has an expe