Scribd
Upload
433 views13 pages

Equipment Plan and BGT Analysis

This document contains calculations for equipment planning and budgeting for a mining project. It compares the specifications and productivity of a PC 200 and PC 300 equipment. The PC 300 can load 283 tons of material per hour and is calculated to take 707 hours to complete 600,000 tons of work, equivalent to 50.51 days or 7.22 weeks. The total budget for the project is estimated to be over 15 billion rupees.

Uploaded by

Iwan Dermawan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
433 views13 pages

Equipment Plan and BGT Analysis

This document contains calculations for equipment planning and budgeting for a mining project. It compares the specifications and productivity of a PC 200 and PC 300 equipment. The PC 300 can load 283 tons of material per hour and is calculated to take 707 hours to complete 600,000 tons of work, equivalent to 50.51 days or 7.22 weeks. The total budget for the project is estimated to be over 15 billion rupees.

Uploaded by

Iwan Dermawan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Equipment Plan & BGT Calculation

Base Calculation Planned Calculation


PC 200 PC 300 PC 300
Equipment Scheduled 1 1 1
Material Ore OB OB Ore
Amount - WMT 600,000 600,000
Bucket cap - CUM 1.20 2.10
Bucket fill factor 1.10 1.10
TF 1.60 1.60
DT capacity - Ton 23.00 20.00
N - Number of bucket / truck 12.00 5.00
Load / truck - T 25.34 18.48
CP - Bucket cycle / pass - mins 0.75 0.75
TM - Truck manuevering - mins 0.75 0.75
FP - First pass bucket ~ mins 0.17 0.17
LT ~ Loading time / truck - mins 9.17 3.92
No of truck loaded / hr - ea 6.54 15.31
PC loading rate / hr - tons 166 283 283 332
PC total hours to complete - 2,121 2,121 -
Eff working hour / day 14.00 14.00 14.00
Equiv number of days to complete - 151.52 151.52 #DIV/0!
Number of days per week 7.00 7.00 7.00
Equiv week to complete - 21.65 21.65 #DIV/0!
Prod target / week - T 16,251 27,720 27,720 -
D ~ haul distance - Km - 3.50
S ~ ave truck speed, Km/h 12.00 18.00
TD - dumping time , mins 0.83 0.83
TM - Truck manuevering - mins 0.75 0.75
LT ~ Loading time / truck - mins 9.17 3.92
CT ~ truck cycle time - mins 10.75 28.83
Number of truck required ~ CT/LT 1.17 7.36
Rounded 1.50 7.00 7.00
85 % PA 8.24 8.24
Stripping Base Hrs for 1 PC 300 N Tot Hrs PA % Rp / Hr Hr Charge - Rp Fuel Lt/Hr Rp / Lt Fuel Charge - Rp BGT Total - Rp
PC 300 2,121.21 1 2,121.21 100 706,000 1,497,575,758 11,000 - 1,497,575,758
PC 200 2,121.21 - 100 230,000 - 11,000 - -
Bulldozer 2,121.21 3 6,363.64 100 782,000 4,976,363,636 11,000 - 4,976,363,636
Dumptruck 2,121.21 7 14,848.48 100 423,000 6,280,909,091 11,000 - 6,280,909,091
- - -
Mining - - -
PC 300 #DIV/0! #DIV/0! 100 430,000 #DIV/0! 23.0 10,550 #DIV/0! #DIV/0!
PC 200 #DIV/0! #DIV/0! 100 475,000 #DIV/0! 16.0 10,550 #DIV/0! #DIV/0!
Bulldozer #DIV/0! #DIV/0! 100 782,000 #DIV/0! 20.0 10,550 #DIV/0! #DIV/0!
Dumptruck #DIV/0! #DIV/0! 100 423,000 #DIV/0! 7.0 10,550 #DIV/0! #DIV/0!
- - -
Civil Works / quarry/Stockyard - - -
PC 300 2,121.21 - 100 430,000 - 10,550 - -
PC 200 (Breaker) 1,060.61 1 1,060.61 100 704,000 746,666,667 10,550 - 746,666,667
Dumptruck 2,121.21 - 100 423,000 - 10,550 - -
Vibro 1,060.61 1 1,060.61 100 400,000 424,242,424 10,550 - 424,242,424
Grader 2,121.21 1 2,121.21 100 550,000 1,166,666,667 10,550 - 1,166,666,667
W/truck 1,060.61 1 1,060.61 100 475,000 503,787,879 10,550 - 503,787,879
Bulldozer 2,121.21 - 100 782,000 - - 11,000 - -
Total 15,596,212,121
Prod 600,000
Rp/T 25,994
$/T 1.86
Exclude PPN 10 %
Equipment Plan & BGT Calculation
Base Calculation
PC 200 PC 300
Equipment Scheduled 1 1
Material Ore Ore
Amount - WMT 200+B6:B33000 200,000
Bucket cap - CUM 1.20 2.10
Bucket fill factor 1.10 1.10
TF 1.60 1.60
DT capacity - Ton 20.00 20.00
N - Number of bucket / truck 9.00 5.00
Load / truck - T 19.01 18.48
CP - Bucket cycle / pass - mins 0.75 0.75
TM - Truck manuevering - mins 0.75 0.75
FP - First pass bucket ~ mins 0.17 0.17
LT ~ Loading time / truck - mins 6.92 3.92
No of truck loaded / hr - ea 8.67 15.31
PC loading rate / hr - tons 165 283
PC total hours to complete #VALUE! 707
Eff working hour / day 14.00 14.00
Equiv number of days to complete #VALUE! 50.51
Number of days per week 7.00 7.00
Equiv week to complete #VALUE! 7.22
Prod target / week - T 16,151 27,720
D ~ haul distance - Km - 6.50
S ~ ave truck speed, Km/h 18.00 18.00
TD - dumping time , mins 0.83 0.83
TM - Truck manuevering - mins 0.75 0.75
LT ~ Loading time / truck - mins 6.92 3.92
CT ~ truck cycle time - mins 8.50 48.83
Number of truck required ~ CT/LT 1.23 12.46
Rounded 7.00 12.00
85 % PA 8.24 14.12
Stripping Base Hrs for 1 PC 300 N Tot Hrs PA %
PC 300 - - 100
PC 200 - 100
Bulldozer - 100
Dumptruck - 100

