SUPPLY CHAIN OPTIMIZATION JOURNAL
   

 

Tuesday, March 09, 2010

When can I have it? A not so simple question.


Jake works in customer service, and the phone rings… It has been a long day already, but he is happy when the phone rings, so he says:

"Hello, this is Jake at Western Chemical Resupply. How can I help you?"

"Hello, Jake, this is Paul, I need to order some pool supplies for my pool business." says the voice on the other end of the line.

This is great, no problem. After getting Paul's customer information, he asks:

"So I typically order 150 units of the new chlorine product to start the season, and I am opening my store in a few weeks. Do you have any in stock?"

"Certainly we have 100 units in stock today, and are getting steady re-supply shipments from the manufacturer all the time," Jake says.

So many people have already begun ordering that new product, it looks like it is going to be selling well this season, Jake thinks. Jake begins a new order for the new chlorine product, typing into the order system the SKU and the 150 units, and next comes the date field. When does Paul want it? Jake asks Paul when he would like to have it shipped, and Paul answers with that dreaded question… "When can I have it?"

Yes, we all know it sounds so simple and innocent… a simple request, like "Are you free Friday for lunch?" or "When will your car be out of the shop?" but the plain fact is answering that question can be fraught with difficulty and implications. Difficulty since the state of Jakes information systems do not currently serve this up to him in a friendly way, and there can be implications, since the company policy is to stick to their commitments; once Jake makes a promise on the ship date, he may not change it without the customer's consent: often difficult to get. Jake has already made many commitments for this product, and each new one he makes adds to the importance of not getting this wrong. A wrong answer could mean calling a lot of unhappy customers to re-schedule their ship dates.

In order to be able to answer it properly, Jake needs to know several pieces of information, all of which are in his order system. He needs to know the re-supply schedule over the next several weeks, as far out as the re-supply lead time. He needs to know the open orders that are on the books today, and for which he has already given firm ship dates, that may not slide with out causing him great pain. That's all he needs in theory. But in practice, he needs to see this information combined in such a way to make him be able to give Paul a good answer.

So Jake opens the daily inventory chart for this SKU in the order system. The daily order chart combines the on-hand inventory with the incoming supply, and then subtracts the orders, each day to produce the daily inventory chart, like the one shown below. Jake can see the numbers too, but he is a visual kind of guy, and relates better to the graph.


But as Jake looks at this chart, he struggles with which date to choose to be able to commit to Paul for the 150 units he needs. He can see that there will be enough in inventory on or about Jan 9, then after that there is a spike in inventory around the 18th of Jan. Surely that should work? But what Jake doesn't see is the amount that he can actually promise. He doesn't see it because most tools do not show it. Most tools do not calculate it. Or if they do, it is kept from the user to be able to make good promises while they are on the phone. What Jake needs to see is a inventory graph like the one below, when it is plainly clear when and for what amounts commitments can be made without disturbing the other orders that have already been committed.


If Jake had this chart, he would be able to see in a glance when Paul could have his 150 units. 150 units will be available to promise ("ATP") on Jan 27th. In fact, Jake could suggest shipping as much as 115 units on Jan 10th and the balance on Jan 27th. Paul likes this idea, since it means he can start selling it faster, and accepts Jakes idea. Jake enters the orders for 115 on the 10th and 35 units on the 27th. Paul likes getting some fast, but getting the commitment to get it all by the 27th. Jake likes being able to make the shipping commitment without having to reschedule all the other open orders. Once he enters the order, he refreshes his inventory chart for this SKU just to see what it looks like now. Ok, he thinks, that means no orders for the new chlorine product until the end of the month, at the earliest. Good to know.


Calculating the amount available to promise is not rocket science. Guessing at the amount available to promise is a recipe for a headache.

Profit Point delights in presenting useful information to the people who need it to make their work lives better. ATP is just one of our strong points. Contact us today to see how we can help you be able to answer some of those seemingly simple questions with ease.

This article was written by Jim Piermarini, Profit Point's CEO and CTO.
To learn more about our scheduling optimization services, contact us here.

Labels: , , , , ,


 

 

Friday, June 05, 2009

Understanding Your Risks with Monte Carlos

What is a Monte Carlo model and what good is it? We’re not talking a type of car produced by General Motors under the Chevy nameplate. “Monte Carlo” is the name of a type of mathematical computer model. A Monte Carlo is merely a tool for figuring out how risky some particular situation is. It is a method to answer a question like: “what are the odds that such-and-such event will happen”. Now a good statistician can calculate an answer to this kind of question when the circumstances are simple or if the system that you’re dealing with doesn’t have a lot of forces that work together to give the final result. But when you’re faced with a complicated situation that has several processes that interact with each other, and where luck or chance determines the outcome of each, then calculating the odds for how the whole system behaves can be a very difficult task.

