Add Total Delivered Cost Variances to Manage Your Supply Chain
It is often said that you can only improve what you measure. To that end, there has been a lot of progress in performance tracking and activity-based costing over the past 10 years. With the advent of better activity-based costing, leading companies generate monthly manufacturing variance reports at a detailed and actionable level. However, this does not appear to be the case in the supply chains of many of those same companies. At the end of this post, I’ll recommend some specific supply chain metrics to guide your supply chain improvement.
We routinely find that many companies have a very limited understanding of their supply chain costs: what they are, where they come from or why they’re happening. In a typical engagement with a new client, one of the first things we do is develop a picture of their supply chain current state with respect to flows, cost and service. We work with the client to gather all of the available information, which is much too often a very formidable task, until we can assign the cost from each operation that touches a product or intermediate from the time it is a raw material until it is delivered as a final product to the customer.
When the project team first presents the results to management, we invariably hear, “We don’t do that,” or “Those costs must be wrong.” Unfortunately, we sometimes hear, “There is no way we’re losing that much money at that customer.”
Clearly, there are times when the team learns something new and we have to adjust the costs. However, in the majority of cases we walk through the elements of the costs with management and the realization sets in that the numbers are correct and the costs really are that high. Now that we have all seen the true picture of the supply chain we can align on the effort required to improve it.
Supply chain managers, like their manufacturing counterparts, should demand ongoing metrics at the operational level that are actionable if they want to drive improvement in their supply chains. Reports that provide only the total freight spend, total warehouse spend or total person-hours worked in the supply chain vs. the plan don’t contain enough actionable information to drive performance.
I propose the following metrics as a starting point for managing the total delivered cost to the customer base and welcome your feedback on any metrics that I might have missed or that might replace one I’ve suggested.
Total Delivered Cost Supply Chain Metrics, a Start:
- Actual vs. target for shipping containers
- Actual loaded vs. the maximum allowable capacity for the commodity and shipping container combination
- Actual vs planned cost to serve variance reports at the customer/product level of detail with specific variances called out for
- Cost of Goods Sold (COGS)
- Mode exception (shipped by a premium mode of transport vs. the planned mode)
- Sourcing exception (shipped from a different location than the planned source)
- Fill exception (the difference in cost if the shipping container were filled to the maximum allowable capacity)
- Volume variance (total volume shipped vs. the planned volume to allocate fixed costs)
- Mix variance (change in the mix of products shipped vs. the plan and its impact on cost)
- Price variance (change in the price charged by carriers and other logistics service providers vs. the planned price)
With this set of metrics a supply chain manager should be able to quickly understand the reason for any changes in the total delivered cost to each customer, and thus the gross margin. Now that we can measure it, we can manage it.
The Future of Supply Chain Network Design
Most leading companies perform supply chain network design (SCND) analysis to define the structure of their supply chain as well as the key operations that will be performed at each location in the resulting network. The analysis includes suppliers, manufacturing, warehousing, and distribution. In fact, a number of Fortune 100 companies require such analysis before approving capital to add manufacturing or warehousing infrastructure. Those on the cutting edge are also using SCND analysis on a continual basis to understand the true delivered cost to supply each customer as well as the price required from the customer to achieve profitability goals. Advances in network design modelling and optimization have also opened the door to a broader analysis that focuses on the collective supply chains of all competitors in a marketplace and how best to supply the market at the lowest cost and maximum profit.
Twenty-five years ago, the optimization tools to analyze and strategically set one’s supply chain infrastructure were new and untested. Those companies on the cutting edge had the vision to employ this technology to gain competitive advantage. They analyzed the trade-offs among raw material, production, transportation, distribution and inventory costs to understand the most cost effective way to meet their customer demand at higher customer service levels. In today’s world, what was once the domain of a few has become a “best practice” in supply chain management. Most supply chain managers are on the band wagon and perform some sort of optimization based supply chain analysis when considering major capital investment, key strategic initiatives or when their network has grown too large and unwieldy through acquisition and growth. That does not mean that the world has caught up to the thought leaders….rather the thought leaders continue to push the envelope and are using SCND to do more for their organization than they did in the past.
In particular, there are two areas where the best supply chain managers are focusing their attention with regard to SCND: First, they are making SCND an evergreen business process that is fully integrated into all strategic and tactical decisions related to network infrastructure and product sourcing. Second, they are expanding the scope of their supply chain analysis to not only include their own supply chain network, but also to analyze the supply chain dynamics of their major competitors and how the entire market is being served.
Sustained Supply Chain Network Design
In too many cases, SCND analysis is a one-and-done process. The reality is that it’s often difficult to assemble the data required to perform the analysis, but this prevents companies from assessing ongoing risks and opportunities. Through a carefully designed data management process integrated to the right set of tools, leading businesses are putting into place sustainable business processes to continually revisit their supply chain network structure and operations.
Good data is the driver of good supply chain analysis. Many companies struggle with understanding the true activity costs associated with one or more of the following: raw material supply, production, packaging, warehousing, distribution and inventory. When running a significant supply chain analysis and design project it is often the case that the bulk of time and effort is spent on gathering, organizing and validating the input data that drives the analysis. Unfortunately, too often that effort is wasted, as that data is used once and then forgotten. However this need not be the case.
Those implementing best practices have extended data warehouses to include key activity based operations and cost data that is used in their strategic and tactical network optimization. The data is kept evergreen through continual data management processes and is always available for the next what-if scenario. These what-if scenarios might include:
• Short term: How best to tactically respond to unexpected events like strikes, weather disruptions, major capacity losses, etc…?
• Mid-term: How do I evaluate new sales opportunities for large additional volumes and how will these impact my ability to deliver across the supply chain?
• Long Term: How do I evaluate new merger and acquisition opportunities? How do I plan for capacity expansions?
Companies who maintain the proper data and do not have to start from scratch on each new what-if analysiscan use a tried and true process to respond more quickly and more accurately to the opportunities that constantly and continually present themselves.
Extending Supply Chain Network Design to Competitive Markets
If you have used optimization SCND to analyze a portion of your business in the past couple of years, then you are running with the herd. If you have implemented sustainable business process to refresh and maintain the critical data and are able to run supply chain network what-if analysis at a moment’s notice, then you are running at the front of the herd. Those running way out in front are also using SCND analysis to understand the true delivered cost of supplying product to each customer and managing their business profitability accordingly.
Advances in network design modelling, optimization, and game theory have recently opened the door to a broader analysis that focuses on the collective supply chains of all competitors in a marketplace. These tools can be used to which customer/product combinations should be targeted and at what price to maximize profit. There are three key steps to being able to accomplish this.
1. Understand your own Total Delivered Cost to each customer.
Understanding your true total deliver cost to each of your customers enables you to analyze and determine the profit you are earning from each customer. It also partially informs your pricing decisions, especially in competitive situations or when the demand is greater than your ability to supply. Not only does this analysis determine the profitability by customer, it also determines the impact of adding or dropping a customer, thus answering the question, “Even though it’s low margin business, can we afford to lose the volume?”
2. Estimate competitor costs for supplying to a shared set of customers
While pricing information is largely influenced by your own internal costs for producing, delivering and selling to your customers, it is also heavily influenced by the market conditions and at what price your competitors are able and willing to sell their competitive products to the same customers. In order to understand the market dynamics, you need to be able to reasonably estimate your competitor’s costs. For example, if you are in an industry where transportation delivery costs are significant, then regionally located manufacturing will have an impact on price and profitability. Understanding which customers are more profitable for you and which are more costly for your competitors to serve enables you to develop a winning strategy.
3. Use cutting edge optimization technology to model the competitive market
While most businesses are good at determining pricing and identifying profitable customers intuitively and on and ad hoc basis, few have put into place the rigorous business processes and analytics to be able to do it accurately on a routine basis. This requires a deep understanding of your total delivered cost, your supply chain sourcing options, and the flexibility you have on both the cost and revenue side of the equation. It also requires a better understanding of your competitors supply chain, and what they may or may not be able to do, based on their own costs.
Supply chain network design optimization tools have become well integrated into modern business decision making processes at leading edge companies. They are used to rigorously analyze and make the best decision in response to both short-term events such as weather disruptions, spot sales opportunities, capacity outages) and long-term strategy, such as capacity expansion or mergers and acquisitions. These analytical approaches and technologies have recently been extended to enable businesses to analyze not just their own operations, but the sum of multiple supply chains in the competitive market place. It is exciting work and adding additional millions of dollars to bottom line profit each year.
December 1st, 2015 5:11 pm Category: Distribution, Global Supply Chain, Green Network, Inventory Management, Network Design, Optimization, Optimization Software, Scheduling, Solver Optimization, Supply Chain Improvement, Supply Chain Optimization, Supply Chain Planning, Transportation, Vehicle Routing, Warehouse Optimization, by: Gene Ramsay
Profit Point has been helping companies apply mathematical techniques to improve their business decisions for 20 years now, and it is interesting to review some of the advances in technology that have occurred over this time that have most enabled us to help our clients, including:
• The ability for companies to capture, store and access increasingly larger amounts of transaction and anecdotal data that quantify the behavior and motivation of customers, manufacturers, suppliers and other entities
• The improvement in analytical capabilities that help make optimized choices, in such areas as the solving mixed integer optimization problems, and
• The improvement of computing technology, allowing us to perform calculations in a fraction of the time required just a few years ago
A recent post on the Data Science Central website highlights the use of advanced techniques based on these advances by on-line marketplace Amazon, which is generally acknowledged as one of the most tech-savvy companies on the planet. 21 techniques are listed that Amazon uses to improve both their day-to-day operations and planning processes, including supply chain network design, delivery scheduling, sales and inventory forecasting, advertising optimization, revenue / price optimization, fraud detection and many others. For a complete list see the link below:
Like our customer Amazon, Profit Point is committed to using these techniques for the benefit of our clients – we have been concentrating on implementing business improvement for our clients, including optimization in various forms, since our very beginning. Are you, like Amazon, using the best methods to seize the opportunities that are available today?
By now, we’ve all probably heard about the fact that there is a worldwide glut of crude oil.
This is due to many factors of course, including the increased production of oil and natural gas in North America (especially as a result of fracking), as well as the rising proportion that renewable energy sources have come to represent in the overall energy marketplace. And members of the OPEC cartel have made no secret that they are increasing or at least maintaining relatively high production levels so as to drive competitors out of the market and thus maintain their market share. Therefore the supply of petroleum on world markets is high, thus driving down the price.
This oversupply of crude oil in relationship to demand has had a big impact on the supply chain for moving oil from supplier to customer. Over the past decade, there has been a huge increase in the oil supply chain infrastructure. Trading companies have built vast storage facilities in order to insulate themselves from the high prices they experienced in the past. But now with the current glut of petroleum most of this on-shore storage capacity is full, and this has led to an interesting phenomenon. Now, some trading companies are being forced to use their marine transportation assets, i.e. oil tankers and supertankers, as simply floating tank farms. As the spot price of oil has collapsed, it now makes economic sense to simply load the vessels without a definite destination or customer in mind and store the oil at sea.
Such a strategy, of using transportation assets as de facto storage locations is very typical of any commodity type market where the market power of the customer is much stronger relative to the producer. For example, this situation has long been typical in certain commodities that are delivered by rail, where customers simply leave product parked in cars out on a rail siding somewhere until it’s needed.
Of course, over time as normal market forces do their work, the relative bargaining positions of the buyer and seller can shift. In the case of oil, various economic and political forces can quickly move the markets such that leaving tons of oil floating out on the seas in very expensive storage tanks no longer makes economic sense. And when this happens, those vessels will soon be put back to the purpose for which they were truly built.
One of our main activities at Profit Point is to help companies and organizations to plan better, to make informed decisions that lead to improvements such as more efficient use of resources, lower cost, higher profit and reduced risk. Frequently we use computer models to compare the projected results for multiple alternative futures, so that an organization can better understand the impacts and tradeoffs of different decisions. Companies can usually effectively carry out these types of processes and make decisions, since the CEO or Board of the entity is empowered to make these types of decisions, and then direct their implementation.
Infrastructure and resource allocation decisions must be made on a national and international basis as well, and are usually more difficult to achieve than within a company. An example of this today is the on-going controversy in southeastern Asia regarding the use of water from the Mekong River in the countries through which it flows: China, Myanmar, Laos, Thailand, Cambodia and Vietnam.
For a map of the river and region, refer to the link below:
The Mekong River rises in the Himalayan Mountains and flows south into the South China Sea. For millennia the marine ecosystems downstream have developed based on an annual spring surge of water from snow melt upstream. The water flow volume during this annual surge period causes the Tonle Sap River, a Mekong tributary in Cambodia, to reverse flow and absorb some of the extra water, resulting in a large temporary lake. That lake is the spawning ground for much of the fish population in the entire Lower Mekong river basin, which is in turn the main protein source for much of the human population in those areas.
Now China has an ambitious dam construction program underway along the upper Mekong, and other countries (along with their development partners) are planning more dams downstream. Laos, for one, has proposed construction of eleven dams, with an eye towards becoming “The Battery of Asia”.
The challenge here is to find and implement a resource allocation tradeoff that meets multiple objectives, satisfying populations and companies that need clean water, countries that need electricity to promote economic development and fish that need their habitat and life cycle.
Multiple parties have developed measures and models that can help forecast the impact of different infrastructure choices and water release policies on the future Mekong basin. Let’s hope that the governments in Southeast Asia are able to agree on a reasonable path forward, and implement good choices for the future use of the river.
For more information here are a few examples of articles on the Mekong:
July 21st, 2015 2:58 pm Category: Global Supply Chain, Network Design, Operations Research, Optimization, Optimization Software, Profit Network, Publications, Supply Chain Agility, Supply Chain Optimization, Supply Chain Planning, Warehouse Optimization, by: Ted Schaefer
Profit Point’s recent article in Industry Today, “The Future of Supply Chain Network Design,” describes how to fully leverage the new advances in a traditional supply chain optimization process to include not only your internal supply chain, but the supply chains of your competitors, as well.
Supply chain network design optimization tools have become well integrated into modern business decision-making processes at leading edge companies. The tools are used to rigorously analyze and make the best decisions in response to both short-term events such as weather disruptions, spot sales opportunities, utility outages and to longer-term strategy issues, such as capacity expansion or mergers and acquisitions. These analytical approaches and technologies can be game changers. The newest versions of SCND tools have been expanded: businesses can now analyze not just their own operations, but also the sum of multiple supply chains in the competitive marketplace, creating a new way to integrate competitive risk into the design of your supply chain.
Please contact us if you’d like to learn more about new ways to leverage traditional ideas.
We all know the saying, “An apple a day keeps the doctor away.” However, for many of our neighbors, it’s easier said than done. According to some recent surveys, most of you reading this eat about 40% more fresh produce than the segment of the population that is served by our nation’s food banks. In Texas, according to the recently released Feeding America Map the Meal Gap data, 17.6% percent of the overall state population struggled to avoid hunger in 2013, including nearly two million children. Surprisingly, in many cases the problem is not the availability of food -, it is a supply chain problem.
Through a CSCMP friend at the Houston Food Bank, I recently started a project with Feeding Texas, a network of the 21 food banks serving the state, to increase the amount of fresh produce we can deliver per dollar spent. Just like in many private sector companies that have grown in size over time, each Feeding Texas member food bank operates independently. Across the food banks resources are tough to come by and tend to be used in the day-to-day operations to bring in food and get it out the door to clients. Thus, they have not yet adopted many of the current best practices in supply chain management.
Even though there is more fresh produce available than they can use at any given time, many of the key issues that Feeding Texas members face, like
- Lack of transportation capacity to move produce when it is offered
- The high cost of transportation that consumes limited budget funds and restricts the amount of produce that can be obtained
- Purchase of Out-of-State produce when produce is available in Texas
are typical of an organization that haven’t implemented modern network design, supply/demand planning and transportation planning processes.
We are currently collecting data to complete a more extensive review of the total Feeding Texas supply chain to identify opportunities to move more fresh produce at a lower cost. We are also engaging with key industry contacts and donors to help us understand whether we can adopt some of their best practices in the movement of fruits and vegetables. I have to say that I have been very gratified at the number of times I’ve called a supply chain colleague to ask for their help on this project. In almost all cases, the response has been an unhesitating, “What can I do to help?”
I’ll keep posting our updates as we hit new milestones in our project. In the meantime, I would ask you to reach out to the food bank in your neighborhood and ask if your supply chain expertise can be put to good use.
April 22nd, 2015 12:30 pm Category: Global Supply Chain, Network Design, Operations Research, Optimization, Profit Network, Supply Chain Improvement, Supply Chain Optimization, Supply Chain Planning, Supply Chain Software, by: Gene Ramsay
At Profit Point network design analysis, answering such questions as
• how many facilities a business needs,
• how large they should be and where they should be located, and
• how they should change over time, etc.
is one of our specialties. We have performed this type of analysis for a range of companies across multiple industry types and geographical regions, and we have developed our own network design-focused software package to help us do this type of study. (And we teach folks how to use the software as well, so they can answer their own network design questions, if they want to pursue that.)
Our modeling “toolbox”, our Profit Network software, is designed to be flexible and data-driven, so that the user can focus more attention on a key part of the supply chain where the questions must be answered, without having to define more detail than is really desired in other areas to the supply chain.
One of the key elements in many of the models we or our clients construct is the bill of materials. This data specifies the materials that are required to produce goods along the supply chain, be they intermediate materials or finished goods. For instance, if you are making a finished good such as a loaf of bread, the bill of materials would specify the quantities of flour, yeast, salt and other ingredients that would go into a batch.
To get trustworthy results from a model, it must require that the bill of materials (BOM) data be defined, and be used, in deriving the solution. (In some models we have encountered the BOM is just a suggestion, or products can be created from thin air if the BOM data in not defined.)
The BOM logic must also be able to capture the reality of a situation. The BOM may need to vary from one machine to another within the same facility. Or it might need to vary over time – as an example, when agricultural or dairy products are ingredients to a manufacturing process, the ingredients might have different characteristics over the seasons of the year, thus requiring different input quantities over time to produce a consistent, standardized output.
We work closely with our clients to ensure that our software is matched to their needs, and that it gives them the flexibility they need as their businesses change.
November 14th, 2014 9:45 am Category: Global Supply Chain, Green Network, Green Optimization, Network Design, Operations Research, Optimization, Optimization Software, Profit Network, Risk Management, Supply Chain Improvement, Supply Chain Optimization, Supply Chain Planning, Sustainability, by: Gene Ramsay
In developing a supply chain network design there are many criteria to consider – including such factors as the impact of the facility choices on
• Cost of running the system,
• current and future customer service,
• ability to respond to changes in the market, and
• risk of costly intangible events in the future
to name a few.
Frequently we use models to estimate revenues / costs for a given facility footprint, looking at costs of production, transportation, raw materials and other relevant components. We also sometimes constrain the models to ensure that other criteria are addressed – a constraint requiring that DCs be placed so that 80% of demand be within a day’s drive of a facility, for instance, might be a proxy for “good customer service”.
Some intangibles, such as political risk associated with establishing / maintaining a facility in a particular location, are difficult to measure and include in a trade off with model cost estimates. Another intangible of great interest for many companies, and that has been difficult to make tangible, is water risk. Will water be available in the required quantities in the future, and if so, will the cost allow the company to remain competitive? For many industry groups water is the most basic of raw materials involved in production, and it is important to trade off water risk against other concerns.
As I wrote in a previous blog published in this forum,
There are several risks that all companies face, to varying degrees, as global water consumption increases, including
• Physical supply risk: will fresh water always be available in the required quantities for your operations?
• Corporate image risk: your corporate image will likely take a hit if you are called out as a “polluter” or “water waster”
• Governmental interference risk: governmental bodies are becoming increasingly interested in water consumption, and can impose regulations that can be difficult to deal with
• Profit risk: all of the above risks can translate to a deterioration of your bottom line.
The challenge has been: how to quantify such risks so that they can be used to compare network design options.
Recently a post entitled “How Much is Water Worth” on LinkedIn highlighted a website developed by Ecolab that offers users an approach to monetization of water risks. This website allows the user to enter information about their current or potential supply chain footprint – such as locations of facilities and current or planned water consumption – and the website combines this information with internal information about projected GDP growth for the country of interest, the political climate and other factors to calculate a projected risk-adjusted cost of water over the time horizon of interest.
This capability, in conjunction with traditional supply chain modeling methods, gives the planner a tool that can be used to develop a more robust set of information that can be used in decision-making.
For more details visit the website waterriskmonetizer.com
July 17th, 2014 5:04 pm Category: Global Supply Chain, Green Network, Network Design, Optimization Software, Supply Chain Agility, Supply Chain Improvement, Supply Chain Optimization, Sustainability, Transportation, by: Gene Ramsay
Many of our activities at Profit Point are focused on helping clients in identifying and implementing changes that improve the efficiency of existing supply chain networks, ranging from planning to operations and scheduling. In the short term we are usually trying to find ways to use existing capabilities more effectively, but as you look out over longer time horizons supply chains evolve to develop new links, and these must be considered as you plan.
One instance of this evolution was described by my colleague, John Hughes, who recently wrote about the rise of a “New Silk Road”– a rail network stretching through Western China, Kazakhstan, Russia and Belarus to Europe – used for transporting manufactured goods from Asia to meet demand in Europe.
But Asia has a complementary demand that must be met for their manufacturing systems to function, the demand for energy to power their factories and cities. The growing worldwide demand for energy, and for faster routes to market, is opening up another new link in the global trade routes – the Northern Sea Route, a maritime route connecting Pacific ports with Europe via the Arctic.
Lawson Brigham, professor of geography and Arctic policy at the University of Alaska Fairbanks, was recently quoted on the arcticgas.gov website as saying “What’s really driving the Northern Sea Route is global commodity prices and natural resource development, particularly in Russia.”
The northern reaches of the earth are currently hotbeds of energy development, and much of the activity is focused on adding Liquefied Natural Gas (LNG) production capacity. Projects are on-line or in progress stretching from the North Slope in Alaska to the Yamal Peninsula in Siberia to Hammerfest in Norway. The Northern Sea Route offers quicker shipments of many of these supplies to major Asian ports, shaving ten to twenty days off one-way transit times from Russia and Norway to ports in Korea and China, compared to routes through the Suez Canal.
Climate change has made these routes generally ice-free for several months of each year, and thus more cost effective, but ice-strengthened cargo ships, with icebreaker support, are still required to keep the route open in the colder months, thus driving up the costs.
Supply chain planning activities on a global scale will over time need to expand to consider the potential impact of these types of shipping options. Keep an eye out for this and other new links in the global chain as they become available – change is inevitable.
For a more information on this route see articles like these:
April 16th, 2014 10:21 am Category: Global Supply Chain, Network Design, Operations Research, Optimization, Optimization Software, Profit Network, Supply Chain Optimization, Supply Chain Planning, Supply Chain Software, by: Gene Ramsay
Recently I had the opportunity to speak to an operations management class for MBA students in the Goizueta Business School at Emory University. The class is intended to give the students an introduction to a variety of problems that they might encounter during their careers, and to management science techniques that might be applied to them, using Excel as a solution platform. The professor had asked me to address the course topic from the point of view of one who had used these methods in the real world, and I was glad to do so, recounting my work in supply chain network design, hydro power generation scheduling, routing of empty shipping containers, natural gas supply contract management and various other problems.
During Q&A one of the students asked how a company should determine the appropriate source of resources to use for solving these types of problems – should it be in-house expertise or an outside consultant?
As I told him, to me, this depends on a number of factors, and I gave an example, based on our experience: In our practice we perform supply chain network design studies, and we also license the network design software that we use to our clients, if they desire. A number of clients have engaged us to first do an analysis for them, and then they have licensed the software so that they can then perform future projects themselves, using our initial project as a base. Many of these clients have used the software very effectively.
Those that have been most successful at using the software in-house, and at performing management science projects in-house in general, have several common characteristics-
- They are committed to tactical and strategic planning as tools for meeting their business goals,
- They have enough work in this area, and related areas, to keep an analyst or group of analysts busy full time, due to such factors as
- The scale and scope of their operations
- The speed of innovation in their industry
- The level of complexity of their supply chain and variety of products made, and
- Their desire for a “continuous improvement” approach as opposed to a “one-time reorganization” approach
- They have a commitment to maintaining personnel who
- have the proper skills and training to address these problems, and
- are allowed the time to work on these problems, rather than being constantly pulled off for “firefighting” short term or operational problems.
Most companies can make good use of management science solution methods, but, as you think about how to do this, try to make a realistic determination of your internal priorities, so you can decide between insourcing and outsourcing, or a mixture of the two.
When we help our clients improve their supply chains the first step in the process is usually to identify what problem they need to solve, or what questions they are trying to answer. Examples of such questions might be
- What will be the impact of several possible capital investments in our distribution system?
- A major customer is considering changes in their manufacturing – how should we respond?
- How can we improve the assignment of available production / inventory to customer orders?
After pinning down the objectives, the focus will then shift to the design of a planning model, or a software system, that will help them to address the identified needs. We find that a key design tenet for the model, or the scope of the supply chain to be covered, is to include enough detail to be able to answer the questions at hand, but no more.
A typical supply chain will stretch from procurement of raw materials to manufacturing to distribution to customers (and possibly beyond, on either or both ends.) Part of capturing the supply chain behavior will be to define the transformation of materials along the chain. This can be done by defining a bill of materials, or BOM, which defines the quantities of input ingredients that are required at a point in the supply chain to make an output material of interest. For instance, if you are a baker then your BOM is your recipe – e.g. the amounts of flour, buttermilk, leavening and various other ingredients required to make the batch of biscuits.
Deciding on the detail of the materials going into the BOM, and getting the right quantities for the BOM, is a key step in properly modeling the supply chain. If you are working at an operational supply chain level, the BOM will need to be detailed enough to actually make the product, but many times in a planning situation, it is reasonable to omit some of the detail, and only capture the main flows of product through the system. You will need to make these decisions based on your project objective.
For instance, if you are modeling a beverage company’s supply chain, water may be a key ingredient in the production process. If the question you are trying to answer for the beverage company is whether traditional warehouses vs. crossdocks is a better distribution solution for a part of the territory, then you may decide that the sources and cost of water for the production facilities will not have a big impact on the answer, so you can omit the water consumption from the analysis. On the other hand, if the objective of the analysis is to evaluate the impact of alternative future production locations on the company’s overall environmental impact and commitment to sustainable practices, then water for production (and waste water, and other intermediate or byproduct materials) would likely need to be included in the production BOMs.
Making good choices in defining your BOM is one of the important steps in getting a supply chain model to help you answer your questions effectively. Our extensive supply chain experience allows us to bring a large knowledge base to the assignment when we are helping our clients design in enough detail, but no more.
Profit Point, a leading supply chain optimization firm, adds total delivered cost and margin at the customer location-product level of detail to its supply chain network design software.
Profit Point, the leading supply chain optimization consultancy, today announced the release of an update to Profit Network™, a supply chain network design software that is used by supply chain managers all over the world to gain visibility in to the trade-offs they will face when designing or optimizing a global supply chain. In addition to several other new enhancements, Profit Network now allows users to analyze and report on the total delivered cost and the resulting gross profit margin for all products delivered to each customer location.
“With the ever-increasing availability of granular data across the supply chain, many of our clients have expressed a strong interest in analyzing and reporting on the total delivered cost of a single product or set of customer products,” said Alan Kosanksy, Profit Point’s President. “Previously, it was quite a challenge to understand how costs accumulate over time from raw material procurement through manufacturing, inventory, transportation and customer delivery. Now our customers are able to see the true total cost for each unit of product delivered to each customer. This will be a powerful tool in helping them evaluate their product and customer portfolios.”
In addition to total delivered cost, now Profit Network also enables more control over source-destination matching, as well as inventory levels by establishing minimum and maximum number of days of inventory demand.
“Profit Network software has been helping Fortune 500 companies around the world build more robust and profitable supply chains for more than 10 years,” said Jim Piermarini, Profit Point’s CEO and CTO. “Over that time, the dramatic increase in data availability across the supply chain has provided us tremendous opportunities to solve unique and critical problems in a variety of supply chain networks.”
In addition to Profit Network, Profit Point’s line of supply chain software also includes Distribution and Vehicle Planning, Sales and Operations Planning (S&OP), Production Planning, Scheduling and Order Fulfillment software.
About Profit Point
Profit Point Inc. was founded in 1995 and is now the leading supply chain software and consulting company. 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 has combined software and service solutions that have been successfully applied across a breadth of industries and by a diverse set of companies, including Dow Chemical, Coca-Cola, Lifetech, Logitech and Toyota.
Profit Point announced that it has successfully completed a distribution network optimization project with the hydrogen peroxide business team at Arkema Inc. Arkema is a global chemical company and France’s leading chemicals producer. Profit Point is a leading supply chain optimization company, delivering solutions to global manufacturers to optimize their supply chain networks, distribution plans and S&OP processes using a combination of targeted software and consulting services.
In the very competitive hydrogen peroxide market, Arkema’s objective is to continuously improve product availability and customer service across North America, while simultaneously managing costs throughout the supply chain. Profit Point examined Arkema’s distribution options from manufacturing to the end customer to develop supply chain options to provide the right level of customer service at the best total delivered cost.
“The team at Profit Point developed an understanding of our business and they analyzed complicated data and made it easy to understand,” noted Ed Gertz, Arkema’s Director of Supply Chain for hydrogen peroxide. “They made it easier for us to see how different distribution infrastructure options impacted our cost and our service, which gave us the confidence we needed to make significant changes in our terminal network.”
The solution combined Profit Point’s supply chain design software, Profit NetworkTM, and the consulting team’s supply chain optimization expertise. By leveraging existing enterprise data, Arkema was able to develop an actionable infrastructure plan that meets the business’ strategic objectives.
“This is a classic example of the type of benefits large manufacturers can see when they bring together the right stakeholders and the right process, ” added Ted Schaefer, Director of Logistics and Supply Chain Services at Profit Point. “It reminds me a lot of what my Italian grandmother used to say about cooking, ‘If you choose the best ingredients, you will like the result.”
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 has combined software and service solutions that have been successfully applied across a breadth of industries and by a diverse set of companies, including Dow Chemical, Coca-Cola, Lifetech, Logitech and Toyota.
A global chemical company and France’s leading chemicals producer, Arkema is building the future of the chemical industry every day. Deploying a responsible, innovation-based approach, we produce state-of-the-art specialty chemicals that provide customers with practical solutions to such challenges as climate change, access to drinking water, the future of energy, fossil fuel preservation and the need for lighter materials. With operations in more than 40 countries, some 14,000 employees and 10 research centers, Arkema generates annual revenue of $8.3 billion, and holds leadership positions in all its markets with a portfolio of internationally recognized brands.
What kind of risks are you prepared for?
As a supply chain manager, you have profound control over the operations of your business. However, it is not without limits, and mother nature can quickly and capriciously halt even the smoothest operation. Or other man-made events can seemingly conspire to prevent goods from crossing borders, or navigating traffic, or being produced and delivered on time. How can you predict where and when your supply chain may fall prey to unforeseen black swan events?
Prediction is very difficult, especially about the future. (Niels Bohr, Danish physicist) But there are likely some future risks that your stockholders are thinking about that you might be expected to have prepare for. The post event second guessing phrase: “You should have known, or at least prepared for” has been heard in many corporate supply chain offices after recent supply chain breaking cataclysmic events: tsunami, hurricane, earthquake, you name it.
- What will happen to your supply chain if oil reaches $300 / barrel? What lanes will no longer be affordable, or even available?
- What will happen if sea level rises, causing ports to close, highways to flood, and rails lines to disappear?
- What will happen if the cost of a ton of CO2 is set to $50?
- What will happen if another conflict arises in the oil countries?
- What will happen if China’s economy shrinks substantially?
- What will happen if China’s economy really takes off?
- What will happen if China’s economy really slows down?
- What will happen if the US faces a serious drought in the mid-west?
What will happen if… you name it, it is lurking out there to have a potentially dramatic effect on your supply chain.
As a supply chain manager, your shareholders expect you to look at the effect on supply, transportation, manufacturing, and demand. The effect may be felt in scarcity, cost, availability, capacity, government controls, taxes, customer preference, and other factors.
Do you have a model of your supply chain that would allow you to run the what-if scenario to see how your supply chain and your business would fare in the face of these black swan events?
Driving toward a robust and fault tolerant supply chain should be the goal of every supply chain manager. And a way to achieve that is to design it with disruption in mind. Understanding the role (and the cost) of dual sourcing critical components, diversified manufacturing and warehousing, risk mitigating transportation contracting, on-shoring/off-shoring some manufacturing, environmental impacts, and customer preferences, just to begin the list, can be an overwhelming task. Yet, there are tools and processes that can help with this, and if you want to be able to face the difficulties of the future with confidence, do not ignore them. The tools are about supply chain planning and modelling. The processes are about risk management, and robust supply chain design. Profit Point helps companies all over the world address these and other issues to make some of the of the best running supply chains anywhere.
The future is coming, are you ready for it?
Manufacture and delivery of a company’s products usually consume a wide array of materials, either directly or indirectly, ranging from rare commodities like titanium or zinc, to the most basic, such as water. Given the explosive growth of world population in recent history, and the resulting increases in consumption of food and other products, and the finite nature of raw materials, the sustainability of the supply chain over time is a growing planning concern for many companies. Water is often a key focus in their planning, whether it is the main ingredient in their product, as it is in the beverage industry, or a major component, as it is for power generation, paper production, mining and many other industries.
One way to measure the water impact of companies (or countries, or production of industrial or agricultural products, such as textiles, rice or beef) is through the calculation of a “water footprint”, which can help identify what water is used (both directly and indirectly), where it comes from, and the relative efficiency of its use. This concept is discussed in detail on the website www.waterfootprint.org which has a wide array of statistics, as well as an interactive water footprint calculator and the option to download extensive research materials. According to the website 92% of total water consumption in the world is associated with agricultural use. However, since agricultural products are raw materials in many corporate supply chains, and are shipped from one location to another around the world, nations and companies effectively consume water from around the world. The figure below shows major international water consumption flows, taking into account such factors as goods consuming water in production in one part of the world are shipped to a consumer in another area.
Source:Mekonnen and Hoekstra (2011)
Why should a company be concerned about their water consumption? There are several risks that all companies face, to varying degrees, as global water consumption increases, including
- Physical supply risk: will fresh water always be available in the required quantities for your operations?
- Corporate image risk: your corporate image will likely take a hit if you are called out as a “polluter” or “water waster”
- Governmental interference risk: governmental bodies are becoming increasingly interested in water consumption, and can impose regulations that can be difficult to deal with
- Profit risk: all of the above risks can translate to a deterioration of your bottom line.
But with risk comes opportunity – planning for your water consumption, and footprint, as part of your supply chain analysis, and acting in response, can keep you ahead of the curve!
DC Velocity featured an article entitled A Network Design is Never Done. The article, which included an interview with Profit Point’s Alan Kosansky, touches upon on the trend of large manufacturers to move from designing their supply chain networks once to continuously improving the design to meet customer demand and supplier mix, among other things.
You can read the complete article here.
July 30th, 2012 12:56 pm Category: Enterprise Resource Planning, Global Supply Chain, Network Design, Operations Research, Optimization, Profit Network, Profit Vehicle Planner, Profit Vehicle Router, Risk Management, Supply Chain Improvement, by: Jim Piermarini
There is nothing like a bit of vacation to help with perspective.
Recently, I read about the San Diego Big Boom fireworks fiasco — when an elaborate Fourth of July fireworks display was spectacularly ruined after all 7,000 fireworks went off at the same time. If you haven’t seen the video, here is a link.
And I was reading an article in the local newspaper on the recent news on the Higgs: Getting from Cape Cod to Higgs boson read it here:
And I was thinking about how hard it is to know something, really know it. The data collected at CERN when they smash those particle streams together must look a lot like the first video. A ton of activity, all in a short time, and a bunch of noise in that Big Data. Imagine having to look at the fireworks video and then determine the list of all the individual type of fireworks that went up… I guess that is similar to what the folks at CERN have to do to find the single firecracker that is the Higgs boson.
Sometimes we are faced with seemingly overwhelming tasks of finding that needle in the haystack.
In our business, we help companies look among potentially many millions of choices to find the best way of operating their supply chains. Yeah, I know it is not the Higgs boson. But it could be a way to recover from a devastating earthquake and tsunami that disrupted operations literally overnight. It could be the way to restore profitability to an ailing business in a contracting economy. It could be a way to reduce the greenhouse footprint by eliminating unneeded transportation, or decrease water consumption in dry areas. It could be a way to expand in the best way to use assets and capital in the long term. It could be to reduce waste by stocking what the customers want.
These ways of running the business, of running the supply chain, that make a real difference, are made possible by the vast amounts of data being collected by ERP systems all over the world, every day. Big Data like the ‘point-of’sale’ info on each unit that is sold from a retailer. Big Data like actual transportation costs to move a unit from LA to Boston, or from Shanghai to LA. Big Data like the price elasticity of a product, or the number of products that can be in a certain warehouse. These data and many many other data points are being collected every day and can be utilized to improve the operation of the business in nearly real time. In our experience, much of the potential of this vast collection of data is going to waste. The vastness of the Big Data can itself appear to be overwhelming. Too many fireworks at once.
Having the data is only part of the solution. Businesses are adopting systems to organize that data and make it available to their business users in data warehouses and other data cubes. Business users are learning to devour that data with great visualization tools like Tableau and pivot tables. They are looking for the trends or anomalies that will allow them to learn something about their operations. And some businesses adopting more specialized tools to leverage that data into an automated way of looking deeper into the data. Optimization tools like our Profit Network, Profit Planner, or Profit Scheduler can process vast quantities of data to find the best way of configuring or operating the supply chain.
So, while it is not the Higgs boson that we help people find, businesses do rely on us to make sense of a big bang of data and hopefully see some fireworks along the way.
June 22nd, 2012 3:46 pm Category: Distribution, Enterprise Resource Planning, Global Supply Chain, Green Network, Green Optimization, Network Design, Optimization, Supply Chain Agility, Supply Chain Improvement, Supply Chain Planning, Transportation, Vehicle Routing, by: Editor
Supply Chain optimization is a topic of increasing interest today, whether the main intention is to maximize the efficiency of one’s global supply chain system or to pro-actively make it greener. There are many changes that can be made to improve the performance of a supply chain, ranging from where materials are purchased, the types of materials purchased, how those materials get to you, how your products are distributed, and many more. An additional question on the mind of some decision makers is: Can I minimize my environmental footprint and improve my profits at the same time?
Many changes you make to your supply chain could either intentionally – or unintentionally – make it greener, so effectively reducing the carbon footprint of the product or material at the point that it arrives at your receiving bay. Under the right circumstances, if the reduced carbon footprint results from a conscious decision you make and involves a change from ‘the way things were’, then there might be an opportunity to capture some financial value from that decision in the form of Greenhouse Gas (GHG) emission credits, even when these emission reductions occur at a facility other than yours (Scope 3 emissions under the Greenhouse Gas Protocol).
As an example, let’s consider the possible implications of changes in the transportation component of the footprint and decisions that might allow for the creation of additional value in the form of GHG emission credits. In simple terms, credits might be earned if overall fuel usage is reduced by making changes to the trucks or their operation, such as the type of lubricant, wheel width, idling elimination (where it is not mandated), minimizing empty trips, switching from trucks to rail or water transport, using only trucks with pre-defined retrofit packages, using only hybrid trucks for local transportation and insisting on ocean going vessels having certain fuel economy improvement strategies installed. These are just some of the ways fuel can be saved. If, as a result of your decisions or choices made, the total amount of fuel and emissions is reduced, then valuable emission credits could be earned. It is worth noting that capturing those credits is dependent on following mandated requirements and gaining approval for the project.)
If your corporate environmental strategy requires that you retain ownership of these reductions, then you keep the credits created and the value of those credits should be placed on the balance sheet as a Capital Asset. Alternatively, if you are able, the credits can be sold on the open market and the cash realized and placed on the balance sheet. Either way, shareholders will not only get the ‘feel good’ benefit of the environmental improvement, but also the financial benefit from improvement to the balance sheet. If preferred, the credits can be sold to directly offset the purchase price of the material involved, effectively reducing that price and so increasing the margin on the sales price of the end-product and again improving the bottom line. If capital investment is required as part of the supply chain optimization, the credit value can also be a way to shorten the payback period and improve the ROI, or to allow an optimization to occur
So, when you consider improving your environmental impact or optimizing your supply chain, consider the possibility that there might be additional value to unlock if you include both environmental and traditional business variables in your supply chain improvement efforts.
Written by: Peter Chant, President, The FReMCo Corporation Inc.
IDK (“I Don’t Know”)
After listening to a Freakonomics Radio podcast on NPR, the following question and blog comments emerged:
Why do people feel compelled to answer questions that they do not know the answer to?
What I’ve found in business is that we are all prone to hiding our ignorance when asked a question that we cannot answer. So even if someone absolutely has no idea what the answer is, if it’s within his or her realm of expertise, “faking” seems to be an essential part of the response.
My professor friend told me that she has learned the following from teaching MBA students: “One of the most important things you learn as an MBA student is how to pretend you know the answer to any question even though you have absolutely no idea what you’re talking about. It’s really one of the most destructive factors in business. Everyone masquerades like they know the answer and no one will ever admit they don’t know the answer, which makes it almost impossible to discover the correct answer”.
I ask: Does every question need to be answered?
Everyone expects answers to every question, especially if the question comes from someone higher up in an organization. However, not every unknown question is worth the time and resources to research. If it comes down to the choice of making-up an answer or being saddled with a research project, many people will prefer to make-up an answer. Perhaps in some situations, combined with the ego/self-image issues, every question will be answered, regardless of the person’s knowledge.
I ask: Should IDK be a legitimate response?
Perhaps, if the question has minimal economic impact on the business, and you know something related to the question, then maybe a guesstimate (an estimate made without using adequate or complete information) is fine.
But then, for significant economic impact questions …maybe it’s better to say “IDK the answer to that question, but we are studying it”, and then do the study!
As an example, management asks: Will our delivered cost per SKU increase or decrease if we add more distribution centers to meet expected growth rates and satisfy customer service levels?
The first reaction guesstimate might be “yes they will increase”, although, this might not be true.
The smart analyst will say: “Hmmm, IDK! Give me a few hours (days) to do a quick analysis, and see what the true impact will be.”
A small spreadsheet study looking at the increase in production and distribution levels combined with the increase fixed and variable costs associated with adding a few new distribution centers may be surprising. It may indicate that the increase volume and revenues and lower transportation costs will offset the increased DC costs.
This small study may also be the first in a stage gate approach to perform a forward looking comprehensive supply chain infrastructure study. A detailed strategic infrastructure study can capture the manufacturing and distribution details, including costs and constraints, generating results that will allow management to make a reliable strategic economic decision.
No field is exempt from their know-it-alls, even when the correct answer really is IDK.
I submit, if you are in an uncertain position, try the IDK approach and then offer the following response “I can check into that and find an answer for you”. You may be surprised to learn that your credibility with management will improve.
“Every act of conscious learning requires the willingness to suffer an injury to one’s self-esteem. That is why young children, before they are aware of their own self-importance, learn so easily.”