AWG Ops Platform
● LIVE
--:--:--
Secure Access
K2 Global
AWG Operations Platform
👁
❌ Invalid credentials — please try again
🔐 K2 Global Login
➕ Register New AWG Plant
✏️ Edit Plant Details — Le Meridien New Delhi
💰 Add Payment Receipt
K2 Global
|
Admin Panel
📊 Overview
👤 Create User
📋 All Users
🔐 Permissions
🔑 Change Password
Dashboard Overview
User accounts and access summary
Total Users
Admins
Ops / QC / Fin
1
Active Plants
All User Accounts
NameUser IDRolePagesPlantActions
Create New User
Add a new user account with role and page permissions
Account Details
👁
Page Access Permissions
⚙ Operations
Daily data entry, flow meters, OEE
🔬 Quality Control
pH, TDS, turbidity readings
₹ Financials
Revenue, expenses, invoices
📦 Consumables
Inventory and stock management
All Users
Manage existing accounts — click a row to edit inline
NameUser IDPasswordRolePagesPlantActions
Edit Permissions
Change what pages a user can access
Change Password
Update password for any user account
👁
👁
K2 Global / Fleet Overview
Live
Revenue YTD − Operational Expenses YTD (Sep–Feb)
Loading...
Sep 2025 – Feb 2026 · Le Meridien New Delhi · All data from Excel
Revenue YTD
₹—
Op.Expenses (Sep–Feb)
₹—
Total All Expenses
₹88.1L
Total Deployed (CAPEX+All)
₹1.26Cr
Fleet KPIs — FY 2025–26
📦 Bottles YTD ↗
4,73,112
Sep'25–Feb'26
💰 Revenue YTD ↗
₹53.7L
₹53,71,713 (Sep–Feb)
📊 Total Expenses ↗
₹88.1L
Per Excel summary
Active Plants
1
1 registered
📅 Latest Month ↗
₹8.02L
₹8,02,179 (Feb 2026)
Plants — Click to open dashboard
Le Meridien New Delhi
📍 Windsor Place, New Delhi 110001
● ACTIVE
7.4
pH
42
TDS ppm
3,240
Btl/day
Tank Alpha72%
Tank Beta55%
Watergen GEN-150 · 2 Units · 2×2,000L
+
ADD NEW PLANT
Register AWG facility
Monthly Performance
Monthly Bottles
Revenue vs Op.Expenses
Revenue
Op.Expenses
Le Meridien New Delhi
Windsor Place, New Delhi 110001 · Plant ID: AWG-LM-DEL-001 · Est. Sep 2025
Watergen GEN-150 · 2 Units AWG Cap: 1,200 L/day Bottle Cap: 6,000/day 2 × 2,000L SS Tanks
Live Sensor Readings
Live
pH Level
🧪
7.4
✓ Optimal · Range 6.5–8.5
TDS Level
💧
42ppm
✓ Below 100 ppm
Bottles Today ↗
🍶
3,240
▲ +4% vs yesterday · Click for hourly
AWG Output
🌊
847L
Target 1200L · 71%
Storage Tanks
2×2,000L SS
Tank Alpha
2000L1000L0L
1,440 L
72%
Tank Beta
2000L1000L0L
1,100 L
55%
Tank Alpha72%
Tank Beta55%
Daily Goal71%
Bottling Line A88%
Live Trend (3s)
pH×10
TDS ppm
Btl÷20
AWG L/hr÷10
System Status
8 sensors
AWG Unit 1 (GEN-150)
28.4°C · 75% RH
RUNNING
AWG Unit 2 (GEN-150)
28.1°C · 74% RH
RUNNING
RO Membrane
1.2 bar
NORMAL
Carbon Filter B (20" BigBlue)
Maintenance
DUE
UV Sterilizer 254nm
30mJ/cm²
ACTIVE
Bottling Line (Shree Bhagwati)
88% cap
RUNNING
125 KVA Servo Stabilizer
230V · 50Hz
ONLINE
Air Compressor
6.0 bar
RUNNING
AWG Hourly Generation — Data Entry (Plant Team)
Enter Actual AWG Generation per Hour
Enter hourly L/hr readings
Hours Entered
0 / 24
Total Generated Today
0.0 L
GEN-L Model Expected
— L
Quick fill: Operator ID:
AWG Generation vs Weather — Date & Hour Wise Correlation
ℹ️ Weather data from Open-Meteo API for Windsor Place, New Delhi (28.6139°N, 77.2090°E). Hourly AWG generation from Cost Sheet 2 flow meter data (93 days: Nov'25–Jan'26). Actual vs GEN-L model output shown per hour. Select date to view correlation.
Select Date for Hourly Analysis
Loading...
Avg Temp
Avg Humidity
Actual AWG Total
Model AWG Total
Actual AWG L/hr (Flow Meter)
GEN-L Model Output (Temp+Humidity)
Humidity % / 1.5
Hourly Correlation Table
HourTemp (°C)Humidity (%)Wind (km/h)GEN-L Model (L/hr)Actual AWG (L/hr)VarianceMatch %
Select a date above to load data
Today Hourly Bottles
AWG Daily Generation History
Last 30 days
Actual (L)
Projected (L)
📊 Actual vs Projected Generation — Flow Meter Analysis
Actual AWG (L/day)
Projected (GEN-L model, L/day)
% Achieved
pH Level
7.4
Optimal: 6.5 – 8.5
TDS Level
42 ppm
Max 100 ppm (BIS)
QC Pass Rate
98.7%
Target ≥ 98%
QC Log Entry — Staff enter details below with their login ID
New QC Check Entry
Latest Status per Stage (auto-updated from entries)
9-Stage Purification Summary
Real-time
StageLast ActionDate / TimepHTDSOperatorNotesStatus
No entries yet. Use form above to log QC activity.
24h pH Log
Within Range
24h TDS Log
Below Limit
Revenue YTD − Expenses YTD (Le Meridien)
Loading...
Sep 2025 – Feb 2026
Revenue YTD
₹53,71,713
Op. Expenses YTD
₹37,52,696
CAPEX
₹37,60,874
ℹ️ About the ₹88.1L figure: The Excel Summary Sheet shows Total Expenses = ₹88,11,425. This includes: Pre-operation expenses Apr–Aug'25 (₹49.4L: setup, rent, salaries, equipment before revenue started) + Operational expenses Sep'25–Feb'26 (₹38.7L). The ₹76.3L shown previously was CAPEX ₹37.6L + OpEx ₹38.7L (Sep-Feb only). Full picture below includes all three components.
ROI — Full Investment Recovery Analysis
Revenue YTD (Sep'25–Feb'26)
₹52.6L
4,73,112 bottles invoiced
CAPEX (Equipment / Machinery)
₹37.6L
Machinery, tanks, bottling line
Pre-Op Expenses (Apr–Aug'25)
₹49.4L
Setup period before revenue
Operational Expenses (Sep–Feb)
₹38.7L
Salary, elec, consumables, water
Total Investment (All-In)
₹88.1L
CAPEX + Pre-Op + Sep-Feb OpEx
Net P&L vs OpEx Only
−₹22.4L
Revenue − (Sep-Feb OpEx only): 135%
Revenue vs Total Investment (CAPEX + Op.Expenses)
70% recovered
Total Deployed: ₹75,13,570 Est. break-even: ~4 months Revenue So Far: ₹53,71,713
Month-on-Month Summary — Income & Expenditure
MoM P&L Table
Sep'25–Feb'26
MonthBottlesRevenue (₹)Op.Expenses (₹)Monthly P&L (₹)Cumulative Rev (₹)Cumul. P&L (₹)Payment
Add Invoice / Transaction
New Entry
Income & Expenditure
Payment Tracker
Short/Excess
DATEINVOICE (Billing Period)DESCRIPTIONBILLED (₹)(-) ELECTRICITY (₹)(-) WATER (₹)NET RECEIVABLE (₹)RECEIVED (₹)SHORT / EXCESSSTATUS
Total Billed (Gross):₹0
(-) Electricity Debits:₹0
Total Net Receivable:₹0
(-) Water Charges:₹0
Total Received:₹0
Outstanding (Net):₹0
Monthly Rev vs Exp
Revenue
Op.Expenses
Manually Added Entries
DateInvoiceBottlesTypeCategoryDescriptionAmount (₹)
No manual entries yet. Use form above.
Invoice Register — Complete (143 invoices Sep'25–Feb'26 · Direct from SALE INV sheet)
All Sale Invoices
DateInvoice No.BottlesTaxable (₹)GST (₹)Total (₹)
CAPEX Register
DateDescriptionSupplierAmount (₹)
Consumables Register — All Items Editable
#Item NameCategoryUnitIn StockMin StockSupplierUnit Cost (₹)Status / Actions
Receive Stock
Stock Receipt
Stock Movement Log
Filter Cleaning Timeline
K2 Global AWG Operations Platform · Windsor Place, New Delhi 110001 Open-Meteo Weather · Real Data · Feb 2026
📦
Bottles Produced
Le Meridien, New Delhi · Sep 2025 – Feb 2026
📝
Financial Data Entry
Admin · Accounts · Corrections & Future Entries
USER ID PIN
🔒 Please login to access data entry
📦
Plant-Wise Drill-Down
Le Meridien, New Delhi · Sep 2025 – Feb 2026
📝
Financial Data Entry
Admin · Accounts · Corrections & Future Entries
USER PIN
🔒 Please login with your User ID and PIN to access data entry
✏️ Edit Payment Entry — Admin
🔐 Admin PIN required to edit:
DateItemTypeQtyCostSupplierBy
No stock movements yet.