500 SKUs killed + Phantom stock released for a $50 Mn F&B Household FMCG
Forging a
data-driven legacy
A $50M F&B brand was scaling aggressively. Nobody knew the true cost of a single SKU.
25 most valuable consulting brands
The CEO Magazine’s 2022 Survey of Top Consulting FirmsΒ 
8.9 for consulting outcomes
Prequate’s Client Survey Grail Report 2022
9.1 for engagement
 team quality
Prequate’s Client Survey Grail Report 2022
50 fastest growing advisory
SIndia’s Annual Survey
THE CLIENT

A household name in the F&B landscape with decades of history, renowned for quality, now expanding from pure-play F&B into the FMCG/CPG sector.

Clocking ~$50M in revenue and on track to hit $70M in the year, the brand was scaling aggressively across channels and geographies. But underneath the growth, there was a systemic lack of visibility at the unit level on SKU COGS.

An underutilized ERP system masked the true material journey. Decisions were made without a framework β€” driven by hunch and emotion rather than data β€” leaving leadership and finance misaligned on the numbers that mattered most.

Industry
F&B expanding into FMCG/CPG
Stage
~$50M β†’ $70M revenue, scaling
Location
Multi-facility, national footprint
Size
5,000+ SKUs
Our Offering
Operational Excellence & Cost Architecture
theΒ problem
Scaling fast, but flying blind
01

Financial obscurity & poor cash-flow

A systemic lack of visibility at the unit level on SKU COGS made true profitability impossible to see.

‍

02

Processes are black-boxes

An underutilized ERP system existed, but it masked rather than revealed the actual material journey.

‍

03

Stakeholder misalignment

Decisions were made without a framework β€” driven by hunch and emotion instead of shared data.

‍

THE SOLUTION
Because you cannot build without fixing how your products are recorded
PHASE 1
Build a

scalable codification engine

Because you cannot build without fixing how your products are recorded.

‍

STAGE 1
Audit the existing landscape
  • Orchestrated a full deep-dive of 5,000+ SKUs β€” uncovered rudimentary and inconsistent tracking
  • Stress-tested existing ERP systems β€” found them drastically underutilized and incorrectly configured

‍

STAGE 2
Engineer the new codification
  • Implemented a new 4-tier smart product codification system used by FMCG majors in the country
  • Created centralized BOM profiles linking all input pricing directly from systems of record

‍

STAGE 3
Deploy, rationalize & scale
  • Ran a single-day migration to the new code structure across all retail outlets, production, and warehousing facilities
  • Reduced Goods Received Note data errors by 90% and eliminated phantom inventory

‍

BEFORE
Rudimentary, inconsistent product codes β€” the same product showed different costs Unknown true COGS for 400–500+ SKUs, making margin analysis impossible 5,000 SKUs with multiple redundant entries cluttering the system
AFTER
Unified 4-tier codification ensuring product cost is identical regardless of sales channel True channel profitability analysis enabled for the first time Clean, rationalized SKU master, scalable for FMCG/CPG expansion
PHASE 2
Eliminate existing

manufacturing black-boxes

Because once you know the truth, you fix how you're tracking it.

‍

Material journey tracking
Traced every stage
  • Reconfigured ERP systems to track raw materials through every production stage
  • Made wastage visible at the SFG processing stage for the first time
  • Enabled precise throughput measurement at the finished goods stage

‍

SKU & inventory rationalization
Cleaned the catalogue
  • Led intensive inventory rationalization across the entire product catalogue
  • Eliminated phantom inventory created by data hygiene issues over several periods
  • Built a granular, clean, scalable product master ready for CPG expansion

‍

ERP & FinOps re-engineering
Unlocked the system
  • Unlocked the full potential of the client's existing ERP system
  • Re-engineered manufacturing process flows to mirror actual production
  • Created a single source of truth for all operational and financial data

‍

PHASE 3
Enable

data-driven strategic decisions

Because after the data is clean and the system is live, strategy becomes possible.

‍

01
Establish true SKU profitability
  • Leadership can now identify and eliminate unprofitable products, earlier hidden by flawed costing
  • True COGS visible for every SKU across channels, for the first time

‍

02
Activate smarter supplier management
  • Newly visible throughput data used to objectively assess vendor quality
  • Data-backed supplier negotiations replacing gut-feel procurement

‍

03
Build growth & institute culture
  • Leadership can now evaluate retail, online, and export expansion using actual channel-wise profitability
  • Fostered a company-wide shift from emotion-driven to evidence-driven decision-making

‍

theΒ impact
engineering enterprise value across the organization
The Prequate difference

We operate as an indispensable extension of the Owner's office β€” providing the strategic financial horsepower to spot emergent problems, identify new growth avenues, and achieve the long-term vision.

We are not a consultant. We are a partner in enterprise value creation.

‍

TRANSFORMED

A $70M F&B brand with opaque data systems

a data-backed decision system

‍

ESTABLISHED

An error-prone supply chain setup Β 

100% visibility across 4,000+ SKUs

‍

REPLACED

Decisions made on gut and emotion Β 

a data-first & framework culture

‍

UNLOCKED

800+ redundant product lines Β 

growth-focused lines for strategic thinking

‍

THE RESULT
800+
Redundant SKUs eliminated from the master catalogue
90%
Reduction in Goods Received Note data errors
4,000+
SKUs now with 100% cost & channel visibility
$70M
Revenue scale the new system is built to support
We went into a $70M F&B and retail business and gave the leadership team something they had never had: the ability to make product decisions based on exactly what a product actually costs. No assumptions. Eight hundred redundant SKUs were eliminated. Every product's true COGS visible for the first time.
– Prequate Team
See ways we have partnered in institution building
Get full-stack strategy to execution with Prequate
Prequate Advisory partners with the most ambitious promoters to turn strategy into outcomes and latent potential into enterprise value.
Subscribe to
Our Industry Insights
Be the first to discover trends, inspirations, and special offers as we bring the world of capital directly to your inbox
Rated 8.5 / 10 by people just like you.