Fleet Capacity Estimator v2

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 41

Parameters

Rated Capacity 24 m3
Fill Factor 93%
Carry Capacity 22.32 m3
Swell Factor % 120% %
In-situ Density 1.35
Loose Density 1.13
Payload 25.11 t
Availability 85% %
Use of Availability 95% %
Equipment Efficiency 95% %
OEE 77% %
Shift 1
Calendar Time 12 h
Standby Lunch 1h
Standby Others 0.3 h
Working Hours 10.7 h
Effective Working Hours 8.21 h
Speed - Loaded 26 km/h
Speed - Empty 28 km/h

Truck Cycle
Loading Area - Backing/Spotting 1.29 min
Hauling 8.05 min
Dumping Area - Backing/Spotting 1.29 min
Tipping / Dumping 1.58 min

Excavator Cycle
Model P058
Bucket Capacity m3
Shovel Swing Time 21.00 sec
Adjustment Factor 1.30
Adjusted Shovel Cycle 27.30 sec

Truck Wait - Backing/Spotting 1.29 min


Area Prep / Positioning 0.50 min

Daily Production 25,000 t


Haul Distance 1.81 km
Total Cycle Time #REF! min
Trips #REF! trips
Daily Tonnage per Truck #REF! t

Daily Excavator Truck Loads #REF! truck loads


Daily Excavator Tonnage #REF! t
Hourly production #REF! tph

Fleet Ratio
Excavator 1 unit
Truck #REF! unit

Fleet Requirement
Required Trucks #REF! unit
Required Excavator #REF! unit
Excavator Capacity Required Allocated
Digger ID Distance (m) Exc tph
No. (m3) ADTs ADT
1 P200-801 3.30 1,500 310 3 5
2 P200-801 3.30 1,000 310 3 2
3 - - 3
4 - - 4
5 - - 2
6 - - 2
7 - - 4
8 - - -
9 - - -
10 - - -
Total 620 6 22

223,087
Daily Tonnes

2,543 Loose Density 1.13


1,568
- Load Per Truck 25.11
- Eff. Hrs 8.21
- OEE
-
-
-
-
-
4,111
Excavators Bucket size 3.30 Speed - Loaded
Tonnes per 3.71 Speed - Empty
Passes 6.76 Loading Area - Backing/Spotting
Load per tr 25.11 Dumping Area - Backing/Spotting
Adjusted S 27.3 sec Tipping / Dumping
Truck Wait 1.285 min
Area Prep / 0.5 min Trucks Travel Time
Loading ti 4.86 Spot/Dump Etc
Loads/Cycle 12.34 Total Cycle
T/hr 309.84
T/d 2,543.27 Truck hrs

Trucks
26 km/h
28 km/h
1.285 min
1.285 min
1.58 min

400.55
4.15
10.83

18.27

3.00
Period Feb-23 Mar-23 Apr-23
Days 28 31 30
12 12 12
Working Hrs/month 336 372 360

Course 35,056 53,945 97,383


Fine 87,135 108,704 128,296
Ultra-Fine 42,109 17,152 44,021
164,300 179,800 269,700
127,200 139,200 139,200

Course&Fine Stk 111,674 146,465 196,464


Ultra-Fine Stk 52,626 33,335 73,236
164,300 179,800 269,700

Location 1 0 0 0
Location 2 164,300 179,800 269,700
Location 3 0 0 0

Halage Route
Course + Fine m 1,500 1,500 1,500
Ultra-Fine Stockpile + Course m 700 700 700

Excavators
Productivity 309.84 309.84 309.84
Hours - - -
Hours 691.24 756.45 1,134.68
Hours - - -
691.24
Trucks per location
- - -
2.06 2.03 3.15
- - -
2.06 2.03 3.15

Trucks
Cycle time UF Dump 10.83 10.83 10.83
Cycle time Coarse &Fine Dump 7.27 7.27 7.27

Truck Hours 1046.03873 1371.9245 1840.26378


330.823833 209.553872 460.38125
1376.86256 1581.47837 2300.64503

3 4 5
1 1 2
4 5 7

1538.98451
4.58031103

Period NumbMASS remove


