Scribd Logo
Upload

Welcome to Scribd!

  • 87 views

    Duke Coal Allocation New & Final

    Uploaded by

    krishna chaitanya
    The document provides information on coal demand, costs, and allocation for 5 power plants. It lists the power production and heat rate for each plant, as well as details on contracted tons, costs per ton, and BTU content for 7 coal suppliers. The suppliers' coal is then allocated across the plants to minimize total costs based on transportation costs and BTU value per ton delivered. The total costs of coal and transportation are calculated.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Duke Coal Allocation New & Final

    Uploaded by

    krishna chaitanya
    87 views12 pages
    The document provides information on coal demand, costs, and allocation for 5 power plants. It lists the power production and heat rate for each plant, as well as details on contracted tons, costs per ton, and BTU content for 7 coal suppliers. The suppliers' coal is then allocated across the plants to minimize total costs based on transportation costs and BTU value per ton delivered. The total costs of coal and transportation are calculated.

    Original Title

    Duke coal allocation New & Final (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides information on coal demand, costs, and allocation for 5 power plants. It lists the power production and heat rate for each plant, as well as details on contracted tons, costs per ton, and BTU content for 7 coal suppliers. The suppliers' coal is then allocated across the plants to minimize total costs based on transportation costs and BTU value per ton delivered. The total costs of coal and transportation are calculated.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    87 views12 pages

    Duke Coal Allocation New & Final

    Uploaded by

    krishna chaitanya
    The document provides information on coal demand, costs, and allocation for 5 power plants. It lists the power production and heat rate for each plant, as well as details on contracted tons, costs per ton, and BTU content for 7 coal suppliers. The suppliers' coal is then allocated across the plants to minimize total costs based on transportation costs and BTU value per ton delivered. The total costs of coal and transportation are calculated.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 12

    COAL DEMAND

    POWER PROD HEAT RATE POWER IN


    PLANT (MWH) (BTU PER KWH) MNBTU

    Miami Fort Unit 5 550,000 10,500 5775000


    Miami Fort Unit 7 500,000 10,200 5100000

    Beckjord Unit 1 650,000 10,100 6565000

    East Bend Unit 2 750,000 10,000 7500000


    Zimmer Unit 1 1,100,000 10,000 11000000

    COST OF COAL
    Number of
    Supplier Tons Cost ($/ton) BTU/lb BTU/TON MNBTU/TON
    Contracted For
    RAG 350,000 22 26000000
    13000 26
    Peabody Coal Sales 300,000 26 26600000
    13300 26.6
    American Coal Sales 275,000 22 25200000
    12600 25.2
    Consol, Inc. 200,000 32 24500000
    12250 24.5
    Cyprus Amax 175,000 35 24000000
    12000 24
    Addington Mining 200,000 31 24000000
    12000 24
    Waterloo 180,000 33 22600000
    11300 22.6
    American Coal Sales NEW 80000 30 12600 25200000 25.2

    COST $/TON
    Miami Fort Miami Fort Unit Beckjord East Bend Zimmer Unit
    Unit 5 7 Unit 1 Unit 2 1
    RAG 15.000 15.000 14.750 10.000 10.750
    Peabody Coal Sales
    13.750 13.750 14.500 9.750 10.500
    American Coal Sales
    16.000 16.000 17.750 12.000 11.750
    Consol, Inc. 13.250 13.250 13.850 10.250 9.850
    Cyprus Amax 15.000 15.000 14.750 10.000 10.750
    Addington Mining
    7.250 7.250 8.000 6.250 6.000
    Waterloo 13.000 13.000 12.600 9.000 10.600
    American Coal Sales NEW
    16.000 16.000 17.750 12.000 11.750
    COAL TRANSPORTATION COST
    Supplier Miami Fort Miami Beckjord Unit East Bend Zimmer
    ($/TON) Unit 5 Fort Unit 7 1 Unit 2 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

    American 3.00 3.00 2.75 3.00 2.75


    new

    ADD ON COST
    Supplier Miami Fort Miami Fort Beckjor East Bend Zimmer Unit 1
    NBTU/TON ($/TON) Unit 5 Unit 7 d Unit 1 Unit 2
    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

    American 13.00 13.00 15.00 9.00 9.00


    New

    MWH PER TON


    Miami Fort Miami Fort Beckjord East Bend Zimmer Unit
    Unit 5 Unit 7 Unit 1 Unit 2 1
    RAG 4.50 5.10 3.96 3.47 2.36
    Peabody Coal
    Sales
    4.61 5.22 4.05 3.55 2.42
    American Coal
    Sales
    4.36 4.94 3.84 3.36 2.29
    Consol, Inc. 4.24 4.80 3.73 3.27 2.23
    Cyprus Amax 4.16 4.71 3.66 3.20 2.18
    Addington
    Mining
    4.16 4.71 3.66 3.20 2.18
    Waterloo 3.91 4.43 3.44 3.01 2.05
    American Coal
    Sales NEW 4.36 4.94 3.84 3.36 2.29
    COAL ALLOCATION (TONS)
    Miami
    Fort Unit Beckjord Unit East Bend
    Miami Fort Unit 5 7 1 Unit 2 Zimmer Unit 1
    RAG 0.0 0.0 61538.5 288461.5 0.0 350000
    Peabody Coal Sales 217105.3 11278.2 71616.5 0.0 0.0
    300000
    American Coal Sales 0.0 0.0 0.0 0.0 275000.0
    275000
    Consol, Inc. 0.0 0.0 116163.3 0.0 83836.7 200000
    Cyprus Amax 0.0 0.0 0.0 0.0 0.0 0
    Addington Mining 0.0 200000.0 0.0 0.0 0.0
    200000
    Waterloo 0.0 0.0 9469.0 0.0 0.0
    9469.0
    American New 0.0 0.0 0.0 0.0 80000.0
    80000.0
    5775000 5100000 6565000 7500000 11000000

    5,775,000 5,100,000 6,565,000 7,500,000 11,000,000

    T &A ( COST) 16146232.89406

    COST OF COAL 36862477.8761


    TOTAL COST 53008710.7702
    SAVINGS 398538.6
    = 350000
    300000
    =
    275000
    =
    = 200000

    <= 175000
    200000
    <=
    180000
    <=
    80000
    <=
    COAL DEMAND
    POWER PROD HEAT RATE POWER IN
    PLANT (MWH) (BTU PER KWH) MNBTU

    Miami Fort Unit 5 550,000 10,500 5775000


    Miami Fort Unit 7 500,000 10,200 5100000

    Beckjord Unit 1 650,000 10,100 6565000

    East Bend Unit 2 750,000 10,000 7500000


    Zimmer Unit 1 1,100,000 10,000 11000000

    COST OF COAL
    Number of
    Supplier Tons Cost ($/ton) BTU/lb BTU/TON MNBTU/TON
    Contracted For
    RAG 350,000 22 26000000
    13000 26
    Peabody Coal Sales 300,000 26 26600000
    13300 26.6
    American Coal Sales 275,000 22 25200000
    12600 25.2
    Consol, Inc. 200,000 32 24500000
    12250 24.5
    Cyprus Amax 175,000 35 26000000
    13000 26
    Addington Mining 200,000 31 24000000
    12000 24
    Waterloo 180,000 33 22600000
    11300 22.6

    COST $/TON
    Miami Fort Miami Fort Unit Beckjord East Bend Zimmer Unit
    Unit 5 7 Unit 1 Unit 2 1
    RAG 15.000 15.000 14.750 10.000 10.750
    Peabody Coal Sales
    13.750 13.750 14.500 9.750 10.500
    American Coal Sales
    16.000 16.000 17.750 12.000 11.750
    Consol, Inc. 13.250 13.250 13.850 10.250 9.850
    Cyprus Amax 15.000 15.000 14.750 10.000 10.750
    Addington Mining
    7.250 7.250 8.000 6.250 6.000
    Waterloo 13.000 13.000 12.600 9.000 10.600
    COAL TRANSPORTATION COST
    Supplier Miami Fort Miami Beckjord Unit East Bend Zimmer
    ($/TON) Unit 5 Fort Unit 7 1 Unit 2 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

    ADD ON COST
    Supplier Miami Fort Miami Fort Beckjor East Bend Zimmer Unit 1
    NBTU/TON ($/TON) Unit 5 Unit 7 d Unit 1 Unit 2
    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

    MWH PER TON


    Miami Fort Miami Fort Beckjord East Bend Zimmer Unit
    Unit 5 Unit 7 Unit 1 Unit 2 1
    RAG 4.50 5.10 3.96 3.47 2.36
    Peabody Coal
    Sales
    4.61 5.22 4.05 3.55 2.42
    American Coal
    Sales
    4.36 4.94 3.84 3.36 2.29
    Consol, Inc. 4.24 4.80 3.73 3.27 2.23
    Cyprus Amax 4.50 5.10 3.96 3.47 2.36
    Addington
    Mining
    4.16 4.71 3.66 3.20 2.18
    Waterloo 3.91 4.43 3.44 3.01 2.05
    COAL ALLOCATION (TONS)
    Miami
    Fort Unit Beckjord Unit East Bend
    Miami Fort Unit 5 7 1 Unit 2 Zimmer Unit 1
    RAG 0.0 0.0 61538.5 288461.5 0.0 350000
    Peabody Coal
    Sales 217105.3 11278.2 71616.5 0.0 0.0
    300000
    American Coal
    Sales 0.0 0.0 0.0 0.0 275000.0
    275000
    Consol, Inc. 0.0 0.0 33877.6 0.0 166122.4 200000
    Cyprus Amax 0.0 0.0 85769.2 0.0 0.0 85769.23
    Addington Mining 0.0 200000.0 0.0 0.0 0.0
    200000
    Waterloo 0.0 0.0 0.0 0.0 0.0
    0.0
    5775000 5100000 6565000 7500000 11000000

    5,775,000 5,100,000 6,565,000 7,500,000 11,000,000

    T & A( COST) 16022876.45625

    COST OF COAL 37151923.0769


    TOTAL COST 53174799.5332
    5025365.10
    DEL COST
    PRO COST 10997511.36082
    350000
    =
    300000
    =
    275000
    =
    200000
    =
    175000
    <=
    200000
    <=
    180000
    <=
    COAL DEMAND
    POWER PROD HEAT RATE POWER IN
    PLANT (MWH) (BTU PER KWH) MNBTU

    Miami Fort Unit 5 550,000 10,500 5775000


    Miami Fort Unit 7 500,000 10,200 5100000

    Beckjord Unit 1 650,000 10,100 6565000

    East Bend Unit 2 750,000 10,000 7500000


    Zimmer Unit 1 1,100,000 10,000 11000000

    COST OF COAL
    Number of
    Supplier Tons Cost ($/ton) BTU/lb BTU/TON MNBTU/TON
    Contracted For
    RAG 350,000 22 26000000
    13000 26
    Peabody Coal Sales 300,000 26 26600000
    13300 26.6
    American Coal Sales 275,000 22 25200000
    12600 25.2
    Consol, Inc. 200,000 32 24500000
    12250 24.5
    Cyprus Amax 175,000 35 24000000
    12000 24
    Addington Mining 200,000 31 24000000
    12000 24
    Waterloo 180,000 33 22600000
    11300 22.6

    COST $/TON

    Miami Fort Miami Fort Unit Beckjord East Bend Zimmer Unit
    Unit 5 7 Unit 1 Unit 2 1
    RAG
    15.000 15.000 14.750 10.000 10.750
    Peabody Coal Sales
    13.750 13.750 14.500 9.750 10.500
    American Coal Sales
    16.000 16.000 17.750 12.000 11.750
    Consol, Inc. 13.250 13.250 13.850 10.250 9.850
    Cyprus Amax 15.000 15.000 14.750 10.000 10.750
    Addington Mining
    7.250 7.250 8.000 6.250 6.000
    Waterloo 13.000 13.000 12.600 9.000 10.600
    COAL TRANSPORTATION COST
    Supplier Miami Fort Miami Beckjord Unit East Bend Zimmer
    ($/TON) Unit 5 Fort Unit 7 1 Unit 2 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

    ADD ON COST
    Supplier Miami Fort Miami Fort Beckjor East Bend Zimmer Unit 1
    NBTU/TON ($/TON) Unit 5 Unit 7 d Unit 1 Unit 2
    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

    MWH PER TON

    Miami Fort Miami Fort Beckjord East Bend Zimmer Unit


    Unit 5 Unit 7 Unit 1 Unit 2 1
    RAG
    4.50 5.10 3.96 3.47 2.36
    Peabody Coal
    Sales
    4.61 5.22 4.05 3.55 2.42
    American Coal
    Sales
    4.36 4.94 3.84 3.36 2.29
    Consol, Inc. 4.24 4.80 3.73 3.27 2.23
    Cyprus Amax 4.16 4.71 3.66 3.20 2.18
    Addington
    Mining
    4.16 4.71 3.66 3.20 2.18
    Waterloo 3.91 4.43 3.44 3.01 2.05
    COAL ALLOCATION (TONS)

    Miami Fort Unit Miami Fort Beckjord Unit East Bend Zimmer Unit
    5 Unit 7 1 Unit 2 1
    RAG 0.0 0.0 61538.5 288461.5 0.0
    Peabody Coal
    Sales 36654.1 191729.3 71616.5 0.0 0.0
    American Coal
    Sales 0.0 0.0 0.0 0.0 275000.0
    Consol, Inc. 0.0 0.0 33877.6 0.0 166122.4
    Cyprus Amax 0.0 0.0 0.0 0.0 0.0
    Addington Mining 200000.0 0.0 0.0 0.0 0.0

    Waterloo 0.0 0.0 98672.6 0.0 0.0

    5775000 5100000 6565000 7500000 11000000


    POW IN BTU
    5,775,000 5,100,000 6,565,000 7,500,000 11,000,000

    ( COST) 16001054.63869

    COST OF COAL 37406194.69027


    Q 1A, 1B,
    1C,1D OFV TOT COST 53407249.32895
    TRANSP COST 4775837.36
    PROD COST 11225217.28322

    AVG COST IN CENTSPER MILLON


    Q3 123.9 97.7 115.1 84.6
    BTU

    Q4 AVG BTU PER POUND OF COAL 12201.35 13300 12353.9208 13000

    Q6 COST PER MWH 16.6 15.2 17.3 12.3


    TOTAL COAL
    350000
    350000 =
    300000
    300000 =
    275000
    275000 =
    200000
    200000 =
    175000
    0 <=
    200000
    200000 <=
    180000
    98672.6 <=

    103.3

    12468.2

    14.8

    You might also like