Let’s just get some jargon out of the way. To be a little more technical, any process which has a range of possible outcomes and where luck is what ultimately determines the actual result is called “stochastic”, “random” or “probabilistic”. Flipping a coin or rolling dice are simple examples. And a “stochastic system” would be two or more of these probabilistic events that interact.

Imagine that the system you’re interested in is a chemical or pharmaceutical plant where to produce one batch of material requires a mixing and a drying step. Suppose there are 3 mixers and 5 dryers that function completely independent of one another; the department uses a ‘pool concept’ where any batch can use any available mixer and any available dryer. However, since there is not enough room in the area, if a batch completes mixing but there is no dryer available, then the material must sit in the mixer and wait. Thus the mixer can’t be used for any other production. Finally, there are 20 different materials that are produced in this department, and each of them can have a different average mixing and drying time.

Now assume that the graph of the process times for each of the 8 machines looks somewhat like what’s called a ‘bell-shaped curve’. This graph, with it’s highest point (at the average) right in the middle and the left and right sides are mirror images of each other, is known as a Normal Distribution. But because of the nature of the technology and the machines having different ages, the “bells” aren’t really centered; their average values are pulled to the left or right so the bell is actually a little skewed to one side or the other. (Therefore, these process times are really not Normally distributed.)

If you’re trying to analyze this department, the fact that the equipment is treated as a pooled resource means it’s not a straightforward calculation to determine the average length of time required to mix and dry one batch of a certain product. And complicating the effort would be the fact that the answer depends on how many other batches are then in the department and what products they are. If you’re trying to modify the configuration of the department, maybe make changes to the scheduling policies or procedures, or add/change the material handling equipment that moves supplies to and from this department, a Monte Carlo model would be the best approach to performing the analysis.

In a Monte Carlo simulation of this manufacturing operation, the model would have a clock and a ‘to-do’ list of the next events that would occur as batches are processed through the unit. The first events to go onto this list would be requests to start a batch, i.e. the paperwork that directs or initiates production. The order and timing for the appearance of these batches at the department’s front-door could either be random or might be a pre-defined production schedule that is an input to the model.

The model “knows” the rules of how material is processed from a command to produce through the various steps in manufacturing and it keeps track of the status (empty and available, busy mixing/drying, possibly blocked from emptying a finished batch, etc.) of all the equipment. And the program also follows the progress and location of each batch. The model has a simulated clock, which keeps moving ahead and as it does, batches move through the equipment according to the policies and logic that it’s been given. Each batch moves from the initial request stage to being mixed, dried and then out the back-door. At any given point in simulated time, if there is no equipment available for the next step, then the batch waits (and if it has just completed mixing it might prevent another batch from being started).

What sets a Monte Carlo model apart however is that when the program needs to make a decision or perform an action where the outcome is a matter of chance, it has the ability to essentially roll a pair of dice (or flip a coin, or “choose straws”) in order to determine the specific outcome. In fact, since rolling dice means that each number has an equal chance of “coming up”, a Monte Carlo model actually contains equations known as “probability distributions”, which will pick a result where certain outcomes have more or less likelihood of occurrence. It’s through the use of these distributions, that we can accurately reflect those skewed non-Normal process times of the equipment in the manufacturing department.

The really cool thing about these distributions is that if the Monte Carlo uses the same distribution repeatedly, it might get a different result each time simply due to the random nature of the process. Suppose that the graph below represents the range of values for the process time of material XYZ (one of the 20 products) in one of the mixers. Notice how the middle of the ‘bell’ is off-center to the right (it’s skewed to the right).


So if the model makes several repeated calls to the probability distribution equation for this graph, sometimes the result will be the 2.0-2.5 hrs, other times 3.5-4.0 hrs, and on some occasions >4hrs. But in the long run, over many repetitions of this distribution, the proportion of times for each of the time bands will be the values that are in the graph (5%, 10%, 15%, 20%, etc.) and were used to define the equation.

So to come back to the manufacturing simulation, as the model moves batches through production, when it needs to determine how much time will be required for a particular mixer or dryer, it runs the appropriate probability equation and gets back a certain process time. In the computer’s memory, the batch will continue to occupy the machine (and the machine’s status will be busy) until the simulation clock gets to the correct time when the process duration has completed. Then the model will check the next step required for the batch and it will move it to the proper equipment (if there is one available) or out of the department all together.

