SUPPLY CHAIN OPTIMIZATION JOURNAL
   

 

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: , , , , , , ,


 

 

Thursday, March 19, 2009

Why Profit Point can provide good value with fixed price projects

Uncertainty can be a tremendous challenge when it comes to managing a project. How much will a project cost? How long will it take to complete it? As a client, wouldn't you like to know exactly what a project will cost and when it will be completed to be able to determine whether a project will achieve what you intend with a satisfactory return before you commit to it?

For most of our projects, we work with our clients to develop a project scope and commit to delivering that scope at a fixed price with a fixed timeline. Our customers appreciate this approach because it gives them a good understanding of what the project will entail and they know the cost up front. Our approach takes time and effort before the project starts but in the end our clients and Profit Point benefit.

How does this happen?

We rigorously develop a scope to the point that we are comfortable in understanding what the client wants and the client is comfortable with what we will deliver. The scope is detailed enough such that we are both confident of a successful project but not so detailed that we can't change course somewhat as the project enfolds. Our customers appreciate our collaborative approach and being flexible when assumptions that we were made up front don't pan out exactly the way we both expected.

Then we very carefully manage the scope of the project to ensure that the deliverables are met. For minor changes we typically just take care of them without any additional cost to the client. For more major scope changes we will develop a separate scope for them with a separate fixed price.

Our average 20 years experience allows us to operate this way. Our supply chain consultants have been completing successful projects for many years. We know not only the technical details of our consulting practice but how to deliver those technical details that ultimately delivers what the client wants in a way where both the client and Profit Point benefit. How can we do this for you today?

This article was written by Mark Rockey, Profit Point's Production Scheduling Practice Leader.

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

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: , , , , , ,


 

 

Thursday, February 12, 2009

Doing It Better

People ask... What do you do? My response: "We help companies do things better." Specifically we help supply chain and manufacturing executives "do things better". It might be better planning, better scheduling, better processes, or several other areas of better. We receive calls and emails on a daily basis from executives, managers, analysts, and other consultants that want to share their business pain with us. Many want to improve their supply chain operations by reducing costs. Many executives have a fairly good idea of what keeps them up at night, and they want to share their challenges with us to see if we can offer any help. Almost all have an idea on how to make things better, but they are unclear on how to start the process or how to make the magic happen.

Sometimes we cannot help. Many times we can.

We listen. We ask questions. We ask for clarification. Then, we restate the "thing that they want to do better" in our vocabulary to get validation that we understand. They might be searching for software. They might be searching for services. Many times it's a combination of both, but in all cases, people are searching for solutions.

Deliverables can take the form of improved technology with the tools that a company already owns, or with new tools. A good consultant does not promise the big "solve everything button." A good consultant will understand the goal and match results with expectations.

Many times this takes the form of delivering services and software that is customized to individual clients needs. It could take the form of optimizing your supply chain. It's not reinventing the wheel. It's inflating the tire to the correct air pressure depending on the road conditions. When the economy get's rocky, you might need better tires. So, when your problems become challenging, maybe it's time to get a better approach.

So what do supply chain consultant's offer? They help supply chain and manufacturing executives do things better.

If you would like to learn more about our Optimization services, please contact us. And if you would like to receive future updates on the supply chain optimization industry, subscribe to our SCO Journal and our SCO Newsletter.

Contributed by Richard Guy, Profit Point's Director of Sales

Labels: ,


 

 

Wednesday, January 28, 2009

Where is Optimization Technology Headed in 2009?

By Dr. Alan Kosansky, President of Profit Point

There is certainly a lot of change in the business optimization world today. From the significant changes at optimization software companies, to the growing areas of business optimization implementation, the world of optimization is a fast changing and exciting place.

