EST-04519516 WREQ0127859 - New Ford Tracking Interface

STATEMENT OF WORK CHANGE REQUEST ESTIMATE

Client	DHLT	Project	AA	Site	-
Client Reference	WREQ0127859	Aptean Reference	04519516	Estimate Version	1.00
Prepared By	A N Walker			Estimate Date	08/08/2025
Invoice Reference	-			Priority	-
Customer	Ford			System Version	12.48

Client Request

A new interface is required for Ford. It needs to contain Ford shipment ID, dealer code, date and arrival time at the delivery point. Please use the same logic as developed for Tesla tracking for the arrival time and date. We will use DHL Link to translate into the Ford outbound file but for information the format is attached. (Attachment: TransportationOrderRequest.pdf)

Aptean Solution

To achieve the requirements, the existing Tesla Tracking EDI process will be modified. In general, the tracking processes will be modified so that: The specified customer will determine which decodes to use. Explicit lists of EDI processes can be listed that are part of this tracking (i.e. this AA Tracking for 3rd-parties) The process will be modified to translate (decode) the Ford dealerships, DU Types and Locations. The process will be modified to allow for a selection of which events are active for that particular EDI process. The changes will be written in such a way that the new functionality will not affect the existing TESLA functionality, and the existing TESLA_TRACKING EDI process already created will not require any modification to continue to run as it does now. When the software is released, the following actions will be required: A new FORD_TRACKING EDI Process will need to be created, just for tracking event DEL. A new decode type of AA_TRACKING will be available, and populated with the new AA EDI tracking processes.= (i.e. TESLA_TRACKING, FORD_TRACKING) A new decode type of AA_CUST_DECODE will be available, and populated with the decode prefixes for each customer that might require it (e.g. FORD = FORD, TESLA = TESLA). This will allow for future additions of customers to this flow if required (e.g. SCANIA = TOYOTA) When the changes are implemented, the new FORD_TRACKING process will, for customer FORD, send a tracking event just for DEL. This will be populated with as much order information is required for the mapping within DHL to be completed. Note: The requirement does not contain details of which message will be sent for delivery confirmation from the messages and descriptions in the attachment. Therefore we cannot check which elements are required. The message described here can send all order-based information, including order information records. Consultancy time has been set aside in this estimate for the mapping exercise. Discrepancies in mappings may result in additional time being required for this change, therefore a contingency has been added to account for this. Time has also been accounted for for helping with implementation and testing of the new interface with DHL.

Cost Details
Activity	Hours	Rate per hour (£)	Cost (£ Exc. VAT)
Requirements	0.00	152.00	£0.00
Change Request Evaluation	7.50	152.00	£1,140.00
Functional Specification	10.75	152.00	£1,634.00
Technical Specification	0.00	152.00	£0.00
Development	27.00	152.00	£4,104.00
Testing and Release	10.50	152.00	£1,596.00
Implementation	7.50	152.00	£1,140.00
Project Management	12.75	152.00	£1,938.00
TOTAL	76.00		£11,552.00

Estimate excludes training, release to live and go live support.

Copyright © Aptean 2025. This estimate has an expiry date of 30 days from the specified Estimate Date. The information contained herein is supplied without liability for errors or omissions.