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
You own a put option on Ford Stock with a strike price of $10. The opti?on will expire in exactly six months time. If the stock is trading at $8 in 6 months, what will be the
In a CAPM framework, prohibiting short sales: The beta of an efficient portfolio: Which of the following is not a general conclusion of studies of stock prices? The fact that
Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,000,000 loan, to assess the firm’s financial leverage and financial risk. On the basis
You are borrowing money today at 8.48 percent, compounded annually. You will repay the principal plus all the interest in one lump sum of $12,800 two years from today. How muc
Since it can be shown that share repurchases have exactly the same wealth effect for shareholders in the absence of taxes and are more beneficial when we account for taxes, wh
The Paper will involve the concepts learned in class to an analysis of Check-N-Go by using data from its annual report. you will analyze the strengths and weaknesses of the Ch
Winston Enterprises would like to buy some additional land and build a new factory. The anticipated total cost is $180.12 million. The owner of the firm is quite conservative
In 2013 Caterpillar Inc, had about 651 million shares outstanding. Their book value was $30 per share, and the market price was $85.00 per share. The company's balance sheet s