Spreadsheet: 876032d1722677595-array-hours-on-the-road-logistics-02-08-2024
Sheet: Logistics

 | Logistics
 | Client delviery requirement | tons/day |  | 120 |  | Distance A to B |  | [NAME] | 1397
 | Supplier delivery capacity | tons/truck |  | 36
 | To meet client requirement | trips/day |  |  |  | Prepare |  | hours | 1
 | Trucks required | number |  |  |  | Collect |  | hours | 2
 |  |  |  |  |  | Loading |  | hours | 1
 |  |  |  |  |  | Travel |  | hours
 | [NAME] stock surplus | tons |  |  |  | Breaks |  | hours | 1.5
 | [NAME] stock deficit | tons |  |  |  | Fueling |  | hours | 1
 |  |  |  |  |  | Offload |  | hours | 1
 | Departures from depot every | hours ([NAME]) |  | 6 |  | Turnaround |  | hours | 3
 |  | hours (actual) |  |  |  | A-B |  | hours
 | Av. round trip to meet delivery requirement | hours |  |  |  | Estimated round trip |  | hours
 | Arrival at destination after | hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Av. return trip to meet delivery requirement
 |  | round trip | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | return trip | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  | >< cycles | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | >< cycles | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  | Truck No. | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours |  | Truck No. | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Trips/day |  |  | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3
 | Reversion to mean trips/day
 |  | Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | Departure from A | Hours
 |  | 0 |  | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2 | 6 | 1 | 4 | 8 | 3 | 6 | 2 | 5 | 8 | 4 | 7 | 2 | 6 | 1 | 4 | 8 | 3 | 6 | 2 | 5 | 8 | 4 | 7 | 2 | 6 | 1 | 4 | 8 | 3
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4 | 0 | 0 | 6 | 0 | 0 | 8 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 0 | 6 | 0 | 0 | 8 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 0 | 6 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total trucks departing/day
 | Hours on road per day for all trucks
 | Arrival at B & Departure back to A | Hours
 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 2 | 6 | 1 | 4 | 8 | 3 | 6 | 2 | 5 | 8 | 4 | 7 | 2 | 6 | 1 | 4 | 8 | 3 | 6 | 2 | 5 | 8 | 4 | 7 | 2 | 6 | 1 | 4 | 8
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1 | 4 | 7 | 3 | 6 | 1 | 5 | 8 | 3 | 7 | 2 | 5 | 1
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 4 | 0 | 0 | 6 | 0 | 0 | 8 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 0 | 6 | 0 | 0 | 8 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 0 | 6 | 0
 | Total trucks arriving/day
 | BoP stock
 | [NAME] | tons/day
 | Client Requirement | tons/day
 | EoP stock
 |  |  | 1 | 1.1 |  |  | 49 | 73
 |  |  | 2 | 2.1 |  |  | 50 | 74
 |  |  | 3 | 3.1 |  |  | 51 | 75
 |  |  | 4 | 4.1 |  |  | 52 | 76
 |  |  | 5 | 5.1 |  |  | 53 | 77
 |  |  | 6 | 6.1 |  |  | 54 | 78
 |  |  | 7 | 7.1 |  |  | 55 | 79
 |  |  | 8 | 8.1 |  |  | 56 | 80
 |  |  | 9 | 9.1 |  |  | 57 | 81
 |  |  | 10 | 10.1 |  |  | 58 | 82
 |  |  | 11 | 11.1 |  |  | 59 | 83
 |  |  | 12 | 12.1 |  |  | 60 | 84
 |  |  | 13 | 13.1 |  |  | 61 | 85
 |  |  | 14 | 14.1 |  |  | 62 | 86
 |  |  | 15 | 15.1 |  |  | 63 | 87
 |  |  | 16 | 16.1 |  |  | 64 | 88
 |  |  | 17 | 17.1 |  |  | 65 | 89
 |  |  | 18 | 18.1 |  |  | 66 | 90
 |  |  | 19 | 19.1 |  |  | 67 | 91
 |  |  | 20 | 20.1 |  |  | 68 | 92
 |  |  | 21 | 21.1 |  |  | 69 | 93
 |  |  | 22 | 22.1 |  |  | 70 | 94
 |  |  | 23 | 23.1 |  |  | 71 | 95