Mining
PC 300 707.07 1 707.07 100
PC 200 707.07 2 1,414.14 100
Bulldozer 707.07 1 707.07 100
Dumptruck 707.07 12 8,484.85 100
Civil Works / quarry/Stockyard
PC 300 - - 100
PC 200 707.07 1 707.07 100
Dumptruck - 100
Vibro 353.54 1 353.54 100
Grader 353.54 1 353.54 100
W/truck 353.54 1 353.54 100
Bulldozer 353.54 1 353.54 100
Planned Calculation
PC 300
1 1
OB Ore

283 330
- -
10.00 14.00
- -
7.00 7.00
- -
19,800 32,303

552,929,292.93
12.00 14.00
14.12 28.24
Rp / Hr Hr Charge - Rp Fuel Lt/Hr Rp / Lt Fuel Charge - Rp BGT Total - Rp
706,000 - 11,000 - -
475,000 - 11,000 - -
782,000 - 11,000 - -
423,000 - 11,000 - -
- - -
- -
706,000 499,191,919 10,550 - 499,191,919
475,000 671,717,172 10,550 - 671,717,172
782,000 552,929,293 10,550 - 552,929,293
423,000 3,589,090,909 10,550 - 3,589,090,909
- - -
- -
706,000 - 10,550 - -
475,000 335,858,586 10,550 - 335,858,586
423,000 - 10,550 - -
400,000 141,414,141 10,550 - 141,414,141
550,000 194,444,444 10,550 - 194,444,444
475,000 167,929,293 10,550 - 167,929,293
782,000 276,464,646 - 11,000 - 276,464,646
Total 6,429,040,404
Prod 200,000
Rp/T 32,145
$/T 2.30
Exclude PPN 10 %
Equipment Plan & BGT Calculation
Base Calculation
PC 300 PC 300
Equipment Scheduled 1 1
Material Ore OB
Amount - WMT 200,000 600,000
Bucket cap - CUM 2.10 2.10
Bucket fill factor 1.10 1.10
TF 1.60 1.60
DT capacity - Ton 20.00 20.00
N - Number of bucket / truck 5.00 5.00
Load / truck - T 18.48 18.48
CP - Bucket cycle / pass - mins 0.75 0.75
TM - Truck manuevering - mins 0.75 0.75
FP - First pass bucket ~ mins 0.17 0.17
LT ~ Loading time / truck - mins 3.92 3.92
No of truck loaded / hr - ea 15.31 15.31
PC loading rate / hr - tons 283 283
PC total hours to complete 707 2,121
Eff working hour / day 14.00 14.00
Equiv number of days to complete 50.51 151.52
Number of days per week 7.00 7.00
Equiv week to complete 7.22 21.65
Prod target / week - T 27,720 27,720
D ~ haul distance - Km 6.50 3.50
S ~ ave truck speed, Km/h 18.00 18.00
TD - dumping time , mins 0.83 0.83
TM - Truck manuevering - mins 0.75 0.75
LT ~ Loading time / truck - mins 3.92 3.92
CT ~ truck cycle time - mins 48.83 28.83
Number of truck required ~ CT/LT 12.46 7.36
Rounded 12.00 7.00
85 % PA 14.12 8.24
Stripping Base Hrs for 1 PC 300 N Tot Hrs PA %
PC 300 2,121.21 1 2,121.21 100
PC 200 2,121.21 - 100
Bulldozer 2,121.21 3 6,363.64 100
Dumptruck 2,121.21 7 14,848.48 100