In 2008, two of the leading software providers of mathematical optimization engines - both Profit Point partners - were acquired by much larger companies: ILOG, and their CPLEX optimization software, was acquired by IBM. Dash Optimization, and their XPRESS optimization software, was acquired by Fair Isaac. In addition, 2008 saw the launch of a new significant player into the market: Gurobi Optimization, with a management team that was involved with the initial launch of CPLEX.

Each of these players has the potential to lead the market over the long term, yet each presents their own uncertainty looking forward. How optimization technology fits into the long term strategies of acquiring companies IBM and Fair Isaac is the topic of much speculation. How quickly Gurobi is able to release competitive products and how well they are able to compete for customers is the topic of much anticipation. We will be keeping a close eye on these situations as they unfold, and will be back to share with you our insights in the future.

From the business and application perspective, business optimization and the software applications that act as enablers for better business decision making continues to explode in the marketplace. Leveraging the fact that more and more data is available to businesses and the key decision makers in their organization, those companies that are incorporating advanced decision technologies are realizing significant competitive advantages.

We have had recent success with a number of these industry leaders. They include a retailer using optimization to determine how best to manage their backlog of orders and fulfill customer needs, a production equipment leasing company managing the a delivery of capital intensive assets to maximize utilization and throughput, and a transportation delivery company minimizing customer wait times and maximizing the satisfaction of their customers' experience.

Each of these success stories were driven by data, elevated by optimization, and guided by thoughtful and forward thinking management. Are you the next success waiting to happen?

If you would like to learn more about our Optimization services, please contact us. And if you would like to receive future updates on the supply chain optimization industry, subscribe to our SCO Journal and our SCO Newsletter.

Labels: , , , , , ,


 

 

Thursday, November 13, 2008

System Dynamics Modeling to Improve Your Supply Chain

Profit Point has recently added another tool for analyzing and managing businesses and supply chains - system dynamics modeling. System dynamics focuses on feedback effects in complex systems. That is what distinguishes it from other simulation and modeling techniques. Feedback means that although X influences Y, it is also true that Y influences X even if this influence is mediated by a string of causal relations.

Here is a typical System Dynamics drawing from Wikipedia. In this diagram there is a flow of individuals from a category called potential adopters into a category called adopters. The rate of adoption is controlled by the 'valve' called 'new adopters'. Many simulation modeling approaches would treat this as a 'one-way street' and attempt to model the system by controlling the valve with some external data in the hope of reproducing behaviors observed in the real system.



The point of System Dynamics is to explicitly include the feedback which causes the observed behavior. The model above could be a portion of a model of product adoption for the pharmaceutical industry. Another classic example is a predator - prey population model. When prey are plentiful, the predator population increases, which reduces the prey, which in turn reduces the predators. The extension of this classic model to a system of a business and its resources is fairly natural.

The System Dynamics approach has also been widely applied in typical supply chain scenarios. The effects of feedback can be studied in the context of inventory management and shipping policies. The figure below is of a classic System Dynamics approach to modeling the supply chain from raw materials production through shipment of the finished goods. Feedback is represented by the directed arrows from upstream processes back to the downstream processes. In many cases these represent control mechanisms meant to keep the system in balance or within limits. Successful feedback usually dampens oscillatory behavior - stock-outs, long supply, or obsolete inventory items, for instance.



System dynamics models are classified as continuous simulation models and are typically built in languages specifically designed for these types of models. They are quite different from the usual simulation models that are based on discrete entities and systems that jump from event to event in time. System dynamics models are based on equations that describe (usually) continuous flows of material, people, money, influence, etc. The models are highly useful as policy analysis tools - revealing the often unintended consequences of business rules. The models can examine periods of years or decades, while including external effects, e.g. the economy, and all the significant interactions within a business and with the outside world.

We look forward to bringing this exciting, powerful, and well-established analysis tool to bear on problems and opportunities of our clients.

This article was written by Joe Litko, Profit Point's Business Optimization Practice Leader.

To learn more about our Business Optimization services, contact us.

Labels: , , ,


 

 

Tuesday, October 21, 2008

