Supply Chain · Operations

Is your planning method eating your working capital?

Mohit Saini · 12 May 2021 · 4 min read

Is your planning method eating your working capital?

When cash gets tight, most companies reach for the same lever: an inventory target. Each department is told to bring its raw material, work-in-progress or finished goods down to a number, and the numbers are checked at month end.

Within a few months, the month-end report looks much better. But has the company actually released any working capital?

How a month-end number is met

Everyone knows the date on which inventory is recorded, so people do what any sensible person would do: they make sure inventory is low on that date.

  • Purchase holds trucks of raw material outside the gate for the last two days of the month and unloads them on the first.
  • Sales and logistics push as much finished stock as possible to distributors in the last week, sometimes by relaxing credit limits.
  • Production avoids starting new batches in the last few days, so work in progress drops.
  • In make-to-order businesses, partial orders are dispatched to show lower inventory, sometimes simply turning inventory into receivables.

None of this is dishonest. It is the natural response to a measure taken on one day.

What the month-end report hides

Let us imagine two graphs for the same company.

Graph 1: inventory on the last day of each month, over a year. It moves within a narrow band, say between ₹550 million and ₹600 million. Management concludes that the company carries about ₹570 million of inventory.

Graph 2: inventory on every day of one month. It starts low on the 1st, climbs steadily, peaks at around ₹700 million in the middle of the month, and drops sharply in the last few days. The average across the month is close to ₹660 million.

The working capital the company really needs is driven by Graph 2: by the peak and the average across the month, not by the dip on the last day. The month-end report shows the cleanest moment of the month, not the reality.

Working capital is decided by the peak of the month, not the last day of it.

The gap is not small. The difference between the ₹570 million that management believes it carries and the ₹660 million it actually carries on an average day is ₹90 million. At a borrowing cost of 10%, that is about ₹9 million a year in interest alone, before counting the overtime, urgent freight and discounts that come with the month-end rush. None of it appears on the report that everyone reviews.

Why the curve looks like an upside-down U

The shape is not an accident of measurement. It comes from monthly planning.

Here is how a typical monthly cycle runs:

  1. Just before the month starts, sales estimates next month’s demand, adjusting for stock in the channel.
  2. Production nets this against what it expects to finish in the last few days, then passes requirements to purchase.
  3. Purchase nets again and places orders on suppliers.
  4. Suppliers, who also plan monthly, start reacting well into the new month.

So the first week of the month is slow: material is still arriving, kits for assembly are incomplete, and capacity is underused. By the middle of the month, material has arrived and inventory peaks. In the last ten days, the plant and logistics go into overdrive to dispatch the month’s volume, with overtime and urgent freight. Billing bunches at month end, so collections bunch too.

Many managers accept this as part of life. Working late at month end is almost a tradition.

Two steps out of the trap

Step 1: measure honestly

Track inventory daily, and set any reduction target on the peak or the monthly average, not the month-end figure. A daily trend can’t be gamed by holding trucks at the gate for two days. This alone stops the actions that make the peak worse.

But it won’t remove the upside-down U. As long as planning runs in monthly cycles, the curve stays.

Step 2: plan daily, from actual demand

The real fix is to move from a monthly plan to a daily, consumption-based flow:

  • Each link in the chain (distributor, warehouse, plant, supplier) replenishes what was actually consumed yesterday, against a stock buffer sized for its replenishment time.
  • Production priorities are set daily by buffer status, not by a monthly plan made weeks earlier.
  • Suppliers receive daily signals instead of a monthly schedule.

Fifty years ago, daily planning wasn’t practical. Today, any ERP and basic connectivity can support it. The barrier is not technology. It is the habit of planning in monthly buckets and managing to monthly targets.

What changes

When companies make this shift, a few things happen together:

  • The first week of the month stops being slow, so output goes up.
  • Dispatches spread across the month, so logistics costs and overtime come down.
  • Billing and collections spread out, so cash flows more evenly.
  • The mid-month peak shrinks, so real working capital falls, not just the month-end number.

The month-end report may change less than you expect. The bank balance will change more.

Related reading

Mohit Saini

Strategy, supply chain & sales transformation consultant. About · Book a discussion