1
2
3
4
5 57999.9855
6 59999.9936
7 119999.948
8 115999.943
9 57999.9935
10 55999.9825
11
12
13
14
15 57999.9858
16 59999.9863
17 57999.9911
18 59999.9926
19 59999.9906
20 57999.9938
21
22
23
24
25
26
27 57999.9898
28 59999.9882
29 57999.99
30 59999.9917
31 59999.9937
32
33
34
35
May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
31 30 31 31 30 31 30 31
12 12 12 12 12 12 12 12
372 360 372 372 360 372 360 372

58,483 149,648 18,086 82,062 62,464 24,080 4,135 427


46,240 86,183 37,019 114,440 45,793 26,432 48,487 76,711
174,277 123,769 316,895 175,498 161,442 219,188 120,978 12,762
279,000 359,600 372,000 372,000 269,700 269,700 173,600 89,900
144,000 197,200 204,000 264,000 255,200 145,000 140,000 -

87,178 190,937 49,679 171,884 89,518 43,288 51,382 77,010


191,822 168,663 322,321 200,116 180,182 226,412 122,218 12,890
279,000 359,600 372,000 372,000 269,700 269,700 173,600 89,900

0 89,900 93,000 93,000 89,900 89,900 86,800 89,900


279,000 269,700 279,000 279,000 179,800 179,800 86,800 0
0 0 0 0 0 0 0 0

1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500


700 700 700 700 700 700 700 700

309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84


- 378.23 391.27 391.27 378.23 378.23 365.18 378.23
1,173.80 1,134.68 1,173.80 1,173.80 756.45 756.45 365.18 -
- - - - - - - -

- 1.00 1.00 1.00 1.00 1.00 1.00 1.00


3.16 3.15 3.16 3.16 2.10 2.03 1.01 -
- - - - - - - -
3.16 4.15 4.16 4.16 3.10 3.03 2.01 1.00

10.83 10.83 10.83 10.83 10.83 10.83 10.83 10.83


7.27 7.27 7.27 7.27 7.27 7.27 7.27 7.27

816.589609 1788.488 465.340345684 1610.01955 838.509971 405.476354 481.288318 721.348692


1205.84799 1060.26625 2026.20184841 1257.98948 1132.67467 1423.29051 768.299512 81.0287574
2022.4376 2848.75425 2491.5421941 2868.00903 1971.18464 1828.76687 1249.58783 802.37745

2 5 1 4 2 1 1 2
4 3 6 4 4 4 3 1
6 8 7 8 6 5 4 3

MASS removeMASS removed from KING_YF_FINAL


127199.954 127,200
139199.94 139,200
139199.947 139,200
143999.947 144,000
139199.967 197,200
143999.951 204,000
143999.96 264,000
139199.984 255,200
86999.9774 145,000
83999.9777 140,000
-
-
-
-
81199.9876 139,200
83999.9869 144,000
81199.9856 139,200
83999.9882 144,000
83999.9852 144,000
81199.9879 139,200
81199.9843 81,200
-
-
86999.9835 87,000
79499.9922 79,500
9854.3663 9,854
81199.9888 139,200
83999.9852 144,000
25046.1145 83,046
60,000
60,000
-
-
-
-
Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24
31 29 31 30 31 30 31 31 30 31
12 12 12 12
372 348 254 246 254 246 254 254 246 254

0 0 0 0 41,236 65,343 17,649 20,427 0 0


0 0 0 0 98,323 77,039 52,239 79,173 743 0
0 0 0 0 325,441 307,117 319,235 86,400 63,801 0
0 0 0 0 465,000 449,500 389,123 186,000 64,544 0
0 0 0 139200 144000 139200 144000 144000 139200 81199.98

0 0 0 0 127187.8 122779.9 64593.02 93471.74 742.7812 0


0 0 0 0 337812 326719.8 324530.2 92528.23 63800.94 0
0 0 0 0 465,000 449,500 389,123 186,000

0 0 0 0 186,000 179,800 186,000 186,000 64,544 0


0 0 0 0 279,000 269,700 203,123 0 0 0
0 0 0 0 0 0 0 0 0 0

1500 1500 1500 1500 1500 1500 1500 1500 1500 1500
700 700 700 700 700 700 700 700 700 700

309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84
- - - - 600.30 580.29 600.30 600.30 208.31 -
- - - - 900.45 870.44 655.57 - - -
- - - - - - - - - -

- - - - 2.00 2.00 2.00 2.00 1.00 -


- - - - 4.00 4.00 3.00 - - -
- - - - - - - - - -
- - - - 6.00 6.00 5.00 2.00 1.00 -