In this way then, the model would continue to process batches until it either ran out of batches in the production schedule that was an input, or until the simulation clock reached some pre-set stopping point. During the course of one run, the computer would have been monitoring the process and recording in memory whatever statistics were relevant to the goal of the analysis. For example, the model might have kept track of the amount of time that certain equipment was blocked from emptying XYZ to the next step. Or if the aim of the project was to calculate the average length of time to produce a batch, the model would have been following the overall duration of each batch from start to finish in the simulated department.

The results from just one run of the Monte Carlo model however are not sufficient to be used as a basis for any decisions. The reason for this is the fact that this is a stochastic system where chance determines the outcome. We can’t really rely on just one set of results, because just through the “luck of the draw” the process times that were picked by those probability distribution equations might have been generally on the high or low side. So the model is run repeatedly some pre-set number of repetitions, say 100 or 500, and results of each of these is saved.

Once all of the Monte Carlo simulations have been accumulated, it’s possible to make certain conclusions. For example, it might turn out that the overall process time through the department was 10 hrs or more on 8% of the times. Or the average length of blocked time, when batches are prevented from moving to the next stage because there was no available equipment, was 12 hrs; or that the amount of blocked time was 15hrs or more on 15% of the simulations.

With information like this, a decision maker would be able to weigh the advantages of adding/changing specific items of equipment as well as modifications to the department’s policies, procedures, or even computer systems. In a larger more complicated system, a Monte Carlo model such as the one outlined here, could help to decrease the overall plant throughput time significantly. At some pharmaceutical plants for instance, where raw materials can be extremely high valued, decreasing the overall throughput time by 30% to 40% would represent a large and very real savings in the value of the work in process inventory.

Hopefully, this discussion has helped to clarify just what a Monte Carlo model is, and how it is built. This kind of model accounts for the fundamental variability that is present is almost all decision making. It does not eliminate risk or prevent a worst-case scenario from actually occurring. Nor does it guarantee a best-case outcome either. But it does give the business manager added insight into what can go wrong or right and the best ways to handle the inherent variability of a process.

This article was written by John Hughes, Profit Point's Production Scheduling Practice Leader.

To learn more about our supply chain optimization services, contact us here.

Labels: , , , , , , ,


 

 

Friday, March 06, 2009

Rohm and Haas Picks Profit Point to Improve Production Scheduling

Profit Point's data integration and scheduling optimization services deliver reliable results with reduced operations costs.


North Brookfield, MA

Profit Point today announced that its Profit Data InterfaceTM software has been selected by Rohm and Haas Company (NYSE: ROH) to integrate its scheduling processes with the company's ERP data warehouse. The company, which last reported nearly $9 billion in annual sales, produces innovative products for nine industries worldwide through a network of more than 100 manufacturing, technical research and customer service sites. Optimizing and supporting the production and distribution scheduling across this network is a complex and ever-changing process.

"Rohm and Haas has a history of improving our operations to enhance customer service levels and reduce cost," said Dave Shaw, the company's Business Process Manager for MFG and Supply Chain. "Production scheduling, which entails constant change to meet demand, is one of the toughest challenges in the supply chain. In the past, the lack of a reliable data interface has limited our ability to react quickly and with a high degree of confidence in our results. Profit Point's Data Interface software has given us near real-time access to highly reliable data, so we can respond quickly and know that our plan is right."

Profit Data Interface is a robust application that helps decision makers boost the effectiveness of their ERP data by extending its usefulness with optimization applications. By leveraging existing ERP systems, the software provides a robust and proven method that supply chain managers can rely upon to optimize their critical business processes and improve profitability.

"Rohm and Haas is a recognized leader in the chemicals industry with a reputation for supply chain excellence," said Jim Piermarini, Profit Point's CEO. "We have supported their scheduling processes for years. So, it was clear that the next evolution was to directly connect their optimization software to the date store using our Data Interface product."

Profit Data Interface, which integrates with SAP® and Oracle® data stores, can be used to optimize the entire supply chain including network planning, production and inventory planning, distribution scheduling, sales planning and vehicle routing.

To learn more about Profit Point's supply chain software and services, visit www.profitpt.com.

About Profit Point:
Profit Point Inc. was founded in 1995 and is now a global leader in supply chain optimization. The company's team of supply chain consultants includes industry leaders in the fields infrastructure planning, green operations, supply chain planning, distribution, scheduling, transportation, warehouse improvement and business optimization. Profit Point's has combined software and service solutions that have been successfully applied across a breadth of industries and by a diverse set of companies, including General Electric, Dole Foods, Logitech and Toyota.

