Month-Till-Date Revenue
—
Loading…
FY Till Date Revenue
—
Loading…
Monthly Chem Volume
—
Loading…
Active Pipeline
—
Loading…
3M Pipeline Run Rate
—
Loading…
Monthly Commercial Rev.
—
Pipeline est.
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 |
|---|
Priority Alerts
Loading alerts…
Monthly SKU Volume — Commercial Plants (MT)
Commercial Rev.
—
Loading…
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 ↕ | Owner ↕ | Stage | Output T/mo ↕ | Formulations · Dosage · TC/t | Status / Remarks |
|---|
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
—
—
3-Month
—
+Validation+Plant Trials
12-Month
—
All convertible stages
Not-Live Potential
41 Plants
See Prospecting
Revenue by forecast window (₹ Cr)
Revenue share by customer group
All Pipeline Plants — Revenue Detail
| Plant | Customer | Owner | Output T/mo | Formulation | Attr.% | Attr. T/mo | Dosage % | TC ₹/t | Blend Rev. | Plant Total Rev. |
|---|
Total Pipeline Plants
—
Commercial
—
Active revenue
Customer Groups
—
Account Owners
—
| Plant / Opportunity | Customer Group | Stage | Output T/mo | Owner | Wtd. Revenue ₹/mo |
|---|
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— derived from pipeline blend lines
| Location | Formulation · Dosage | SKU-A | A% | SKU-B | B% | SKU-C | C% | Water% | Batch kg | TC/t |
|---|
GA Formulation Recommendation Engine
Powered by UNISOL's 1,051 clinker-adjusted trial runs across 113 trial groups. Computes strength delta vs control with clinker normalisation (Clinker Logic matrix) and ranks formulations by adjusted performance, trial count and cost fit.
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)
H. Water Repellence & Workability
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
Dispatch Log
Consumption Analysis
Sites with Critical SKU
0
Sites with Low Stock
0
Total SKU Lines
0
OK Lines
0
GRN Entry — Goods Receipt at Plant Site
Recent GRN Entries
| Date | Plant | SKU | Qty (kg) | Action |
|---|
Log Batch Preparation
Total kg prepared — can cover multiple batches or a full day.
Batch Log
| Date | Plant | Formulation | Total (kg) | SKU Consumed |
|---|---|---|---|---|
| No batches logged yet. | ||||
Dispatch Log — Invoices & Shipments
Log each shipment at time of dispatch. AMs confirm receipt at plant — GRN is auto-created on confirmation. Visible to Admin, CXO and MIS only.
| Invoice # | LR # | Dispatch Date | Plant | SKU | KG | Rate | Amount | Expected Arrival | Status | Action |
|---|
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 UNISOL GA trial database (1,031 runs · 111 groups) · 22 competitor runs visible in history but excluded from rec engine.
Component Intelligence
Performance analytics for each individual chemical component across all trial runs. Use the tabs below to switch between strength/Blaine analysis and water repellence (DRT) analysis for SBHP-series and competitor water repellent formulations.
Strength & Blaine
Water Repellence (DRT)
| Component (R&D Code) | Trial Runs | Avg % in Formulation | Adj-28D Δ MPa (clinker-adj) | 1D Δ MPa | Blaine Gain m²/kg | Best Grade | Grade Breakdown |
|---|
DRT (Drop Retention Time) measures water repellence. Higher DRT = better. Shows individual HPA-series components ranked by their DRT performance across SBHP-series trials. Competitors are excluded as their component compositions are not known.
| HPA Component | Formulations Used In | DRT Runs | Best DRT ↑ | Avg DRT ↑ | Worst DRT | Performance |
|---|
Average DRT — Higher is BetterSorted by best avg DRT
SKU Volume Forecast
Forecasted dispatch volumes by SKU across 1M / 3M / 6M / 12M windows. Derived from pipeline: Stage Probability × Output × Attributed% × Dosage% × SKU% in Formulation × Months-to-Convert weighting. Compared against actual dispatched volumes from the Dispatch Log.
| SKU | 1-Month Forecast (MT) Commercial 95% | 3-Month (MT) +Validation | 6-Month (MT) +Trials | 12-Month (MT) All stages | Last Month Actual (MT) | 6-Month Avg Actual (MT) | Vs Last Month | Vs 6M Avg |
|---|
Total SKUs
—
Highest Price
—
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 |
|---|
Total POs
—
Open
—
Partial
—
Pending Qty (kg)
—
Purchase Orders
| Sr# | Plant | PO Number | PO Date | Status | Next Dispatch | Ordered (kg) | Dispatched (kg) | Pending (kg) | Remark |
|---|
SKU-wise Pending Dispatch Summary
Open & Partial POs only
| SKU | Open POs | Total Ordered (kg) | Total Dispatched (kg) | Total Pending (kg) | Fulfillment |
|---|