Building a Defensible Savings Baseline Before Your Next Steering Review
Establishing a savings baseline that internal audit and category managers both accept requires documented PO-level rules—not a single spreadsheet pivot.
Every steering committee asks the same question in different words: "Compared to what?" A savings figure without a documented baseline is a talking point, not a metric. After dozens of engagements with Korean manufacturers and distributors, we see three recurring failure modes.
Failure mode 1: Mixing fiscal and calendar periods
Category managers often track savings by contract anniversary while finance reports by fiscal quarter. When these calendars diverge, a Q2 "win" in the category spreadsheet may fall in Q3 on the CFO's view. Before any visualization work, align period boundaries in writing and map each PO date to the agreed reporting window.
Failure mode 2: Category bleed from shared suppliers
A single supplier may serve MRO, packaging, and tooling from one master record. Allocating spend by GL code alone misattributes volume when PO descriptions are vague. We recommend a two-pass approach: first allocate by GL, then apply a supplier-specific override table maintained by category owners.
Failure mode 3: Ignoring one-time adjustments
Rebates, retroactive credits, and write-offs belong in a separate adjustment ledger—not silently netted into monthly spend. Steering committees lose confidence when a smooth trend line hides a KRW 400M credit buried in March.
Practical checklist
- Document baseline period and currency in the first page of your methodology appendix
- Store PO-level attribution rules in a version-controlled workbook
- Separate recurring spend from one-time adjustments before charting
- Have category managers sign off on supplier override tables before prototype delivery
These steps add a week to preparation but eliminate the revision cycles that plague rushed dashboard projects.