On-time handover BRD (Shipment level)
- Mituj Rana
- ASHITA GUPTA (Unlicensed)
It will be calculated for both Eshopbox shipping as well as non Eshopbox shipping.
Assumption: Expected handover date is available for all orders.
The logic for the Expected handover date:
RTS time < 12 noon Same day
RTS time > 12 noon Next day
Filter:
This dashboard will have the following filters:
Expected handover date
Date filter (Reference orders date filter)
Sales channel
List of active sales channel
This filter will have a search as well
Eshopbox sales channel to show Eshopbox logo (Reference: Sales channel filter available in orders page)
Origin
List of State + Facility code of Fulfillment center (Eshopbox + Self fulfillment FC)
Example:
Haryana: Gurgaon (AGGN)
Maharastra: Mumbai (ZMUM)
Delhi: DEL101
This filter will have a search as well.
Sorting A to Z
How is your handover performance over a period of time?
Tooltip content -
On-time handover rate -It tells you about the success rate of orders handed over on time. To calculate the data, your on-time orders get divided by the total no. of orders.
Late-Orders for which the first handover attempt was made after the expected handover date.
Overdue- Orders that are due for the first handover attempt, even after passing the expected handover date.
Exception-Orders that are not considered while calculating the on-time handover rate.
Orders need to be bifurcated into below segments:
On-time
Late
Overdue
Exception
Scenario | Expected handover date | Handover attempt (Failed) | Handover on | Expectation |
|---|---|---|---|---|
Expected handover date >= Handover on | 1 March 5 PM | - | 28 Feb 3 PM | On time |
Expected handover date < Handover on | 1 March 5 PM | - | 2 March 5 PM | Late |
Expected handover date > =Current date AND handover in not done | 1 March 5 PM | - | - | On time |
Expected handover date < Current date AND handover in not done | 1 March 5 PM | - | - | Overdue |
Expected handover date > Failed to handover attempt | 1 March 5 PM | 28 Feb 3 PM | - | On time |
Expected handover date < Failed to handover attempt | 1 March 5 PM | 2 March 5 PM | - | Exception |
Expected handover date > Failed to handover attempt AND Handover date < Expected handover date | 1 March 5 PM | 1 March 1 PM | 1 March 4 PM | On time |
Expected handover date > Failed to handover attempt AND Handover date > Expected handover date | 1 March 5 PM | 1 March 1 PM | 2 March 4 PM | Exception |
What is the on-time handover rate across different sales channels?
This widget will show the order bifurcation at the sales channel level. Only active sales channels are to be shown.
The top 10 records to be shown by default have a maximum on-time handover rate.
Sorting will be applicable for all fields as shown in the screenshot. Sorting will happen in total results.
The user can click on view all and will be redirected to a new wizard having:
Filters
Pagination (per page 50 records)
What is the on-time handover rate across different locations?
This widget will show the order bifurcation at the fulfillment center level (Eshopbox + Self fulfillment FC). Only active FC’s are to be shown.
The top 10 records to be shown by default have a maximum on-time handover rate.
Sorting will be applicable for all fields as shown in the screenshot. Sorting will happen in total results.
The user can click on view all and will be redirected to a new wizard having: (Similar to the previous widget)
Filters
Pagination (per page 50 records)
What will the Export template look like?
The format of the Exports will be as follows: https://docs.google.com/spreadsheets/d/11tSdRXXcSeaooJourJhATMEX0ZwcWtgOiLYqMyfyHlg/edit?usp=sharing
Note: The filters shown on the dashboards will also be applicable for the exports.