Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Case Problem 5 DUKE ENERGY COAL ALLOCATION

Duke Energy manufactures and distributes electricity to customers in the United States and Latin America. Duke recently purchased Cinergy Corporation, which has generating facilities and energy customers in Indiana, Kentucky, and Ohio. For these customers Cin- ergy has been spending $725 to $750 million each year for the fuel needed to operate its coal-fired and gas-fired power plants; 92% to 95% of the fuel used is coal. In this region, Duke Energy uses 10 coal-burning generating plants: five located inland and five located on the Ohio River. Some plants have more than one generating unit. Duke Energy uses 28-29 million tons of coal per year at a cost of approximately $2 million every day in this region.

The company purchases coal using fixed-tonnage or variable-tonnage contracts from mines in Indiana (49%), West Virginia (20%), Ohio (12%), Kentucky (11%), Illinois (5%), and Pennsylvania (3%). The company must purchase all of the coal contracted for on fixed-tonnage contracts, but on variable-tonnage contracts it can purchase varying amounts up to the limit specified in the contract. The coal is shipped from the mines to Duke Energy's generating facilities in Ohio, Kentucky, and Indiana. The cost of coal varies from $19 to $35 per ton and transportation/delivery charges range from $1.50 to

$5.00 per ton.

A model is used to determine the megawatt-hours (mWh) of electricity that each gen- erating unit is expected to produce and to provide a measure of each generating unit's effi- ciency, referred to as the heat rate. The heat rate is the total BTUs required to produce 1 kilowatt-hour (kWh) of electrical power.

Coal Allocation Model

Duke Energy uses a linear programming model, called the coal allocation model, to allo- cate coal to its generating facilities. The objective of the coal allocation model is to deter- mine the lowest-cost method for purchasing and distributing coal to the generating units. The supply/availability of the coal is determined by the contracts with the various mines, and the demand for coal at the generating units is determined indirectly by the megawatt- hours of electricity each unit must produce.

The cost to process coal, called the add-on cost, depends upon the characteristics of the coal (moisture content, ash content, BTU content, sulfur content, and grindability) and the efficiency of the generating unit. The add-on cost plus the transportation cost are added to the purchase cost of the coal to determine the total cost to purchase and use the coal.

Current Problem

Duke Energy signed three fixed-tonnage contracts and four variable-tonnage contracts. The company would like to determine the least-cost way to allocate the coal available through these contracts to five generating units. The relevant data for the three fixed-tonnage con- tracts are as follows:

Supplier

Number of Tons Contracted For

Cost ($/ton)

BTUs/lb

RAG

350,000

22

13,000

Peabody Coal Sales

300,000

26

13,300

American Coal Sales

275,000

22

12,600

For example, the contract signed with RAG requires Duke Energy to purchase 350,000 tons of coal at a price of $22 per ton; each pound of this particular coal provides 13,000 BTUs.

The data for the four variable-tonnage contracts follow:

Supplier

Number of Tons Available

Cost ($/ton)

BTUs/lb

Consol, Inc.

200,000

32

12,250

Cyprus Amax

175,000

35

12,000

Addington Mining

200,000

31

12,000

Waterloo

180,000

33

11,300

For example, the contract with Consol, Inc., enables Duke Energy to purchase up to 200,000 tons of coal at a cost of $32 per ton; each pound of this coal provides 12,250 BTUs.

The number of megawatt-hours of electricity that each generating unit must produce and the heat rate provided are as follows:

Generating Unit

Electricity Produced (mWh)

Heat Rate (BTUs per kWh)

Miami Fort Unit 5

550,000

10,500

Miami Fort Unit 7

500,000

10,200

Beckjord Unit 1

650,000

10,100

East Bend Unit 2

750,000

10,000

Zimmer Unit 1

1,100,000

10,000

For example, Miami Fort Unit 5 must produce 550,000 megawatt-hours of electricity, and 10,500 BTUs are needed to produce each kilowatt-hour.

The transportation cost and the add-on cost in dollars per ton are shown here:

Supplier

Miami Fort Unit 5

Miami Fort Unit 7

Beckjord Unit 1

East Bend Unit 2

Zimmer Unit 1

RAG

5.00

5.00

4.75

5.00

4.75

Peabody

3.75

3.75

3.50

3.75

3.50

American

3.00

3.00

2.75

3.00

2.75

Consol

3.25

3.25

2.85

3.25

2.85

