When Inventory Policy Becomes Theater: The Spreadsheet Reality

Policy vs. Reality

• Inventory policies display what should happen. Safety stock calculations follow documented formulas. Batch sizes reflect standard economics. Reports show clean numbers. Dashboards confirm inventory is optimized.

• Reality runs parallel. Teams keep shadow spreadsheets since systems capture decision-making that was made years ago. Judgment is used to override calculations by the planners. Site managers liaise with each other by calling and email. Due to lagging system status, operators keep personal records of real availability.

• The divergence is not intentional resistance. It is a rational adaptation to a fundamental mismatch: inventory policies were designed for 2010 stability while operating in 2025 volatility.

The Policy Shows One Story

Pharmaceutical inventory policy is developed based on assumptions of 2005-2015 when the demand was predicted each year, the supply chains were predictable and market disruptions were viewed as exceptions. Such reasoning developed reasonable rules: 45 days safety stock, fixed batches, monthly order.

Today, conditions inverted. Demand shifts quarterly. The disruptions in supply occur once a month. The regulatory requirements are volatile. But as of 2010, inventory policies continue to control 2025.

Documentation seems to be clean formulae that have been put in writing, computations that can be verified, measures that demonstrate that the policy is functioning. In the meantime, the real inventory choices are made along lines which the policy never considered.

Why Inventory Decisions Move Outside Policy

1. Where the policy is incapable of adjusting, pressure evades workarounds.

2. Lead times are unpredictable. The policy presupposes delivery within 12 weeks. Sometimes 8 weeks, sometimes 16. Planners also operate their own performance monitors and also make an order adjustment by direct contact with the supplier not via the system.

3. Demand variability increased. Policy uses past-year data. The spreadsheets are used by regional planners to predict market-specific demand and override system suggestions via email since the system does not have fields to indicate the presence of demand shifted by competitor launch.

4. Regulatory constraints. Policy defines inventory without taking into consideration compliance requirements, recall requirements, tracking of lots, cold chain buffers. Separate documentation is upheld by compliance teams whilst operations enforced informal policies.

5. Exceptions are routine. Policy presumes that exceptions are exceptional. In pharma, they occur once a month. Through team relationships, only direct relationships solve the problem, not escalation processes. A manufacturing director calls distribution: Saying: We are experiencing a product X demand spurt, change your forecast. The decision is carried in the phone call. The result is subsequently recorded in the system.

6. Each workaround feels temporary. Over months, teams build invisible infrastructure carrying actual inventory decisions. The policy has become theater. It documents what the company says it does, not what it actually does.

The Strain Is Not Visible in Metrics

• Dashboards display green while teams maintain two parallel systems: official policy and the real one.

• A planner's day: receive demand signals, apply judgment, manually adjust recommendations. Then input whatever the system expects and enter data retrospectively to satisfy reporting. First activity is where decisions happen. Second is compliance theater.

• A site manager coordinates through calls, negotiating who holds buffer stock based on current supply and demand. These negotiations are invisible. After decisions are made through relationships, inventory is moved and records are updated. The system records the end state, not the decision process.

• An operations director maintains personal spreadsheets tracking inventory across sites because official dashboards lag three days. When inventory risks running short, the director knows this through private tracking, not system alerts. Decisions happen through calls.

• Cost is invisible and distributed: time maintaining duplicate spreadsheets, decisions verified through back channels, coordination outside formal processes, mental load of tracking two inventory truths.

• The organization appears functional because execution is routed around policy limitations. This depends on specific people with institutional knowledge, high individual effort compensating for system inflexibility, and relationships replacing trust in policy. Not sustainable at scale.

Trust in the Policy Erodes

Operators no longer trust inventory policy when that policy fails to align with operational reality. Planners cease to look at the system and consult colleagues. Inventory is verified by the site managers using reports by the warehouse staff. The operations directors develop their demand models. Such erosion is logical, they have been betrayed by the system too many times to the point where they are now verifying.

This distrust is passed to new employees automatically. Onboarding educates on the official and actual procedure. Record your own recommendation in the system to facilitate audit purposes only but negotiate the decision with your contact with the site manager. The distance is institutionalized knowledge that is transferred in an informal manner by the experienced individuals to the inexperienced.

This is a weak knowledge transfer. It relies on informal instruction, is susceptible to changes of teams and not reliably scalable. However, it is important since the official system cannot be relied upon.

Adding More Controls Makes It Worse

• Usually, when inventory challenges arise, the common reaction is to enhance governance: adding more approval layers, adding more documentation, adding more strict safety stock equations, and adding compliance inspections.

• Each of the controls deals with a symptom and does not diagnose the reason work got out of the system. The teams react by creating additional workarounds. In case there are three approval layers to the system that reduce inventory, planners will organize reductions outside the system and keep records afterward.

• Rigidity increases. Reality fragments further.

• The system turns into nothing but a compliance layer. Steps are being taken by people to please auditors, not enhance optimization of inventory. Control makes the official record less accurate since control and operational efficiency begin competing rather than complementing each other.

• The adherence is increased in the reports and the increasing gap between the activity recorded and the actual inventory management is not visible in leadership. The system seems to be more controlled and the reality to be less coordinated.

What Inventory Reports Cannot Detect

1. Inventory dashboards report what is logged, not what occurred. Standard reporting measures safety stock levels, inventory turns, cycle times, and forecast accuracy. What it does not show: manual reconciliations before data entry, phone calls bypassing the system, spreadsheets reflecting true demand signals, escalations through personal relationships, inventory positioned through informal agreement, decisions made through email instead of workflow approvals.

2. The gap compounds over time. As more coordination moves outside the system, reported metrics become increasingly disconnected from operational reality. Inventory appears more efficient while actual strain increases. Data and reality move in opposite directions.

3. Leaders make resource allocation decisions based on incomplete information, believing dashboards reflect true performance when they reflect fiction.

The Real Question Beneath the Problem

• Most pharma companies approach inventory optimization as a technical problem: better forecasting, tighter systems, more data. The actual problem is structural: the inventory policy is built on a time period that no longer exists. Better data within the same policy structure will not solve this.

• The real question is not "how do we optimize inventory within our current policy?" The real question is "does our policy reflect how inventory decisions are actually made in 2025?" When the answer is no, optimization efforts fail. Teams compensate through workarounds. Metrics improve while strain increases. Dashboards show green while the system becomes increasingly fragile.

Diagnosis Must Precede Optimization

Before changing inventory policy or systems, understand how inventory decisions actually happen:

Map real flows, not documented ones. Find out at what point decisions are being made. Documentation: communications that matter. Follow the resolution of urgent exceptions. Talk to the people who do the work, they understand where the friction is, what steps will not add value, what approvals are rubber stamps, where they work around the system and why.

The goal is understanding the actual decision structure and building policy that reflects it instead of contradicting it, which is where life science supply chain consulting becomes critical.

What Actually Works

• A functional inventory policy makes inventory coordination easier, not harder. Teams rely on it voluntarily because it reflects reality: safety stock targets match actual demand variability, batch sizes reflect current economics, inventory levels align with regulatory requirements without separate documentation, approval authority matches where decisions are actually made, system status is current, and exceptions are acknowledged as routine.

• The measure of a working inventory policy is simple: people use it because it makes their work easier, not harder.

• To see how similar challenges play out in practice, read our case-study on improving operational consistency in regulated pharma operations.

• Listen to this article on Spotify - Why Pharma Companies Are Losing Millions in Their Own Warehouses