Jelly Belly Analytics

Total Revenue -- Incl. GST, charges & rounding

Gross Revenue -- Menu subtotal before discounts

Net Revenue -- Gross minus discounts

Orders Count --

Avg Order Value -- Avg bill per order

Total Discount -- Discounts given to customers

Total Taxes --

Items Sold --

Amount Collected as Charges --

Item's Avg Selling Price --

Item Count Per Order --

Total Cancelled Orders --

Loss From Cancelled Order --

Total Voided Orders --

Loss From Voided Order --

Revenue Trend

Payment Methods

Outlet-wise Revenue

Brand Revenue Trend

Top 10 Restaurants

Top 10 Items

Avg Order Value Trend

Sales by Day of Week

Peak Hours

Total Revenue -- Bill rounded amount (what you receive)

Gross Revenue -- Menu subtotal before taxes & charges

Est. Commission -- ~27% of Swiggy + Zomato revenue

Food Cost % -- Material + supplies as % of total revenue

Gross Margin % -- After food cost, commission & GST

Profit & Loss Waterfall

Total revenue flowing through each cost to net profit

Channel Revenue

Gross vs bill amount by platform — gap shows aggregator cut

Food Cost vs Margin

Raw material cost % vs margin % per channel

Margin Trend

Monthly food cost % and gross margin % over time

Branch P&L

Per-branch breakdown — revenue, costs, commission & net margin

Commission & Settlements

Actual data from Zomato & Swiggy settlement Excel reports via Gmail

Net Order Value -- Total value of delivered orders

Service Fee -- Commission charged by platforms

Avg Commission % -- Service fee as % of commissionable value

Net Payout -- Amount received after all deductions

Payout Breakdown

Net order value flowing through deductions to net payout

Commission % Trend

Deduction Split

Where your money goes — commission, taxes, ads, hyperpure

By Restaurant

Settlement breakdown per restaurant ID on Zomato

Settlement Reports

All downloaded settlement Excel files with parsed data

Bank Statement & Reconciliation

HDFC bank deposits matched against commission settlement payouts

Platform Payout -- From commission Excel

Bank Received -- Platform deposits in bank

EMI Deducted -- Deducted at escrow

PhonePe (Store) -- Direct store payments

Net Flow -- All deposits minus withdrawals

Deposit Trend

EMI Reconciliation

Reconciliation

Bank deposits vs commission settlement payouts by date & platform

Bank Transactions

Inventory Intelligence

Stock health, revenue drivers & menu optimization

Active Menu -- Items in stock

Utilization -- % with sales

Dead Stock -- Items never sold

Fast Movers -- Selling >10/day

Revenue Drivers

Items selling 3+ per day that drive the majority of revenue

Item Velocity

Top 15 items by daily sales rate

Category Revenue

Branch Efficiency

Items selling vs dead stock per branch

Dead Stock

Items available but never sold at active branches

Availability Matrix

Green = selling, Yellow = not selling, Red = out of stock, Gray = not carried

All Items

Wastage Intelligence

Daily signals, branch benchmarks & audit reconciliation

Est. Wastage -- Based on audit history

Food Cost % -- Target: < 35%

Material Consumed -- Recipe deductions

Active Alerts -- Items flagged

Branch Food Cost Ranking

Food cost % per branch — bars past the 35% target line need attention

Category Consumption

Food Cost % Trend

Daily food cost percentage with 35% target line

Consumption Anomalies

Items with >30% deviation from 7-day average consumption

Stock Days Alert

Perishable items with 3+ days of stock — spoilage risk

Over-Ordering

Items where transfer in exceeds consumption for 3+ days

Stock Movement

Transfer in, recipe consumed, voided & audit per item

Procurement

Purchase orders, suppliers & material costs

Total POs -- Purchase orders

Total GRNs -- Goods received

GRN Spend -- Total procurement

Suppliers -- Active suppliers

Top Suppliers

Category Spend

Spend Trend

Top Items by Cost

Most purchased items across all procurement documents

Recent Documents

Outlets

Revenue across physical locations — all brands combined per kitchen

Outlets -- Named clusters + others

Total Revenue -- All outlets combined

Top Outlet -- --

Avg Revenue / Outlet -- Across named outlets

Outlet Growth Trajectory

Monthly stacked revenue by outlet with month-over-month growth line

Outlet Revenue Ranking

All physical outlets sorted by total revenue

Brand Mix per Outlet

How each brand contributes to each outlet's revenue

Outlet Details

Click a row to see branch codes rolled up into that outlet

Store Locations

Active outlets & planned expansion across Hyderabad

Active Planned

Manage Locations

Demand Forecast

14-day item-level predictions via statistical ensemble

Model Accuracy -- wMAPE (lower is better)

Items Forecasted --

Branches --

Forecast Range --

Clusters -- K=8 per branch

MAE -- Mean Absolute Error

Accuracy by Branch

wMAPE per outlet (lower = better)

Accuracy Trend

Daily wMAPE over backtest period

Category Breakdown

Forecast volume by category

Top Forecasted Items

Highest predicted demand (next day)

14-Day Forecast Volume

Total predicted demand by day across all branches