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
Assume you are at the beginning of 2001. The real risk-free rate of interest is 3 percent and expected to remain constant. Inflation is expected to be 2 percent, 3 percent, 4
ABC Corportion has 90-day receivables of Euro 500,000. The following info is available: A call option on Euro that expires in 90 days has an exercise price of $1.20 and has a
The stock of Nogro Corporation is currently selling for $30 per share. Earnings per share in the coming year are expected to be $6. The company has a policy of paying out 40%
You’ve observed the following returns on Crash-n-Burn Computer’s stock over the past five years: 14 percent, –7 percent, 17 percent, 15 percent, and 10 percent. What was the a
A firm has common stock with a market price of $100 per share and an expected dividend of $5.61 per share at the end of the coming year. A new issue of stock is expected to be
A stock paid $3.85 in dividends at the end of last year and is expected to pay a cash dividend until infinity. No growth is expected. Investors require a 6% rate of return. Wh
Cathy Foods will release new range of candies which contain antioxidants. New equipment to manufacture the candy will cost 2 million, which will be depreciated by straight lin
You want to buy a car, and a local bank will lend you $10,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 6% with interes