Total Inward Volume
—
Factory Received Net Weight
2,213 Batches
Avg Purchase Rate
—
Mandi Purchase Rate (Before Cuts)
Mandi Gross
Avg Lab Oil Quality
—
Tested Oil Content (Target: 42%)
Benchmark 42%
42% Benchmark Cost
—
(Landing Cost ÷ Oil%) × 42
—
Net Margin Surplus
—
Loss: 1,644
Profit: 538
Status:
100% Quality Covered
3-Day Benchmark
—
Last 3 trading days avg 42-cost
Rolling Avg
AI Flagged Lots
—
Low Oil (< 39%) or High Moisture (> 6%)
Purchase Rate, Landing Cost & 42-Benchmark Cost Trend
Comprehensive Timeline: Mandi Purchase Rate, Factory Landing Cost
(Post-Katoti), and 42% Standard Quality Cost
Loss Lots:
1,644
74.3%
Profit Lots:
538
24.3%
No Profit - No Loss:
29
1.3%
Lab Pending:
1
0.05%
Total Lots:
2,213 Lots
Seed Purchase & Lab Quality Register
Search, filter, and audit individual mustard seed truck receipts, laboratory
reports, and 42 costing calculations
Rows:
| PARTY & INWARD LOT | WEIGHT (QTL) | PURCHASE RATE | LANDING COST | TESTED OIL % | 42% STANDARD COST | QUALITY IMPACT | STATUS | ACTION |
|---|
Seed Oil Quality Distribution Histogram
Distribution of lots relative to the 42.00% standard benchmark
Tested Oil % vs. NIR Analyzer Oil %
Comparison & accuracy between Debit Note tested oil % and NIR Analyzer report
Debit Sheet Avg Oil
—
NIR Analyzer Avg Oil
—
Average Variance
—
Seed Quality Discrepancies & Calibration Outliers
Shipments where Debit Note Oil differed by >0.05% from Lab Analyzer
| GIN / Lot | Supplier | Date | Debit Sheet Oil % | NIR Analyzer Oil % | Test Variance | Audit Impact |
|---|
🏆 Sourcing Intelligence Hub — Lowest Rate & Value Discovery
Compare procurement rates across Suppliers, Brokers, Supervisors, and Mandis.
| Rank | Supplier Name |
Purchase Rate (Mandi Rate) |
Landing Cost (Post-Katoti) |
42% Costing ★ Benchmark Cost |
Rate Difference (vs Purchase Rate) |
Lab Oil % (Target: 42%) |
Delivered Volume | Deals / Lots | Verdict |
|---|
🥇 Top Suppliers by Highest Oil % (Quality Champions)
Suppliers delivering maximum oil yield on factory NIR tests
| Supplier Name | Purchase Rate (Mandi Rate) |
Landing Cost (Post-Katoti) |
42% Costing (Benchmark Cost) |
Lab Oil % | Rate Diff (vs Rate) |
Volume |
|---|
💰 Top Best-Value Suppliers (Lowest 42 Costing)
Suppliers delivering optimal cost-efficiency after oil quality adjustments
| Supplier Name | Purchase Rate (Mandi Rate) |
Landing Cost (Post-Katoti) |
42% Costing (Benchmark Cost) |
Lab Oil % | Rate Diff (vs Rate) |
Volume |
|---|
Weekly Supplier Breakdown
Week-by-week active suppliers, inward volume, and effective 42 costing
| Week | Supplier Name | Lots | Weight | Oil % | 42% Standard Cost |
|---|
Location & Mandi-wise
Analysis
Mandi-wise supply concentration, average oil yields, and landing rates
| Mandi / Station | Suppliers | Total Volume | Avg Oil % | Landing Rate | 42% Standard Cost |
|---|
📞 No-Bargain Alerts: Inactive Historical Suppliers
Key historical suppliers who have had no purchase bargains/deals in the last 14+
days
| Supplier Name | Station | Past Total Volume | Historical Avg Oil | Last Traded Date | Status / Alert Reason |
|---|
Complete Supplier Performance Register
Evaluating suppliers by delivered oil content, 42-adjusted cost, foreign matter,
and condition compliance
| Supplier Name | Total Shipments | Delivered Qty | Avg Purchase Rate | Contracted Condition | Delivered Oil % | 42% Standard Cost | Loss / Profit % | Avg Moisture | Foreign Matter | Anomalies |
|---|
Anomaly Types & Distribution Breakdown
Empirical breakdown of quality variances, sub-standard oil yields, and ledger reconciliation discrepancies
1,407
Total Flagged
Transactions Flagged by AI & Statistical Engine
1,127
Total
Shipments with high rate / low quality combinations, moisture spikes, or
significant lab variances
Rows:
| GIN | GRN | Supplier | Station | Purchase Rate (₹) | Lab Oil % | 42% Standard Cost (₹) | Cost Impact | Anomaly Reasons | Audit Action |
|---|
Simple Sourcing to 42% Costing Calculator
Direct Real-World Flow: Seller Price − Katoti (FM, Greenish, Moisture, etc.) = Landing Cost ➔
(Landing Cost ÷ Lab Oil%) × 42 = 42% Costing
₹
Contract purchase rate agreed with
supplier
₹72,000.00 / MT
%
Benchmark Target: 42.00%
3. Katoti Deductions (Jo Jo Kata Jata Hai — Excel Single-Line
Row):
Total Katoti: -₹420.00 / Qtl (-₹4,200.00 / MT)
₹/Qtl
= -₹40.00 / Qtl
₹/Qtl
= -₹180.00 / Qtl
₹/Qtl
= -₹30.00 / Qtl
₹/Qtl
= -₹120.00 / Qtl
₹/Qtl
= -₹20.00 / Qtl
₹/Qtl
= -₹30.00 / Qtl
Excel Format Note: Values can be
entered in ₹/Qtl (e.g. 15.00), Percentage (e.g. 0.45%), or
Excel Decimal (e.g. 0.0045).
Current Mode: Direct
₹/Quintal Rate
Net Factory Landing Cost
Seller Rate −
Katoti
₹6,930.00 / Qtl
₹69,300.00 / MT
Effective price paid inside
factory gate after deducting all Katoti
42% Benchmark Costing
(Landing ÷ Lab Oil%) ×
42
₹6,832.39 / Qtl
₹68,323.94 / MT
Normalized cost required to
produce 42.00% standard oil yield
Quality Profit (Savings)
42% Cost − Seller
Rate
-₹45.23 / Qtl
-₹452.26 / MT
(Quality Profit)
₹7,154.77 (42% Cost) − ₹7,200.00 (Seller Rate) = -₹45.23
42% Cost (₹7,154.77) is ₹45.23/Qtl lower than Seller Rate (₹7,200.00) due to ₹420.00 Katoti
deductions.
Step 1: ₹7,000.00 − ₹70.00 Katoti = ₹6,930.00 Landing ➔
Step 2: (₹6,930.00 ÷ 42.60%) × 42.00 = ₹6,832.39 / Qtl
-₹167.61 / Qtl (-2.39% Quality Profit)
Executive Costing Summary & Financial Audit
Complete mathematical breakdown formatted clearly in ₹/Quintal and ₹/MT with
zero scrolling clipping
| Stage / Step | Formula & Business Meaning | ₹ / Quintal | ₹ / Metric Ton (MT) | Impact / Status |
|---|
Verified Calculation Audit from Real XLSX Records
Side-by-side comparison of Excel formulas, application engine calculations, and
manual proofs
| Record GIN | Supplier Name | Purchase Rate | Contract Condition % | Tested Oil % | 42% Standard Cost | System Value | Variance | Audit Status |
|---|---|---|---|---|---|---|---|---|
| INWDMSD27/0001 | Bhawani Trading Company | ₹6,859.91 | 39.59% | 41.02% | ₹7,023.80 | ₹7,023.8020 | 0.000000 | 100% Match |
| INWDMSD27/0002 | Bhawani Trading Company | ₹6,929.97 | 39.88% | 40.25% | ₹7,231.28 | ₹7,231.2765 | 0.000000 | 100% Match |
| INWDMSD27/0003 | Jai Sri Rama Trading Co. | ₹6,863.93 | 39.49% | 40.28% | ₹7,157.02 | ₹7,157.0238 | 0.000000 | 100% Match |
| INWDMSD27/0004 | Jai Sri Rama Trading Co. | ₹6,821.05 | 39.30% | 40.35% | ₹7,099.97 | ₹7,099.9742 | 0.000000 | 100% Match |
| INWDMSD27/0048 | Lucky Enterprises | ₹7,063.92 | 39.60% | 40.26% | ₹7,369.22 | ₹7,369.2196 | 0.000000 | 100% Match |
| INWDMSD27/0486 | Goyal Agri Products | ₹6,908.59 | 39.53% | 39.05% | ₹7,430.49 | ₹7,430.4901 | 0.000000 | 100% Match |
Audited Records
2,038
Total inward transactions evaluated & verified
Lab Results Pending
14
Zero-denominator protection active (missing NIR oil)
Stations Normalized
850
Preserved: Original Raw Mandi Names → Canonical Stations
Direct Purchases
1,022
Direct supplier/mandi procurement (₹0 broker commission)
Data Validation & Integrity Rules Enforced
Zero-Denominator
Protection
1 Lot Safeguarded
1 lot has missing Oil NIR/Lab Data because seed
arrived at the gate and invoice is recorded, but lab analysis is in progress. The application assigns
badge LAB_PENDING
rather than silently failing with #DIV/0! or NaN across all 2,038 lots.
Moisture Typo Outlier
Guard
1
Outlier Capped
Row 502 (GIN INWDMSD27/0488) contained
Moisture In QC = 455.0% (gate pre-sample was 0.05 / 5.0%). The system dynamically flags
this as a critical data entry typo, preventing it from corrupting averages while maintaining original
audit history.
Excel Corrupted Date
Fallback
2,038 Dates Verified
Raw Excel date serials (e.g. 6693546.0 producing #VALUE!) are safely caught
and resolved to verified GIN inward dates across the 01-Apr-2026 to
10-Sep-2026 timeline with 100% data integrity.
Inward GIN Split Handling
37
Shared GINs
76 rows share 37 GIN numbers
due to multiple purchase orders against a single truck inward. The atomic primary key is structured as
Composite(GIN, PO_NO, S_NO) to prevent accidental data overwrites across all 2,038 lots.
Google Sheets Live Daily Synchronization
Connect directly to Khandelia Oil's live Google Sheet for automatic daily updates
Whenever new seed purchases are entered or lab report results are updated in your Google Sheet, click Sync Now or configure automated background synchronization. The system validates incoming records, recalculates 42 Costing, and refreshes all dashboards and AI insights.
Recent Synchronization Logs
| Timestamp | Source | Total Rows | Status | Details |
|---|
TOTAL INWARD WEIGHT
42,178.9 MT
4,21,789.0 Quintals • 2,038 Inward Lots
TAXABLE BILL VALUE
₹319.38 Cr
Authoritative Bill Amount without Tax
TOTAL NET DEDUCTIONS
₹11.48 Cr
Oil, Shortage, Bardana, Moisture deductions
AVG LANDING COST / MT
₹73,000.16
₹7,300.02 / Qtl (After Deductions)
AVG LAB OIL (NIR) %
39.78%
Instrument NIR Result (Benchmark: 42.00%)
AVG 42% COSTING / MT
₹77,074.08
+₹4,073.92/MT Quality Penalty (+₹17.18 Cr)
Executive Margin Shield & Net Recovery Equation
100% Quality Loss Recovered
Total Katoti Deductions (₹13.48 Cr) minus Intrinsic Quality Yield Deficit (₹5.68 Cr) = Net Retained Protection Shield
Katoti Cut from Suppliers
+₹13.48 Cr
42% Oil Yield Deficit
₹5.68 Cr
Net Cash Margin Shield
+₹7.80 Cr Surplus
Showing 1 to 25 of 2,038 records
| Party & Inward Lot | Billed & Rec Wt |
Purchase Rate
(Mandi Buying)
|
Katoti Cuts | Landing Cost | Tested Oil % |
42% Standard Cost
★ Benchmark Target
|
Rate Difference
(42% Cost − Purchase Rate)
|
Audit |
|---|
Real-Time
AI Market Predictor
Indian Mustard Seed Price Intelligence
Pure dynamic search & AI econometric forecast synthesizing all-India physical spot mandis, international edible oil complex, and real-time crushing economics.
DYNAMIC BENCHMARK
ID: --
TODAY'S MUSTARD SEED PRICE
Market: All-India Indian Mustard Seed Benchmark
(Pure Dynamic Search)
Gemini 3.8 / Flash AI Model
Expected Price
₹--
₹ / Quintal
Expected Range
₹-- – ₹--
₹ / Quintal
Confidence
--%
Analytical
Confidence Level
Market Bias
▲
Bullish
Current Mandi: ₹-- / Qtl
Market Advisory & Risk Disclosure:
Based on currently available market data, the
estimated range is ₹____–₹____. AI-generated market estimate. This is not a guaranteed future price.
Agricultural commodity prices are subject to spot delivery volumes, global edible oil shifts, and central
government trade policies.
Live Intelligence Sources & Reference
Links
Synthesized for Current Date &
Time
Agmarknet Mandi Portal
Official Government Spot Mandi Arrivals & Rates (25+ Mandis)
NCDEX Commodity Exchange
Mustard Futures Benchmark & Delivery Contract Rates
Solvent Extractors' (SEA)
Domestic Crushing Economics, Import Tariffs & Inventory
CommodityOnline Agri Wire
Live Trade Sentiment, Weather Alerts & Spot Mandi Bhav
CBOT Soyoil & ICE Canola
Global Edible Oil Complex, CPO Parity & USD/INR Rates
PREDICTION RECORDS
Accurate date-and-time audit log of every generated prediction. Compare forecast vs actual market rates.
International Markets & Edible Oil Benchmarks
LIVELive international oilseeds & energy surveillance (CBOT Soybeans, BMD Palm Oil, ICE Canola, WTI Crude) driving Indian mustard procurement economics.
Strategic Commodity Spotlights
Direct Mustard CorrelationSoybeans
CBOT Futures • ZS=F
--
cents/bu
--
CBOT Soy Oil (ZL=F):
-- cents/lb
Domestic De-oiled Cake:
Export Parity Anchor
KOGM Costing Impact: Anchors global edible oil supply & meal export demand. High soybean
crushing pressure directly impacts domestic mustard seed meal realizations and mill operating margins.
Palm Oil
BMD Malaysia • FCPO
--
MYR/MT
--
Kandla CIF Parity:
₹-- / Qtl
India Import Share:
~55% Total Edible Imports
KOGM Costing Impact: India's largest imported edible oil. Palm oil landing cost plus
import tariff sets the commercial floor and ceiling for domestic Mashal Mustard Oil retail demand.
Canola
ICE Canada • RS=F
--
CAD/MT
--
Botanical Correlation:
Brassica (Rapeseed 92% r²)
Canadian Oil Yield:
42.0% - 44.0% Standard
KOGM Costing Impact: Direct botanical counterpart to Indian Sarson. Global rapeseed
harvest conditions and Canadian crush run-rates heavily influence domestic mandi spot expectations.
Crude Oil
WTI / Brent • CL=F / BZ=F
--
$/bbl
--
Brent Crude (BZ=F):
-- $/bbl
USD/INR Exchange Rate:
₹--
KOGM Costing Impact: High crude prices drive palm/soya into biodiesel blending mandates
globally, tightening edible stocks. Also dictates ocean freight and domestic mandi trucking freight rates.
OFFICIAL MARKET FEED
TradingEconomics • BMD • ICE • CBOT Exchanges
Global Commodity & Edible Oil Price Intelligence
Live benchmark rates featuring Palm Oil, Canola, Soybeans, Crude Oil, and Indian Mandi benchmarks with
zero clutter.
| Market / Commodity | Actual Rate | Unit | Daily Chg | Day % | Month % | Year % | Khandelia 42 Costing Impact | Official Link |
|---|
Verified real-time streaming rates from TradingEconomics, Bursa Malaysia Derivatives (BMD), ICE Canada,
CBOT, and Jaipur spot mandis.