KPI Dashboard

Real-time performance metrics and analytics

Perfect Order Rate

96.2%

Traditional Trade 95.8%

Modern Trade 97.1%

E-Commerce 96.5%

Q-Commerce 95.0%

Forecast Accuracy

92.4%

Traditional Trade 91.2%

Modern Trade 93.7%

E-Commerce 94.1%

Q-Commerce 90.8%

Demand Volatility (per wk)

Traditional

Modern

E-Commerce

Q-Commerce

Madbury

12%

18%

25%

22%

7-Star

15%

20%

28%

32%

Cilka

10%

14%

21%

26%

Low

Medium

High

Very High

Raw Materials Scorecard

Composite Score 87.5

Cocoa Beans 89.2

Sugar 92.1

Milk Solids 85.7

Nuts 83.4

Flavors 87.3

Packaging Materials Scorecard

Composite Score 82.8

Primary Laminates 85.3

Secondary Outers 79.6

Assorted Packs 81.2

C-Boxes 84.7

Analytics Dashboard Preview

Manufacturing Dashboard

Select Plant:

OEE %

84.5%

↑ 2.3% vs last week

Downtime Hours

12.5

Planned: 8h | Unplanned: 4.5h

Batch Yield %

96.2%

↑ 1.1% vs target

Energy/Tonne

142 kWh

↓ 8% vs last month

On-Time Orders %

93.7%

↑ 5.2% vs last week

Raw Material Levels

Cocoa Beans 78%

Sugar 85%

Milk Solids 92%

Nuts 45%

Reorder

Flavors 67%

SKU Inventory @ Plant

SKU	Units	DOH
Madbury	1,247	8.5
7-Star	892	6.2
Cilka	2,134	12.3

Production Belts

Belt A

SKU: Madbury

Speed: 85%

Uptime: 92%

Status: Running

Belt B

SKU: 7-Star

Speed: 78%

Uptime: 89%

Status: Running

Belt C

SKU: Cilka

Speed: 0%

Uptime: 0%

Status: Maintenance

Workforce Snapshot

Total Employees 247

Shift Coverage 96%

Absenteeism 4.2%

Maintenance Tickets

Last Maintenance May 15, 2024

Next Due May 22, 2024

Open Tickets 3

Live Logistics Tracking

Truck #MH12-3456

Status: Inbound RM

ETA:

Inventory Dashboard

Real-time inventory tracking across all locations

Inventory Turnover

6.2x

↑ 1.1x vs last month

Avg DOH

18.5

↓ 2.3 vs target

Stockout Incidents

↓ 5 vs last month

Write-offs %

0.8%

↓ 0.3% vs last month

Warehouse Utilization

87%

↑ 5% vs last month

Inventory by Plant

Plant	SKUs	Units	Value
Pune	3	2,450	₹24.5L
Chennai	3	3,120	₹31.2L
Gurgaon	3	1,890	₹18.9L
Bhopal	3	2,100	₹21.0L

SKU Inventory

Madbury

Inventory: 2,450 units

DOH: 8.5 days

Status: Healthy

7-Star

Inventory: 3,120 units

DOH: 6.2 days

Status: Healthy

Cilka

Inventory: 2,100 units

DOH: 12.3 days

Status: Overstock

Inventory Aging Analysis

0-30 days 85% items

30-60 days 12% items

60-90 days 2% items

90+ days 1% items

Distribution Centers

Total Centers 25

Active SKUs 75

Total Stock Value ₹95.6L

Raw Materials by Plant

Plant	Material	Stock	Status
Pune	Cocoa Beans	450 kg	Adequate
Chennai	Sugar	620 kg	Adequate
Gurgaon	Milk Solids	280 kg	Low

Packaging Materials Scorecard

Primary Laminates

Composite Score: 85.3

Secondary Outers

Composite Score: 79.6

Demand Volatility Heatmap (per week)

Traditional

Modern

E-Commerce

Q-Commerce

Madbury

12%

18%

25%

22%

7-Star

15%

20%

28%

32%

Cilka

10%

14%

21%

26%

Forecasting Dashboard

AI-powered demand forecasting & capacity planning

Forecast Accuracy %

92.4%

↑ 3.2% vs last month

Capacity Utilization

87.3%

↑ 5.1% vs last week

Flexibility Index

8.7

↑ 0.5 vs target

Contractor Dependency %

15.2%

↓ 2.8% vs last month

Scenario Coverage

12/mo

On track

Sales Trends by SKU

Madbury - Last 30 Days

+12.5%

7-Star - Last 30 Days

+18.7%

Cilka - Last 30 Days

