Monthly Revenue (Commercial)
₹20.3 Cr
32 plants · 95% prob · attr. output adjusted
Monthly Chem Volume
517 MT
NTR10 210MT dominant
Active Pipeline
31 Plants
7 Validation · 6 Plant Trial · 8 Lab
3-Month Forecast
₹22.6 Cr
With pipeline conversions
10Need Analysis
0.5% · 12 mo
0.5% · 12 mo
8Lab Trials
5% · 6 mo
5% · 6 mo
6Plant Trials
25% · 3 mo
25% · 3 mo
7Validation
50% · 2 mo
50% · 2 mo
32Commercial
95% · 1 mo
95% · 1 mo
Top Revenue PlantsFull forecast →
| Plant | Formulation | Attr. Output T/mo | Rev/mo |
|---|---|---|---|
| Dalmia JCW | ADSE010 | 3,80,000 | ₹6.67 Cr |
| Dalmia RGP | EASE005 | 2,85,000 | ₹5.29 Cr |
| JK Prayagraj | ADSE008+SBHP | 75,000 | ₹1.46 Cr |
| Dalmia ARY | LASE017 | 2,00,000 | ₹0.90 Cr |
| Dalmia BCW | ADSE010 | 2,00,000 | ₹0.63 Cr |
Priority Alerts
SLC823 critical — Dalmia RGP. ~8 days cover. Reorder immediately.
NTR10 low — Dalmia RGP. 12 days remaining.
Adani Kodinar — Plant trial active. ₹153/t TC. High-value ₹2.17Cr potential.
Adani Roorkee — Validation. ₹138/t TC formulation. Close urgently.
JK Prayagraj — Commercial. SBHP001 at ₹380/kg SLC823.
Monthly SKU Volume — Commercial Plants (MT)
Commercial Rev.
₹20.3 Cr
32 plants · attr. output
Validation Est.
₹1.2 Cr
7 plants · 50%
Plant Trial Est.
₹0.6 Cr
6 plants · 25%
Lab + NA Est.
₹0.14 Cr
18 plants · <5%
Click any value in the Output column to edit inline. Use the sort and search controls above to navigate large lists.
| Plant / Opportunity ↕ | Customer ↕ | Owner ↕ | Stage | Output T/mo ↕ | Formulations · Attr. Output · Dosage · TC/t · Blend Rev. | Total Wtd. Rev. ↕ |
|---|
Revenue Forecast Engine
Formula: Σ (Stage Probability × Cement Output × Attributed Output% × Treatment Cost ₹/t) for plants where Months-to-Convert ≤ window. Treatment Cost from BlendLines data. Attributed Output = % of plant output where UNISOL product is used.
1-Month
₹20.3 Cr
32 commercial plants
3-Month
₹22.6 Cr
+Validation+Plant Trials
12-Month
₹22.8 Cr
All convertible stages
Not-Live Potential
41 Plants
See Prospecting
Revenue by forecast window (₹ Cr)
Revenue share by customer group
All Commercial Plants — Revenue Detail (32 plants)
| Plant | Customer | Owner | Output T/mo | Formulation | Attr.% | Attr. T/mo | Dosage % | TC ₹/t | Blend Rev. | Plant Total Rev. |
|---|
Total Locations
35
States Covered
18
Pan-India
Customer Groups
11
Field Managers
6
| Location | Customer Group | Unit | State | Region | Plant Owner (UNISOL) |
|---|
Prospecting — Not Live Plants
41 plants identified but not in active sales cycle. Priority score = plant output capacity + indicative dosage potential. Use "→ Pipeline" to move a plant into active tracking.
Not-Live Plants
41
Across 14 companies
Potential Output
~47L T/mo
Est. Addressable Rev.
~₹8–15 Cr
At avg ₹20–40/t
Dosage Not Set
19 Plants
Needs assessment
| Plant | Customer | Output T/mo | Indicative Dosage | Est. Revenue Potential | Priority Score | Action |
|---|
Deployed Formulations
23
Across 35 locations
R&D Trial Database
250+
Families
8
EASE·LASE·ADSE·BMTP·SBHP·SASE·WRSP·SRSE
Active SKUs
10
Treatment Cost Calculator
Formula: Treatment Cost (₹/t cement) = Σ (SKU_i price ₹/kg × SKU_i % in formulation / 100) × Dosage (g/t) / 1000. Prices are list prices from Component Master.
Treatment Cost Calculator
Treatment Cost
—
—
Prices used: list prices from Component Master. Actual negotiated prices may differ.
Active Formulations by Location
| Location | Formulation | SKU-A | A% | SKU-B | B% | SKU-C | C% | Water% | Batch kg |
|---|
GA Formulation Recommendation Engine
Powered by UNISOL's 1,000+ trial database. Matches plant parameters against historical runs to rank formulations. Supports dual objectives and targeted strength day requirements.
Plant Parameters
Manual Entry
Bulk Upload (Excel)
Log Trial RunR&D / Field Team
C. Cement Composition
D. Clinker Quality
E. Grinding Conditions
G. Strength Results (MPa)
Bulk Trial Data UploadUNISOL_GA_Data_updated.xlsx format (v4.1)
Upload file must follow UNISOL GA Trial Intelligence Data format. Sections: A. Trial Identity · B. Cement Grade & Mill · C. Composition · D. Clinker Quality · E. Grinding Conditions · F. Formulation · G. Test Results · H. Outcome. Trial Group code must be consistent across all runs in one trial.
Click to browse or drag & drop
.xlsx format · Max 10MB · UNISOL GA Data format (row 5 onwards = data)
Inventory Engine
Monthly consumption = Line Kg from BlendLines (actual usage per plant per SKU). Days cover = Current Stock ÷ (Monthly Consumption ÷ 30). Critical <15 days · Low Stock 15–30 days. Batch preparation deducts from stock in real time.
Stock Status
GRN Entry
Batch Preparation
Consumption Analysis
Sites with Critical SKU
0
Sites with Low Stock
0
Total SKU Lines
0
OK Lines
0
| SKU | Plant Site | Monthly Need (kg) | Est. Stock (kg) | Stock Level | Days Cover | Status | Action |
|---|
GRN Entry — Goods Receipt at Plant Site
Recent GRN Entries
| Date | Plant | SKU | Qty (kg) | Action |
|---|
Batches can be prepared using standard formulations for that site or any custom formulation created below. Stock is deducted in real time on submission.
Create Custom / Modified Formulation
Session — available at any plant
Use when a plant is running a trial, seasonal or modified blend different from the standard. Enter a unique code and SKU proportions. Saved formulations appear in the batch prep dropdown for all sites.
Log New Batch
Batch Log
| Date | Plant | Formulation | Size (kg) | SKU Consumed |
|---|---|---|---|---|
| No batches logged yet. | ||||
Consumption Analysis Engine
Estimated = Plant Output (T/mo) × Duration × Attributed Output % × Dosage % × SKU % in Formulation
Actual = Opening Stock + GRN Receipts − Closing Stock (or: deductions via batches prepared)
Reconciliation flags variance between theoretical and physical consumption — useful for detecting leakage, measurement error, or dosage drift.
Actual = Opening Stock + GRN Receipts − Closing Stock (or: deductions via batches prepared)
Reconciliation flags variance between theoretical and physical consumption — useful for detecting leakage, measurement error, or dosage drift.
Analysis Parameters
Overall Win Rate
68%
Of plants that reached Validation
Avg. Time to Commercial
14 mo
From Need Analysis
Fastest Stage
Validation → Commercial
Avg 2.1 months
Pipeline Velocity
+3 plants
Advanced stage in last 90 days
Analytics Configuration
Pipeline Stage Distribution — Monthly Trend
Plants per stage over time
Win / Loss / In-Progress by Customer
Stage Transition Matrix
Plants moved between stages
Pipeline Value by Owner
Avg. Time in Stage (months)
Weighted Revenue Pipeline — Monthly Evolution
Trial History Database
Historical trial records from the UNISOL GA trial intelligence database. Select filters and click Load to retrieve matching records. Use Bulk Upload in Trial Entry to add new records from the standard Excel format.
Filters
Showing records from the built-in sample dataset and any bulk-uploaded files.
Total SKUs
10
Highest Price
SLC823
₹380/kg · OTS-HPA-113
Highest Volume
NTR10
210 MT/month
Monthly Raw Mat. Cost
~₹9.8 Cr
SKU Master — Trade Names & R&D Component Codes
| Trade Name (SKU) | R&D Code | Pack Size (kg) | List Price ₹/kg | Commercial Vol MT/mo | Function |
|---|---|---|---|---|---|
| NTR10 | NTR10 | 25 | ₹250 | 210.1 | Base GA activator / amine backbone |
| AR550 | LL-AP-106 | 230 | ₹175 | 119.7 | Liquid amine performance booster |
| SR550 | CSLA-105 | 25 | ₹125 | 49.8 | Solid amine carrier / extender |
| AE324 | ALL-TSP-110 | 250 | ₹150 | 78.6 | Triisopropanolamine alternative |
| TP1000 | HC-MOT-101 | 210 | ₹250 | — | High-conc. TIPA blend |
| TP-D1000 | CSEL-102 | 230 | ₹250 | 7.9 | Dual-action strength enhancer |
| DYN32 | ALG-TSP-104 | 230 | ₹150 | 0.25 | Alginate-TSP modifier |
| SLC823 | OTS-HPA-113 | 180 | ₹380 | 48.6 | High-performance OTS activator (PSC/slag) |
| TP-M550 | LC-MOT-103 | 230 | ₹130 | 2.4 | Low-conc. mill throughput agent |
| TGA100 | FG-MOT-108 | 230 | ₹150 | — | Functional grinding / pack-set reduction |