What Decision Makers Should Know About Infrastructure Planning

"The structure of your supply chain network
determines 75-80% of your total supply chain costs.
Therefore, it is the biggest opportunity
to reduce those costs."

The opportunity to improve your infrastructure and design your supply chain network only comes along once in a while. But, our supply chain consultants are optimizing supply chain networks every day. So, we've seen the pitfalls and the opportunities that face decision makers when they make critical infrastructure investments.

What else should you know before your begin designing your network? We've compiled a list of the top 10 things that supply chain and manufacturing executives should consider before undertaking any significant infrastructure investments. Complete the the short form below to receive the complete list of things you should know about supply chain planning.

Download a copy of 10 Things to Know About Infrastructure Planning.

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: , , , ,


 

 

Monday, September 29, 2008

Can you be green and profitable?

This month's cover story in the CSCMP's Supply Chain Quarterly magazine feature's an excellent article written by Profit Point's Green Optimization Practice Leader, Ted Schaefer, and the firm's President, Dr. Alan Kosansky.

The article, Can you be green and profitable?, deals with two competing, yet critical issues that face supply chain managers across the globe. As the authors point out, "profitability and sustainability don't have to be mutually exclusive. By considering environmental issues when setting financial objectives for a supply chain network analysis, companies can successfully balance the trade-offs between them."

You can read the complete article here.

If you would like to learn more about our Green Supply Chain Optimization services please contact us.

Labels: , , , , , ,


 

 

Tuesday, January 22, 2008

Congratulations to Profit Point partner Dash Optimization!







Earlier today, Fair Isaac Corporation (NYSE:FIC), the leading provider of analytics and decision management technology, announced that it has acquired U.K.-based Dash Optimization, makers of Xpress-MP, the world's leading software product for decision modeling and optimization. The move augments Fair Isaac's decision management solutions, which automate, improve and connect decisions to enhance business performance.

Read the complete press release here.

The acquisition is considered a strategic move by Fair Isaac that will greatly benefit both Dash and Fair Isaac customers. According to Dash, all of the Dash employees are very excited about this new direction and will continue working as Fair Isaac employees. Fair Isaac views Dash as a key business which it is looking to grow and leverage while making a significant investment in the product suite.

We look forward working with the new combined company and expect that it will provide new resources and opportunities for all Profit Point clients.

Labels: ,


 

 

Friday, December 21, 2007

Smart Software Applications

Look for our new web-based release of Profit Network in spring 2008. Profit Network is a stand-alone optimization planning software package that is used to design better supply chain networks. Profit Network can be used to analyze the placement and location of production facilities, distribution centers and warehouses over a multi-period planning horizon. Profit Network helps firms restructure their supply chains after mergers, periods of rapid growth or in anticipation of geographic or product preference shifts in the market. Savings of 10% of supply chain costs and 25% of supply chain cycle time are typical.

Profit Vehicle Router
(PVR) helps distributors save money by cutting the time needed to develop sales/distribution territories and schedules, as well as reducing delivery miles and the number of sales/delivery vehicles and drivers needed. PVR helps you plan optimal delivery or sales territories, cycle-day territories (what days each site will receive deliveries), and daily routes from a distribution center or office, improving customer service, employee productivity and ultimately increasing profits.

Labels: , , ,


 

 

Wednesday, December 19, 2007

Re-writing the Rules with Optimization




Machinery Link is "Re-writing the Rules" about owning farm equipment. Today, machinery operating and ownership expenses account for nearly 40 percent of a producer's total annual production costs. And the cost of owning agricultural equipment increases each year.

The MachineryLink Innovation Ag Equipment Program provides producers with popular name-brand combines. MachineryLink's fleet of machines allows them to provide their customers with the size, model, and equipment features that best fit their farming operation.

MachineryLink manages transportation, scheduled delivery, maintenance, and parts, supported by professional operations, transportation, logistics, and field service teams. Combines move efficiently and dependably across the country between producers as harvest seasons progress.