10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582
7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385

0 0 0 0 913.9208 882.2473 464.1396 671.6505 5.337328 0


0 0 0 0 1629.055 1575.564 1565.005 446.2055 307.6718 0

0 0 0 0 4 4 2 3 1 0
0 0 0 0 7 7 7 2 2 0

4660
Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25
30 31 31 28 31 30 31 30 31 -45870

246 254 254 230 254 246 254 246 254 -376512

55,821 29,331 0 0 0 0 0 0 0 815,576


10,615 52,696 0 0 0 0 0 0 0 1,176,267
20,364 7,528 0 0 0 0 0 0 0 2,537,976
86,800 89,554
0 0 86999.98 79499.99 9854.366 139200 144000 83046.1 59999.99 59999.99

49689.97 73227.08 0 0 0 0 0 0 0 1747170


37110.02 16327.27 0 0 0 0 0 0 0 2782649

0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
86,800 89,554 0 0 0 0 0 0 0

1500 1500 1500 1500 1500 1500 1500 1500 1500


700 700 700 700 700 700 700 700 700

309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84


- - - - - - - - -
- - - - - - - - -
280.14 289.03 - - - - - - -

- - - - - - - - -
- - - - - - - - -
1.00 1.00 - - - - - - -
1.00 1.00 -

10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582


7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385

357.0522 526.1805 0 0 0 0 0 0 0
178.9583 78.73618 0 0 0 0 0 0 0

2 3 0 0 0 0 0 0 0
1 1 0 0 0 0 0 0 0
0

0
A1
Parameters
Rated Capacity 24 m3
Fill Factor 93%
Carry Capacity 22.32 m3
Swell Factor % 120% %
In-situ Density 1.35
Loose Density 1.13
Payload 25.11 t
Availability 85% %
Use of Availability 90% %
Equipment Efficiency 90% %
OEE 69% %
Shift 1
Calendar Time 12 h
Standby Lunch 1h
Standby Others 0.3 h
Working Hours 10.7 h
Effective Working Hours 7.37 h
Speed - Loaded 26 km/h
Speed - Empty 28 km/h

Truck Cycle
Loading Area - Backing/Spotting 1.29 min
Hauling 8.05 min
Dumping Area - Backing/Spotting 1.29 min
Tipping / Dumping 1.58 min

Excavator Cycle
Model P058
Bucket Capacity m3
Shovel Swing Time 21.00 sec
Adjustment Factor 1.30
Adjusted Shovel Cycle 27.30 sec

Truck Wait - Backing/Spotting 1.29 min


Area Prep / Positioning 0.50 min

Daily Production 25,000 t


Haul Distance 1.81 km
Total Cycle Time #REF! min
Trips #REF! trips
Daily Tonnage per Truck #REF! t

Daily Excavator Truck Loads #REF! truck loads


Daily Excavator Tonnage #REF! t
Hourly production #REF! tph

Fleet Ratio
Excavator 1 unit
Truck #REF! unit

Fleet Requirement
Required Trucks #REF! unit
Required Excavator #REF! unit
10%
1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan
15% 18% 16% 18% 14% 4% 10%
34% 18% 21% 18% 32% 39% 31%
49% 36% 37% 36% 46% 43% 41%

1-Dec 2-Dec 3-Dec 4-Dec 5-Dec 6-Dec


12% 0% 20% 15% 5% 26% 15%
26% 33% 16% 27% 31% 18%
34% 33% 36% 42% 37% 26% 33%

14000 6750
4727.823
2081.067

1-Jul-22 1-Aug-22 1-Sep-22 1-Oct-22 1-Nov-22


420,067 448,677 393,173 439,476 417,354
252,040 269,206 235,904 263,686 250,412
8,130 8,684 7,863 8,506 8,347

8400

10000

1260
7140
3570

Eff. Hrs
Trucks
Cycle time
Loads per hr/truck
Total loads per hr
Loads per day
Tonnes per day
7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan 14-Jan 15-Jan
22% 32% 29% 5% 7% 1% 9% 10%
23% 26% 19% 36% 31% 38% 38% 40%
45% 57% 48% 40% 38% 40% 47% 50%

7-Dec 8-Dec 9-Dec 10-Dec 11-Dec 12-Dec 13-Dec 14-Dec 15-Dec


