Extraung – Order and Delivery Dashboard

Presented by:Suresh Kumar Dharshni

Agenda

• Objectives• Dashboard and Analysis• Recommendations

Objectives

• Real Time updates on target achievement

• Identify the root causes of delayed shipments

• Identify potential customers to increase orders

Dashboard

Dashboard

• Main KPI – Delivery on Time.

• KPI is configurable

• A snapshot of the current percentage and recognized

and unrecognized revenue from delayed deliveries and

on time deliveries

• Analysis: Impact of the delayed deliveries on the

company’s profits

Dashboard

Contribution of orders of each country • Countries to target for future

orders • Anticipate and plan the order

delivery.

Contribution of products to total orders• Salability of the products at any

point of time • Take preventive measures if

there is a significant decrease in any of the products.

Dashboard

• Overview of the trend of the percentage of deliveries made on time and with various delay periods– On time deliveries: trend line - easier to view the months

where KPI is met. – Delayed deliveries: Stacked barchart - clearer to see the

category of delayed deliveries which is most.

Dashboard

Combined Analysis: Impact of the number of orders from

each country on the delivery times to the country

Orders by country• Split up of orders based on Plants • Allows load balancing of orders• Optimization of the Plants’ resources

since the load is distributed among the plants.

Delivery times by country/customer• Allows further drilldown into customers.• Easier to target the orders from specific

companies which are impacting the overall country’s KPI

Dashboard - Orders

Dashboard - Orders

• Identify the reason for late shipments in order to rectify the issue to ensure that the number of delayed deliveries to customers is reduced and for the company to meet its On Time Delivery KPI.

Recommendations

• Solution : Allow input field for reason for delay to be entered for every order which is delayed

• Impact : Analysis of the reasons for delays which would aid to reduce the total number of delays overall.

No data on why a certain order is

delayed

• Solution : Calculate distance between Customer location and Plant location. Given coordinates, derive the approximate distance between the customer and the Plant.

• Impact :Correctly gauge whether the time given for the delivery to be considered as on time ,is accurate

Lack of information on the distance

between the Plant location and the

Customer location