Arkema and Profit Point Optimize the Distribution of Hydrogen Peroxide
April 23rd, 2013 6:00 am Category: Network Design, Press Releases, Supply Chain Software, by: Editor
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.”
To learn more about Profit Point’s supply chain network design software and services, call us at (866) 347-1130 or contact us here.
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.
About Arkema
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.
No Doubt a better process for testing an application
April 13th, 2013 10:53 am Category: About Profit Point, Global Supply Chain, Jim Piermarini, Operations Research, Optimization, Software Optimization, Supply Chain Improvement, Supply Chain Software, by: Jim Piermarini
Building applications, especially custom ones, carries with it the burden of answering the question: Does this do what the customer wants?
With complicated systems with many interacting features and business rules, answering this question can be daunting. In fact, evaluating the answer can be daunting too, from the perspective of the customer. Having the sales guy check some boxes in a questionnaire, or watching a demo just doesn’t leave you with the assurance that the application with handle all the business requirements, from either perspective, the vendors or the customer. Everyone I have spoken to who has sold complex software, or who has participated in the purchasing process of software has expressed the same doubt. They are just not sure that the tool will be a good fit. As we all know, that doubt does not always prevent the purchase of the software, as each organization has its own level of risk tolerance, and trust in the vendor’s brand or reputation. Often these other considerations can outweigh the amorphous doubt that some folks might feel. How can one quantify that doubt? Frankly, it’s a quandary.
This thought got us at Profit Point thinking… Wouldn’t it be great if there was another way to evaluate the goodness of fit or an application, or the appropriateness of the parameter settings, to match the business needs of an organization. Would it be great if there was a way to eliminate (or greatly reduce) the doubt, and replace it with facts. Either a business rule is obeyed or it is not. Either a decision is made according to the requirements, or it is not. Let’s eliminate the doubt, we thought, and the world would be a better place. (well a little bit anyway).
There are many processes for testing an application as it is being developed, with writing test scripts, and evaluating the results. All these are based on testing little pieces of code, to ensure that each function or sub routine does what it should do in each case of input data. These processes work fine in our opinion, but only when the sub of function is able to be considered independently form the others. When the system has functions that interact heavily, then this approach doesn’t reduce the doubt that the functions may conflict or compete in a way that the whole system suffers. How then to evaluate the whole system? Could we treat the entire application as one black box, and evaluate the important business cases, and evaluate the results? This is exactly what we have done, with the effect of reducing the doubt to zero about the suitability of the application for a business.
With several of our clients we have worked out what seems to be a great process of testing a complex software solution for suitability to the business requirement. In this case, the detailed level function testing methods were not open to us, since the solution relied on a Linear Programming technique.
This process is really just an amplification of the standard testing process.
- Define the test case, with the expected results
- Construct the test data
- Build or configure the application
- Run the Test using the Test Data and Evaluate the results – Pass or Fail
This is the standard process for testing small functions, where the expected results are clear and easy to imagine. However, in some systems where there many interacting rules and conflicting priorities, it may not be simple to know what the expected results should be without the help of the tool’s structure to evaluate them. Such is the case with many of our application, with layer upon layer of business rules and competing priorities… The very reason for using an LP based approach makes testing more complex.
In the revised process, we have, for each new business requirement:
- Construct the test case with the test data
- Build or configure the application
- Set the expected results using the results of the first pass build
- Re-factor the code and test until all test are passing
In my next blog I will show you the simple excel based tools we use to facilitate the test evaluation.
In practice, the process works well, new versions of the application go into production without any surprises, and with full confidence of the application management team that all the business requirements are 100% met.
No doubt – no doubt a better process.
By Jim Piermarini
The Future of Supply Chain Management
February 28th, 2013 5:35 pm Category: Alan Kosansky, Optimization, Supply Chain Improvement, by: Editor
Here’s an audio interview with Dr. Alan Kosansky on the “Future of Supply Chain Management”.
TRANSCRIPT:
Interviewer: What’s the future of supply chain management? Many companies have implemented ERP software solutions, but if you’re relying on well-traveled, standardized software to manage your supply chain, you could actually be eroding your competitive edge. Joining us now to explain why is Dr. Alan Kosansky, co-founder and President of Profit Point. Alan, welcome!
Now, Alan—ERP Software has definitely become commonplace as a solution in supply chain management—it’s certainly convenient, but is the software on its own enough?
Kosansky: ERP software plays a critical role in the enterprise. From its inception it has provided the backbone for accounting and financial functions. As it has extended into supply chain functions, it allows us to quantitatively manage the supply chain. All these systems have enabled significant efficiencies for companies over the past 20 years. And they have become commoditized. Leading companies are both leveraging what these ERP have to offer AND ALSO defining complementary supply chain processes that offer competitive advantage. For those supply chain processes for which being as good as the marketplace is enough, out of the box ERP and APS solutions are great. However, for those supply chain processes where your company believes they can create and maintain competitive advantage, using the solutions that the marketplace is using is not enough.
Interviewer: At Profit Point you believe that the future of supply chain management is in optimization based decision making – what is optimization based decision making?
Kosansky: Supply Chain profitability is based on the price you sell your goods minus the total delivered cost of making and getting those products to your customers. While this may seem like simple arithmetic, it is actually very difficult for companies to accurately predict profitability and then make supply chain planning decisions that maximize their profitability. Firstly, Computing the total delivered cost is difficult. Secondly, even those companies that are have a centralized way to view all this data typically have difficulty making the tradeoffs implicit in their supply chain costs: Inventory or customer service? Manufacturing, warehousing or transportation costs? Optimization based decision making allows supply chain planners to both see all the relevant data and make the tradeoffs that lead to maximum profitability.
Interviewer: … and how can optimization based decision making help ‘unlock’ a company’s competitive edge?
Kosansky: Companies that identify supply chain processes where they have developed some sort of competitive advantage need to embody those processes in enabling technology that support this better decision-making. Most often, this includes some form of optimization decision technology that quickly evaluates alternative scenarios and identifies those decisions that lead to maximum profitability. By combining the big data that is available today, with leading edge decision making technologies, leading companies are beating their competitors in every aspect of their operations, including the supply chain.
Interviewer: Well Alan this is great news – thanks for coming on and telling us about it! That was Dr. Alan Kosansky, President of Profit Point. For more information go to ProfitPT.com… that’s ProfitPT.com.
Big Data Vacation Perspective
July 30th, 2012 12:56 pm Category: Enterprise Resource Planning, Global Supply Chain, Jim Piermarini, 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.
Guest Post: Cashing In On Your Green Supply Chain Decisions
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
Uncovering the Value Hiding Behind Environmental Improvement Investments
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.
How to Increase Your Velocity in Your Supply Chain Without Breaking a Sweat
June 11th, 2012 7:07 pm Category: Mark Rockey, Scheduling, Supply Chain Agility, Supply Chain Improvement, Supply Chain Planning, Supply Chain Software, by: Mark Rockey
What is it about the Autobahn that is so alluring? The idea of driving on a road without a speed limit is thrilling. Or how about breaking the sound barrier in a jet plane?
At the risk of sounding like a supply chain nerd, here at Profit Point, I get a similar sense of exhilaration in enabling our clients to increase the velocity in their supply chains by implementing decision support tools that enable faster and better decisions.
These decision support tools enable faster and better decisions in at least the following 3 ways:
1. Faster visibility to the data – By having a software tool that holds all the data needed to make a particular decision with automated interfaces to source systems, our users don’t have to spend countless hours combing through multiple spreadsheets and other software systems to get the data they need. We bring all the data needed together in one place for the user to be able to make effective decisions.
2. Faster understanding of the data – Supply chain decision support tools have huge amounts of data coming in and going out of them. Making sense of it all can be challenging. Typically what we do is build tools that allow the user to sort through all this data by:
a. Having graphical user interfaces that make it easier to understand what is going on. After all a picture is worth a thousand numbers any day of the week.
b. Show only the exceptions or problems that need to be resolved to help the user focus on what needs to be changed.
3. Faster processing of the data – Oftentimes we will automate tasks that are menial and time consuming or if the task is very complex it may be appropriate to employ an optimization or heuristic solution approach to speed getting to a feasible or better solution. We like to call these “Power Assist” tools that greatly ease the burden on the user while still giving them ultimate control over the decisions that are made.
Do you feel the need for more speed in your supply chain? Give us a call so we can discuss how we can help to get you moving faster.
Supply Chain Planning: What Hasn’t Changed in the Last Decade
April 5th, 2012 2:16 pm Category: Danielle Cohen Jarvie, Operations Research, Scheduling, Supply Chain Planning, by: Danielle Cohen Jarvie
A husband, two kids and a golden retriever later… I am back to implementations in Supply Chain planning and scheduling. To my surprise, the same challenges I encountered 10 years ago remain in force today: data, defining business processes, data, implementing software, data, training people, data, supporting the change to a new system and data.
Data collection remains one of the cornerstones of success of a supply chain planning or scheduling implementation. Though scores of data may exist in a company’s business, harnessing it to feed into a planning or scheduling model can be extremely complex and time consuming. Interestingly, the data collection process often drives an elucidation of manufacturing practices and process flows, and clients learn what they do and don’t know about their business. This may seem backwards and risky in terms of getting things out of order. In a perfect world, a thorough understanding of manufacturing and business processes would pave the way towards building an Advanced Planning and/or Scheduling System. In reality, they often happen in tandem and are evolutionary in nature.
Deciding how data will be housed, derived and propagated early on in an implementation will pay off in the long run. Establishing a systematic, automated way to update and propagate data is equally important as the decision of what software system to use. It is worth the investment to take the time to put this automation in place as a greater and greater number of products are added to a system the data will remain manageable and scalable.
From PC to Cloud, emails to tweets, networking happy hours to LinkedIn, it is nice to know some things stay the same.
Special Report: S&OP Survey
December 5th, 2011 9:58 pm Category: Supply Chain Improvement, Supply Chain Planning, Supply Chain Software, White Papers, by: Editor
Sales and operations planning (S&OP) is an integrated business management process that enables a company to continually balance and manage the supply chain supply and demand to achieve its strategic and tactical business objectives. More and more business leaders are relying on S&OP to align and improve decision making across the disparate parts of their organization. And, many companies are still adopting and improving the techniques and tools that they use to improve S&OP.
So this year, we conducted an S&OP Survey of key decision makers to learn more about their challenges, concerns and expectation for 2012. Business leaders from a variety of companies and industries were polled. Here’s what we learned:
- Many companies lack the metrics needed to capture the benefits from S&OP
- Scenario and sensitivity analysis is the tool of choice for S&OP planners who understand that sales forecasts are imperfect
- More companies are beginning to collaborate with suppliers and customers to improve S&OP
- For many companies, point-of-sale (POS) data may be the key to effective sales and operations planning
To read the complete report, including our conclusions, click the link below:
To learn more about Profit Point’s S&OP services and S&OP software, call (866) 347-1130 or contact us here.
How to avoid the collapsing soufflé and other Supply Chain Challenges
November 21st, 2011 12:20 pm Category: Global Supply Chain, Jim Piermarini, Network Design, Optimization, Risk Management, Scheduling, Supply Chain Agility, Supply Chain Improvement, Supply Chain Planning, Sustainability, by: Jim Piermarini
Change is hard.
In the businesses that I help, change comes for several reasons. It may be thrust upon the business from the outside, a change in the competitive landscape for instance, or a new regulation. It may come from some innovative source within the company, looking for cost savings to increase profitability of productivity, or a new process or product with increased productivity. Change can come from the top down, or from the bottom up. Change can come in a directed way, as part of a larger program, or organically as part of a larger cultural shift. Change can come that makes your work easier, or harder, and may even eliminate a portion (or all) of the job that you were doing. Change can come to increase the bottom line or the top line. But primarily change comes to continue the adaptation of the company to the business environment. Change is the response to the Darwinian selector for businesses. Adapt or decline. Change is necessary. It is clear to me from my experience that businesses need to change to stay relevant.
This may seem trite or trivial, but accepting that change is not only inevitable, but that it is good, is the shift in attitude that separates the best companies (and best employees) from the others.
So, you say, I see the need to change, it is not the change itself that is so difficult, but rather the way that it is inflicted upon us that makes it hard. So, why does it have to be so hard? Good question.
Effective managers know that change is necessary but hard. They are wary of making changes, and rightly so. Most change projects fail. People generally just don’t like it. Netflix is a great example. Recently, Netflix separated their streaming movie service from their DVD rental business. After what I am sure must have been careful planning, they announced the change, and formed Quikster, the DVD rental site, and the response from the customer base was awful. As you likely know, Netflix, faced with the terrible reception from their customer base and stockholders, reversed their decision to separate streaming from DVDs. What was likely planned as a very important change, failed dead. Dead, dead, dead. Change can be risky too.
If change is necessary, but hard and risky… how can you tame this unruly beast?
The secret of change is that it relies on three things: People, Process, and Technology. I name them in the order in which they are important.
People are the most important agents relative to change, since they are the one who decide on the success or failure of the change. People decided that the Netflix change was dead. People decide all the time about whether to adopt change. And people can be capricious and fickle. People are sensitive to the delivery of the change. They peer into the future to try to understand the affect it will have on them, and if they do not like what they see… It is the real people in the organization who have to live with the change, who have to make it work, and learn the new, and unlearn the old. It is likely the very same people who have proudly constructed the current situation that will have to let go of their ‘old’ way of doing things to adopt to the new. Barriers to change exist in many directions in the minds of people. I know this to be true… in making change happen, if you are not sensitive to the people who you are asking to change, and address their fears and concerns, the change will never be accepted. If you do not give them a clear sense of the future state and where they will be in it, and why it is a better place, they will resist the change and have a very high likely hood of stopping the change, either openly, or more likely passively and quietly, and you may never know why the fabulously planned for change project failed.
Process is the next aspect of a change project that matters. A better business process is what drives costs down. Avoiding duplication of efforts, and removing extra steps. Looking at alternatives in a ‘what-if’ manner, in order to make better decisions, these are what make businesses smarter, faster, better. A better business process is like getting a better recipe for the kitchen. Yet, no matter how good a recipe; it still relies on the chef to execute it and the ovens to perform properly. Every business is looking for better business processes, just as every Chef is looking for new recipes. But putting an expert soufflé recipe, where the soufflé riser higher, in the hands of an inexperienced Chef does not always yield a better soufflé. People really do matter more than the process.
Technology is the last aspect of the three that effect change. Better technology enables better processes. A better oven does not make a Chef better. The Chef gets better when they learn to use the new oven in better ways, when they change the way they make the soufflé, since the oven can do it. A better oven does not do it by itself. An oven is just an oven. In the same way, better technology is still just technology. It by itself changes nothing. New processes can be built that use it, and people can be encouraged to use it in the new process. Technology changes are the least difficult to implement, and it is likely due to this fact that they are often fixed upon as the simple answer to what are complex business problems requiring a comprehensive approach to changing the business via it people, process, and technology.
Change is necessary, but hard and risky. Without change businesses will miss opportunities to adapt to the unforgiving business world, and decline. However, change can be tamed if the attitude towards it is changed to be considered a good thing, and is addressed with a focus on people, process and technology, in that order. Done right, you can implement the change that will increase the bottom line and avoid a collapse of your soufflé.
Today’s Business Needs, Yesterday’s Supply Chain
October 25th, 2011 9:00 am Category: Distribution, Supply Chain Improvement, Transportation, by: Editor
The following is a guest blog post from Sam Polakoff, President, TBB Global Logistics.
Now sit down and think about it for a moment. Exactly when did your company establish its current distribution network? In all likelihood, the answer is three or more years. Is your business the same as it was three years ago? Probably not. What factors commonly drive change necessitating a shift in supply chain strategy? There are many including, but not limited to, the addition of key customers, product introductions, changing sources of supply, competitive threats, mergers, acquisitions, natural disasters and shifting demographics. So how do you rationalize using yesterday’s supply chain for today’s business needs? At best, you are getting by with higher costs and lower margins. You may feel as if you are losing the battle to stay competitive in a difficult economy.
To compete effectively in a dynamic business environment, continuous evaluation of the marketplace is a critical success factor. Once knowledge is in-hand, your supply chain must be built in an agile manner allowing for efficient shifts to accommodate expected and unexpected change.
I recently spoke to the owner of a U.S. manufacturing company that dates back to the early 20th century. He was explaining how he was in the final stages of divesting the company of all its hard assets. They had long ago moved manufacturing offshore. They had evolved into a substantial importer managing a series of company-owned distribution centers. Today, all of the distribution is outsourced and the old company headquarters building is up for sale. The shift to a virtual company is near complete. The executives are now free to work on product innovation and the related sales and marketing. They still compete effectively but with higher margins and more agility. This old line company has adapted and overcome, multiple times, aligning and realigning supply chain process with strategic business objectives and changing marketplace conditions. The results are higher profits, supply chain flexibility and happier customers.
Establishing and using key performance indicators will serve as confirmation of effective supply chain process or as a red flag requiring attention. Aligning supply chain with strategic business objectives and keeping your finger on the pulse of the customer will propel you forward on the road to prosperity.
Filling the Gap: Tying ERP to the Business Strategy
August 25th, 2011 5:27 pm Category: Alan Kosansky, Enterprise Resource Planning, Jim Piermarini, Publications, by: Editor
This article written by Alan Kosansky and Jim Piermarini was originally published in Supply Chain Brain.
More than a decade has passed since businesses started using Enterprise Resource Planning (ERP) for managing data and transactions throughout the supply chain. Traditionally, ERP systems have provided transparency and insight into transaction-level data in the supply chain that support important business planning activities. Now, a new generation of applications is being developed to help fill the gaps between general business planning and business-specific, tactical and strategic decisions. These ERP-connected applications offer supply chain executives previously unavailable analysis and insights into the decisions that directly impact customer service, profitability and competitive advantage.
Supply Chains Differences
Supply chains are as different as the companies and people that run them. Some companies view their supply chain operations as a “utility” that is expected to function without any investment in intellectual capital. These organizations are content to rely on industry best practices in their supply chain operations and follow the leaders (or the features that are added by ERP software providers) in supply chain improvement. Other organizations see their supply chain operations as a strategic opportunity to develop a competitive advantage and increase market share. They know that with some small departures from the norm and a modest investment in intellectual capital, supply chains can provide enhanced performance to the business. These companies understand that there are opportunities for creative and unique ideas in the supply chain to improve company performance and achieve business strategy objectives.
Today, many C-level executives see their ERP systems as key enablers to company productivity, and for the most part, they are correct. Since ERP systems perform many valuable functions, there is a natural assumption that they can handle whatever business strategy the company adopts. However, new business ideas by definition run the risk of stressing the ERP system features beyond their ability to cope. Usually these failures are discovered only during the implementation of a new business strategy. So what happens when the ERP system fails to support the new business strategy in certain critical details? Those working in the trenches know this scenario all too well. But, what can be done to implement strategic supply chain initiatives when ERP is not equipped to handle business-specific initiatives?
Making the ERP Work
There are three possible approaches for implementing supply chain planning activities that offer a company a competitive advantage:
1. Figure out how to get the ERP system to do it. This approach works well if the company’s needs align well with current industry practices supported by ERP systems. Otherwise, companies may find themselves going down a path that consumes significant resources for a poor fit in the end. Companies that adhere to this path typically do so in part because there is a strong C-level edict in favor of simple, clean upgrades for the ERP system. Faced with this, the IT organization has enormous power to shape the nature of the supply chain operation to fit within the established ERP norms, and thus can act as a barrier for business innovation and supply chain improvement.
2.Modify the ERP system to provide new functionality. This is an approach often promoted by IT organizations committed to supporting the fewest number of tools. While this is an important cost management objective, it is important to understand the full cost to implement and support the system over the long term. What can be accomplished is often limited by the lack of flexibility in large ERP systems and IT organizations. Since ERP systems are mission-critical systems, the support and maintenance of the core functions are of paramount importance. This task, placed on a limited IT staff, leads to large backlogs of enhancement work and long queue times. And while IT departments are well-equipped to manage their primary assets, few if any IT departments have the requisite domain knowledge to cross over into supply chain optimization. Given long wait times, organizations will often choose the simplest approximation of the business change that can be ushered to the top of the queue. This approach can result in a quick-fix style of strategy implementation, rather than a priority-based feature development, and may leave the most important aspects of the initiative lingering in the queue.
3. Add an integrated solution to the ERP system that replaces one or more functions that are needed to achieve the business strategy. This could be from an out-of-the-box third-party provider, or for full competitive advantage, a targeted or custom supply chain application that integrates with the company’s ERP data. This approach has the benefit of including priority-based features that the current ERP system lacks, and the additional benefit of avoiding the ERP enhancement queue. The downside, however, is that it suffers from the stigma of being yet another application and not the ERP system itself. This usually presents a hurdle that requires a careful analysis to understand the total cost relative to the strategic benefit. While not all business changes will overcome this roadblock, there are good reasons to look at this approach. These include:
- Ensuring a tight fit between the business strategy and the tool execution
- Minimizing the cost, overhead, and extra setup and maintenance in un-needed functions from a shrink-wrapped general purpose tool
- Providing the marketplace with a specialized and unique operation of the supply chain for competitive advantage.
Example from the Field
A leading consumer electronics company with about $2bn in annual sales implemented an integrated solution to its ERP system to manage its order fulfillment process for competitive advantage. The company had recently modified its corporate strategy to increase retail sales through its “big box” customers (Walmart, Best Buy, Staples, etc.). However, key service level agreements were not being met for these customers due to lower than expected order fulfillment measures. A simple inventory analysis recommended large increases in the stock required at the warehouse, with some method of segregating inventory for each big-box customer so it could not be taken by orders from other customers.
In this case, one of the leading causes of low service for customers was that they ordered “just-in-time”. These JIT orders were not being given any priority over other customers’ orders with longer lead times. The company noted that these important customers may have provided accurate plan information, but that was not being used to assure them any better service. The analysis recommended that separate stocks of inventory be set up based on the big-box planning information, and that other customers not be allowed to take from those inventory locations. This would result in a large increase in overall stocks, but should achieve the desired increase in service levels.
One manager questioned this recommendation, wanting to know why the ERP system did not use the big-box planning information to appropriately manage the company’s service levels. She also questioned what could be done to avoid increasing her inventory risk and yet still achieve the business strategy. This is a question many managers face when their analysts say that to improve service you need to increase inventory levels. Often there are alternatives. This key manager’s insight set the path for her company to make a significant shift in their supply chain operations, with remarkable benefits. What follows will answer the question: Can I raise the service level of my key customers without increasing my inventory and capital risk? The short answer is, “yes”. Significant service benefits and risk reductions can be achieved, but only if you are willing to deviate from your ERP’s standard approach to implementing key supply chain initiatives.
The industry standard approach for assigning available inventory to open orders is to use a FIFO (first in, first out) approach. This approach prioritizes orders based on when the order was received and assigns on-hand inventory to those orders that were received and entered into the system first. While this approach has a degree of fairness to it, and is available in all ERP systems, it did not align well with the business objectives of this company. It actually penalized key customers who issued JIT purchase orders while giving ample planning information. These JIT orders would have to wait until all the older orders, from non-key customers, were allocated before they would be assigned any inventory.
The standard ERP process does not take into consideration the customer’s strategic importance or their planning information. Given this FIFO process, the internal recommendation makes sense: set up separate safety stocks for each big-box customer (based on their planning information), in separate inventory locations, and make a rule that directs big-box orders to their separate inventory.
But having separate safety stocks violates the principle that more customers need lower inventory together, than each does individually. Pooling the inventory helps to avoid unnecessary capital risk. The standard ERP FIFO inventory assignment process could be replaced with one that met customer needs more effectively.
The company embarked on a project to take into account several important factors when deciding how much inventory to assign to each order:
- The priority of the customer
- The amount of inventory actually in the sales channel of the customer, and
- The planning information that the customer shared with the company.
Customer priority is a key and strategic factor in deciding which customers receive product, when inventory availability is limited or delayed. This business need meant that strategic and high-volume customers should typically be serviced before others. However, this may not be the case if a strategic or high-volume customer happens to be sitting on a lot of inventory in their channel. In these cases, it may be preferable to share the wealth with smaller volume resellers to maximize the sell-through to retail customers. Moreover, these rules may apply differently for each SKU in a manufacturer’s product line.
The business rules to implement these sorts of complex trade-offs can get complicated. If one wants to retain a certain amount of flexibility in these rules, then the ERP system is a poor place to make these decisions. However, since most, if not all, of the data resides in the ERP system, these decisions must be tightly integrated with the data and transaction handling within the ERP system. So an application was constructed to manage the inventory assignment process in this way to more closely match the business strategy. The new application is run several times a day, extracting needed info from the ERP system, making the assignment of inventory to all open orders, and sending back the info to the ERP system.
Using this integrated solution, overall service levels for these key customers were sharply increased, prompting several supply chain awards from these big-box customers. As a result of the increase in service level, Walmart (a strategic customer) was so pleased they chose to increase their orders of all this company’s products by 100 percent. The overall inventory did not increase.
The new method demonstrated that pooled inventory was an effective approach to containing inventory levels. In subsequent versions of this application, the integration of point of sale data has allowed even more control over the inventory in the various channels to market. As a result, this company has declared this application a business-critical application. It overcame the hurdle, and the application can defend its spot on the chart of critical business applications alongside the ERP system.
Integrated Solution Success
Using an integrated solution to the ERP system was a win-win approach that allows the business the flexibility to manage order fulfillment for competitive advantage while maintaining the benefits of centralized data and the strong transactional handling capabilities delivered by ERP.
But order fulfillment is not the only area where there is opportunity to supplement the strengths of ERP with flexible and powerful business optimization processes and tools. Other areas where leading companies have decided to enhance their ERP capabilities include optimization-based infrastructure planning, sales and operation planning, distribution route and territory planning, transportation bid optimization, transportation fleet planning, and production scheduling.
These are just some examples of where complex and/or strategic business rules can provide competitive advantage through improved supply chain performance. While ERP systems remain the backbone of all successful large business operations today, they are not the only path available to companies who desire to apply innovative approaches to their business and supporting supply chain activities. Global enterprises that seek a competitive advantage now have the opportunity to leverage their ERP investments by integrating optimization-based solutions to key business strategies.
Making Sound Business Decisions in the Face of Complexity
June 24th, 2011 3:08 pm Category: Alan Kosansky, Global Supply Chain, Operations Research, Optimization, Publications, Supply Chain Agility, Supply Chain Improvement, Ted Schaefer, by: Editor
The summer issue of
Manufacturing Today includes an article authored by Ted Schaefer and Alan Kosansky entitled Face Complexity – Making Sound Business Decisions.
“With every passing year, the amount and variety of information available to make business decisions continues its exponential growth. As a result, business leaders have an opportunity to exploit the possibilities inherent in this rich, but complex, stream of information. Alternatively, they can continue with the status quo, using only their good business sense and intuition and thereby risk being left in the dust by competitors. Top-tier companies have learned to harness the available data with powerful decision support tools to make fast, robust trade-offs across many competing priorities and business constraints.”
Read the complete article here: Face Complexity – Making Sound Business Decisions
Sales and Operations Planning Solution Helps Manufacturers Align Production to Real Demand
June 16th, 2011 9:00 am Category: Enterprise Resource Planning, Global Supply Chain, Inventory Management, Press Releases, Supply Chain Improvement, Supply Chain Planning, Supply Chain Software, by: Editor
Profit Point, the leading supply chain optimization software and services company, today announced the release of its Profit S&OP software to complement it’s S&OP consulting services. Profit Point’s combined S&OP solution provides business decision makers with the process and tools to manage and optimize sales and operations planning across the supply chain.
The Profit S&OP software tool is fully-customizable to meet the needs of supply chains across all industries and is designed to improve tactical planning for the key decision makers across a company, including finance, sales, manufacturing, logisitics and supply chain. The software provides a centralized dashboard to gain insights and control over a company’s supply chain, including features to enhance collaborative forecasting and improve manufacturing, distribution, and inventory decisions.
“Global manufacturers struggle to accurately plan for global demand across their product lines in a timely manner,” noted Alan Kosansky, Profit Point’s President. “Our S&OP solution solves this problem with a combination of effective processes and a shared planning tool that provides one set of numbers for the key stakeholders across the entire supply chain.”
Using Profit Point’s S&OP solution, manufacturers can coordinate with their supply chain planners across the globe to build accurate, detailed manufacturing and distribution plans quickly and integrate with point-of-sale demand tracking systems. And, the software connects with existing ERP systems, such as SAP® and Oracle®, so analysis and decisions are up to date across the entire organization.
“Improved planning can help any large manufacturer reduce inventory excess and capital risk.” said Jim Piermarini, Profit Point’s CEO. “But the key to successful planning includes the right technology and the right process to align employees with the company’s strategic objectives.”
Profit S&OP has an integrated optimization engine that seamlessly drives the best scenarios to the forefront of a tactical planning sessions. Throughout the process, decision makers are able to visualize and test multiple future scenarios to achieve a collaborative, cross discipline decision making process. Key features in the software include the ability to automatically generate an optimal tactical plan down to the bill of materials (BOM) level, integration with existing ERP data warehouse, multi-period planning horizon, scenario analyzer to systematically assess multiple future scenarios, complex BOM exploration and the ability to visualize plans, timelines and bill of materials to correct bottlenecks and reduce excesses.
To learn more about Profit Point’s sales and operations planning software and services, call us at (866) 347-1130 or contact us here.
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 Dow Chemical, Coca-Cola, Toys “R” Us, Logitech and Toyota.
When ERP Is Not Enough
June 14th, 2011 1:12 pm Category: Enterprise Resource Planning, Global Supply Chain, Mark Rockey, Optimization, Supply Chain Improvement, Supply Chain Software, by: Mark Rockey
Here at Profit Point we regularly hear from clients with well established Enterprise Resource Planning (ERP) systems that they need something more. ERP systems are excellent for doing certain things including:
- Providing central repositories of data
- Enabling cross functional work processes within and across companies
- Costing of goods
- Planning resources and materials at a high level
However the more complicated your business work processes and manufacturing production processes the less sufficient a standard ERP system will be in providing the best decision support functionality. Some of the complications that require decision support systems (DSS) and which we have been helping clients deal with lately include:
- Work processes to handle make to order versus make to stock material assignments
- Allocation of inventory to customer orders when in an oversold position
- Sequence dependent setups / cleanings of manufacturing equipment
- Scheduling of production sequenced through a “product wheel”
DSS are necessary because of the complexity of first finding a feasible solution and then having some means of sorting through the huge number of feasible options to find a “good” or “optimal” solution. DSS help in these kinds of situations to:
- Reduce costs
- Reduce manufacturing lead times
- Improve customer service
- Increase revenue
ERP systems are a necessary part of being able to deliver a DSS by providing the data necessary for making the decisions in question but don’t have the following:
- Ability to be tailored to a specific work process or manufacturing environment
- Advanced analytical capability to sort through the complexity and volume of options to get to a “good” or “optimal” solution
- Graphical user interface tools to be able to allow a user to visualize the data in a way that gives them the insights needed to make decisions
At Profit Point we specialize in listening to our clients needs and then building DSS to unlock improvement opportunities which enable our clients to outdistance the competition.
S&OP: “If it’s not in the system then it’s a rumor”
January 4th, 2011 1:10 pm Category: About Profit Point, Enterprise Resource Planning, Global Supply Chain, Mark Rockey, Supply Chain Planning, by: Mark Rockey
At Profit Point, we often repeat the mantra “People, Process, Technology.” All three are important for the kinds of projects we work on. You have to have good systems (the technology part) that support good work processes and people that follow the process and use the systems. If your people are not committed to following the process and using the systems, you are going nowhere fast.
Recently we were discussing with a senior manager at one of our clients what makes for a good Sales and Operations Planning Process (S&OP Process). Being someone who is more of a process and technology guy I was thinking that he might say something like “You have to have a well thought out work process that is clearly communicated to everyone involved” or “You have to have a system that is easy to work with that supports the work process well.” WRONG!
The first thing he mentioned was that senior management needed to be openly committed to the process and systems. He illustrated this for us by recounting what another senior manager at this same client said during an S&OP meeting with a large group. The group was going back and forth discussing a “potential” order from a customer and this particular senior manager said “If it’s not in the system then it’s a rumor and we don’t plan and schedule for rumors.”
As you can imagine, this cut down on the chatter in the room quite quickly. This client had spent a lot of time and money developing processes and systems that worked well and those two things are necessary but not sufficient. You have to have leadership that says “We have a work process to follow and a system to use to support executing that process. Follow the process and use the system.”
Next you have to have people who do exactly that! If this is not happening then as I heard from another executive “Either the people will change or the people will change!”
You have to be able to trust the data in the system but really at its root this boils down to trusting the people who entered the data in the system. As I was reminded, this starts at the top!
Supply Chain Café
December 22nd, 2010 2:45 pm Category: About Profit Point, Optimization, Richard Guy, Supply Chain Agility, Supply Chain Improvement, Supply Chain Software, by: Richard Guy
Okay. I am an anomaly. I live in Utah and drink coffee. The majority of the people that live in Utah do not drink coffee, and that is OK, but I do. So, is there a shortage of coffee Cafés in Utah? No. There are many cafés and several that serve outstanding coffee.
We have an exceptional espresso café downtown, located on a side street off of Main. They roast their own coffee and use triple certified organic grown beans. It is the type of place the local coffee lovers go to hang out and have good conversation over a morning or afternoon latté or espresso. Possibly the best coffee I have ever had. What is interesting to me is that a large percentage of the residents in my area do not even know that this café exists.
So what is my point? When it comes to outstanding services or products most people are unaware of what is available, primarily because it does not fit into their lifestyle or what they’re accustomed to. I believe you can transfer this similarity to the business world. Manufacturing logistics and transportation people become accustomed to doing things a certain way. Over time they may become blind to ideas for improving the supply chain. They are unaware of an exceptional Supply Chain Café, even when it is located just seconds from a combination of keystrokes and Google.
It is not their fault they are missing the best latté available. We, as consultants, who prepare those delightful solutions from the Supply Chain Café menu, have probably not done the finest job of promoting our services and software to your neighborhood, but that is changing.
There are many empty cups in the supply chain, waiting to be filled with successful solutions. Supply Chain and Logistic managers tackle difficult supply chain problems every day, but they are so focused on getting their job done and making it through the day that they have little time to think of alternatives that may improve their processes and well being. I am not sure how we can help everyone, so let’s focus on the window shoppers. These are the ones that are aware of the café, but have never been inside. Maybe you are one?
If you are reading this blog, then you must be a window shopper. I am guessing you are looking for a better espresso. OK, you found “Profit Point”, although you may not know what we do. Guess what? Help is on its way. We can share our menu with you. We just published four videos that will introduce you to the Profit Point team and what we do. Embrace three minutes out of your day, select one of the videos, and watch it. Learn how we help companies improve their supply chain, by serving the best coffee with a smile.
Yes, you can improve your supply chain with our help. The supply chain solution that you are looking for, is about to be yours. And if you place an order, we can fill your cup to the top, with the “good triple certified” stuff. If you cannot seem to find that special item on our Supply Chain menu, then no fear, we love special orders.
So, is there a shortage of Supply Chain Cafés? No. You just need to find the one that serves the optimal latté. I know it’s out there somewhere.
To learn more about Profit Point’s Global Supply Chain Optimzation services, please contact us.
Leveraging Value in the Executive Suite
October 28th, 2010 3:32 pm Category: Publications, by: Editor
This month’s issue of Supply Chain Solutions magazine features an article by Dr. Alan Kosansky and Dr. Joe Litko entitled Leverage Value.
“Executive-level business decisions include a broad range of interconnected variables leading to an extensive array of options. In the supply chain arena, this often plays out as a tradoff between operating costs, working capital, asset utilization and customer service levels.”
This article looks at the challenges faced by executives in making these decisions and the value of modeling future scenarios to make better decisions. You can read the complete article here.
If you would like to learn more about our Supply Chain Optimization and decision support services, please call (866) 347-1130 or contact us here.
Enabling the Virtual Company
October 5th, 2010 4:34 pm Category: About Profit Point, Jim Piermarini, Operations Research, Optimization, Software Optimization, by: Jim Piermarini
At Profit Point we are in the ‘Science of Better’, and we are always looking for new ways to do business, both for our clients, and for ourselves. When we started, we had the challenge of being a virtual company, that is, we have never had a corporate office space. Since 1995, each of us has always worked from home. While there are numerous benefits of this style of company architecture, including having a family that actually knows who you are, and keeping the company’s overhead to a minimum, it also has its drawbacks. Like forcing each person to make the deliberate decision about when to start work, and harder still, when to stop work each day. We knew when we started this company that we wanted to keep our overhead costs low, so a virtual office seemed like the natural choice.
More recently, we have been faced with another challenge, how to reduce the cost of the projects we do. Projects in the supply chain business require a certain amount of industry and company specific knowledge. Until recently, we had been building into our projects ample on-site time where the project team could gel and collaborate and build the trust that is needed for the free flow of ideas. But the world has changed, and we have changed with it. No longer are big travel budgets a normal part of the projects we see. So the challenge was: how to reduce the travel expense line item, without sacrificing the project speed or quality?
In the consulting business, there is sometimes no substitute for ‘face-time’. So travel to the customer site perforce happens. Over the course of the last 15 years, I have seen a marked drop in the amount of time that we need to travel, going from 60-70% a decade ago to less than 20% currently, and this has been brought about primarily by two factors: 1) Companies simply do not want to pay the travel expenses. Since 9/11, most major companies have been slashing their travel budgets, and expect their consultants to follow suit. One particular project comes to mind where I had seen travel expenses that were as much as the consulting bill each month. But in general, we see pressure to reduce the travel expenses that are generated by projects across the board. 2) ‘Remote Touch’ Technology has provided the means to travel less. There are some great remote desktop control tools that allow two or more people to have a telephone or VOIP conversation, and look at the same computer screen, to discuss and collaborate on ideas and tools. These web based telephony and remote control tools have eliminated the need for travel to a greater extent than you might think. Many of our projects today have only two face to face meetings, one to kick it off, and one to present the results or close it out. Some of our clients are handled successfully without any face time. I must say though, that in our experience, low face-time projects only work well within the culture and language: that is, when language and culture barriers exist in the project team, face-time is the best way to bridge these gaps, and mitigate the risk of project overruns and delays.
In business, technology comes into being as a means to enable better business processes. The processes that we use that are enabled by this remote touch technology includes an agile approach to solving business problems or developing software solutions. We use several readily available web based tools every day in our business, and boy have they allowed us to reduce the travel expenses. These include:
This is the best remote touch tool out there in our opinion. Until a robust free app comes along, this will remain the best value for the money. The best part of the app is the recent addition of the integrated VOIP, where you can use a head set (I would recommend the Logitech ClearChat PC Wireless Headset: http://www.logitech.com/en-us/webcam-communications/internet-headsets-phones/devices/4226) to join the integrated telecon line. This has the advantage of freeing up your phone, and being instantly connected to the telecon as soon as you start it. No more long telecon numbers with their passcodes! We use this many times every day, and it is the primary reason why we can travel less.
This is a simple to use and secure web based file storage and sharing application that fosters and supports collaboration with people both in your company and externally. We love this app, and my clients seem to as well. Just drop a file into this app, and share it securely with anyone with an email address. Use it when email attachments just will not do, due to size limitations, or just when the email hassle is too much.
This is a terrific project management tool that is designed for agile projects, and makes it simple to create and manage user stories for tool development. While inviting new members can be a hassle (since their email seems to get caught in many spam filters), once they are in, these folks have made a stellar user interface to manage the tasks in a project of nearly any size. Use it to track bugs too. We have done several projects using this tool. and we will be using it for many more. Great tool.
If you like to look at data, like we like to look at data, then you will want to look at Tableau. You can think of it like a pivot table / chart on steroids. You open it, connect to you data, (whereever or what ever data you’ve got, it can connect to it), and then you start to explore your data like you’ve never been able to before. Like a pivot table, you can drag and drop fields, aggregate data along dimensions, and make sums, etc, but the really cool part of Tableau is the part where it suggests new ways of the looking at the data. Go ahead, make maps, heat charts, time phased graphs, whatever. Then you can assemble the graphs into a dashboard. Dashboards are the best. Want to see a ton of data distilled down into a very compact visually stunning view suitable for management? Get a copy of Tableau, and you can make that view in minutes.
Used appropriately, these tools, and others like them, have enabled us to travel less, and work faster and better. (and more!)
If you have other great apps like these that enable better business processes, I would love to hear about them.
Jim Piermarini to Speak at CSCMP 2010
September 27th, 2010 5:13 pm Category: Inventory Management, Jim Piermarini, Supply Chain Improvement, by: Editor
CSCMP’s Annual Global Conference is in full swing and a couple of our team members are on-site in San Diego.
Jim Piermarini will be speaking at the event tomorrow along with Michele Hermann, the VP of Global Operation Solutions for Logitech. Please stop by and hear Jim and Michele talk about our efforts to help Logitech improve its supply chain and inventory. You can find the full details below.
And, if you’d like to meet up with Jim at any other time during the conference, you can send us a note here.
Logitech: A Better Way to Assign Inventory to Backlog Orders
Tuesday, 9/28, 3:30 pm to 5:00 pm
- Learn techniques to control assignment of inventory to backlog orders.
- Gain an understanding of the challenges of replacing enterprise resource planning (ERP) functions with offline decision systems.
Michele Hermann, Vice President Global Operation Solutions, Logitech
Jim Piermanni, Chief Executive Officer, Profit Point, Inc.
Including Capital Costs in Network Design Analysis
September 22nd, 2010 11:42 am Category: Gene Ramsay, Network Design, Profit Network, by: Gene Ramsay
When making infrastructure planning decisions regarding adding new facilities, or adding capacity to existing facilities, you will want to take into account a variety of facility costs to ensure you make the right decisions. These costs include…
- variable cost, dependent on the volume through the facility
- operating fixed cost, to cover costs such as taxes, security, leases, etc.
- depreciation, based on the life of the equipment, and
- cost of the capital used to construct / purchase the facility
In an optimization model you can capture all of these costs separately, or perhaps you will want to consider the fixed costs as a “lump sum”.
Here are two ways that you could build the cost of capital into the decision-making process:
- Add a Capital Recovery Cost to the objective function, to reflect the cost of the capital required to build or expand a facility. One way to do this is the approach used in the Microsoft Excel PMT function, which asks for four inputs to the calculation of recovery cost for a time period:
- capital cost of the asset to be added, e.g. a plant, production line, distribution facility, waste water treatment facility, etc.
- useful life of the asset - the entry here for the number of time periods should be consistent with the frequency of time in your model
- salvage value at the end of the asset’s used useful life, if any
- capital cost charge (interest) rate to be charged in each time period – again, the entry here should be consistent with the frequency of time in your model. (This number could be annual, monthly, or based on another frequency, depending on how you have defined your model.)
The Capital Recovery Charge can be thought of as a loan repayment for the amount of capital required in purchase and install the facility. Excel has help files describing the details of the PMT function, so we will go into more detail here.
- Use Economic Profit as the objective of the model, or as a measure that you use to compare alternative solutions. Economic Profit is your standard accounting profit, less the opportunity cost of capital invested in the business. The opportunity cost is the return that the company would have been able earn if it had invested in the next best alternative project. For instance, if you consider a future alternative where
- the accounting profit for the time period (say, year) is 100, with the additional asset, but
- the asset has a capital cost of 1000, and
- the opportunity cost for capital is 15% per year (the company could have received a 15% return by investing the capital elsewhere) , then
- the Economic Profit for the year is 100 – .15*1000 = -50.
If you are minimizing cost rather than maximizing profit in your model, then you can calculate Impact on Economic Profit for a given alternative, adjusting the operating costs from the model for the effective tax rate, and subtracting the capital charge.
Including the cost of capital appropriately will allow you to present a more complete analysis.
Network Design Team






















