ADT 300D Production Estimating Program
ESTIMATING PURPOSES ONLY
Read instruction sheet before starting. Yellow colored cells are for job entry data; light blue cells contain
information; gray cells contain the grade calculator if needed.  
Material Density (lbs. per bank cubic yard) Rated ADT payload is 60,186 lbs.
Load Factor (see instructions)   Rated capacity is 21.6 c.y. heaped
ADT Payload (lbs)      
Excavator Bucket Size (heaped c.y.)        
Fill Factor (see above)        
Base Cycle Time of Excavator (sec.)        
Loose material 17 sec.      
Medium material 22 sec.      
Hard material 27 sec.       Sec. Min.
Excavator wait & repositioning allowance (sec.) Total Cycle Time
Normally 1.5 sec. if next ADT is in position; sec. if not in position  
 
Calculated excavator cycles per ADT would be The actual number is cycles.
Enter x in the yellow cell (B17) to select as the number of excavator cycles.
  Number of cycles selected
Haul (see below) Grade % Grade % Haul Road Total Time    
  Distance (ft) Adverse Favorable Factor Resistance (min) MPH  
Section A  
Section B  
Section C  
Section D  
Section E  
Section F  
Section G  
Section H  
Section I  
Section J  
Section K  
Tot. Dist.   Tot. Time Avg. MPH
 
Haul Road Description   Factor  
Very firm and smooth, well maintained 1 Use whole numbers only. Max calculated total resistance is 49 on the haul and 60 on the return. If vehicle speed will be reduced by the driver for safety or other reasons on any section, select a haul road factor that will result in the desired speed. Example: ADT will be negotiating curves on a downslope where the computed speed would be 30 mph, but desired safe speed would be 10-12 mph. Select a haul road factor that would result in a total resistance of 4 on the haul or 10 on the return.
Firm and well maintained   2
Firm with flexing or gradual undulations 3
Giving but fairly smooth: 1" tire penetration 4
Soft, smooth surface: 2" of tire penetration 5
Soft, smooth surface: 3" of tire penetration 6
Very soft with 4" of tire penetration   8
Very soft with 8" of tire penetration   14
Extremely soft with 12" of tire penetration 20
Extremely soft with 16" of tire penetration 26  
Extremely soft with 20" of tire penetration 32  
 
Important: Payload is lbs. over/ ( - if under) rated load. The total haul road  
resistance factor was automatically for each haul section.  
 
Grade Calculator  
Enter degree of grade (up to 16 deg.) 1 Read % of grade  
Enter first number of ratio to one, e.g. 12 in a 12:1 1 Read % of grade  
 
Fill    
Positioning and dump time (sec.)  
Fast .5 min. 15 Sec. Average .75 min. 45 Sec. Slow > 75 Sec.  
 
Return (see below) Grade % Grade % Haul Road Total Time    
  Distance (ft) Adverse Favorable Factor Resistance (min) MPH  
Section  
Section  
Section  
Section  
Section  
Section  
Section  
Section  
Section  
Section  
Section  
Tot. Dist.   Tot. Time Avg. MPH
 
Default Delay (Acceleration/deceleration calculated by spreadsheet) Sec. (haul and return)
Additional Delay (Record any anticipated maneuver/delay time for each ADT cycle in sec.)
Examples of additional delays are: Making sharp turns on high speed sections (8 sec. delay per turn), crossing highway, going up short slope for which there is not a separate section, intentionally driving at slower than max speed on any high speed sections (if not accounted for in haul road factors). Do not include wait at loading area--account for that in cell F13.)
 
  Total number of BCY to be moved or Tons to be moved per hour
  Number of hours for job completion Weeks (40 hr)  
 
PRODUCTION ESTIMATE
 
  Estimated Load (BCY) Actual excavator cycles per load*
  Effective cycles per load
  Time (min)    
  Load Haul Dump Return Delay Total  
   
     
  Time (sec)    
  Load Haul Dump Return Delay Total  
   
 
     
 
  Total Distance (ft) Average Speed (MPH) Includes haul, return, and delay.
   
  50 min hr 60 min hr  
  Cycles per Hour per ADT  
 
  50 min hr 60 min hr  
  Production per ADT in BCY      
  Production per ADT in Tons  
   
  Number of ADTs needed to complete job on time (50 min/hr)  
  (May require larger or additional excavators)  
  Maximum number of ADTs that can be employed    
  (Adjusted for excavator bottleneck)  
  BCY Hours BCY Weeks Tons Hours
  Time required for ADTs to complete job
  Time required for ADTs to complete job
  Time required for ADTs to complete job
           
  * Total loading time is based on full cycles. Production (BCY) is based on
  excavator cycles per truck.        
 
The production estimates are based on gradeability performance calculations and field tests. Results on any given job can vary significantly if trucks are out of specification (especially engine and tire inflation), operators are driving at less than maximum speed for the conditions, etc.