Background & Problem
Ultra Tech Machinery is a leading automation machines provider that owns and operates two facilities in Cuyahoga Falls, Ohio. Ultra Tech had a large warehouse of numerous parts, ranging in size from a single screw to large machine parts. They had never efficiently tracked these parts, which caused issues when opening new purchase orders for jobs for their customers. It also caused issues when trying to find parts while working on an existing job order. In order to overcome this, they came to us wanting to develop a new system that would include handheld devices to scan parts coming into their warehouse, scan when using parts for a project, and ultimately scan when moving unused parts to an inventory cage for future use.
Solution & Results
The Provato Group proposed to design a system that would not only accommodate Ultra Tech’s needs, but also go beyond what they thought was possible. The technologies leveraged in this proposed solution were as follows:
● ASP.NET MVC
● ASP.NET Web API
● SQL Server
● Entity Framework
● iOS Development
After prototyping base concepts, Provato proposed using QR Codes and Barcodes to leverage Ultra Tech Machinery’s existing label printers. Provato proposed building two web-based applications for this solution: first, an information system for showing where parts were located, the history of parts, and a location administration tool for managing their different warehouses, respective bays, respective racks, and respective bins where parts would be stored. Second, a web service that would contain all logic that an iPod application could call when scanning barcodes. Needless to say, Ultra Tech LOVED this idea.
This solution is now a large part of the inventory system for all parts that enter their warehouse. This has resulted in increased efficiency in their warehouse and for their employees to track, locate, and use parts when working on job orders. Armed with accurate inventory data, Ultra Tech Machinery also saved costs by reducing unnecessary orders and making use of all parts on hand.