Industrial Machine Parts Manufacturing and Distribution Firm

Problem

A company specializing in commercial and industrial machined metal goods acted as both a made-to-order job shop and a distribution center. The old system, with which they were very comfortable, was a legacy DOS based system that was quickly exhausting its capabilities. The system was composed of conglomerate independent programs that relied on file transfers to provide an exchange of data. Redundant and fragmented data was problems, as was the use of single entries spread over multiple columns to extend field length. On going support of the system was becoming an issue.

Solution

AdvanTec designed and implemented a totally integrated business solution comprised of:

·         UA Corporate Accounting – Professional

• AdvanTec Production Control Module
• AdvanTec Market Quote—commodity quote pricing
• AdvanTec Enhanced Payroll
• Data conversion
• New server with Microsoft SBS
• Integrated with existing LAN infrastructure and local network support personnel
• Terminal services access for west coast branch office
• Subsequent growth of the business warranted an upgrade to Enterprise Edition—17 users between two offices

Benefits

Tied east and west coast offices together

Enhanced network functionality and capabilities

Integrated software programs and databases

Better control over processing and work schedule

More accurate record keeping

Less paper work. Integrated factory floor processing with front office processing

Gave salespeople greater handle on production status of orders

Converted shop from 90% Job Shop, 10% stock, to 30% JIT stock order, 60% Job, and 10% stock.