WIREFRAME work in progress, draft layout on sample data← Back
Draft. Colour is held back on purpose, except the red, amber, green health pills, so the layout is judged first.
Net sales (12 mo)
Rs 3523 Cr
11 brands
Volume
298 KT
tonnes shipped
Gross margin
28.4%
10.7% contribution
Trade spend
10.2%
share of net sales
Sales vs plan
+0.1%
against plan
Fill rate
95.1%
8 green · 1 amber · 2 red
Brand heatmap 11 brands · click any tile to drill in
Surya Edible OilsRED
StaplesWestDraft
Net sales (12 mo)Rs 632 Cr
Gross margin12.3%
Sales vs plan-3.9%
Fill rate90.7%
service below the 92 percent line
Frostbite FoodsRED
Frozen and DairyWestLate
Net sales (12 mo)Rs 191 Cr
Gross margin29.6%
Sales vs plan+7.1%
Fill rate91.7%
service below the 92 percent line
Sparkle Home CareAMBER
Home and PersonalNorthDraft
Net sales (12 mo)Rs 231 Cr
Gross margin29.4%
Sales vs plan-2.9%
Fill rate95.8%
Aanand AttaGREEN
StaplesNorthDraft
Net sales (12 mo)Rs 707 Cr
Gross margin19.0%
Sales vs plan-1.6%
Fill rate97.6%
Namkeen NagarGREEN
FoodsWestDraft
Net sales (12 mo)Rs 333 Cr
Gross margin34.3%
Sales vs plan-0.1%
Fill rate97.0%
Tashan BiscuitsGREEN
FoodsNorthDraft
Net sales (12 mo)Rs 306 Cr
Gross margin33.3%
Sales vs plan+3.8%
Fill rate96.3%
Komal Personal CareGREEN
Home and PersonalWestDraft
Net sales (12 mo)Rs 297 Cr
Gross margin44.0%
Sales vs plan-0.9%
Fill rate95.0%
Chai JunctionGREEN
BeveragesEastDraft
Net sales (12 mo)Rs 266 Cr
Gross margin38.1%
Sales vs plan+0.2%
Fill rate95.5%
Zing BeveragesGREEN
BeveragesSouthDraft
Net sales (12 mo)Rs 247 Cr
Gross margin41.0%
Sales vs plan+4.9%
Fill rate97.3%
Pavitra SpicesGREEN
FoodsSouthDraft
Net sales (12 mo)Rs 217 Cr
Gross margin35.9%
Sales vs plan+4.0%
Fill rate95.2%
Honeybee NaturalsGREEN
FoodsNorthDraft
Net sales (12 mo)Rs 96 Cr
Gross margin38.8%
Sales vs plan+7.4%
Fill rate94.6%
Commercial and supply layer

Sales vs plan, worst first

BrandSales vs planGross margin
Surya Edible Oils-3.9%12.3%
Sparkle Home Care-2.9%29.4%
Aanand Atta-1.6%19.0%
Komal Personal Care-0.9%44.0%
Namkeen Nagar-0.1%34.3%
Chai Junction+0.2%38.1%
Tashan Biscuits+3.8%33.3%
Pavitra Spices+4.0%35.9%
Zing Beverages+4.9%41.0%
Frostbite Foods+7.1%29.6%
Honeybee Naturals+7.4%38.8%

Trade spend vs plan

BrandActualPlanGap
Komal Personal Care15.9%16.0%-0.1%
Zing Beverages15.4%15.5%-0.1%
Frostbite Foods13.9%14.0%-0.1%
Honeybee Naturals13.3%13.5%-0.2%
Sparkle Home Care13.2%13.0%+0.2%
Tashan Biscuits12.2%12.5%-0.3%
Namkeen Nagar12.0%12.0%+0.0%
Chai Junction11.1%11.0%+0.1%
Pavitra Spices9.0%9.0%+0.0%
Aanand Atta6.6%6.5%+0.1%
Surya Edible Oils4.9%5.0%-0.1%

Service and inventory

BrandFill rateInv. days
Surya Edible Oils90.7%30
Frostbite Foods91.7%65
Honeybee Naturals94.6%55
Komal Personal Care95.0%47
Pavitra Spices95.2%46
Chai Junction95.5%42
Sparkle Home Care95.8%50
Tashan Biscuits96.3%43
Namkeen Nagar97.0%44
Zing Beverages97.3%37
Aanand Atta97.6%29
Sales and margin shape

Net sales vs plan, by category

Staples
Rs 1338 Cr / plan Rs 1376 Cr
Foods
Rs 952 Cr / plan Rs 927 Cr
Home and Personal
Rs 528 Cr / plan Rs 537 Cr
Beverages
Rs 513 Cr / plan Rs 501 Cr
Frozen and Dairy
Rs 191 Cr / plan Rs 179 Cr
Plan comparison to be confirmed against the signed budget.

Net sales by channel

Rs 3550 CrNET SALES, 12 MO
GTGeneral TradeRs 2019 Cr · 57%
MTModern TradeRs 750 Cr · 21%
QCQuick Commerce and E-commerceRs 414 Cr · 12%
INSTInstitutional and HoReCaRs 283 Cr · 8%
EXPExportsRs 84 Cr · 2%

Net sales and contribution trend

Trend chart goes here in the build.
Four quarters, all brands, recomputes when filtered.
Data health the reconciliation layer, built in
Data issues to fix
12
Brands flagged (risk)
3
Rows reconciled
8,010
Checks run
7
2 channel split below brand total1 missing submission1 service below threshold1 inventory days outlier1 margin step-down1 trade spend over plan1 payables timing1 wastage spike1 duplicate channel row1 price master stale1 draft not final
BrandExceptionPeriodSeverity
BR003Channel split below brand total2025-10-31High
BR007Channel split below brand total2025-11-30High
BR009Missing submission2024-02-29High
BR005Service below threshold2026-02-28High
BR005Inventory days outlier2026-01-31Medium
BR002Margin step-down2026-03-31Medium
Separates a data problem to fix from a real business risk to escalate.