Cyprus

5.00

5.00

4.75

5.00

4.75

Addington

2.25

2.25

2.00

2.25

2.00

Waterloo

2.00

2.00

1.60

2.00

1.60

Supplier

Miami Fort Unit 5

Miami Fort Unit 7

Beckjord Unit 1

East Bend Unit 2

Zimmer Unit 1

RAG

10.00

10.00

10.00

5.00

6.00

Peabody

10.00

10.00

11.00

6.00

7.00

American

13.00

13.00

15.00

9.00

9.00

Consol

10.00

10.00

11.00

7.00

7.00

Cyprus

10.00

10.00

10.00

5.00

6.00

Addington

5.00

5.00

6.00

4.00

4.00

Waterloo

11.00

11.00

11.00

7.00

9.00

Managerial Report

Prepare a report that summarizes your recommendations regarding Duke Energy's coal allocation problem. Be sure to include information and analysis for the following issues:

1. Determine how much coal to purchase from each of the mining companies and how it should be allocated to the generating units. What is the cost to purchase, deliver, and process the coal?

2. Compute the average cost of coal in cents per million BTUs for each generating unit (a measure of the cost of fuel for the generating units).

3. Compute the average number of BTUs per pound of coal received at each generat- ing unit (a measure of the energy efficiency of the coal received at each unit).

4. Suppose that Duke Energy can purchase an additional 80,000 tons of coal from American Coal Sales as an "all or nothing deal" for $30 per ton. Should Duke Energy purchase the additional 80,000 tons of coal?

5. Suppose that Duke Energy learns that the energy content of the coal from Cyprus Amax is actually 13,000 BTUs per pound. Should Duke Energy revise its procure- ment plan?

6. Duke Energy has learned from its trading group that Duke Energy can sell 50,000 megawatt-hours of electricity over the grid (to other electricity suppliers) at a price of $30 per megawatt-hour. Should Duke Energy sell the electricity? If so, which generating units should produce the additional electricity?

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M91883333

Have any Question?


Related Questions in Accounting Basics

Question - tribune manufacturing purchased a machine for 60

Question - Tribune Manufacturing purchased a machine for $60 000 on 1 January 2015 which is expected to have a 5 year useful life, no residual value, and to produce a total of 20 000 gadgets before it is scrapped. Assumi ...

Question refer to the hat rack cash flow statement 2002 in

Question: Refer to the Hat Rack Cash Flow Statement, 2002 in the text on page 17. Answer the following questions and submit to me via Canvas by the due date. 1. Cash flow from operations? 2. Cash flow from investing? 3. ...

Question - on january 1 2019 tony orlando industries had

Question - On January 1, 2019, Tony Orlando Industries had outstanding $1,000,000 of 12% bonds with a book amount of $966,130. The indenture specified a call price of $981,000. The bonds were issued previously at a price ...

Question - primo industries collected 105000 from customers

Question - Primo Industries collected $105,000 from customers in 2015. Of the amount collected, $25,000 was for services performed in 2014. In addition, Primo performed services worth $40,000 in 2015, which will not be c ...

Question -1 you work for thunderduck custom tables inc this

Question - 1. You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer. This month, you ...

Question - bob smith borrowed 200000 on january 1 2015 the

Question - Bob Smith borrowed $200,000 on January 1, 2015. The interest rate of 8% is compounded semiannually to be repaid January 1, 2025. To repay this Bob wants to start making five equal annual deposits into fund tha ...

Question - donuts r us sells expensive donuts the companys

Question - Donuts R Us sells expensive donuts. The company's annual fixed costs re $54000. The sales price of a donut is $10, and it costs the company $6 to make each donut. Ignore income taxes for the following requirem ...

Question - on december 31 2016 alpha company invested 10000

Question - On December 31, 2016, Alpha Company invested $10,000 in 2 years, certificate with a 4% annual interest rate with semi-annual compounding. Use this information to determine the maturity value of the certificate ...

Question - a 1000 investment pays 10 percent compounded

Question - A $1,000 investment pays 10 percent compounded annually for 2 years; another pays 10 percent compounded semiannually for 2 years. Calculate the future value of both investments at the end of year 2, and explai ...

Question - dillons camping equipment was burglarized on

Question - Dillon's Camping Equipment was burglarized on 3/10/15. It is unclear how many items were stolen. Dillon and its insurance company are currently working to estimate the dollar value of the stolen goods in order ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As