About Rohm and Haas Company:
Leading the way since 1909, Rohm and Haas is a global pioneer in the creation and development of innovative technologies and solutions for the specialty materials industry. The company’s technologies are found in a wide range of industries including: Building and Construction, Electronics and Electronic Devices, Household Goods and Personal Care, Packaging and Paper, Transportation, Pharmaceutical and Medical, Water, Food and Food Related, and Industrial Process. Innovative Rohm and Haas technologies and solutions help to improve life every day, around the world. Visit www.rohmhaas.com for more information.

Contact:
Richard Guy
Profit Point
(866) 347-1130
http://www.profitpt.com

Labels: , , , , , ,


 

 

Tuesday, October 07, 2008

Profit Point Improves Toyota's North American Part Center California's Supply Chain Processes

Leveraging Profit Point's supply chain optimization methodologies, Toyota North American Part Center California improves efficiency and quality of their workload planning sequencing process to receive containers from Japan.

North Brookfield, MA (PRWEB) October 6, 2008

Profit Point today announced that Toyota Motor Sales (TMS), U.S.A., Inc.'s North American Part Center California (NAPCC) has improved its receiving sequencing processes using advanced mathematical optimization techniques. NAPCC is one of the parts distribution centers among TMS' North American Parts Operations network, which was established to improve local parts sourcing and manage a parts distribution network that supplies all North American Toyota distributors, U.S. Toyota, Lexus and Scion dealers as well as export to parts centers in Japan. NAPCC turned to Profit Point to apply mathematical optimization techniques to further improve their supply chain operations.

"We turned to Profit Point to apply mathematical optimization techniques to further improve our supply chain operations," Johnnie Garlington, NAPCCs warehouse operations manager. The program supported the increase in daily offload by 16% resulting in labor savings, off-site storage costs and detention expenses.

Profit Point, the leading supply chain optimization company, combines proprietary software with proven optimization techniques to help business managers improve their operations. Profit Point supported NAPCC's objective to redesign their workload planning process to improve the efficiency and quality of their sequencing processes. Profit Point carried this out by designing and building custom supply chain software to optimize their sequencing processes.

"We were asked to investigate a mathematical approach to solving Toyota NAPCC's container receiving sequencing process," said Joe Litko, Profit Point's Business Optimization Practice Leader. "This was an interesting challenge for several reasons. We needed a cost-effective solution using legacy tools, the model needed to run quickly, be flexible, and give robust solutions that consider several performance measures simultaneously."

NAPCC had been using a traditional spreadsheet to manually achieve an hourly workload plan. Profit Point reviewed the sequencing process and designed a stand-alone application to smooth out the flow of containers to maximize the daily unload capacity.

"Like most businesses, Toyota NAPCC was using good, traditional operations practices," said Dr. Alan Kosansky, Profit Point's President. "But, by combining the right mathematical optimization methods with a clear understanding of the business requirements, we were able to achieve a superior supply chain process for Toyota."

To learn more about Profit Point's supply chain optimization software and services, visit www.profitpt.com.

About Profit Point:

Profit Point Inc. was founded in 1995 and is now a global leader in supply chain optimization. The company's team of supply chain consultants includes industry leaders in the fields infrastructure planning, green operations, supply chain planning, distribution, scheduling, transportation, warehouse improvement and business optimization. Profit Point's has combined software and service solutions that have been successfully applied across a breadth of industries and by a diverse set of companies, including The Coca-Cola Company, General Electric, Rohm and Haas and Toyota.

Contact:
Richard Guy
Profit Point
(866) 347-1130
http://www.profitpt.com

Labels: , , , ,


 

 

Friday, January 19, 2007

Scheduling Process Assessment

There are many approaches to production scheduling, each relying on different business process and/or technology solutions. Manufacturers have a key decision to make at each of their production facilities: How much information technology is needed to support the scheduling process, and how could the manufacturing process be simplified to reduce the information technology requirements?

Profit Point uses a structured decision process to help determine the appropriate level of technology to support scheduling in each manufacturing environment. This assessment process considers the following factors:

