Skip to content
Back to work

Enterprise Tools

Factory Planning Audit

Traces a production planning workbook backwards, from output sheets to the formulas feeding them.

Status
Delivered
Year
2026
Discipline
Enterprise Tools
Client
Global FMCG company

Overview

Large planning workbooks accumulate formula chains nobody fully remembers. This tool starts from the sheets people actually read — targets, pivots, tracking, release — and walks the dependency chain backwards, mapping which columns feed which result across two production sites. The output is a written critical-path document rather than a diagram, so the reasoning behind a number can be reviewed and challenged.

What matters

  • Starts from the sheets people read, not from the raw data
  • Maps column-level dependencies across two production sites
  • Produces a reviewable written document, not just a diagram

Client name withheld under confidentiality.