Software for growth: Turning Performance

Headquartered in Alexandria, Minnesota, Alexandria Pro-Fab Co. Inc.’s custom machining services involve CNC turning and milling (2D and 3D), five-axis milling, prototyping and machining. Production runs range from small to very large, and workpiece materials include steel, stainless steel, aluminum, brass and plastic, as well as castings and forgings.

As the company grew over the years from its humble founding in 1976 with one used welding machine to a contract machine shop with more than 150 employees operating out of a 100,000-sq.-ft. facility, Alexandria Pro-Fab’s production management system failed to keep up with the growth. In particular, the system offered minimal inventory management capabilities and was unable to accept electronic data interchange, or EDI, files from customers to simplify the order entry process.

Seeking a more up-to-date, robust enterprise resource planning system to resolve these and other shop floor challenges, Alexandria Pro-Fab turned to Global Shop Solutions Inc. in The Woodlands, Texas.

“Our previous system served us well when we were a smaller company, but the fact is we just outgrew it,” said Plant Manager Dave Dahl. “We needed more from our ERP software, and Global Shop Solutions fit all our needs as a growing enterprise.”Alexandria Pro-Fab runs upward of 3,000 jobs annually. The company also stocks finished products for some customers, allowing them to draw from inventory as needed on a preset schedule. The manufacturer often starts producing these products months in advance of the actual due date, using forecasts received through EDI to have sufficient stock on hand for customers. Hence, the need for precise material movement and inventory management is paramount. And he said Global Shop Solutions’ ERP software is more than up to the task.When running partial jobs, Dahl said the software makes it easy to track raw materials, parts, work in progress, or WIP, and finished goods as jobs progress. Order entry personnel use the work orders to create demand based on the requirements for material, machining and outside processing lead times. As operators machine the parts and log their results against the work orders, the software automatically tracks material usage and the status of each job.”We do a lot of partials on the large stock orders, so every day we are ‘WIPing’ product to finished goods,” he said. “It might take several weeks to complete a job, but we need to WIP them every two or three days in order to ship them. With Global Shop Solutions’ ERP software, we know at any point in time how many partials we have, where they are and how many more we need to complete the job.”To keep up with the high volume of jobs, Alexandria Pro-Fab regularly runs three shifts. The first shift always operates at full capacity, which can put a strain on the individual capacity of the CNC machines during the day. With only so much time available on each machine, accurate scheduling is essential for maximizing labor and machine efficiencies. Global Shop Solutions’ Advanced Planning & Scheduling application assists with the task by allowing flexible workweek scheduling. Depending on the projected workload and due dates, planners schedule each machine from a 40-hour workweek up to a 100-hour workweek.Alexandria Pro-Fab operates CNC turning and milling machines, along with robots, lathes, grinders, saws and a wire electrical discharge machine, and performs small assembly and open setups. Image courtesy of Alexandria Pro-Fab

“With APS, we can easily see where we have available time on our machines in case we need to move up a job or push others out,” Dahl said. “And if we decide to forward- or backward-schedule, the results are instantaneous. As soon as we make the change, the system immediately shows how it affects every other job on the schedule. We don’t have to wait a week for the system to reload, and we don’t have to pore over a spreadsheet with thousands of lines on it to
decipher what we just did.”