278684

DHL MTS

Planning Report

FUNCTIONAL SPECIFICATION - 10.5

21/07/2010 - 1.0
Reference: FS 278684 AR-86YL88

Client Requirement

Highlight and report under-utilised trips and strategic planned stops with no order activity.

Vehicle to vehicle transhipments

Solution

Highlight & Report Under-utilised Trips

The solution is designed to automatically route cages and other delivery units by reference to a template driven strategic plan set into the systems master data. Planning is therefore largely automatic however, some manual planning using existing C-TMS functionality will be required to handle ad-hoc collection and delivery orders, dealership returns and any exceptions arising due to over utilisation or breakdown of vehicles.

The system will provide through real time enquiry and reports, a status of trip utilisation. Any underutilised trips or unused trip stops and any over-allocated burst trips will be highlighted for manual intervention.

C-TMS provides a suite of screens to allow trips to be manually manipulated. This will cover manual addition of unallocated orders to existing trips either to consolidate or create new delivery stops within the trip schedule, creation of new trips, deletion of under-utilised trips or deletion of unused stops. These functions are generally controlled through right click menu functions from the planning screens.

C-TMS currently supports planning trips that represent a driver’s shift, for example two radial delivery rounds in one trip where the driver returns the depot or out base to reload. Trips can be generated covering this type of scenario from fixed schedules in C-TMS, or planned trips can be merged manually (trip stringing) within C-TMS as either a planning or transport function.

Every trip will be allocated to an owning depot location and a carrier assigned whether own fleet or a third party sub-contract haulier. Parameters can be set against the carrier fleet profile to govern shift times, drive times and breaks times and any deviation in plan exceeding these rules are highlighted with the trip schedule.

Vehicle to Vehicle Transhipments

C-TMS currently supports x-dock planning and trailer swapping. There is a requirement to support vehicle transhipments where cages are passed over from one vehicle to another. Some development amendments will be necessary to cater for vehicle to vehicle transhipments, particularly to maintain all the order and asset tracking requirements of the business. This function needs further definition and ideally should be controlled by the driver using a function on the Microlise HHT.

Scope

This change will be applied to system version 10.6.0 on SARTST and once approved SARPRD.

Set-up

Pre-requisites

None

Menu Structure

Unchanged

Functional Description

DP_CSV Package Changes

A new ‘comma separated value’ (CSV) extract procedure will be added to the existing package DP_CSV, this package handles the generation of extracts which can be read by MS Excel and other spreadsheet applications.

The extract will be in two formats a summary and a detail level extract will be available as selection criteria when the user initiates the extract.

In addition to the format the user will be prompted to enter the following criteria to reduce the number of records reported:

• Date From
• Date To
• Origin Depot (option to select ALL will be available)
• Utilisation Filter with two options:
  • ‘Less Than/Equal to’ or ‘Greater Than/Equal to’
  • Number between 0 and 999 (percentage)

Summary Report Format

NB the actual file will contain header information regarding selection criteria, run date and user information. All data columns will be separated by ‘,’ (commas). The data will be summarised and reported at a trip header level.

Route Number	Schedule	Trip ID	Driver	Vehicle	Vehicle Type	Vehicle Max RPE	RPE On Depart	Forecast RPE	Max Actual RPE	Trip Start	Trip End	Utilisation %	Distance	Time
1	100720	MAN-0002344	John Smith	VF55 DHF	45FT	26	26	26	27	20/07/2010 15:00	20/07/2010 16:55	100.00	166.94	01:30
2	100720	MAN-0002345	James Clarke	DE10 TRS	45FT	26	25	25	25	20/07/2010 15:43	20/07/2010 17:38	96.15	66.84	02:00
3	100720	MAN-0002346	Paul Geoffreys	MX59 OFM	18T Rigid	13	12	12	12	20/07/2010 16:26	20/07/2010 18:21	92.31	66.63	02:23
4	100720	MAN-0002347	Chris Cooksey	SE57 FGG	18T Rigid	13	10	10	10	20/07/2010 17:09	20/07/2010 19:04	76.92	172.65	01:20
5	100720	MAN-0002348	Jon Dale	UW59 PTN	18T Rigid	13	15	15	15	20/07/2010 17:52	20/07/2010 19:48	115.38	138.31	04:20
6	100720	MAN-0002349	Darren Brett	XU59 POH	45FT	26	26	25	26	20/07/2010 18:36	20/07/2010 20:31	100.00	69.63	04:15
7	100720	MAN-0002350	Daniel Bryant	EF56 JKH	45FT	26	20	20	21	20/07/2010 19:19	20/07/2010 21:14	76.92	70.68	03:30
8	100720	MAN-0002351	Brian Angus	CR55 ZYG	18T Rigid	13	13	13	13	20/07/2010 20:02	20/07/2010 21:57	100.00	130.48	01:15
9	100720	MAN-0002352	Paul White	ZG55 ZXJ	18T Rigid	13	13	13	14	20/07/2010 20:45	20/07/2010 22:40	100.00	50.30	02:04

Detail Report Format

NB the actual file will contain header information regarding selection criteria, run date and user information. All data columns will be separated by ‘,’ (commas). The data contained will be summarised at the trip stop level

Route Number	Schedule	Trip ID	Location	Vehicle Type	Vehicle Max RPE	RPE On Depart	Actual RPE	Forecast RPE	Trip Start	Trip End	Utilisation %	Distance	Time
1	100720	MAN-0002344	DHLROCH	45FT	26	26	26	26	20/07/2010 15:00	20/07/2010 16:55	100.00	166.94	01:30
1	100720	MAN-0002344	MERCWARR	45FT	26	11	15	13	20/07/2010 15:00	20/07/2010 16:55	57.69	166.94	01:30
1	100720	MAN-0002344	MERCBURT	45FT	26	0	11	11	20/07/2010 15:00	20/07/2010 16:55	42.31	166.94	01:30
1	100720	MAN-0002344	DHLROCH	45FT	26	0	0	0	20/07/2010 15:00	20/07/2010 16:55	0.00	166.94	01:30
2	100720	MAN-0002345	DHLROCH	45FT	26	25	25	25	20/07/2010 15:43	20/07/2010 17:38	96.15	66.84	02:00
2	100720	MAN-0002345	MERCKNOW	45FT	26	12	13	15	20/07/2010 15:43	20/07/2010 17:38	50.00	66.84	02:00
2	100720	MAN-0002345	MERCMAN	45FT	26	0	12	11	20/07/2010 15:43	20/07/2010 17:38	46.15	66.84	02:00
2	100720	MAN-0002345	DHLROCH	45FT	26	0	0	0	20/07/2010 15:43	20/07/2010 17:38	0.00	66.84	02:00

References

Ref No	Document Title & ID	Version	Date
1	EST-278684 AR-86YL88 Planning Report	1.0	08/07/10

Document History

Version	Date	Status	Reason	Initials
0.1	21/07/10	Draft	Initial version	MJC
1.0	21/07/10	Issue	Reviewed and Issued	MJC

AUTHORISED BY

Matt Crisford	Development Manager
Peter Greer	TMSCC MTS Product Manager