GPU Cost Projection
GPU Cost Projection
Site Location Kecamatan Rawas Ilir, Kabupaten Musi Rawas, Sumatera Selatan
MINING ± 9.000.000.000
Capex
INFRASTUCTURE ± 1.000.000.000
1. Mining Activity (OB removal, Coal getting, etc.)
2. Coal Hauling to ROM
Scope of Work
3. Coal Hauling to Intermediate Stock Pile
4. Coal Hauling to Jetty
Preparation ± 1 Month
Project Duration
Production ± 5 Years
There is 1 coal seam with thickness of more than 12 meters and
reserve of more than 4 millions tons.
Overview
PROJECT PLAN
GENERAL ASSUMPTION
PROJECT PLAN
GENERAL ASSUMPTION
GENERAL ASSUMPTION
SCHEDULE TIME
Description Unit JAN PEB MAR APR MAY JUNE JULY AUGUST SEPT OCT NOV DEC TOTAL Annual Avg
Possible days days 31.00 28.00 31.00 30.00 31.00 30.00 31.00 31.00 30.00 31.00 30.00 31.00 365.00 30.42
Public holydays days 1.00 - - 4.00 1.00 - 1.00 - - - 2.00 9.00 0.82
Schedule work days days 30.00 28.00 31.00 26.00 31.00 29.00 31.00 30.00 30.00 31.00 30.00 29.00 356.00 29.67
-
Available hours per month hours 720.00 672.00 744.00 624.00 744.00 696.00 744.00 720.00 720.00 744.00 720.00 696.00 8,544.00 712.00
Non productive hours hours 200.16 191.18 202.00 169.42 197.16 184.44 197.16 198.35 200.16 211.67 204.84 198.01 2,354.54 196.21
Productive hours hours / month 519.84 480.82 542.00 454.58 546.84 511.56 546.84 521.65 519.84 532.33 515.16 497.99 6,189.46 515.79
Productive hours hours / day 17.33 17.17 17.48 17.48 17.64 17.64 17.64 17.39 17.33 17.17 17.17 17.17 17.39 17.39
UA MOHH 72% 72% 73% 73% 74% 74% 74% 72% 72% 72% 72% 72% 72% 72%
Productive hours corrected by PA hours / day 14.93 14.77 15.08 15.08 15.24 15.24 15.24 14.99 14.93 14.77 14.77 14.77 14.99 14.99
hours / Month 447.84 413.62 467.60 392.18 472.44 441.96 472.44 449.65 447.84 457.93 443.16 428.39 5,335.06 444.59
UA 62% 61% 63% 63% 65% 65% 65% 63% 62% 61% 61% 61% 69% 63%
Delays minute
Pre-use check 20.00 hours 10.00 9.33 10.33 8.67 10.33 9.67 10.33 10.00 10.00 10.33 10.00 9.67 118.67 9.89
Refueling, lube, tyre 10.00 hours 5.00 4.67 5.17 4.33 5.17 4.83 5.17 5.00 5.00 5.17 5.00 4.83 59.33 4.94
Move equipment 10.00 hours 5.00 4.67 5.17 4.33 5.17 4.83 5.17 5.00 5.00 5.17 5.00 4.83 59.33 4.94
Wait equipment hours - - - - - - - - - - - - - -
Meal / rest / praying 128.00 hours 64.00 59.73 66.13 55.47 66.13 61.87 66.13 64.00 64.00 66.13 64.00 61.87 759.47 63.29
Change shift 120.00 hours 60.00 56.00 62.00 52.00 62.00 58.00 62.00 60.00 60.00 62.00 60.00 58.00 712.00 59.33
Haze hours - - - - - - - - - - - - - -
Idle -
Customer problem hours - - - - - - - -
Strike hours - - - - - - - - -
Total Rain & Slippery hours / month 101.09 102.21 95.75 80.31 87.05 81.43 87.05 97.83 101.09 113.16 109.51 105.86 1,162.34 96.48
Rain & Slippery %/day 16% 17% 14% 14% 13% 13% 13% 15% 16% 17% 17% 17% 15% 15%
Rain & Slippery hours /day 3.37 3.65 3.09 3.09 2.81 2.81 2.81 3.26 3.37 3.65 3.65 3.65 39.20 3.26
PROJECT PLAN
GENERAL ASSUMPTION
Annual Resume with 2 shift running
Schedule work days 29.67 days
Available hours per month 712.00 hour
Production
OB Removal
Productivity 221.00 bcm/hour
Production 212,243.08 bcm
Coal Getting
Productivity 260.00 ton/hour
Production 53,060.77 ton
Stripping Ratio 4.00 bcm/ton
PROJECT PLAN
OB Removal Unit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Avg/Month
Excavator PC 500 2 968 894 1,010 847 1,019 954 1,019 971 968 990 958 926 11,525 960 hour
Dumptruck OB (Scania) 10 4,838 4,472 5,048 4,234 5,096 4,768 5,096 4,857 4,838 4,951 4,792 4,632 57,623 4,802 hour
Bulldozer 2 968 894 1,010 847 1,019 954 1,019 971 968 990 958 926 11,525 960 hour
Waterpump (sykes) 1 270 252 279 234 279 261 279 270 270 279 270 261 3,204 267 hour
Tower Lamp 4 967.68 894.43 1,009.61 846.77 1,019.28 953.52 1,019.28 971.30 967.68 990.26 958.32 926.38 11,525 960 hour
LV Support x 5 2,325 2,100 2,325 2,250 2,325 2,250 2,325 2,325 2,250 2,325 2,250 2,325 27,375 2,281 hour
Water Truck 1 120.96 111.80 126.20 105.85 127.41 119.19 127.41 121.41 120.96 123.78 119.79 115.80 1,441 120
Fuel Truck 1 120.96 111.80 126.20 105.85 127.41 119.19 127.41 121.41 120.96 123.78 119.79 115.80 1,441 120
Coal Getting
Excavator PC 400 1 242 224 252 212 255 238 255 243 242 248 240 232 2,881 240 hour
Dumptruck CO (Fuso 220) 10 2,419 2,236 2,524 2,117 2,548 2,384 2,548 2,428 2,419 2,476 2,396 2,316 28,811 2,401 hour
Excavator PC 200 2 968 894 1,010 847 1,019 954 1,019 971 968 990 958 926 11,525 960 hour
Road Maintenance
Compactor 1 242 224 252 212 255 238 255 243 242 248 240 232 2,881 240 hour
Motor Grader 1 483.84 447.22 504.80 423.38 509.64 476.76 509.64 485.65 483.84 495.13 479.16 463.19 5,762 480 hour
Production Forecast
Production Prodty Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Avg/month
OB Removal 221 213,857.28 197,669.47 223,123.37 187,135.73 225,260.88 210,727.92 225,260.88 214,658.01 213,857.28 218,848.34 211,788.72 204,729.10 2,546,917 212,243 bcm
Coal Getting 260 53,464.32 49,417.37 55,780.84 46,783.93 56,315.22 52,681.98 56,315.22 53,664.50 53,464.32 54,712.09 52,947.18 51,182.27 636,729 53,061 ton
SR 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 bcm/ton
PROJECT PLAN
OB Removal Fuel Cons Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Avg/Month
Excavator PC 500 42 40,643 37,566 42,404 35,564 42,810 40,048 42,810 40,795 40,643 41,591 40,249 38,908 484,029 40,336 liter
Dumptruck OB (Scania) 14 67,738 62,610 70,673 59,274 71,350 66,746 71,350 67,991 67,738 69,318 67,082 64,846 806,716 67,226 liter
Bulldozer 33 31,933 29,516 33,317 27,943 33,636 31,466 33,636 32,053 31,933 32,679 31,625 30,570 380,309 31,692 liter
Waterpump (sykes) 10 2,700 2,520 2,790 2,340 2,790 2,610 2,790 2,700 2,700 2,790 2,700 2,610 32,040 2,670 liter
Tower Lamp 4 3,871 3,578 4,038 3,387 4,077 3,814 4,077 3,885 3,871 3,961 3,833 3,706 46,098 3,842 liter
LV Support x 4 9,300 8,400 9,300 9,000 9,300 9,000 9,300 9,300 9,000 9,300 9,000 9,300 109,500 9,125 liter
Water Truck 4 484 447 505 423 510 477 510 486 484 495 479 463 5,762 480
Fuel Truck 4 484 447 505 423 510 477 510 486 484 495 479 463 5,762 480
Coal Getting
Excavator PC 400 38 9,193 8,497 9,591 8,044 9,683 9,058 9,683 9,227 9,193 9,408 9,104 8,801 109,483 9,124 liter
Dumptruck CO (Fuso 220) 10 24,192 22,361 25,240 21,169 25,482 23,838 25,482 24,283 24,192 24,757 23,958 23,159 288,113 24,009 liter
Excavator PC 200 25 24,192 22,361 25,240 21,169 25,482 23,838 25,482 24,283 24,192 24,757 23,958 23,159 288,113 24,009 liter
Road Maintenance
Compactor 15 3,629 3,354 3,786 3,175 3,822 3,576 3,822 3,642 3,629 3,713 3,594 3,474 43,217 3,601 liter
Motor Grader 15 7,258 6,708 7,572 6,351 7,645 7,151 7,645 7,285 7,258 7,427 7,187 6,948 86,434 7,203 liter
Total Fuel Cons 225,615 208,366 234,961 198,264 237,096 222,100 237,096 226,415 225,315 230,691 223,249 216,408 2,685,576 223,798 liter
Fuel Ratio OB Removal 0.73 0.73 0.73 0.74 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.74 liter/bcm
Fuel Ratio Coal Getting 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 1.08 liter/ton
Fuel Ratio Project 4.22 4.22 4.21 4.24 4.21 4.22 4.21 4.22 4.21 4.22 4.22 4.23 liter/ton
10
PROJECT PLAN
11
PROJECT PLAN
11
PROJECT PLAN
ACTIVITY JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ANNUAL
OB Removal (bcm) 213,857 197,669 223,123 187,136 225,261 210,728 225,261 214,658 213,857 218,848 211,789 204,729 2,546,917
PRODUCTION Coal Getting (MT) 53,464 49,417 55,781 46,784 56,315 52,682 56,315 53,665 53,464 54,712 52,947 51,182 636,729
SR 4 4 4 4 4 4 4 4 4 4 4 4
OB Removal (bcm) 213,857 197,669 223,123 187,136 225,261 210,728 225,261 214,658 213,857 218,848 211,789 204,729 2,546,917
Price (IDR) 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000
OB Removal Revenue 7,485,004,800 6,918,431,520 7,809,317,880 6,549,750,480 7,884,130,800 7,375,477,200 7,884,130,800 7,513,030,452 7,485,004,800 7,659,692,040 7,412,605,200 7,165,518,360 89,142,094,332
Coal Getting (MT) 53,464 49,417 55,781 46,784 56,315 52,682 56,315 53,665 53,464 54,712 52,947 51,182 636,729
Price (IDR) 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500
Coal Getting Revenue 721,768,320 667,134,468 753,041,367 631,583,082 760,255,470 711,206,730 760,255,470 724,470,794 721,768,320 738,613,161 714,786,930 690,960,699 8,595,844,811
REVENUE Hauling Pit to ROM (MT) 53,464 49,417 55,781 46,784 56,315 52,682 56,315 53,665 53,464 54,712 52,947 51,182 636,729
Price (IDR) 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450
Hauling Pit to ROM Revenue 505,237,824 466,994,128 527,128,957 442,108,157 532,178,829 497,844,711 532,178,829 507,129,555 505,237,824 517,029,213 500,350,851 483,672,489 6,017,091,367
Other Activity
Price (IDR)
Other Activity Revenue
Total Revenue 8,712,010,944 8,052,560,116 9,089,488,204 7,623,441,719 9,176,565,099 8,584,528,641 9,176,565,099 8,744,630,801 8,712,010,944 8,915,334,414 8,627,742,981 8,340,151,548 103,755,030,510
Revenue Cum YTD 8,712,010,944 16,764,571,060 25,854,059,264 33,477,500,983 42,654,066,082 51,238,594,723 60,415,159,822 69,159,790,623 77,871,801,567 86,787,135,980 95,414,878,961 103,755,030,510
Unit Rent/owning Cost 3,292,545,600 3,060,349,440 3,425,457,360 2,909,254,560 3,456,117,600 3,247,658,400 3,456,117,600 3,304,031,226 3,292,545,600 3,364,136,880 3,262,874,400 3,161,611,920 39,232,700,586
Fuel Cost 4,399,499,520 4,063,134,348 4,581,738,837 3,866,148,702 4,623,373,170 4,330,941,030 4,623,373,170 4,415,096,148 4,393,649,520 4,498,470,171 4,353,358,230 4,219,946,289 52,368,729,135
Salary & Employe Benefit 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 3,089,400,000
PRODUCTION
Overtime & THR 257,450,000 257,450,000
COST
Living Cost Cost 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 2,400,000,000
Meal 232,500,000 210,000,000 236,220,000 228,600,000 232,500,000 225,000,000 232,500,000 232,500,000 225,000,000 232,500,000 225,000,000 232,500,000 2,744,820,000
CSR & PPM 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 1,200,000,000
Total Production Cost 8,481,995,120 7,890,933,788 8,800,866,197 7,818,903,262 8,869,440,770 8,361,049,430 8,869,440,770 8,509,077,374 8,468,645,120 8,652,557,051 8,398,682,630 8,171,508,209 101,293,099,721
‐
PROFIT/LOSS PLO 230,015,824 161,626,328 288,622,007 ‐ 195,461,543 307,124,329 223,479,211 307,124,329 235,553,426 243,365,824 262,777,363 229,060,351 168,643,339
11
PROJECT PLAN
PLAN 2023 PLAN 2023 PLAN 2023 PLAN 2023 Annual 2021
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC (IDR)
Cash In
Investasi ‐
Cash Flow Bulan sebelumnya ‐ ‐ 1,509,754,176 ‐ 1,821,127,848 ‐ 1,532,505,842 ‐ 1,727,967,384 ‐ 1,420,843,055 ‐ 1,197,363,844 ‐ 890,239,515 ‐ 654,686,089 ‐ 411,320,265 ‐ 148,542,902 80,517,449
Revenue 8,712,010,944 8,052,560,116 9,089,488,204 7,623,441,719 9,176,565,099 8,584,528,641 9,176,565,099 8,744,630,801 8,712,010,944 8,915,334,414 8,627,742,981 8,340,151,548 103,755,030,510
Total 8,712,010,944 6,542,805,940 7,268,360,356 6,090,935,878 7,448,597,715 7,163,685,586 7,979,201,255 7,854,391,286 8,057,324,855 8,504,014,149 8,479,200,079 8,420,668,997 103,755,030,510
Cash Out
Kantor, Mess, APD 567,770,000 65,000,000 632,770,000
CAPEX MOB Demob 172,000,000 8,000,000 180,000,000
Pembangunan Mess & Facility 1,000,000,000 400,000,000 1,400,000,000
Cost Produksi 8,481,995,120 7,890,933,788 8,800,866,197 7,818,903,262 8,869,440,770 8,361,049,430 8,869,440,770 8,509,077,374 8,468,645,120 8,652,557,051 8,398,682,630 8,171,508,209 101,293,099,721
Total 10,221,765,120 8,363,933,788 8,800,866,197 7,818,903,262 8,869,440,770 8,361,049,430 8,869,440,770 8,509,077,374 8,468,645,120 8,652,557,051 8,398,682,630 8,171,508,209 103,505,869,721
Cash Flow (Cash in ‐ Cash Out) ‐ 1,509,754,176 ‐ 1,821,127,848 ‐ 1,532,505,842 ‐ 1,727,967,384 ‐ 1,420,843,055 ‐ 1,197,363,844 ‐ 890,239,515 ‐ 654,686,089 ‐ 411,320,265 ‐ 148,542,902 80,517,449 249,160,788 249,160,788
ACTIVITY JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ANNUAL
OB Removal (bcm) 213,857 197,669 223,123 187,136 225,261 210,728 225,261 214,658 213,857 218,848 211,789 204,729 2,546,917
PRODUCTION Coal Getting (MT) 53,464 49,417 55,781 46,784 56,315 52,682 56,315 53,665 53,464 54,712 52,947 51,182 636,729
SR 4 4 4 4 4 4 4 4 4 4 4 4
OB Removal (bcm) 213,857 197,669 223,123 187,136 225,261 210,728 225,261 214,658 213,857 218,848 211,789 204,729 2,546,917
Price (IDR) 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000
OB Removal Revenue 7,485,004,800 6,918,431,520 7,809,317,880 6,549,750,480 7,884,130,800 7,375,477,200 7,884,130,800 7,513,030,452 7,485,004,800 7,659,692,040 7,412,605,200 7,165,518,360 89,142,094,332
Coal Getting (MT) 53,464 49,417 55,781 46,784 56,315 52,682 56,315 53,665 53,464 54,712 52,947 51,182 636,729
Price (IDR) 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500 13,500
Coal Getting Revenue 721,768,320 667,134,468 753,041,367 631,583,082 760,255,470 711,206,730 760,255,470 724,470,794 721,768,320 738,613,161 714,786,930 690,960,699 8,595,844,811
REVENUE Hauling Pit to ROM (MT) 53,464 49,417 55,781 46,784 56,315 52,682 56,315 53,665 53,464 54,712 52,947 51,182 636,729
Price (IDR) 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450 9,450
Hauling Pit to ROM Revenue 505,237,824 466,994,128 527,128,957 442,108,157 532,178,829 497,844,711 532,178,829 507,129,555 505,237,824 517,029,213 500,350,851 483,672,489 6,017,091,367
Other Activity
Price (IDR)
Other Activity Revenue
Total Revenue 8,712,010,944 8,052,560,116 9,089,488,204 7,623,441,719 9,176,565,099 8,584,528,641 9,176,565,099 8,744,630,801 8,712,010,944 8,915,334,414 8,627,742,981 8,340,151,548 103,755,030,510
Revenue Cum YTD 8,712,010,944 16,764,571,060 25,854,059,264 33,477,500,983 42,654,066,082 51,238,594,723 60,415,159,822 69,159,790,623 77,871,801,567 86,787,135,980 95,414,878,961 103,755,030,510
Unit Rent/owning Cost 3,292,545,600 3,060,349,440 3,425,457,360 2,909,254,560 3,456,117,600 3,247,658,400 3,456,117,600 3,304,031,226 3,292,545,600 3,364,136,880 3,262,874,400 3,161,611,920 39,232,700,586
Fuel Cost 4,399,499,520 4,063,134,348 4,581,738,837 3,866,148,702 4,623,373,170 4,330,941,030 4,623,373,170 4,415,096,148 4,393,649,520 4,498,470,171 4,353,358,230 4,219,946,289 52,368,729,135
Salary & Employe Benefit 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 257,450,000 3,089,400,000
PRODUCTION
Overtime & THR 257,450,000 257,450,000
COST
Living Cost Cost 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 200,000,000 2,400,000,000
Meal 232,500,000 210,000,000 236,220,000 228,600,000 232,500,000 225,000,000 232,500,000 232,500,000 225,000,000 232,500,000 225,000,000 232,500,000 2,744,820,000
CSR & PPM 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 1,200,000,000
Total Production Cost 8,481,995,120 7,890,933,788 8,800,866,197 7,818,903,262 8,869,440,770 8,361,049,430 8,869,440,770 8,509,077,374 8,468,645,120 8,652,557,051 8,398,682,630 8,171,508,209 101,293,099,721
‐
PROFIT/LOSS PLO 230,015,824 161,626,328 288,622,007 ‐ 195,461,543 307,124,329 223,479,211 307,124,329 235,553,426 243,365,824 262,777,363 229,060,351 168,643,339