Profit Point supports this process with a unique optimization approach for the logistics and delivery of the combines. The solution integrates world-class optimization, with state-of-the-art visualization and mapping software, allowing MachineryLink to rebalance their combine to customer assignments during the season. The system accommodates new customers and weather related delays, both issues that had upset their schedules in the past. Jim Bramlett, VP of Operations says: "This system is great; it allows us to increase our asset utilization, while maintaining excellent customer service." Machinery Link is helping farmers lower their costs, and Profit Point is pleased to help them do it.

Labels: , , ,


 

 

Tuesday, November 15, 2005

Improved Process and Optimization Tool

Business Problem: Dole Food Company, Inc. is a producer and marketer of high-quality fresh fruit, fresh vegetables and fresh-cut flowers, and markets several lines of packaged foods. Dole globally purchases containerboard from several paper companies to manufacture containers to transport and inventory their products.

Dole uses an MS Excel spreadsheet to optimize the variables and constraints to develop an annual strategic purchasing plan and on-going monthly tactical purchase plans for the year to minimize the total costs of buying paper products.

Dole had a desire to improve the optimization tool by using Profit Point's supply chain consultants to:
  • Validate the current optimization methodology and algorithms
  • Investigate if there might be a better approach or tool to solve this problem
One of Dole's purchase challenges was developing dynamic monthly plans that were consistent with the annual plan as they move through the year. The terms and conditions offered by the containerboard manufactures include variable costs and constraints that were non-linear. The monthly plan needed to consider these conditions to produce a purchasing plan that provided Dole an optimal cost minimization solution as they reach year-end.

Profit Point's Solution: Validation: Profit Point reviewed Dole's data inputs, assumptions, optimization process and validated that the current spreadsheet model was operating correctly and that the spreadsheet was providing Dole an optimal answer. A few modifications were made to the model which allowed Dole's purchase managers to quickly update and run the tool, and review the output reports. This provided them the ability to confidently make a purchase decision by using the model output or a variant of the output or change the input and re-run the Optimization Tool.

Improved Process and Tool: Profit Point provided Dole with an improved Containerboard Optimization Tool using Frontline Systems' solvers that gave management the ability to:
  • Dynamically solve the optimization problem on a monthly basis and consider all the contractual terms associated with optimizing annual tonnage purchase levels.
  • Easily develop strategic plans that include multiple prices and programs offered by suppliers.
  • Improve the current optimization performance.
A better model and process created value to Dole by:
  • Reducing management's time to analyze multiple scenarios each month
  • Improving management's confidence in making purchase recommendations
  • Reducing total paper purchase costs through use of better management practices and model resources
And creating the opportunity for Dole to:
  • Decrease paper purchase costs
  • Increase management productivity
  • Provide Dole's container production plants with improved purchase plans

To learn more about how Profit Point can help improve supply chain processes, contact us here:

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

Send us an Email

Labels: , , , ,


 

 

Wednesday, October 20, 2004

Solver Consulting Partner

Solver Consultants

Frontline Systems develops mathematical solvers and optimizers and has customers in over 50 countries. Frontline's flagship product, the Premium Solver Platform, greatly extends the power of the Solver in Microsoft Excel, which Frontline developed for Microsoft. This powerful product offers built-in linear, quadratic, conic, nonlinear, interval global and evolutionary Solvers.

Profit Point is Frontline Systems' consulting partner. Profit Point can quickly assist Microsoft Excel users with their modeling needs and projects, reducing model development and programming effort and time. Profit Point's consultants can assist with development of models "from scratch", or help companies that are starting a project that requires more in-depth technical consulting support.

Frontline's Solver technology spans the full range of linear and nonlinear, convex and non-convex, discrete and continuous optimization. The Premium Solver Platform offers the world's best platform for convex optimization - the natural extension of linear programming - and the world's best platform for global optimization.

