ℹ️ Net Receivable = Billed − Electricity − Water. Calculated automatically on save.
✏️ Edit Finance Entry
✏️ Edit Invoice
💡 Edit Taxable + GST → Total auto-updates, or edit Total → Taxable/GST auto-split at 5%
AWG Ops Platform
● LIVE
--:--:--
Secure Access
K2 Global
AWG Operations Platform
👁
❌ Invalid credentials — please try again
🔐 K2 Global Login
❌ Invalid credentials. Try again.
➕ Register New AWG Plant
✏️ Edit Plant Details — Le Meridien New Delhi
💰 Add Payment Receipt
K2
K2 Global
|
Admin Panel
📊 Overview
👤 Create User
📋 All Users
🔐 Permissions
🔑 Change Password
💾 Backup & Restore
Dashboard Overview
User accounts and access summary
—
Total Users
—
Admins
—
Ops / QC / Fin
1
Active Plants
All User Accounts
Name
User ID
Role
Pages
Plant
Actions
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
📄 Revenue & Invoices
Invoice register and revenue totals — no expenses
₹ Full Financials
P&L, expenses, CAPEX, margins — restricted
📦 Consumables
Inventory and stock management
🧫 Lab Observations
Lab reports and taste & odour log
All Users
Manage existing accounts — click a row to edit inline
Name
User ID
Password
Role
Pages
Plant
Actions
Permissions Matrix
Toggle which sections each user can access — unsaved changes are highlighted in blue
Loading users…
Select permission level for each section, then save.
Change Password
Update password for any user account
👁
👁
💾 Backup & Restore
Finance, QC, Ops, Lab, Consumables, Invoices — all data
⚠️ First-Time Setup — Each Device Pushes Once
Every device (Admin laptop, Finance laptop, etc.) needs to push its local data to the server once. After all devices have pushed, the server has the complete merged dataset and all users stay in sync automatically.
Automatic backups run every 2 hours. Last 24 snapshots (48 hrs) kept on Hostinger.
Click "Refresh List" to see available backups.
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,79,352
Sep'25–Feb'26
💰 Revenue YTD ↗
₹54.4L
₹54,40,509 (Sep–Feb)
📊 Total Expenses ↗
₹88.1L
Per Excel summary
Active Plants
1
1 registered
📅 Latest Month ↗
₹8.71L
₹8,70,975 (Feb'26)
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
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
—
Hour
Temp (°C)
Humidity (%)
Wind (km/h)
GEN-L Model (L/hr)
Actual AWG (L/hr)
Variance
Match %
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
Purification Stage — Date-wise QC Summary
Stage × Date Matrix
—
Real-time
No entries yet.
OK / Pass / CleanedAttentionFailReplacedTest / Lab
✏️ Edit QC Entry
🧑💼 Logged by: —
➕ Log QC Entry
Stage
—
Date
—
Time recorded automatically at save
24h pH Log
Within Range
24h TDS Log
Below Limit
Revenue YTD − Expenses YTD (Le Meridien)
Loading...
Sep 2025 – Feb 2026
Revenue YTD
₹54,40,509
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)
₹54.4L
4,79,352 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
Pre-Op + Sep-Feb OpEx
Net P&L vs OpEx Only
Calculating…
Revenue − OpEx only: —
Revenue vs Total All-In Investment (Pre-Op + OpEx = ₹88.1L)
—
Total Deployed: ₹88,15,791Est. break-even: ~4 monthsRevenue So Far: ₹54,40,509
Month-on-Month Summary — Income & Expenditure
MoM P&L Table
Sep'25–Feb'26
Month
Bottles
Revenue (₹)
Op.Expenses (₹)
Monthly P&L (₹)
Cumulative Rev (₹)
Cumul. P&L (₹)
Payment
Add Invoice / Transaction
🔒 Finance data entry requires Finance or Admin access