Mining
PC 300 707.07 1 707.07 100
PC 200 707.07 2 1,414.14 100
Bulldozer 707.07 - 100
Dumptruck 707.07 12 8,484.85 100
Civil Works / quarry/Stockyard
PC 300 2,121.21 - 100
PC 200 (Breaker) 1,060.61 1 1,060.61 100
PC 200 707.07
Dumptruck 2,121.21 - 100
Vibro 1,060.61 1 1,060.61 100
Grader 2,121.21 1 2,121.21 100
W/truck 1,060.61 1 1,060.61 100
Bulldozer 707.07 1 707.07 100

Alat Tambang Mining/Stripping N


PC 300 2
PC 200 2
Dumptruck 19
Vibro 1
Grader 1
W/truck 1
Bulldozer 3
Alat Tambang Civil / Quarry/Stockyard N
PC 300
PC 200 1
Dumptruck
Vibro
Grader
W/truck
Bulldozer 1
Total Equipment N Existing
PC 300 2
PC 200 3
Dumptruck 19
Vibro 1
Grader 1
W/truck 1
Bulldozer 4
Planned Calculation
PC 300

OB Ore
600,000

- 566
#DIV/0! -
14.00
#DIV/0! #DIV/0!
7.00
#DIV/0! #DIV/0!
- -

-
-
Rp / Hr Hr Charge - Rp Fuel Lt/Hr Rp / Lt Fuel Charge - Rp BGT Total - Rp
706,000 1,497,575,758 11,000 - 1,497,575,758
475,000 - 11,000 - -
782,000 4,976,363,636 11,000 - 4,976,363,636
423,000 6,280,909,091 11,000 - 6,280,909,091
- - -
- - -
706,000 499,191,919 10,550 - 499,191,919
475,000 671,717,172 10,550 - 671,717,172
430,000 - 10,550 - -
423,000 3,589,090,909 10,550 - 3,589,090,909
- - -
- - -
706,000 - 10,550 - -
704,000 746,666,667 10,550 - 746,666,667

423,000 - 10,550 - -
400,000 424,242,424 10,550 - 424,242,424
550,000 1,166,666,667 10,550 - 1,166,666,667
475,000 503,787,879 10,550 - 503,787,879
782,000 552,929,293 - 11,000 - 552,929,293
Total 20,909,141,414
Prod 200,000
Rp/T 104,546
$/T 7.47
Exclude PPN 10 %

Dif
TOTAL BUDGET INTERNAL Cost Rp/ Ton Cost $/ Ton
STRIPPING ONLY 15,596,212,121 25,994 1.86
MINING ONLY 6,429,040,404 32,145 2.30
TOTAL MINING + STRIPPING

Stripping EXPENSE TO CONTRACTOR


PPN 10 %
PROFIT 10 %
TOTAL 18,715,454,545 31,192.42 2.23

MINING EXPENSE TO CONTRACTOR


PPN 10 %
PROFIT 10 %
TOTAL 7,714,848,485 38,574 2.76

PRODUCTION UNIT COST OPERATE BY CONTRACTOR

OPERATE BY CNI
20,909,141,414 104,546 7.47
NOTES
Exchange Rate Rp/$ 14,000.00
Week ratio Stripping- Mining 3
Product - WMT 200,000.00
Contingency 10% Total Material Move Week Completion
2.04 600,000.00 21
2.53 200,000.00 7
4.57 800,000.00

93,577
6.68

2.76

9.44

You might also like