BENEVOLENT TRUCKERS LTD.
“An effort by team target to solve maximum issues on the basis of their understanding of the given framework” - Omkar Vishwas Patil - Aditya Kumar
1.5 TONNE LOAD CAPACITY
4.5 TONNE LOAD CAPACITY
WAIT TIME COMPENSATION TEDIOUS DATA ACQUISITION PROCESS
CONSTANT FREIGHT CHARGES FTL/LTL CONSIGNMENT CRACKING ISSUES
Major Mandi’s Major Factories Biggest Go Downs
CITY SPREAD
Products All Around The Year
Load Pattern
• • • • •
15%
50% 35%
Food Plastic products Garments Water Medicine etc.
Semi – Seasonal • • • •
Firecrackers Notebooks Light decoration Holi colours
Seasonal All Around The Year Seasonal
Semi - Seasonal
• Mangoes • Strawberries • Ganpati idols
Market Share
40 35
‘Manufacturing outputs of different places of Mumbai’
30 25 20 15 10 5 0 Palghar
Dharavi
Andheri Market…
Bhiwandi
Rest of the city
VOLUME ASSUMPTIONS
Normal Size Truck
Mini Truck
Sr No
Cost Item
Cost/day
Cost/Km
Sr No
Cost Item
Cost/day
Cost/Km
1
Loan Instalment
400
400/100=4
1
Loan Instalment
200
400/100=4
2
Vehicle Insurance Driver Insurance
25000/365=70
0.7
2
Vehicle Insurance 15000/365=41
0.41
330/365=8.3
0.0091
3
Driver Insurance
330/365=8.3
0.0091
5000/365=13.8
0.0138
4
0.083
1000
10
5
Servicing Cost Per Year Fuel
3000/365=8.3
5
Servicing Cost Per Year Fuel
700
7
6
Driver Salary
20000/30=665
6.65
6
Driver Salary
1500/30=500
5
7
10000/30=334
3.34
7
Conductor Salary 8000/30=267
2.67
8
Conductor Salary Food
160(For Both)
1.6
8
Food
160(For Both)
1.6
9
Toll
100
1
9
Toll
100
1
10
Parking
100
1
10
Parking
100
1
2831
28.31~29(Appro x)
Total
2077
20.77~21(Approx )
3 4
Total
Operational Cost for Truck/month = Rs. 85,000/-
Operational Cost for Tempo/month = Rs. 62,310/-
Source
Destination
Distance (KM)
Time (min)
Palghar
Masjid
100
150
Bhiwandi
Masjid
50
75
Palghar
Bhiwandi
60
90
Total Distance=210
Total Time=315
Assumption : The traffic is considered to be low at 1:00 AM night and the given Distribution of Distance versus time is an ideal case.
Inference : Time required to travel 1km in ideal case (Y)= 1.5 minutes = 3/2
TRAFFIC ASSUMPTIONS
CONTENTIONS OF SOLUTION 1. 2. 3. 4. 5. 6. 7.
Dynamic freight charge pricing mechanism Dynamic module for compensating the wait time Dynamic delay Incorporation Hassle free Data acquisition process Truck positioning Seasonality Identification Mechanism Driver Incentive Model
Before the pricing… The Base Fare (BF) for Tempo/Km in an ideal case: 60 The Base Fare (BF) for Truck/Km in an ideal case: 75
Multiplying Factor X: X= (Time Given by GPS)/ (Distance * Y) X (MF of Traffic) = (Given Time * 2)/ (Distance * 3)
FTL PRICE ALGORITHM Parameter
1. 2. 3. 4.
Traffic Routes: Good Source to Good Destination Good Source to Bad Destination Bad Source to Good Destination Bad Source to Bad Destination
Delivery Type: 1. Normal 2. Express
Multiplying Factor X 1. 2. 3. 4.
1.0 1.25 1.5 2.0
1. 1.0 2. LTL=1.5
Fare in FTL (FF)= (Base Fare) *(MF of Traffic(X)) *(MF for Route) *(Distance) *(MF Delivery Type)
LTL PRICE ALGORITHM Parameter
Multiplying Factor
Traffic
1. 2. 3. 4.
X
Routes: Good Source to Good Destination Good Source to Bad Destination Bad Source to Good Destination Bad Source to Bad Destination
Delivery Type: 1. Normal 2. Express
• • • •
1. 2. 3. 4.
1.0 1.25 1.5 2.0
1. 1.0 2. LTL=1.5
Assuming Average occupancy of 60% in LTL An additional MF of 2.0 for loads in LTL is required Loads in LTL have to priced based on their volumetric weights (MFL) MFL= (Volumetric Weight of Load)/ Capacity of Vehicle
Formula : Fare in LTL (FL)= (Base Fare * 2.0 * MFL) *(MF of Traffic(X)) *(MF Route) *(Distance) * (MF Delivery Type)
WAIT TIME ALGORITHM Base Penalty (BP) for Tempo = 30 Base Penalty (BP) for Trucks = 40 Wait time penalty to be calculated upon these factors: • • • •
Customer Rating Time Delay Type of Member No of Times delayed
WAIT TIME PENALTY CALCULATION Factors Customer Rating 1. >4.5 2. 4-4.5 3. 1-4 Type of Member 1. Platinum 2. Gold 3. Silver Time Delay 1. 0-30 min 2. 30-60 min 3. 1-2 hour 4. >2 hours
MF for Trucks/Tempo 1. BP * 1.0 2. BP * 1.25 3. BP * 1.5
No of Times delayed in Past: 1. 0-2 2. 3-4 3. >4
1. BP * 0 2. BP * 1 3. BP * 1.5
1. FTL : • Formula: Total Penalty in FTL (FP)= BP * (MF of CR) *(MF Member) * (MF Time Delay) * (MF Past Delays)
1. BP * 0.5 2. BP * 0.75 3. BP * 1.0 1. 2. 3. 4.
BP * 0 BP * 1.0 BP * 1.25 BP * 2.0
2. LTL : • In LTL, we will multiply the Base Penalty by a multiplying factor of: • BPL= (Volumetric weight of load)/ (Total Capacity of truck)
•
Formula:
Total Penalty in LTL (LP)= (BP * BPL) *(MF of CR) *(MF Member) * (MF Time Delay) * (MF Past Delays)
1. FTL :
TOTAL FARE
Final Estimated Fare for FTL= FT + FF Final Fare FTL=[FT * (X3/X)] + FF Final Fare for FTL ={ [(Base Fare) *(MF of Traffic) *(MF for Route) *(Distance) *(MF Delivery Type)]*(X3/X)} + [BP * (MF of CR) *(MF Member) * (MF Time Delay) * (MF Past Delays)]
2. LTL : Final Estimated Fare for LTL= FL +FP Final Fare LTL=[FL * (X3/X)] + FP Final Fare for LTL = {[(Base Fare * 2.0 * MFL) *(Multiplying Factor of Traffic) *(MF Route) *(Distance) * (MF Delivery Type)]*(X3/X)} + [(BP * BPL) * (MF of CR) *(MF Member) * (MF Time Delay) * (MF Past Delays)]
Uncertainty Analysis For Estimated MF Traffic(X)=2 Graph of Actual MF Traffic For Past 12 Days
X3=(Actual Time to Reach)/(Distance*Y) Uncertainty Analysis
3 2.5 2 1.5 1 0.5 0 Day 1
Day 2
Day 3
Day 4
Day 5 Day 6 Estimated(X)
Day 7 Day 8 Actual(X3)
Day 9
Day 10
Day 11
Day 12
Calculation of X1 and X2 For Estimated Fare Range To incorporate dynamic delays and variation of MF Traffic X, we will consider the 3 highest and 3 lowest values among the graph: Higher traffic MFs(X1) X1= (2.4+2.2+2.6)/3=2.4 Lower Traffic MFs(X2) X2= (1.8+1.8+1.8)/3=1.8
The displayed fare to the user is a range based on substituting x1 and x2 instead of x in the formula.
Membership Categories Type of Member
Benefits
Silver
3 Coupons for 20% Discount Lower Wait Time Charges as compared to Silver Members 1. No additional charge for Express Delivery 2. Lowest Wait Time Charges Among all Members
Gold
Platinum
To Upgrade Membership To Maintain Membership Take 4 rides in 1st Month Every Registered User Take an average of 3 rides a month for 3 months No Further Upgradation Possible
Takes an average of 2 rides a month Take an average of 5 rides a month
Additional Benefits • Registration: One time, Hassle Free verification Process. • Truck Positioning: Major sources and destinations of city is identified based on past records, number of factories, demand in the industry, products seasonality etc. • Seasonality Identification: Locations that become active at particular durations of the year are identified and their Multiplying Factors are updated accordingly.
UI FEATURES DRIVER
CUSTOMER
1.Rating the customer and shipper
1.Select the type of truck 2.Option to select express or normal delivery 3.View level of membership and how many trips he needs to do more for an upgrade 4.Incentives on upgradation 5.Geotagging on the truck till the truck reaches the customer and gives a notification. 6.Add multiple drop points on the location.
2. Check if the current delivery is profitable or not 3.Google maps feature for direction
4.Driver’s profile, he will be able to check the amount of incentive he made for himself.
Driver Incentive Model TEMPO
TRUCK
Minimum revenue Required: 1.2 Lakhs
Minimum revenue Required: 1.8 Lakhs
Customer Rating
Revenue Generated > 1.2 Lakhs
Revenue Generated > 1.8 Lakhs
Customer Rating
Revenue Generated > 1.2 Lakhs
Revenue Generated > 1.8 Lakhs
>4.5
7% Total Revenue
10% Total Revenue
>4.5
7% Total Revenue
10% Total Revenue
4-4.5
4% Total Revenue
6% Total Revenue
4-4.5
4% Total Revenue
6% Total Revenue
1-4
2% Total Revenue
4% Total Revenue
1-4
2% Total Revenue
4% Total Revenue
FTL
TEST CASE 1
WAIT TIME PENALTY CALCULATION
FTL FARE CALCULATION Type of Factor
Value of Factor
Consequent
Type of Factor
Value
Consequent
Type of Vehicle
Tempo
BP=Rs 30
Time Delay
1hr 30 mins
1.25
Past Delay
3
1
Type of Member
Platinum
0.5
Customer Rating
4.9
1
Time Required (As 150 Mins per GPS)
MF=X
Distance
50
Route Delivery Type
50 KM
Good Source Good MF=1 Destination Normal
MF=1
Multiplying Factor X: X (MF of Traffic) = (Given Time * 2)/ (Distance * 3) M.F = X = 150*2/50*3 X=2 Actual Time Taken: 175 Mins X3=175/50*1.5=2.33 Fare Range calculations : Days Observed M.F
1 1.9
2 1.7
3 1.7
4 1.8
X1 = (2.4 + 2.3 + 2.2)/3=2.3 X2 = (1.7 + 1.8 + 1.7)/3=1.73
5 2.3
6 2.1
7 1.9
8 2
9 2
10 2.2
11 2.4
12 2
Formula : Total Fare = FT + FF= (Base Fare) *(MF Traffic) *(MF Route) *(Distance) *(MF Delivery Type) + BP * (MF of CR) *(MF Member) * (MF Time Delay) * (MF Past Delays)
Substituting Values: Total Estimated Fare= 40*2*1*50 + 40*1.25*1*0.5*1=4,025
Total Estimated Fare= 4,025
Fare Displayed to User Based on Substituting X1 and X2=3485-4625 Final Fare=FT*(X3/X)+FF=4660+25=4685
LTL
TEST CASE 2
LTL FARE CALCULATION
LTL WAIT TIME CALCULATION
Type of Factor
Value of Factor
Consequent
Type of Vehicle
Tempo
BP=Rs 30
Time Required (As per GPS)
150
MF=X
Distance
50 KM
50
Route
Good Source Good Destination
MF=1
Delivery Type
Normal
MF=1
Volumetric Weight
100 KG
MFL= Volumetric Weight/Total Capacity= 0.067
Type of Factor
Value
Consequent
Time Delay
1hr 30 mins
1.25
Past Delay
3
1
Type of Member
Platinum
0.5
Customer Rating
4.9
1
Multiplying Factor X: X (MF of Traffic) = (Given Time * 2)/ (Distance * 3) X=150*2/50*3 X=2 Actual Time Taken: 175 Mins X3=175/50*1.5=2.33 Fare Range calculations : Days Observed M.F
1 1.9
2 1.7
3 1.7
4 1.8
X1 = (2.4 + 2.3 + 2.2)/3=2.3 X2 = (1.7 + 1.8 + 1.7)/3=1.73
5 2.3
6 2.1
7 1.9
8 2
9 2
10 2.2
11 2.4
12 2
Formula : Total Fare = FL + FP= (Base Fare * 2.0 * MFL) *(MF Traffic) *(MF Route) *(Distance) *(MF Delivery Type) + (BP * BPL) * (MF of CR) *(MF Member) * (MF Time Delay) * (MF Past Delays)
Substituting Values: Total Fare=402 + 1.675
Total Estimated Fare=403.675 Fare Displayed to User Based on Substituting X1 and X2=349.4 – 464
Final Fare=FL*(X3/X)+FP=468.33+1.675=470
CONCLUSION