10% 11% 14%
21% 32% 28% 24% 31% 29% 33% 31% 22%
31% 32% 28% 24% 43% 29% 33% 31% 36%

1-Dec-22 1-Jan-23 1-Feb-23


439,426 375,638
263,655 225,383
8,505 7,270

10
9
30
2
18
180
4500
16-Jan 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan
15% 36% 10% 5% 0% 14% 18% 15% 14% 12%
33% 14% 28% 34% 37% 49% 37% 39% 29% 41%
48% 50% 38% 39% 37% 64% 55% 54% 43% 53%

16-Dec 17-Dec 18-Dec 19-Dec 20-Dec 21-Dec 22-Dec 23-Dec 24-Dec 25-Dec
10% 10% 0% 0% 9% 18% 11% 12% 10% 15%
24% 25% 32% 34% 27% 24% 25% 20% 22% 19%
34% 35% 32% 34% 36% 42% 36% 32% 32% 34%

432000
26-Jan 27-Jan 28-Jan 29-Jan 30-Jan 31-Jan 1-Feb 2-Feb 3-Feb 4-Feb
26% 15% 10% 11% 10% 22% 22% 17% 16% 23%
38% 37% 39% 37% 40% 36% 40% 42% 41% 38%
64% 52% 49% 48% 50% 58% 62% 59% 58% 61%

26-Dec 27-Dec 28-Dec 29-Dec 30-Dec 31-Dec


11% 13% 19% 12% 13% 18%
24% 22% 18% 31% 25% 18%
35% 35% 37% 42% 38% 36%
5-Feb
16%
41%
57%
Period Feb-23 Mar-23 Apr-23
Days 28 31 30
Working Hrs/month 336 364 352

Course 35,056 53,945 97,383


Fine 87,135 108,704 128,296
Ultra-Fine 42,109 17,152 44,021

164,300 179,800 269,700


Course&Fine Stk 111,674 146,465 196,464
Ultra-Fine Stk 52,626 33,335 73,236

Location 1 0 0 0
Location 2 164,300 179,800 269,700
Location 3 0 0 0

Halage Route
Course + Fine m 1,500 1,500 1,500
Ultra-Fine Stockpile + Course m 700 700

Excavators 2,230.87
Productivity 309.84 309.84 309.84
Hours - - -
Hours 691.24 756.45 1,134.68
Hours - - -

Trucks per location


- - -
2.06 2.08 3.23
- - -
2.06 2.08 3.23

Trucks
Cycle time UF Dump 10.83 10.83 10.83
Cycle time Coarse &Fine Dump

Truck Hours 1180.59349 1052.43758 1411.71235


0 0 0
1180.59349 1052.43758 1411.71235

4 3 5
0 0 0

4 3 5

4 3 4
May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
31 30 31 31 30 31 30 31
364 352 364 364 352 364 246 254

58,483 149,648 18,086 82,062 62,464 24,080 4,135 427


46,240 86,183 37,019 114,440 45,793 26,432 48,487 76,711
174,277 123,769 316,895 175,498 161,442 219,188 120,978 12,762

279,000 359,600 372,000 372,000 269,700 269,700 173,600 89,900


87,178 190,937 49,679 171,884 89,518 43,288 51,382 77,010
191,822 168,663 322,321 200,116 180,182 226,412 122,218 12,890

0 89,900 93,000 93,000 89,900 89,900 86,800 89,900


279,000 269,700 279,000 279,000 179,800 179,800 86,800 0
0 0 0 0 0 0 0 0

1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500


700 700 700 700 700 700 700 700

309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84


- 290.15 300.15 300.15 290.15 290.15 280.14 290.15
1,173.80 1,134.68 1,173.80 1,173.80 756.45 756.45 365.18 -
- - - - - - - -

- 1.00 1.00 1.00 1.00 1.00 1.00 1.00


3.23 3.23 3.23 3.23 2.15 2.08 1.48 -
- - - - - - - -
3.23 4.23 4.23 4.23 3.15 3.08 2.48 1.00

10.83 10.83 10.83 10.83 10.83 10.83 10.83 10.83

626.426304 1371.99386 356.974213 1235.08625 643.241961 311.051048 369.208301 553.364616


0 0 0 0 0 0 0 0
626.426304 1371.99386 356.974213 1235.08625 643.241961 311.051048 369.208301 553.364616

2 4 1 4 2 1 2 3
0 0 0 0 0 0 0 0