For more capacity and speed, users can choose from eight plug-in large scale Solver Engines that offer a range from traditional linear, quadratic and mixed-integer programming to powerful convex and conic optimization, nonlinear optimization, global optimization, and optimization of arbitrary Excel models using genetic algorithms, tabu search and scatter search.

To learn more about how Profit Point can help you get the most out of Solver, contact us here:

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

Send us an Email

Labels: , , ,


 

 

Carlisle SynTec's Infrastructure Planning Study

Carlisle Supply Chain Optimization
The construction materials division of Carlisle Companies wanted to evaluate their longstanding practice of co-locating their major warehouses next to their manufacturing operations. Carlisle was looking to reduce their transportation and warehousing costs and questioned if there was a particular set of new warehouse locations that would result in a more desirable distribution network resulting in lower costs and better customer service.

Profit Point developed an optimization model to trade off transportation and warehousing costs while meeting product demand. The model included the top 100 distribution locations in the US along with Carlisle's existing warehouse sites as potential locations for the model to consider.

Profit Point was able to identify achievable annual savings of $1 million by showing them how to use their existing network more efficiently and by adding one new warehouse location next to the new manufacturing plant being built. The model showed that Carlisle's existing warehouses were located in desirable areas regarding operating cost and proximity to vendor, manufacturing and customer locations, but also identified business changes to the way Carlisle manages their inventory at several warehouses, allowing them to realize larger savings. The study also confirmed which new manufacturing plant location out of several candidates was the most cost efficient in regards to transportation costs.

"Profit Point did not come to Carlisle with a pre-determined answer to our logistics issues. They did an excellent job of listening to our needs, working with our personnel to extract the necessary information, and formulating recommendations to reduce our costs." said Bob Stout, Vice President in charge of Purchasing and Logistics at Carlisle SynTec Inc.

To learn more about how Profit Point can help you get the most out of your Supply Chain Infrastructure Planning, call us at (866) 347-1130 or send us an email.

Labels: , , , , , , ,


 

 

Saturday, April 03, 2004

Profit Point selected as ILOG Service Alliance Partner

ILOG has selected Profit Point Inc. as a preferred ILOG SP Service Provider due to our strong technology expertise and proven ability to integrate software components into custom solutions.
ILOG products are used by tens of thousands of end users in telecommunications, manufacturing, transportation, defense, and other industries.

Labels: , , ,


 

 

Thursday, April 01, 2004

Infrastructure Planning with Profit Network

Profit Network Software
Our Profit Network optimization tool is a stand-alone software package that is used to solve supply chain network design problems. Profit Network can be used to analyze alternative placements of production facilities, distribution centers and warehouses over a multi-period planning horizon. Profit Network helps firms restructure their supply chains after mergers, periods of rapid growth and in anticipation of geographic or product preference shifts in the market. Savings of 10% of supply chain costs and 25% of supply chain cycle time are typical when implementing results from models such as Profit Network.

Profit Network allows the user to model their existing or proposed supply chain for a geographic area, with its locations, flow limits and costs. Input data include raw material sources and costs, plant locations, plant production rates and costs, warehouse and distribution center locations and costs and customer locations and anticipated demand. You will be able to solve detailed supply chain network design problems in a few moments with optimal results.

Profit Point has both delivered this product to clients and used it on infrastructure planning diagramSupply Chain consulting engagements. This proprietary tool is now available for delivery and use at your company.

To learn more about Profit Network, go to: http://www.profitpt.com/profit_network.asp

To learn more about how Profit Point can help you get the most out of your Supply Chain Infrastructure Planning, call us at (866) 347-1130 or send us an email.

Labels: , , , , , , ,


 

 

Topics

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

 

 

Infrastructure Planning Software

Territory Planning and Vehicle Routing Software

Transportation and Vehicle Routing Software

Distribution Scheduling Software

Meeting and Event Scheduling Software

Green Supply Chain Network

Infrastructure Planning

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