+8.3%

AI Forecasting Assistant

You:

"What if +15% Zepto demand in Mumbai next week?"

AI:

Based on current inventory and capacity, we recommend increasing Madbury production by 200 units and expediting supply to Mumbai RDC.

Network Capacity Utilization

Plants 87.3%

RDCs 92.1%

Micro-DCs 78.5%

Co-Manufacturing 65.2%

Current Inventory Snapshot

Raw Materials

Cocoa Beans 2,450 kg

Sugar 1,890 kg

Milk Solids 1,245 kg

Finished Goods

Madbury 2,450 units

7-Star 3,120 units

Cilka 2,100 units

Digital Data Analytics Tablet Modern Office Workspace

Sales Dashboard

Real-time sales performance across all channels

Distributor Fill Rate %

94.7%

↑ 2.3% vs last week

On-Shelf Availability %

91.2%

↑ 1.8% vs last week

Sell-through Rate

78.5%

↑ 3.7% vs last month

Sales/Distributor

₹1.24L

↑ ₹15K vs last month

Top-10 SKU Contribution %

67.3%

↓ 2.1% vs last month

Distributor Performance Leaderboard

Rank	Distributor	Revenue	Growth
1	Metro Distributors, Mumbai	₹34.5L	+18.7%
2	Rapid Retail, Delhi	₹28.9L	+12.3%
3	Fresh Mart, Bangalore	₹25.7L	+22.1%
4	City Stores, Chennai	₹22.3L	+8.9%

Live Stock with Distributors

Madbury

Total Units: 12,450

Avg Days Cover: 8.2

7-Star

Total Units: 9,875

Avg Days Cover: 6.7

Cilka

Total Units: 15,200

Avg Days Cover: 11.4

Regional Demand Surges (Last 7 Days)

Mumbai

+32% spike in Madbury demand

High Priority

Delhi

+24% increase in 7-Star sales

Medium Priority

Bangalore

+18% growth across all SKUs

Monitor

SKU Performance Analysis

Top Performing SKUs

Madbury - Mumbai +32%

7-Star - Delhi +24%

Cilka - Bangalore +18%

Channel Distribution

Traditional Trade 45%

Modern Trade 28%

E-Commerce 19%

Q-Commerce 8%

Growth Metrics

Total Revenue ₹2.34Cr ↑15%

Active Distributors 1,647

Coverage % 91.5%

Sourcing Dashboard

Supplier performance tracking and risk management

Supplier OTIF %

94.2%

↑ 3.1% vs last month

Quality Index

8.7/10

↑ 0.5 vs last month

Lead Time Variability

±2.3d

↓ 0.7d vs last month

% Sustainable/Certified

78.5%

↑ 5.2% vs last month

Supplier Risk Score

3.2/10

Low Risk

Supplier Scorecard

Cocoa Beans - Ghana Farms

Composite Score 89.2/100

OTIF: 96.5% | Quality: 9.1/10 | Lead Time: 12d±1.2

Sugar - Brazil Mills

Composite Score 92.1/100

OTIF: 97.8% | Quality: 9.3/10 | Lead Time: 8d±0.8

Milk Solids - New Zealand Dairy

Composite Score 85.7/100

OTIF: 91.2% | Quality: 8.9/10 | Lead Time: 15d±2.1

Nuts - California Farms

Composite Score 88.4/100

OTIF: 94.3% | Quality: 8.7/10 | Lead Time: 18d±1.5

Flavors - Netherlands Extracts

Composite Score 91.3/100

OTIF: 96.7% | Quality: 9.2/10 | Lead Time: 10d±0.9

Purchase Order Status

PO-2024-0156

Cocoa Beans - 500kg

In Transit → ETA: May 22

PO-2024-0157

Sugar - 750kg

Delivered → May 18

PO-2024-0158

Milk Solids - 400kg

Delayed → ETA: May 25

PO-2024-0159

Nuts - 300kg

Open → Pending confirmation

Risk Alerts & Updates

Port Congestion Alert

Mumbai Port congestion causing 3-day delay for cocoa bean shipment

Updated: May 20, 2024

Quality Issue Notification

Milk solids batch #ML-2024-05 showing 2% variance in quality specs

Updated: May 19, 2024

Supplier Performance Matrix

Supplier	OTIF %	Quality	Lead Time	Sustainability	Overall
Ghana Farms	96.5%	9.1/10	12d±1.2	85%	89.2
Brazil Mills	97.8%	9.3/10	8d±0.8	78%	92.1
NZ Dairy	91.2%	8.9/10	15d±2.1	95%	85.7