The current downturn is putting pressure on companies not just to reduce costs but also to reduce the working capital requirements. A significant portion of working capital is money locked up in inventory in the form of raw material, finished goods and work-in-progress. In most organizations, the typical management approach towards reducing the inventory is by target setting – if one wants to reduce inventory, just force a target on managers. We assume that managers will, somehow, find a way out to get the numbers. As long as numbers are met, the means can be justified. Since everyone knows the official recording date of inventory, managers take “appropriate” steps to ensure that part of the inventory, which is under their control, is kept as low as possible on the record date. For e.g. Purchase department can stop the entry of trucks bringing in the raw material inventory on the last 2 days of the month. (It is not uncommon to see trucks loaded with raw material waiting outside the gate of companies only to be brought in on the 1st of next month). The downside is reduced production levels in the first week of the month or even additional demurrage charges to the transportation companies. The upside is of course to have fewer inventories reported on the record date. Similarly, Sales & Logistics would try to dispatch whatever FG they can, so that FG inventory will be low. Some companies go to the extent of opening credit limits of their distributors to dispatch a  large part of the monthly target in the last few days. The downside of reduced distributer off-takes in the first few weeks of the next month and the gradual build of finished goods inventory in production is hidden from the monthly MIS reports. Similarly, to show better numbers in month-end WIP, production managers try to reduce WIP by not taking new batches on the last couple of days of the month leading to capacity wastages. In a made-to-order company, a month-end pressure can force a dispatch of partial orders to get the numbers. If payments are linked to full orders, then such actions may just shift the inventory into receivables. The “myopic” actions are possible because of the way inventory is tracked in companies. For most of the companies, inventory is officially recorded only on the last day of each month. This record is then plotted as a trend graph over a long period of time with each data point showing month-on-month inventory under various categories of RM, WIP, and FG & TOTAL. The shape of the trend line shows whether the inventory is increasing, decreasing or remaining constant. The “artificial” reduction of inventory by tweaking the system at the month’s end, does not meet the real purpose of the business. The working capital requirements of a company are controlled more by the peak requirements of the month rather than the reduced number at the month’s end. The problem can be easily visualized if one keeps  track of inventory at a daily level. The dichotomy between “monthly” reporting and “daily” reporting can be best explained by analyzing the graphs given below. Figure 1 below is a typical graph of inventory over 1 year as recorded on the last date of each month. As can be seen, it is varying in a very narrow range of about Rs. 4 Cr. (from Rs. 38 Crs to Rs. 42 Crs.). <figure class="image"><img style="aspect-ratio:16668/12339;" src="https://backend.vectorconsulting.in/storage/editor_uploads//pmb-blog-20-img-1-01_1738570931.jpg" width="16668" height="12339"></figure>It gives an impression that the average inventory of the company is about Rs. 40 Crs.Figure 2 below shows a typical graph of inventory as recorded on each date of a typical month. As can be seen, the variation in this case is over a much larger range of Rs.40 Cr to Rs. 50 Cr. The average inventory in the month is about Rs. 48 Cr. On the first 2 days & last 2 days of the month, a sharp decrease in inventory can be observed. The reason for this sharp decrease is the various steps as described above, taken by people to show fewer inventories on the record date (which is the last date of the month).<figure class="image"><img style="aspect-ratio:16668/11990;" src="https://backend.vectorconsulting.in/storage/editor_uploads//pmb-blog-20-img-2-01_1738570941.jpg" width="16668" height="11990"></figure>The reason why top management wants inventory to be low is to keep carrying costs & working capital under control. To check whether this goal is being achieved or not, they look at an MIS which shows them Figure 1.What is the conclusion from looking at Figure 1? It indicates that the average inventory is about Rs. 40 Cr. So, the working capital & carrying costs would be in accordance with this number. What is the reality? It is Figure 2. It indicates that the average inventory of the company is about Rs.48 Cr (& not Rs. 40 Cr). So, the actual working capital & carrying costs are significantly higher than what the MIS indicates. The key question before us is, why do many companies follow MIS practices, which in a way hide the brutal reality? The main reason is the monthly planning system. Most consumer goods companies have material and demands planning which are re-set for every month (the period is higher for long lead time environment). In a monthly system, the demand on the supply chain is not corrected throughout the month, so everyone tries to move as per the original plan regardless of demand variations. As we reach the month-end, the demand is corrected based on likely month-end stocks and likely sales for the next month. This correction starts from customers to the sales team to the production and finally to the suppliers. The production department gets a sales forecast just before the start of the month (based on the distributor netting off his inventory), which in turn is “netted” based on expected production in the last few days and then passed on to materials, who derive the “netted” raw material requirement and place orders on vendors. There is a lead time to finish the netting process  since the process starts only at the previous month’s end. The vendor’s reaction to supplies to the new plan starts getting into the planned month. As the material starts arriving, the capacity utilization remains low in the initial part of the month, more so in cases where production is an assembly of various raw material components – the kits start completing towards mid of the month causing a skew in production volumes. Nobody complains, as sales orders are also skewed towards the end of the month. Close to this period, it’s a huge effort to flush out the inventory out of the system. The overtime goes and logistics goes into an overdrive to do a huge volume of dispatches. The sensitivity to small logistics issues becomes a crisis as a few days of Murphy can lead to targets going haywire. The skewed billing in the last few days of the month end also creates a wave of receivables. The cash coming into the company also follows a skew.This way of monthly planning creates the “inverted U” shaped (inventory peaks at the middle of the month) inventory profile across the weeks of the month. The “U” effect further gets aggravated when managers “manipulate” the system to show low numbers.Some organizations have tried to solve the problem by creating monthly plans much earlier in the previous month or using the concept of rolling plans (next month fixed and subsequent 2 months tentative). But the sales team always tries to move closer to the end of the month as it provides more accurate netting. At the same time, the rolling plans are not used much because of high errors. Over the years, for most companies, the “inverted U curve” effect is accepted as part of typical corporate “life” as the stress levels also peak towards month end. Going home late towards the month’s end is almost a norm for many managers across companies. The first step towards solving this problem is to create an MIS, which does not lie – the daily trend of inventory profile. A daily trend is not susceptible to manipulations as the manipulation can be easily detected. So if a target for inventory reduction has to be given, it should be to reduce the peak of the inventory during the month. This will prevent the “manipulation” actions, which usually aggravate the steepness of the curve. With a daily inventory MIS, the steepness of the curve might reduce but the basic form of U shape will remain as long as one follows the monthly system. The only way the effect can go away is to move away from the monthly planning system to a perpetual daily planning system where demand “netting” is done on a daily basis by all partners in the chain. This way of planning was technically infeasible about 50 years back when there was no supporting information technology. Today most of the ERPs and connectivity technologies can support a daily planning process. The shift from monthly planning to daily planning is actually not a technology issue – it is an issue of paradigm shift in the minds of managers. Most companies make decisions on inventory creation and movement based on pre-decided targets set in the monthly planning phase whereas a daily planning system requires inventory creation and movement to be based on daily flow signals from the downstream point of the chain – a pull signal. This calls for separating the planning phase from the execution. The shift not only eliminates the disastrous inverted “U” curve effect of inventory but also increases the output of the plant as utilization goes up in the first week. The dispatches become more uniform and collections become due throughout the month. The net effect is a much reduced working capital requirement.

BA Read More

Problem: Many organisations unknowingly inflate their working capital needs because their planning approach demands excess buffer inventory (without necessarily improving service levels) due to overly conservative forecasts.<o:p></o:p> <o:p></o:p>Solution: Instead of static safety stock, adopt demand-driven planning with buffers dynamically adjusted based on actual lead times and variability, supported by synchronised replenishment cycles across the supply chain.<o:p></o:p> <o:p></o:p>Benefits: Working capital requirements are reduced, cash is freed up, inventory levels drop without compromising service, and operational agility improves. The organisation becomes also becomes better able to respond to market fluctuations.<o:p></o:p>

Key Takeaways

Traditional monthly inventory reporting can be 'manipulated' to show lower inventory levels on month-ends. However, it does not reflect the company's true working capital needs. A daily inventory management system based on market pull provides transparency, and sustaiably reduces inventory -eliminating the need for any manipulations.