Today • Tue, 06 Oct 26
● OPENING SOON
Tuesday Reopening • Kitchen Prep in Progress (0 Bills)
📅
▾
Live POS Engine: Synced 1m ago
🔒
Hotel Mahila Aghadi is Closed on Mondays (Weekly Off)
Both Shanivar Khoot & Tilakwadi kitchens are closed for weekly maintenance and prep.
Total Net Sales
₹
₹76,400
▲ +14.2%
vs last week
Total Bills
🧾
186 bills
AOV:
₹410.75
Closing Cash
💼
₹39,800
Handover: ₹26,000
Delivery & TAT
⭐
4.6
★ 24m TAT
Zomato + Swiggy →
🛵 Online Delivery Telemetry
Zomato + SwiggyDoorstep orders, delivery speed & platform commissions
Combined Delivery Sales
₹0 Closed Today
Zomato: ₹0 • Swiggy: ₹0
12am4am8am12pm4pm8pm
Total Orders Delivered
0 Closed
Zomato: 0 orders • Swiggy: 0 orders
12am4am8am12pm4pm8pm
Average Delivery Ticket (AOV)
₹0.00
Zomato AOV: ₹0 • Swiggy AOV: ₹0
12am4am8am12pm4pm8pm
🍅 Zomato: 26m avg doorstep TAT (4.2★)
🍊 Swiggy: 28m avg doorstep TAT (4.3★)
Zomato Commission: ~24.5% + GST
Swiggy Commission: ~23.8% + GST
Today (Mon)
Last week
📈 Hourly Sales & Rush Velocity (Total Store)
Peak: Lunch & DinnerTender Breakdown (Section 1)
Cash 59% • UPI 41%
Cash Sales: ₹31,850
UPI / Online: ₹22,125
🍽️ A. REVENUE Channels
Full Sheet →
Funnel & Conversions
12.4k Reach
Menu Opens
2,180
Cart Adds
412
Orders Placed
31
📉 B. COGS & Operating Expenses (Overheads)
Real Procurement & WagesMutton COGS (60kg @ ₹700)
₹42,000
Section 3 Raw Meat
Chicken COGS (40kg @ ₹240)
₹9,600
Section 3 Raw Poultry
Packaging & Containers
₹1,850
Takeaway & Delivery
Staff Salaries & Wages (Sec 4)
₹80,000
Wages / Hamali Logged
MAMA
Belgaum Live
Hotel Mahila Aghadi ERP
💬
Hello! How can I help with the restaurant today?
I have all live records for Shanivar Khoot & Tilakwadi ready. Tap a topic below or type any question:
💵
Sunday Sales & Cash
₹76,400 turnover & ₹26,000 owner handover
🥩
Biryani Meat Check
285g vs 250g recipe portioning cost impact
🔥
Shanivar Gas Consumption
Tandoor burner air damper check
🛵
Delivery Payouts
Zomato (22.8%) & Swiggy (21.5%) bank net
📊
Hotel Mahila Aghadi Records
Sunday 04 Oct 2026 (Peak)
186 Bills • Dine-in ₹38,200 • Takeaway ₹12,400
₹76,400
Saturday 03 Oct 2026
180 Bills • Dine-in ₹36,810 • Takeaway ₹12,210
₹73,620
Cash Drawer Handover
Closing Cash: ₹39,800 • Change Float: ₹5,000
₹26,000
Weekly Staff Payroll
18 Staff (10 Shanivar, 8 Tilakwadi) • 16.9% ratio
₹62,400
📑 WEEKLY DATA ENTRY SHEET
Date Range: 29, Sep 2026 - 04, Oct 2026 (TUE - SUN) • Audited Consolidation
A. REVENUE (Food Week Sales)
Branch 1 (Shanivar) • Branch 2 (Tilakwadi)
Dine - Inn
Shanivar Khoot: ₹72,000 • Tilakwadi: ₹58,000
₹1,30,000.00
45.7% of Revenue
Family Room Section
Shanivar Khoot: ₹0 • Tilakwadi: ₹65,000
₹65,000.00
22.8% of Revenue
Takeaway / Parcel
Shanivar Khoot: ₹36,000 • Tilakwadi: ₹22,000
₹58,000.00
20.4% of Revenue
Zomato Delivery
Shanivar Khoot: ₹6,200 • Tilakwadi: ₹11,300
₹17,500.00
6.2% of Revenue
Swiggy Delivery
Shanivar Khoot: ₹5,000 • Tilakwadi: ₹9,000
₹14,000.00
4.9% of Revenue
Other Items (Drinks, Sides)
Cold drinks, water bottles, extra sides
₹0.00
0.0% of Revenue
Total Revenue & Net Revenue
₹2,84,500.00
100.0% of Revenue
B. COST OF GOODS SOLD (COGS)
Direct Cost of Ingredients Sold
Mutton COGS
Sum of all Mutton purchases (*Mutton*, *मटण*) @ ₹700/kg
₹84,000.00
29.5% of Revenue
Chicken COGS
Sum of all Chicken purchases (*Chicken*, *चिकन*) @ ₹240/kg
₹28,000.00
9.8% of Revenue
Other Items COGS
5% food cost allowance on other items
₹0.00
0.0% of Revenue
Total COGS
₹1,12,000.00
39.4% of Revenue
C. DISCOUNT
Customised Food Discounts
Discount (Customization)
₹0.00
0.0%
D. GROSS PROFIT
Formula: (A - B - C) Profit Before Operating Expenses
Gross Profit
Net Revenue (₹2,84,500) - Total COGS (₹1,12,000) - Discount (₹0)
₹1,72,500.00
60.6% Gross Margin
E. OPERATING EXPENSES (Overheads)
Facility, Wages & Kitchen Utilities
Rent / Lease
Rent of the Restaurant (*Rent*, *भाडे*)
₹0.00
Staff Salaries & Wages
Chef, helpers, cleaning staff, labor, wages, hamali
₹18,000.00
Electricity Bill
Electricity, water charges (*Electricity*, *लाइट*)
₹4,200.00
Water Bill
Maintenance (*Water*, *पाणी बिल*)
₹1,100.00
Gas Cylinder / Bill
Commercial cooking gas (*Gas*, *गॅस*)
₹6,800.00
Internet / Phone Bill
Recharge & POS license (*Internet*, *Phone*)
₹800.00
Delivery Partner Fees
Swiggy & Zomato commissions (45% on delivery sales)
₹14,175.00
Repairs & Maintenance
Equipment upkeep & burner servicing
₹1,450.00
Miscellaneous Supplies
Containers, spoons, cleaning supplies, curd, lemons
₹5,475.00
Total Operating Expenses
₹52,000.00
18.3% of Revenue
OPERATING PROFIT (EBITDA)
Formula: (D - E) Core Operating Profit
Operating Profit (EBITDA)
Gross Profit (₹1,72,500) - Total Operating Expenses (₹52,000)
₹1,20,500.00
42.4% EBITDA Margin
F. OTHER EXPENSES
Depreciation, Interest & Taxes
Depreciation
On kitchen equipment & furniture over time
₹4,000.00
Interest & Taxes
Loans, Pigmi (*Pigmi*, *पिग्मी*), and GST
₹20,000.00
Total Other Expenses
₹24,000.00
8.4% of Revenue
G. NET PROFIT / (LOSS)
Formula: (Operating Profit - Other Expenses) Final Bottom Line
NET PROFIT / (LOSS)
Operating Profit (₹1,20,500) - Total Other Expenses (₹24,000)
₹96,500.00
33.9% Net Margin
📈 Sales, EBITDA & Net Profit Analytics
Multi-horizon financial telemetry across Day, Week, Month, Quarter, and Year.
Gross / Net Sales
₹53,975
▲ +14.2% Growth
EBITDA (Operating Profit)
₹22,625
41.9% Operating Margin
Net Profit (Bottom Line)
₹18,425
34.1% Net Margin
COGS / Food Cost %
₹21,850
40.5% (Mutton/Chicken)
Toggle Curves:
Interactive Retina Chart • Hover for Data
Sales
EBITDA
Net Profit
📋 Day Breakdown (Friday 02 Oct)
⭐ Multi-Platform Reputation & Delivery TAT
Audited ratings and delivery turnaround benchmarks across Google Maps, Zomato, and Swiggy.
📍
Google Business
Dine-In, Family Room & Ambiance4.3 ★
1,480+ Reviews
Food Taste & Authenticity
4.6 ★
Value for Money (Thalis)
4.5 ★
Service & Staff Courtesy
4.2 ★
Special Mutton Thali
Tambda Pandhra Rassa
Family Section
🔴
Zomato Partner
Online Delivery Telemetry4.2 ★
720+ Ratings
Doorstep Delivery TAT
Punch to customer doorstep
Kitchen Prep Time (KPT)
Order to bag sealed
Rider Pickup Wait Time
Delivery partner wait in store
Merchant Acceptance Rate
99.4%
🟠
Swiggy Partner
Online Delivery Telemetry4.3 ★
580+ Ratings
Doorstep Delivery TAT
Average delivery completion
Kitchen Prep Time (KPT)
Order acceptance to ready
Rider Pickup Wait Time
Delivery executive arrival
Order Accuracy Rate
99.5%
🔒
Live Kitchen & KOT Offline
● Restaurant Closed Every Monday (Weekly Off)
Kitchen order ticketing (KOT) is offline today. Full operations, live order streaming, and table tracking resume tomorrow (Tuesday) morning at 11:00 AM.
💼 Daily Cash Drawer Reconciliation (Section 1)
Direct real-time tracking of Opening Cash, Total Cash Inflows, Cash Handover to Owner, and Float Adjustments across both branches.
Default Opening Cash
₹6,000
₹3,000 per branch
Total Cash Sales
₹31,850
Inflow from POS
Owner Cash Handover (Row 11)
₹22,600
Excluded from expenses
Cash Float / Change (Row 12)
₹500
Drawer float
Closing Cash In Hand
₹14,925
Physical in drawer
🏆 Best Selling Dishes (Real POS Sales)
Audited POS dish sales velocity, exact plate counts sold, and revenue contribution.
🏢 Multi-Outlet Comparative Benchmarking
Audited POS reconciliation: Shanivar Khoot (Branch 1) vs Tilakwadi (Branch 2)
Shanivar Khoot Total
₹28,700
70 Bills (39.0% Share) • AOV ₹410.00
Tilakwadi Total
₹44,920
110 Bills (61.0% Share) • AOV ₹408.36
🏛️ Shanivar Khoot (Branch 1)
Counter & Dining Hall₹28,700
70 Bills • Avg Ticket ₹410.00 (Sat, 03 Oct)
Dine-In Sales (Main Hall)
₹18,400
Family Room Section
₹0 (No Family Room)
Takeaway / Parcel Counter
₹4,100
Zomato Online Delivery
₹3,800
Swiggy Online Delivery
₹2,400
Tender Split
Cash: ₹18,200 | UPI: ₹10,500
Owner Handover (Row 11)
₹10,000
Cash Float / Change (Row 12)
₹5,400
Daily Cash Expense
₹1,280
🏬 Tilakwadi (Branch 2)
Main Dining & Family Section₹44,920
110 Bills • Avg Ticket ₹408.36 (Sat, 03 Oct)
Dine-In Sales (Main Hall)
₹18,410
Family Room Section
₹12,320
Takeaway / Parcel Counter
₹2,790
Zomato Online Delivery
₹7,000
Swiggy Online Delivery
₹4,400
Tender Split
Cash: ₹23,280 | UPI: ₹21,640
Owner Handover (Row 11)
₹15,000
Cash Float / Change (Row 12)
₹8,000
Daily Cash Expense
₹1,800
🤖 Multi-Outlet Financial Benchmarking Agent Findings
Audit Insight
1. Outlier Expense Flagged (Commercial LPG):
Shanivar Khoot spends ₹21.40 per ₹1,000 revenue on cooking gas vs Tilakwadi at ₹15.80 (+35.4% higher). Servicing burner jets and simmering stockpots at Shanivar will save an estimated ~₹4,200/month.
2. Family Room Revenue Gap:
Tilakwadi captured ₹12,320 (27.4% of branch sales) from its dedicated Family Room. Shanivar Khoot operates as pure counter + main dining hall with ₹0 Family Room revenue.
3. Handover & Cash Compliance:
Combined cash handover to owner reached ₹25,000.00 (Row 11) (Shanivar: ₹10,000 + Tilakwadi: ₹15,000) with ₹0 cash reconciliation variance.
Shanivar Khoot spends ₹21.40 per ₹1,000 revenue on cooking gas vs Tilakwadi at ₹15.80 (+35.4% higher). Servicing burner jets and simmering stockpots at Shanivar will save an estimated ~₹4,200/month.
2. Family Room Revenue Gap:
Tilakwadi captured ₹12,320 (27.4% of branch sales) from its dedicated Family Room. Shanivar Khoot operates as pure counter + main dining hall with ₹0 Family Room revenue.
3. Handover & Cash Compliance:
Combined cash handover to owner reached ₹25,000.00 (Row 11) (Shanivar: ₹10,000 + Tilakwadi: ₹15,000) with ₹0 cash reconciliation variance.