The festival weekend problem
You run eight stores, and stock for all of them lives in a set of spreadsheets that grew over the years. They work. Everyone knows where to look. Then, in the week before a festival, someone adds a new product line and forgets to copy a formula down one column. Nobody notices, because the sheet still opens, still shows numbers, and the numbers still look plausible.
On Saturday, three stores run out of the item that sells best, at the moment demand is highest.
What it costs
Consider a hypothetical. Three stores each sell ₹60,000 a day of a fast-moving festival range at a 20 per cent margin. If the range is out for three days in a peak week, that is three stores times three days times ₹60,000, or ₹5.4 lakh of sales and about ₹1.1 lakh of margin. Add the customers who go to a competitor and do not return, and the figure is easily double. If the item is more expensive or the stores are busier, the loss grows quickly.
The point is not the exact number. It is that one cell, wrong for a few days, can cost more than a year of software would. And the loss does not show up as an error. It shows up as “bad luck at the weekend”.
Why it happens
Spreadsheets are flexible, which is exactly why they are fragile at scale. Anyone can edit any cell. There is no record of who changed what. A formula can be overwritten by a typed number without any warning, and a sheet that three people update will, sooner or later, have three versions.
Four conditions make the risk rise as a business grows:
- More stores means more sheets and more hand-offs between them
- More products means more rows where a formula can break
- More people editing means less certainty about which figure is current
- Peak periods bring the most changes at the moment there is least time to check
Peak weeks make this worse in a specific way. Demand forecasts get adjusted, new items are added in a hurry, and prices change. These are exactly the edits most likely to break a formula, and exactly the weeks when a mistake costs the most.
What changes it
You do not have to abandon spreadsheets overnight. First, reduce the ways they can fail. Separate the sheet where people enter data from the sheet that calculates, and lock the calculating one. Give each store one owner, and one named person who checks the totals before every peak period.
Second, add a control that does not depend on the formulas: a weekly reconciliation where each store counts a handful of fast-moving items and compares them with the sheet. A difference above an agreed tolerance triggers a check. It takes thirty minutes and catches a broken formula within a week.
Third, decide what a single reliable stock record would need to do for your business: update on every sale and transfer, show stock by store, and warn when a fast item falls below its reorder level. That is the point at which a proper system earns its cost, and you will be able to judge vendors against a clear list instead of a demonstration.
What this does not fix
A system does not remove human error. It moves it: wrong reorder levels, wrong product codes and unrecorded transfers still happen, and a badly set up system can be just as misleading as a sheet. Moving too soon, before the process is clear, usually reproduces the old mess in a more expensive place.
To see how working capital and stock decisions interact as you add stores, try the working capital tool.