Field Service Parts Optimization at Seneca Companies
Seneca Companies, an industry leader in automotive petroleum services, offers a broad range of service station design, construction, service, comprehensive containment and dispensing solutions. Seneca Fuel Systems serves the US Midwest, Southern and Mountain regions with a highly skilled staff of 75 field technicians charged with keeping client fuel stations up and running.
Seneca Fuel operates a central warehouse in Des Moines and 5 additional stocking locations to ensure rapid availability of critical parts. We spoke recently with Dan Miller, Purchasing Manager for Seneca Fuel, who explained Seneca’s inventory planning challenges and how Smart Software has helped.
Keeping fuel systems up and running is crucial to Seneca clients. Down-time means lost revenue and potentially lost customers. Seneca dispatches locally based service technicians equipped with essential parts with the goal of a 90% first visit fix rate. If they don’t have what they need on hand, they must be able to secure what’s necessary from a nearby warehouse in a matter of hours.
The stocking challenge is immediately apparent: which parts to carry in the van, in what quantity, and what to carry in the warehouses to supply them, ensuring maximum service performance while minimizing inventory investment.
When Seneca and Smart began working together, Seneca treated all techs the same with respect to inventory policy. A standard list of parts was supplied to each van, with an approximate of $35K per van. However, clients were not all the same and vary across geographic service areas. Service stations in Southern Illinois, for example, tended to be smaller and require different parts than counterparts in Denver. This increased the likelihood that some parts would stock out in some vans, while others might sit untouched for years. There was a section in the central warehouse dubbed “zero turns,” for items that just didn’t move, which grew to a value of $400K.
“Something needed to change,” said Miller. “We needed the ability to stock to the specific needs of the local tech, resupply them in a timely way from our warehouses, and equip the warehouses to play backstop for any other unusual requirements that van stock wouldn’t cover.” Compounding this challenge was the highly sporadic, intermittent nature of service part demand. “Traditional forecasting didn’t help,” explained Miller. “We see periods of zero demand with seemingly random, unpredictable spikes. We needed a methodology that would enable us to plan for this.”
Seneca Companies turned to Smart Software and its cloud-based solution, Smart Inventory Planning and Optimization. Smart IP&O is an integrated suite of native web applications for collaborative demand planning, inventory optimization and supply chain analytics. Running on the Amazon AWS cloud, Smart IP&O serves automatically receives daily transactional data from their JD Edwards ERP system, models customer demand and inventory performance, and returns optimal inventory policies to JDE to drive replenishment.
“Smart IP&O integrated easily with Seneca’s enterprise systems, and enabled us to model stocking requirements for each technical rep and service area,” said Miller. “Implementation was quick and user training effective, producing initial results within 6-8 week of project start.”
A key capability has been Smart’s unique approach to planning for intermittent demand, the highly variable, seemingly random and unforecastable consumption most common with service parts. This has enabled inventory planning to move from educated guesswork to service level-driven modeling.
“Smart IP&O enabled us to model demand at each stocking location and, using service level-driven planning, determine how much to stock to achieve the service level we require. By running and comparing different scenarios we can easily define and update optimal stocking policies for each tech support rep and stockrooms.”
The software has provided field technicians with evidence they did not have before, showing them their actual consumption, frequency of part use, and rationale for stocking policies, using 90% as the targeted service level norm. Field technicians have embraced its use, with significant results: “Zero Turns” inventory has dropped from $400K to under $100K, “First Fix Rate” exceeds 90%, and total inventory investment has decreased by more than 25%, from $11 million to $ 8 million.
Learn more about Seneca Companies at https://www.senecaco.com/.
Learn more about Smart Software at www.smartcorp.com.
Engineering to Order at Kratos Space – Making Parts Availability a Strategic Advantage
The Kratos Space group within National Security technology innovator Kratos Defense & Security Solutions, Inc., produces COTS software and component products for space communications, tailored products for individual customers, as well as complete satellite and terrestrial ground segment solutions. Theirs is a highly demanding market often requiring engineered-to-order systems with exceptional performance and rapid delivery cycles. Kirk Smith, Vice President of Business Systems Innovation, sat down with us to explain how parts management and planning has become central to their operational excellence, supporting numerous custom projects per year.
Engineering-to-order in Kratos’ world means that traditional finished goods forecasting won’t help you plan for the future. In the tailored marketplace, the past does not provide a usable forecast for the future, even within the Space group’s focused technology areas. You just don’t know ahead of time everything your next tailored system customer is going to request. This is problematic for the company’s contract manufacturers (CMs) that produce key lower level assemblies – they can’t know what to expect, and without some advice will have no ability to pre-order and stock requisite component parts. Short forecast horizons and long component lead times makes competitive bidding for new projects difficult, where time to delivery is crucial.
Leveraging a competitive advantage
“With tailored and custom solutions, the Number 1 reason we win is that we solve very challenging problems for our customers,” says Smith. But a close second is a strategic advantage – the ability to deliver those tailored systems quickly. Kratos has an array of previously designed and engineered building blocks (chassis and board level assemblies) that can be applied to newly designed solutions. This speeds design, but because these building blocks are tailored for each customer, stocking them for future sales is problematic – there are many variants. If Kratos could find a way to effectively forecast their board and component level requirements, they would be able to reduce end-to-end production time, minimize part shortages that delay delivery, and prevent excesses that create obsolete inventory.
Kratos pursued a hybrid planning approach, combining sales planning by its business development team with statistical forecasting from Smart Software. Smith explained the process:
Part 1 – Annual forecast at the CM built assembly level:
- Use Smart to produce a rolling 12-month assembly level forecast for the CM.
- Compare this with the Business Development Opportunity Forecast
- Merge the insights from Smart with the Opportunity Forecast
- Provide resulting adjusted assembly forecast to the CM for revenue and capacity planning.
Part 2 – Provide component level forecasts to Contract Manufacturers:
- Feed assembly level forecast into the ERP Bill of Material function, exploding component level demand for all parts.
- Aggregating demand by part number, generate component level forecasts.
- Provide forecasts to CM procurement to enable them to determine when to buy ahead or increase orders to capture volume price breaks. When they see an opportunity, they contact Kratos, get permission, and increase buys – with the effect of driving down material cost and lead times.
- Also, providing annual forecasts reduces buy-back pressure from the CMs – Kratos is obligated to buy back unused components, but now the CMs can see opportunity at the component level and the value of retaining stocks.
Over the past three years this approach has allowed Kratos to reduce material cost. Moreover, Kratos is able to work with its Contract Manufacturers to reduce stockout risk and achieve shorter delivery commitments. While dealing with components with up to six month lead times, they are able to confidently propose and achieve customer delivery dates.
Jon Good, General Manager at contract manufacturer NeoTech, shared their experience. “We use the Smart forecast provided by Kratos’ Space group to assist in taking advantage of price breaks on material at higher quantities that wouldn’t otherwise be visible in our current business model. This enables us to reduce material cost which translates into reduced pricing to Kratos in the long run.”
Good added that another use is to predict probable material consumption over a longer period of time than would be visible only on open orders. “This enables us to more realistically understand our inventory on hand position in terms of excess. These two benefits allow NEOTech to make smarter decisions related to purchasing and inventory management while at the same time saving days and weeks in the front end of the process and delivering the end product to Kratos as rapidly as possible.”
Looking forward, Smith sees even greater opportunity to team with Kratos Space CMs to streamline their supply chain and associated costs. “The bottom line,” says Smith, “is that we are now able to more effectively communicate with our CM partners, despite the lack of forecastability in our business, and simultaneously reduce material cost and shorten lead times.”
Optimizing Parts Management at BC Transit
BC Transit’s vision statement is to be Your Best Transportation Solution. BC Transit accomplishes this by transporting 57 million annual passenger trips in over 130 communities across British Columbia. Transit is becoming a key part of the solution for many of the complex challenges that communities face across the province, such as climate change, affordability and congestion, and as a result transit service is expanding quickly (9 per cent growth in the past five years). Delivery of this service in a safe and timely manner is paramount. BC Transit’s fleet of 1,185 buses require regular maintenance and rapid repairs to ensure they are as effective and efficient as possible. Having the right part in the right place at the right time is essential. Eric Nelson, Director of Supply Services, discussed the challenges of meeting this responsibility and how their use of Smart Software technology is helping make BC Transit the best transportation solution.
BC Transit was preparing to centralize warehouse operations around a new central distribution center, just as the organization was preparing to upgrade to a new version of its JD Edwards Enterprise Resource Planning (ERP) system. They needed to determine the right stocking levels to serve the entire BC Transit network with 35 active branch plants under an aggressive timeline. In a matter of weeks, the transition would begin to their new ERP and wholesale system updates would be barred.
This was no small matter as BC Transit manages 30,000 discrete skus. Space in the new consolidated Provincial Distribution Centre would be at a premium, and parts planning was a highly manual, qualitative process. Reorder points were set manually, based on weekly requisitions and the buyers’ knowledge and judgement. The move to the new CDC model would require setting optimal reorder points for all stocked parts. The existing process would not be able to do this – there were just too many parts.
Compounding the challenge was the highly intermittent nature of BC Transit parts demand. Rather than following a routine, easily forecastable pattern, service parts often experience highly sporadic, seemingly random demand. Qualitative methods and intuition would not ensure the 95% service level that BC Transit required. The organization needed a better solution.
BC Transit turned to Smart Software. Nelson was aware of Smart’s work with other transit systems and was drawn to Smart Inventory Planning & Optimization for a number of reasons:
- Service level-driven planning methodology with probabilistic modeling, enabling ‘what if’ scenario development. and cost vs. performance trade-offs;
- Proven ability to plan for intermittent demand, demonstrated across multiple transit customers;
- Cloud-based suite of web applications, providing anywhere access and eliminating the need for IT infrastructure; and
- Automated data integration and analytics, providing the continuous flow of data from and the return of optimal Min/Max drivers to JD Edwards to drive replenishment.
Smart and BC Transit worked through an accelerated implementation process to get their initial system up and running within two months. BC Transit was able to establish stocking policies to get the new warehouse and central distribution system up and running. Once initial policies were set, they used the first year of operations to monitor and refine reorder points.
“The big change,” says Nelson, “was to shift from the qualitative, manual establishment of reorder points to a highly automated system of setting Min/Max values for all active parts.”
Year 1 focused on getting the process working and relating the new capabilities to overall supply chain operations. The experience established confidence in the system. Their enhanced planning process now treats new items manually until they experience three incidents of demand. At that point the demanded parts transition into production planning and are included in the routine, monthly automated process. Plans are now underway to push Min/Max planning out to the 28 regional transportation systems and all 35 stocking locations.
“We could not have consolidated central distribution into one facility without Smart,” says Nelson. “During the transition we discovered a need for 3,000 additional SKUs. There just wouldn’t have been room. It is difficult to put a monetary value on this.”
Using Smart IP&O, BC Transit was able to internalize the impact of centralizing all external shipments. They were able to consolidate demand for all regional transit systems and foresee required stocking levels. Nelson added, “we did not see any instance of incorrect forecasts. And we were able to set policies effectively for parts with exceptionally sparse demand.”
BC Transit values its newfound ability to forecast the financial impact of stocking decisions. They are able to balance capacity against criticality and the cost of inventory. They have been able to reduce the number of orders, determine optimal order quantities, and deal with variability of lead time – especially long lead times. “Smart IP&O has enabled us to utilize service level as a driving KPI, essentially risk adjusting our inventory to address the criticality of not running out, and to deal with the thorny challenges of seasonal and intermittent demand. It is helping us keep our buses on the road, so we can be the best transportation solution for our partners across British Columbia.”
Draped in Success – Inventory Planning at Rose Brand
Rose Brand is North America’s largest provider of theatrical fabrics, fabrications and production supplies for the entertainment, event and display industries. If you’ve been to a play or musical, you’ve probably seen their products. Product availability is crucial to the company’s success, and the company strives to achieve same day shipping from its east and west coast distribution centers. This is a tall order when offering thousands of discrete items. Doug Harvey, Director of Operations, sat down with us to explain how Rose Brand delivers, and how Smart Software helps.
“Having the product in stock is everything,” explains Harvey. “Rose Brand customers know what they want and usually want it now. If a requested item is not in stock, there is a good chance Rose Brand will lose that order and several more, and the customer may not come back.” The array of products is wide and complex – over 10,000 skus, many offered in 5, 10, even 30 colors. And it’s gotten more complex. The company recently acquired a manufacturer of curtain tracks and motors. Lots more parts.
Accelerating growth strained a procurement process that relied heavily on buyers’ domain knowledge and gut feel. Many of their stocked items experience highly sporadic, intermittent demand that staff were ill-equipped to plan. Determining when to order was based on rudimentary spreadsheet models that required extensive manual adjustment, so much so that most items – particularly the thousands of slow movers – were not actively planned. The lack of a methodical planning process, combined with the criticality that they not stock out, resulted in overstocks, stockouts, and strained limited warehouse space.
Rose Brand selected demand and inventory planning software from Smart Software as the foundation for a methodical planning process. This enabled them to effectively implement Min/Max inventory planning, setting optimal Minimum On-Hand values and order quantities. Two capabilities in particular made a big difference. First, the ability to conduct service level-driven planning made it possible to risk adjust inventory. Some critical items cannot be allowed to stock out, and so are be run at very high service levels. A 1% risk of stocking out might be acceptable. Others that are less critical can tolerate lower service levels. This risk adjustment of inventory, and achieving required service levels, reduces inventory and improves service levels.
Second, the software included Smart’s unique methodology for planning intermittent demand. This method, invented and patented by Smart, probabilistically models lead time demand and establishes the requisite Min or reorder point corresponding to the desired service level. Items with this sort of demand profile can now be effectively planned. Way better than knee-jerk or wild guess adjustments to random stockouts.
In addition to providing effective inventory policy drivers, SmartForecasts enabled staff to consider and model what-if scenarios. For example, Rose Brand purchases 1.5 containers from a vendor every 4 weeks. If their supplier could deliver in 3 weeks, how much inventory – and warehouse space – would that save? Half a container. A lot.
Rose Brand reduced inventory at the outset, and as its business grew, managed slow inventory growth as sales increased 50%. A crucial factor in that growth has been the company’s ability to respond to customers’ increasing insistence on immediate availability. SmartForecasts has enabled the company to effectively plan all of its thousands of stocked products, and has provided the planning framework for the company’s growing infrastructure. This included the addition of its West Coast warehouse, and the inclusion of a newly acquired division in 2018.
“Rose Brand has undergone tremendous change and growth since its founding in 1921,” says Harvey. “Smart Software has brought capabilities that help us meet accelerating demand and expectations, and we look forward to pushing this envelope together in coming years.”
Caught in a Perfect Storm, SmartForecasts Helps Rev-A-Shelf Weather the Crisis
The Smart Forecaster
Pursuing best practices in demand planning, forecasting and inventory optimization
Does your extended supply chain suffer from extreme seasonal variability? Does this situation challenge your ability to meet service level commitments to your customers? I have grappled with this at Rev-A-Shelf, addressing unusual conditions created by Chinese New Year and other global events, and would like to share the experience and a few things I learned along the way.
First, let me explain our situation. We import 60% of the parts we use to build our kitchen and bath accessories from China and Europe. Most of the year we were able to plan our inventory needs using a spreadsheet-based min/max approach. But not during Chinese New Year, which drives the planet’s greatest annual population migration. Chinese New Year shuts down production for up to two months, creating significant supply risk as we strive to meet our three day order fulfillment commitment.
We solved our problem, introducing statistical demand forecasting with the flexibility to extend lead times when necessary, the ability to reliably establish safety stocks that achieve our required service levels and a continuous reporting system that lets everyone know exactly where we stand. However, success required much more than a new piece of software. We needed to change the way we view future demand, supply risk and safety stock. Here are a few key things we did that made all the difference.
Stakeholder education and buy-in
Regardless of the project, it’s always best to enlist the buy-in of all stakeholders. We knew we had to do something to solve our problem, but there was bound to be resistance. Senior managers, for example, had developed a healthy distrust of software and wondered whether demand forecasting software could help. Our buyers had developed their own perspectives and procurement methods, and felt personally at risk as we considered new approaches.
People came around as they developed a common understanding of the problem and how we would address it. Education was a big part of the solution. We explained how forecasting works and key factors we should all understand: how to analyze trends, how to use “what if” scenarios, impact of shifting lead times, how to relate service levels to supply risk and safety stock and key performance indicators like inventory turns. Going through this process together, we all became stakeholders in the solution.
Use the Right software
When you have lots of part numbers and any sort of supply or demand variability, you just cannot forecast effectively with a spreadsheet. With our min/max forecasting system, we were planning to an average, and it wasn’t working. Average usage has inherent flaws for planning purposes—it’s always looking backward!
You need software that looks ahead, recognizes seasonal patterns and enables you to determine how much stock you’ll need to meet required service levels over varying lead times.
When the old ways don’t work, you need to be open to adjusting your assumptions. Think less about where you’ve been, and more about where you want to be. Take a look at your lead times and plan to your desired service level. Last year’s history may not be the best predictor of this year’s demand. The same forecast horizon may not be appropriate for all products or certain time of the year.
Make the Forecast Actionable
It’s not enough to produce an accurate forecast and estimated inventory stocking levels. You’ve got to develop a way to make the information actionable for those tasked with using it. We developed a set of reports that enabled buyers to leverage better forecast and safety stock information. Now, at the end of every month, we produce a forecast report that provides a clear picture of current inventory, safety stock, past usage, forecasted usage, incoming deliveries (PO’s) and recommended order quantities.
You can, and we did, test our new methods against our own demand history. Still, an authoritative outsider can make acceptance easier. We commissioned a study by a professor at Louisville University’s College of Business who set one of her graduate students to the task. Through them we were able to reinforce what we saw happening from our results, and feel comfortable that we were on a good path.
All of these factors helped Rev-A-Shelf transform its demand planning process, to great effect. Today we are exceeding our service level targets, and our fill rate, based on a three day ship cycle, is showing steady improvement, and trending up. Overall, units-in-stock have stayed flat while supporting a 13% increase in sales
John Engelhardt is currently Director of Purchasing and Asian Operations for Rev-a-Shelf, LLC in Louisville, KY. He has held a variety of management positions both in private business and public organizations. At Rev-A-Shelf he held the position of International Sales Manager and Director of Sales Support before assuming his current position. He can be reached at johne at rev-a-shelf dot com.
If you both make and sell things, you own two inventory problems. Companies that sell things must focus relentlessly on having enough product inventory to meet customer demand. Manufacturers and asset intensive industries such as power generation, public transportation, mining, and refining, have an additional inventory concern: having enough spare parts to keep their machines running.
This technical brief reviews the basics of two probabilistic models of machine breakdown. It also relates machine uptime to the adequacy of spare parts inventory.
Service Level Driven Planning (SLDP) is an approach to inventory planning based on exposing the tradeoffs between SKU availability and inventory cost that are at the root of all wise inventory decisions. When organizations understand these tradeoffs, they can make better decisions and have greater variability into the risk of stockouts. SLDP unfolds in four steps: Benchmark, Collaborate, Plan, and Track.
Inventory optimization has become an even higher priority in recent months for many of our customers. Some are finding their products in vastly greater demand; more have the opposite problem. In either case, events like the Covid19 pandemic are forcing a reexamination of standard operating conditions, such as choices of reorder points and order quantities.
Forum Energy Streamlines Demand Planning, Improves Market Responsiveness with SmartForecasts
Forum Energy Technologies is a $1.7 billion global oilfield products company, serving the oil and natural gas industry. With over 3,500 employees, Forum is headquartered in Houston, TX and has manufacturing and distribution facilities strategically located around the globe. Forum’s Valve Solutions Division in Stafford, Texas, uses SmartForecasts in combination with its Epicor ERP system for planning at the finished goods and component levels.
Forum faced a complex demand planning challenge. Its business, highly cyclical and sensitive to market changes, required a responsive planning process. This was complicated by the fact that the majority of its stocked items exhibit sporadic, seemingly unforecastable intermittent demand. This is characterized by many zero or low volume values interspersed with random spikes that are often many times larger than average demand.
Forum relied upon a cumbersome excel-based forecasting process that generated estimates of average demand but did not provide guidance on appropriate levels of stock. Determining stock levels was mostly guesswork, based on intuition. The large number of items and lack of effective tools resulted in an inefficient planning process where only a small portion of items could be reviewed on a regular basis. It was not unusual for items to be forecast once per quarter.
Given six to ten month lead times for imported items and a cyclical business climate, Forum needed to forecast more frequently in order to react faster to changing market conditions. This would require a data-driven solution that could determine appropriate stock levels to reduce stockout risk while keeping inventory at an affordable level.
Forum Energy purchased SmartForecasts for its abilities to automatically apply appropriate forecasting methodologies to specific items, handle intermittent demand, and interface with its Epicor ERP.
SmartForecasts enabled Forum to make several changes to the way it managed its inventory:
• automate forecasting, increasing efficiency to the extent that planners could forecast products on a monthly basis and have the time and ability to review exceptions;
• forecast at both the finished goods and component levels, using SmartForecasts intermittent demand forecasting for all components;
• perform a meaningful S&OP process spanning supply chain management and sales; and,
• model different inventory policy and service level scenarios to better allocate inventory investment and react more quickly to market changes.
Like other companies in the oil and gas industry, Forum has experienced a slowdown in its business. SmartForecasts enabled Forum to quickly adjust its inventories by running what-if scenarios and evaluating the risks involved with different actions. While it has only recently started to use Smart’s “Service Level Demand Planning” methodology, according to Rod Cardenas, purchasing manager, “the service level planning method has led to productive conversations between sales and supply chain and given us a platform or common ground from which we base our discussions.”
Forum now does intermittent demand forecasting for all of its components. That capability has been an important factor in increasing confidence in forecasting results. According to Cardenas, “SmartForecasts gives us good information to work with. People are feeling comfortable with numbers, and through our S&OP process we’ve been able to create buy-in across the company.”
Over four years Forum experienced revenue growth of 15-20% per year, and was able to do so without increasing inventory. Using SmartForecasts it has also been able to increase inventory turns from 1.8 times to an estimated 3.0 times this year.
Recently Forum began a vendor-managed inventory (VMI) program for its fasteners. SmartForecasts is being used to help vendors manage their bin sizes. Shifting inventory risk to its vendors, Forum has been able to reduce in-house inventory from 700,000 units to 100,000, and is expected that it will be able to turn its in-house inventory 12 times.
“We’re just scratching the surface of taking advantage of SmartForecasts’ capabilities, added Cardenas. “There’s a lot more we can do.”