Lightspeed Performance Metrics & Training

Project Deliverables

Implement a globally aligned finance and finance control system (global P/L structure, operator productivity measures and KPI’s, profit / cost center structure, intercompany invoicing and accounting scheme
Implement a centralized and standardized approach to manage and close the file ledgers and volume statistics (e.g., kg, TEU, cbm) for the freight forwarding business
Implement an Operations Control Dashboard for the freight forwarding business
Implement an accurate file-based profit-sharing system for the international freight forwarding busines

Global Deployment Team

Operations Control Dashboard (OCD)

SEKO Launched the Operations Control Dashboard (OCD) July 5 ,2023 All global operators should have access to the OCD and utilize this daily to monitor exceptions. If you need access to the OCD contact your regional corporate sponsor

Click Here to Access the Operations Control Dashboard

Check out this short 3 minute video on how to navigate and use the OCD

ocd_dashboard (Original).mp4

Late Billing Metrics

SEKO went live on July 5th with Late Billing KPIs. Late billing logic is strictly looking for the 1st Accounts Receivable billing invoice/sales invoice to be issued. Once that is issued the job will fall off the late billing dashboard. For files that are cost only and no receivable invoice will be issued, operators must put in a profit and loss reason code against the job in order for the job to fall off the dashboard. For BCN files, the dashboard is looking strictly at the ASM shipment type lead master file for the receivable invoice. If the BCN files are entered properly the sub jobs will not appear on the dashboard.

Direction & Product	Trigger 1	Trigger 2	Trigger 3	Fall Back
Ground	Actual Delivered Date + 3 Days			Job Open +30 Days
Air Export	Actual Departure + 2 Days			Job Open +30 Days
Air Import	Actual Delivered Date + 3 Days	Estimated Arrival + 5 Days		Job Open +30 Days
Air Cross Trade	Actual Delivered Date + 3 Days	Estimated Arrival + 5 Days		Job Open +30 Days
Ocean Export	Actual Departure + 3 Days	ETD + 7 Days		Job Open +30 Days
Ocean Import	Actual Delivered Date + 3 Days	Estimated Arrival + 10 Days	Actual Departure + 60 Days	Job Open +75 Days
Ocean Cross Trade	Actual Delivered Date + 3 Days	Estimated Arrival + 10 Days	Actual Departure + 60 Days	Job Open +75 Days
Brokerage	Customs Cleared + 7 Days	Actual Arrival + 10 Days		Job Open +60 Days
Contract Logistics				Month End + 5 Days
Periodic Invoicing	Agreed Configuration Date set up in ORG Profile
None of the Above				Job Open +30 Days

Gross Profit (GP) Accuracy Metrics

SEKO went live with GP Accuracy on September 11th 2023 With Phase 1 & 2

Phase	Exception	Logic	Trigger Days	Trigger Event
1	Aged Recognized WIP MEASURE IS +30 DAYS FROM Target Billing Date	Shipments with recognized WIP older than X days WHEN THE USER AS A WIP (A SALES INVOICE) JOB IS RECOGNISED	30	30 days from target billing date
1	Aged Unrecognized Costs	Shipments with unrecognized costs older than X days	90	Date of CST posting
1	Negative Margin	Where GP < 0 & NO PNL reason code		Upon marking job CMP
2	Aged WHL/ IHL Status	Shipments that have a job status of WHL/IHL for more than 90 days	90	Job Status change date
2	Aged Non Complete Jobs	Jobs in a working status WRK , 30 days AFTER Target Billing Date includes Status - CUS, INV, RDD, JRA , JRB , JRC	Refer On time Billing per product/ mode + 30 days from target billing date
2	Aged Unclosed	Job not in CLS ,JRC, IHL AND WHL , status date present 240 days, after Target billing date	240	From Target Billing date
2	Job Dept Error	Will provide the correct department in separate Column		Job Dept Auto Defaults - Based on Job Type, Mode, Directions (Service Level required for International Parcel) KPI is providing the Flag and the "Correct dept" as another column. All jobs opened up to July 2023, have been bulk updated for errors. After July 2023 errors must be manually corrected
2	Financial Closure	Shows all jobs which are status JFC, which is 30 days prior to Auto Closure to CLS	30 days prior to auto closure	Shows all jobs which are status JFC to review open WIPS & Accruals
2	Excessive Margin	Shipments with a margin above 50% , in combination with Job Status & NO PNL Reason Code	50%	GP % = REV + WIP + CST + ACR)// (REV + WIP)

How to Fix GP Accuracy Errors

Click here to view how to fix GP Accuracy Errors

Lightspeed Roadmap

TBD

Recorded Training Webinars & Documents

Topic	Webinar Date	Video
Operations Control Dashboard GP Accuracy Power Point Training	September 13, 2023	GP Accuracy Webinar Recording
Message from Steen Global Operational Excellence	October 17th, 2023	Message from Steen Global Operational Excellence