Build SQL based Shop Floor Data Collection system updated by 25 Machine Operators

Shop Floor Data Collection and Job Costing
Overview
Specialised Metal Cutting & Service Company to develop a new Shop Floor Data Collection and Job Costing application to run on local network, not the Cloud.

Source Data
Extracted from or imported from existing MS-SQL Database system.
Potentially 12 Fields of Data per Record.
Data to be held in new Updatable Table.

Data Forms
Create Forms based on new Data Table.
Administrator access to modify data if required.

Data Input
Up to 25 Shop floor Tablets/Pc’s/Special Terminals to be used by workforce.
Minimal Manual Data Entry to update data, including time fields.
Possible Bar Code aided input.
Possible input direct from Machines.
Input to update Data Table in as near real time as possible.

Output & reports
Create output Reports.
Create Activity Reports.
Create error Reports.
Create email/messaging of Successes and Failures.