ERP System a Data-Laden Backbone to Support Rapid Growth
|The 30,000-sq.ft. Apex Skypark manufacturing plant performs some fabricating operations, including arc welding shown here, to build and assemble substructures for its robotic parking garages.|
“We took the parent company, Apex Design Technology (a manufacturing supplier to the aerospace industry) from 12 employees and expanded it to 130 employees in five years. Similarly, we expect to grow Skypark from a $10 million company with 20 current employees to a $100 million company with 50 employees in the next five years,” says Gallagher. “With JobBoss as a primary part of the infrastructure (at both companies), we can do that without sacrificing quality or reliability to our customers, thanks to the visibility management can get from the ERP system into the complete operations of the company. The system affords us controlled, yet rapid growth with data from the operations as the backbone of that growth.”
Managing Data from Within and from Suppliers
Robotic parking garages comprise several subsystems that Apex Skypark either fabricates itself, in a 30,000-sq.-ft. shop, or subcontracts out to its supply base. Subsystems include entry and exit modules, robotic trolley assemblies and cargo-style elevators. One garage, for example, scheduled to be erected in Dubai later this year, will have 1288 parking spaces and includes 26 robot trolleys, six entry modules and six exit modules, and four elevators.
“We might have parts coming into our plant from dozens of different vendors, as well as subassemblies being processed at 10 different vendors and another 10 to 15 different operations being performed on our floor at one time,” Gallagher says. “The ERP system allows us to see it all—what’s coming in, what’s going out, and what’s already here.”
JobBoss supports every facet of Skypark’s operations, from quoting to shipping, including shop-floor scheduling, tracking and materials purchasing. Its fabrication shop performs operations including plasma-arc cutting, welding and machining, but a lot of fabrication is outsourced to local shops.
“Everyone in our facility—15 production-floor workers and another five office employees—reports to JobBoss,” Gallagher says. “We have desktop computers running the software in the offices and two terminals out on the floor. And the more accurate the data they input the more accurate our estimates can be, whether we’re looking at costs or schedules.”
JIT Purchasing Helps with Cash Flow
Relatively speaking, “Skypark’s projects are huge, and require a lot of cash payout at the front end,” adds Dave Lechleitner, JobBoss’ senior product expert. “So, cash management and just-in-time materials purchasing is critical. JobBoss lets Skypark know precisely when to order and schedule delivery of its raw materials.” Once a bill of materials has been created and a job schedule developed, the software links the materials requirements to the operation they are required for. “We immediately know what the due date for that material should be,” Gallagher says, “and when to order it and bring it in, based on when it will be needed on the shop floor.”
Gallagher is more than just the typical JobBoss user—he’s the Southern California user-group leader for JobBoss. “He’s not just a user,” says Lechleitner, “Todd is a partner. As such, he has helped us, in the 11 years he’s been using the software (for Apex Design Technology) develop new modules and functionality.”
One area of software development
ShopStats tracks data in four key areas—orders, production, vendor activities and financial reports. Hyperlinked data allow the owner or manager to monitor these key areas in real time.
Also included is a cash-flow tool, which lets Gallagher look forward at Skypark’s cash position, taking into account traditional accounting information such as accounts payables and receivables, but also evaluating how manufacturing data might affect cash flow. Are there, for example, orders on the books that haven’t shipped? And, when the orders do ship, how is cash flow affected? Are there expenses such as material or outside services associated with projects affecting cash flow, even if a purchase order has yet to be issued?
“Without one integrated software system managing and updating the data,” says Gallagher, “data are stored separately and people spend a lot of time updating the data in each place. Our growth curve will require that I can immediately get snapshots of where we’re at, so I can see how many jobs are on the floor, what the utilization rate of each work center is and if the work centers are over- or under-booked. This helps me manage and manipulate the workforce.”
Advanced Scheduling Functionality
Gallagher also takes advantage of an add-on advanced-scheduling module to JobBoss, offered by Exact Software, called ShopBoss. “It’s a visual scheduler,” says Lechleitner, “that lets Todd view graphically his shop’s load versus capacity at any given time.”
“ShopBoss also lets me know, during the quoting stage of a job, if I can take on more work,” continues Gallagher. “It will show me what has to happen in the shop in order to take on another job, where we need to adjust. With the click of a mouse, I can add resources, move people in and out of work centers, and increase or decrease the work hours dedicated to a job.”
Gallagher describes how ShopBoss helped him respond to a customer request. “We had just supplied the customer with a production schedule, and it had made plans to visit our facility to witness acceptance testing of one of its assemblies. Then, the customer called and asked if it could schedule its visit a few days earlier.
“Using ShopBoss, I went into the schedule and, with just a few mouse clicks, quickly moved all of the production dates forward a few days. I was able to simply designate a nonwork day (Saturday) as a work day, and that automatically pulled everything into place. Without the ShopBoss functionality, we might have needed to generate 100 to 150 new travelers out on the shop floor. To manipulate each one by hand would have been a ton of work.”
Finally, Gallagher describes how the JobBoss quality module has helped one company achieve quality registration, and will soon help the newer company get there.
“The quality module helps us quickly and accurately record rework and scrap, and perform our internal and external audits,” he says. “We can track the costs associated with improving quality, costs of rework, identify trends, and determine, for example, if a certain work center or team of employees is having specific problems.
“It helped us efficiently become AS 9100 registered at Apex Design Technology,” adds Gallagher, “and will soon help us reach ISO registration at Skypark.” MF
There are no comments posted at this time.