“The Resource Manager is a great solution for manufacturers who are not ready for a full-blown MRPII, ERP, or Shop Management System but who realize the value of effective scheduling and planning. Resource Manager is unique in that it easily adapts to the way people are running their business today.” – Mike Parks, as Director of Georgia Tech’s CMIT, an affiliate of the NIST Manufacturing Extension Partnership (MEP)
Since 1988, the Hollings Manufacturing Extension Partnership (MEP) works directly with manufacturers to develop new products and customers, expand and diversify markets, adopt new technology, and enhance value within supply chains. MEP provides information, decision support, and implementation assistance to smaller manufacturing firms in adopting new, more advanced manufacturing technologies, techniques, and business best practices.
“We have been working with User Solutions for several years to make their resource management tools available to our readers. Students can go online to the User Solutions website and download sample programs that address real-world issues. This allows students to address examples of production planning and scheduling challenges that are difficult to convey on the written page. Our continuing work with User Solutions has been a wonderful aid in providing students with realistic insights into the challenges of production scheduling.” – Dr. Jay Heizer
Many MRP programs, such as Resource Manager-DB are commercially available. A demo program is available for student use at www.UserSolutions.com
Since 1990, “Principles of Operations Management” has been considered the premier worldwide textbook in its field. Co-authored by Jay Heizer and Barry Render and published in multiple languages, the text features material on Capacity Planning, Supply Chain Management, Inventory Management, Material Requirements Planning (MRP) and ERP, Production Scheduling, and Lean Production Systems. The book has been and continues to be an ideal reference for both students and professionals.
Greg Katz, then Vice President of Manhattan Store Interiors, N.Y., enlisted Industrial Technology Assistance Corp. (ITAC), the local MEP affiliate, to help him find a quick and easy solution for his plant’s planning and scheduling challenges. ITAC recommended Resource Manager from User Solutions.
“I have been involved in the production of store fixtures for over ten years and every day was a struggle until Resource Manager from User Solutions enabled me to print in one minute what it would take hours a day to communicate. Suddenly I was able to quickly forecast our workload and schedule our shipments for our facilities in a fraction of the time it took before I starting using Resource Manager. As a result of using Resource Manager, we forecast a 20% increase in gross profits next year.” – Greg Katz, VP of Manhattan Store Interiors
ACE Controls, Inc., had a requirement to improve their current system and to immediately implement a solution for the day-to-day scheduling challenges of the machine shop. ACE Controls specializes in pneumatic linear decelerators such as those used at Cedar Point and the Power Tower amusement ride. Supported by the NIST/Michigan Manufacturing Technology Center, Resource Manager was selected both for its benefit/cost ratio and for the company’s existing Excel platform, already used to communicate manufacturing reports.
“The product is so flexible and adaptable; it is quite easy to model different scenarios to determine if a certain method or schedule can actually benefit our bottom line.” – Dave Teumer, Buyer and Scheduling Manager, Ace Controls.
While optimization typically has been reserved for bigger companies, with dedicated staff to create and run models using sophisticated software, there are some interesting alternatives to consider for most manufacturing companies. The most famous of optimization problems is the Traveling Salesman Problem (TSP): Given a list of cities and the distances between each pair of cities, what is the shortest possible route that visits each city exactly once and returns to the origin city? Now, if you consider production scheduling optimization you might automatically recognize applying a TSP optimization to Job Shops where you might have a number of different orders, each requiring a different routing. And each routing might have variations as well, can run this product through a multi purpose CNC machine, or run it through individual machines? And, what kinds of people are available to run such equipment? The bottom line is, how should I run the shop to maximize my profits, or minimize my costs, subject to a variety of constraints -customers order due at definite times, workcenters have finite capacity, reduce overtime, per hour costs for various workcenters and labor, etc.?
For process operations, such as blending, the optimization result can minimize cost of components while meeting blending guidelines. Anyway you look at it, optimization up front before releasing a production plan, will result in the most efficient and profitable solution. What’s imperative is, once said optimal plan has been released, how to translate that to a detailed execution plan that will be responsive to day to day changes, and how to react, re-balance, re-optimize said plan while working it.
Now, given the amazing potential ROI for considering this step (optimization), and considering the tools are available in every copy of Excel (Solver), why aren’t more manufacturing concerns leveraging optimization? Well, the truth is, there is a lot of fancy, high level mathematics behind the process, and most folks in that domain space prefer to keep the techniques a bit of a black box. However, it might serve manufacturers well to investigate using Solver (and other open source solvers for Excel) in combination with a good production scheduling solution to achieve the highest level of profitability and efficiency possible.
Production Scheduling Optimization Techniques using Excel Solver
Level loading refers to being able to load jobs, production, etc., on available resources equally. For example, suppose I have three employees that can all do welding. If I want to level load those employees, each job that comes in will be assigned to the employee that has the least amount of hours loaded. So, as jobs are assigned, the employees have, more or less, equal loading (hours to work). This is the same technique that all restaurants use to make sure each wait staff gets an equitable amount of customers (table and customer allocation). Here is an example of level loading production across 4 workcenters. The key assumption is that any welder can do any job, any wait person can handle any customer, etc.
Capacity Level Loading for 4 Workcenters
Finite Capacity Scheduling
Finite capacity scheduling systems check to see what available hours are set for each resource and the scheduling system will ONLY schedule up to that amount, then it needs to find another day (either forward or back in time depending on scheduling horizon) to keep loading remaining hours required.
Other, more advanced techniques include a combination of the two – level loading and finite capacity scheduling.
Production Scheduling Level Loading Example
The above figure is an example for loading across Jim, Mark, and Dennis. All are scheduled for 2 hours on 12-26.
Alternate Workcenters Production Scheduling
The above example illustrates some of these additional rules such as: variable setup and runtime per employee, trigger amounts when certain workcenters can be utilized, even sequential alternates for finishing a job on 2nd shift.
Combining Level Loading with Finite Capacity Scheduling
Level loading distributes the work evenly across resources (departments, workcenters, people, machines, groups, etc) resulting in a more balanced schedule. Without Level Loading some resources are over scheduled, causing needless production overtime, expedited shipping costs and missed promise dates. Other resources are underutilized yet are still a financial burden.
Level Loading for Best Practices Production Scheduling
Finite capacity extends the benefits. Not only is there level loading, but also there is no over scheduling of what is available per day. This produces the best schedule as the finish dates are all viable with minimal or no overtime. For example, if I have 10 hours per day available per worker, 3 workers and 5 jobs to finish, with each job will taking 10 hours, there is 50 total hours of work to do. Without level loading and finite capacity planning, it might get scheduled for one worker for 8 hours per day, taking 6+ days to complete all jobs, due to a host of factors. For example, the other workers might be assigned to stand by status for another job that is running late.