2 4 1 4 2 1

2 4 1 3 2 1 1 2
Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24
31 29 31 30 31 30 31 31 30 31
254 238 254 246 254 246 254 254 246 254

0 0 0 0 41,236 65,343 17,649 20,427 0 0


0 0 0 0 98,323 77,039 52,239 79,173 743 0
0 0 0 0 325,441 307,117 319,235 86,400 63,801 0

0 0 0 0 127187.8 122779.9 64593.02 93471.74 742.7812 0


0 0 0 0 337812 326719.8 324530.2 92528.23 63800.94 0

0 0 0 0 186,000 179,800 186,000 186,000 64,544 0


0 0 0 0 279,000 269,700 203,123 0 0 0
0 0 0 0 0 0 0 0 0 0

1500 1500 1500 1500 1500 1500 1500 1500 1500 1500
700 700 700 700 700 700 700 700 700 700

309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84
- - - - 600.30 580.29 600.30 600.30 208.31 -
- - - - 900.45 870.44 655.57 - - -
- - - - - - - - - -

- - - - 2.00 2.00 2.00 2.00 1.00 -


- - - - 4.00 4.00 3.00 - - -
- - - - - - - - - -
- - - - 6.00 6.00 5.00 2.00 1.00 -

10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582
7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385

0 0 0 0 913.9208 882.2473 464.1396 671.6505 5.337328 0


0 0 0 0 1629.055 1575.564 1565.005 446.2055 307.6718 0

0 0 0 0 4 4 2 3 1 0
0 0 0 0 7 7 7 2 2 0
Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25
30 31 31 28 31 30 31 30 31 -45870
246 254 254 230 254 246 254 246 254 -376512

55,821 29,331 0 0 0 0 0 0 0 815,576


10,615 52,696 0 0 0 0 0 0 0 1,176,267
20,364 7,528 0 0 0 0 0 0 0 2,537,976

49689.97 73227.08 0 0 0 0 0 0 0 1747170


37110.02 16327.27 0 0 0 0 0 0 0 2782649

0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
86,800 89,554 0 0 0 0 0 0 0

1500 1500 1500 1500 1500 1500 1500 1500 1500


700 700 700 700 700 700 700 700 700

309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84 309.84


- - - - - - - - -
- - - - - - - - -
280.14 289.03 - - - - - - -

- - - - - - - - -
- - - - - - - - -
1.00 1.00 - - - - - - -
1.00 1.00 -

10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582 10.82582


7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385 7.265385

357.0522 526.1805 0 0 0 0 0 0 0
178.9583 78.73618 0 0 0 0 0 0 0

2 3 0 0 0 0 0 0 0
1 1 0 0 0 0 0 0 0
0
0
Metalkol_ 0 0 0 0 0 0 0 0 0
Schedule c 0 0 0 0 0 0 0 0 0
Period Start 44958 44986 45017 45047 45078 45108
King Course (t) 35055.95 53944.54 97382.97 58483.39 149647.9 18086.01
King Fine (t) 87134.53 108703.6 128296 46239.64 86183.08 37018.91
King Ultra Fine (t) 42109.45 17151.69 44020.86 174276.8 123768.9 316894.9

YF West 89899.97 92999.96


YF South 164299.9 179799.9 269699.8 278999.9 269699.9 278999.8
Final
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
45139 45170 45200 45231 45261 45292 45323 45352 45383 45413
82062.43 62464.3 24080.18 4134.597 427.2939 41235.83
114439.8 45793.19 26431.99 48487.48 76711.12 98322.75
175497.6 161442.4 219187.7 120977.9 12761.57 325441.3

92999.99 89899.96 89899.97 86799.96 89899.98 185999.9


278999.9 179799.9 179799.9 86799.98 278999.9
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
45444 45474 45505 45536 45566 45597 45627 45658 45689 45717
65343.46 17648.95 20426.62 55821.08 29330.58
77039.49 52238.76 79173.11 742.7812 10615.21 52695.67
307116.8 319235.5 86400.24 63800.94 20363.7 7528.1

179799.9 185999.9 186000 64543.72


269699.9 203123.3
86799.98 89554.36
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
45748 45778 45809 45839 Totals 0 0 0
815576.1 0 0 0
1176267 0 0 0
2537976 0 0 0
0 0 0
1434743 0 0 0
2918722 0 0 0
176354.3 0 0 0

You might also like