-> Material flow through the stages of the manufacturing process (product routing), including alternate routings, manufacturing options, and bill of materials
-> Storage asset utilization
-> Impact of make- to-order and make-to-stock policies on production
-> Manufacturing bottlenecks and their locations (single or multiple)
->Cost of de-bottlenecking the operation
-> Information requirements to support the scheduling process
-> Information sources and bottlenecks, including refreshing of data elements
-> Scheduler (user) experience and analytic capabilities
-> Business rules for customer responsiveness and manufacturing flexibility
-> Cost of information technology solutions and their support
-> Cost of manufacturing simplification

A one day hands-on Scheduling Process Assessment incorporates the needs of the following stakeholders
-> Plant Scheduling Management
-> Plant manufacturing operations
-> Business owner (e.g. product manager)
-> Information Technology support staff

The Assessment process culminates with a specific recommendation for the most cost effective approach to support and sustain the scheduling requirements.

Labels: ,


 

 

Thursday, November 17, 2005

Profit Point gets win with Rohm and Haas

Profit Point was selected by Rohm and Haas Company to provide multiple consulting and support services using AspenTech's Supply Chain Management (SCM) (formerly Aspen MIMI) supply chain modeling software. Aspen SCM is used to power numerous supply chain applications. These applications can include industry optimization solvers like Xpress-MP by Dash Optimization or CPLEX by ILOG, Inc.

Profit Point has worked with Rohm and Haas to design support coverage that was flexible but also responsive to their requirements. The services included end-user support and enhancement work to all Aspen SCM based supply chain scheduling applications. Profit Point provides support service that includes the repair and debug of model problems as they arise, support of the various production and operational processes that feed data to and from the models and minor enhancements to the models. Profit Point's Aspen SCM support service allowed Rohm and Haas's business units to continue providing excellent customer service by delivering quality products with minimal scheduling interruptions.

In addition, Rohm and Haas selected and engaged Profit Point Inc to improve, design and develop several scheduling models to manage Rohm and Haas's production scheduling process for the plastics additives and coatings production, which includes 100+ products, 1,000+ SKUs, and 30+ production facilities. Profit Point worked with Rohm and Haas to identify ongoing requirements for production scheduling and has designed, created and delivered over 30+ plant and process specific scheduling tools to allow Rohm and Haas to achieve their strategic goals to improve production scheduling, lower operating costs and provide better service to their customers.

In addition, Profit Point provides similar services to Bridgestone Firestone North America and Sealed Air Corporation. The services have included:
  • Upgrades
  • Model Enhancements
  • Model Application Design And Development
  • Model And SAP APO (Or Other) Application Integration
  • Technical Support and Training
  • Help Desk Break/Fix Support

To learn more about how Profit Point can help improve and support your scheduling processes, contact us here:

(866) 347-1130 or
(435) 487-9141

Send us an Email

Labels: , , ,


 

 

Topics

Twitter

Follow us on Twitter

Newsletter

Sign-up for our free Optimization Newsletter
Email:  
For Email Marketing you can trust

Recent Posts

Archives

Journal Feed

Subscribe to my feed

Subscribe to SC Optimization Journal by Email

 

 

 

© 1995-2009 Profit Point

 

Contact Us
Toll-free: 866.347.1130
International: 435.487.9141
Fax: 856.722.6790

Mailing Address:
P.O. Box 239
North Brookfield, MA 01535

 

 

Supply Chain Design Software

Territory Planning and Vehicle Routing Software

Transportation and Vehicle Routing Software

Distribution Scheduling Software

Meeting and Event Scheduling Software

Green Supply Chain Network

Supply Chain Network Design

SC Planning

Scheduling

Green Supply Chains

Supply Chain Optimization

Transportation and Vehicle Routing

Transportation Procurement and Carrier Bid Optimization

Process Manufacturing Improvement

Sustainable Supply Chains

Transportation and Routing

Supply Chain Assessments

Solver Optimization

Aspen SCM Support

Software Development

Supply Chain Consultants

Our Partners

Clients

Client Testimonials

Our History

Supply Chain Journal

Press Releases

Supply Chain Management

Manufacturing

Transportation

Distribution

Finance

Other
Chemicals

Manufacturing

Pharmaceuticals

Transportation and Logistics

Food and Beverage

Financial Services

Metals and Mining

Energy

Pulp and Paper

Trade Organizations
Linear Programming

Simulation

Mixed-Integer Programming

Non-Linear Programming

Genetic Algorithms

Constraint Programming

Simulated Annealing

Neural Networks

Excel Solver

 

1995-2008 Profit Point Inc. P.O. Box 239 North Brookfield, MA 01535

TOLL-FREE: 866.347.1130 MAIN: 435.487.9141 FAX: 856.722.6790

Website Design and Search Engine Optimization by Aquo Interactive