EST 355181 Artex Scan Out of Depot Report

STATEMENT OF WORK CHANGE REQUEST ESTIMATE

Client	PART	Project	DEV	Site	PART-KOO
Client Reference	T20181029.0016	Aptean Reference	355181	Estimate Version	0.1
Prepared By	A N Walker			Estimate Date	15/01/2019
Invoice Reference				Priority	3
Customer	Artex			System Version	Latest (4.X)

Client Request

From Ken Hayes, Monday, 14 January, 2019 3:35 PM: Artex have asked for a "scanned out of depot report" which will enable them to monitor their Fork Lift drivers performance. I have reviewed data on the portal and have identified the following fields which should be usable in the report: User: FLT driver Vehicle: FLT truck Start date Arrive date End date Start time Arrive time End time Container (pallet) quantity

Aptean Solution

A new report will be added to the Reports menu item in the CALIDUS ePOD Admin application, selectable from the drop-down list of reports, labelled as "Loading/Unloading Items Report". When the user selects this report, the following criteria will be prompted for: Date Range, which will default yesterday's date for both Date From and Date To. Loading or Unloading selection, defaulting to "Loading". This will also allow the user to select Unloading jobs. When the user clicks the Create Excel Spreadsheet button, the screen will retrieve the data and build a spreadsheet for the user. Based on analysis the data that the Artex customer is currently generating (for example load "010801L"), the report will select all complete jobs for the user's current site, the type selected (loading or unloading), that ended within the date range selected (inclusive), the load on which they were received, and a count of all containers (items) successfully confirmed. The data will be summed per: Site User Vehicle Start date Start time Arrive date Arrive time End date End time The browser will offer to save the report generated. Note that this is dependent on the user's browser settings. The report will be named "Loading Unloading Items Report_YYYYMMDD_HHMMSSNN.xls", where: YYYYMMDD is the date the user ran the report. HHMMSSNN is the time the user ran the report. The report will show: The selection criteria. The results. The Selection criteria will show: Date From Date To Type The report will consist of the following columns: User - the name of the user that processed the load. Vehicle - the vehicle registration assigned to the load. Start Date - the actual date when the tasks started. Arrive Date - the actual time when the tasks started. End Date - the actual date when the tasks ended. Start Time - the actual time when the tasks ended. Arrive Time - the actual date when the tasks arrived. End Time - the actual time when the tasks arrived. Item Quantity - a sum of all the confirmed loaded or unloaded items (containers)

Warning:

Unknown costs for client/year (PART/2019)

Cost Details
Activity	Hours	Rate per hour (£)	Cost (£ Exc. VAT)
Requirements	0.00	0.00	£0.00
Change Request Evaluation	0.25	0.00	£0.00
Functional Specification	0.25	0.00	£0.00
Technical Specification	0.00	0.00	£0.00
Development	1.75	0.00	£0.00
Testing and Release	0.25	0.00	£0.00
Implementation	0.25	0.00	£0.00
Project Management	0.25	0.00	£0.00
TOTAL	3.00		£0.00

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

Copyright © Aptean 2019. 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.