Tender Management Workflow (TND)¶
Module Purpose: Complete automation of the tender screening, participation, and bidding lifecycle. It eliminates manual reading of 100-page PDF tender documents by using OCR and NLP to extract critical eligibility criteria.
[!TIP] Core Concept: "Bid Smart, Not Hard." Don't waste time reading tenders you can't win. Let the system screen them for turnover, experience, and product specs first.
Use Case Quick Reference¶
| ID | Title | Priority |
|---|---|---|
| TND-001 | Tender Document Screening (OCR) | P1 |
| TND-001 | Tender Document Screening (OCR) | P1 |
| TND-002 | Competitive Bidding Analysis | P1 |
| TND-003 | Performance-Based Entity Selection | P1 |
| TND-004 | GEM Portal Lifecycle Automation | P2 |
| TND-004 | GEM Portal Lifecycle Automation | P2 |
UC-TND-001: Tender Document Screening¶
What It Does¶
Uses OCR and NLP to read complex tender PDFs (often 50-100 pages). It extracts critical data points like "EMD Amount", "Submission Deadline", "Product Specifications", and "Eligibility Criteria" (Turnover, Past Experience).
Who: System AI / Bid Manager
When: New Tender Notification Received
How It Works¶
- Ingestion: User uploads PDF or system scrapes it from GEM/CPP Portal.
- OCR Parsing: System converts PDF to text (preserving tables).
- Extraction:
- Buyer: "Indian Railways"
- Item: "Zinc Oxide Grade A"
- Quantity: "50 MT"
- EMD: "₹50,000"
- Criteria: "Minimum Avg Turnover last 3 years > 5 Cr"
- Validation:
- Checks extracted criteria against Company Profile.
- Flag: "🔴 Not Eligible: Turnover < 5 Cr" OR "🟢 Eligible".
Success Signals¶
✅ Extracts 90% of key fields correctly
✅ Accurately flags Ineligible tenders based on criteria
UC-TND-002: Competitive Bidding Analysis¶
What It Does¶
Predicts the winning price by analyzing historical data. It tells you: "For Indian Railways Zinc tenders, L1 (Lowest Bidder) usually quotes between ₹150-155/kg."
Who: System Analytics
When: preparing a financial bid
How It Works¶
- Lookup: Query
tender_historyfor same Buyer + Product. - Analysis:
- Last 3 Tenders: L1 was ₹148, ₹152, ₹150.
- Competitors: "Alpha Chem", "Beta Corp".
- Recommendation:
- "To win, quote below ₹149."
- "Current Raw Material Cost: ₹140. Projected Margin: 6%."
- Decision Support: Bid Manager decides: "Is 6% margin worth it?"
Success Signals¶
✅ Visual Scatter Plot of past bids
✅ Warning if estimated cost > probable winning price
UC-TND-003: Performance-Based Entity Selection¶
What It Does¶
For group companies with multiple legal entities (Entity A, Entity B), the system suggests which entity should bid to maximize chances. Entity A might have the Turnover, but Entity B has the Past Experience certificate.
Who: System Logic
When: Pre-bid Strategy
How It Works¶
- Criteria Input: Tender requires "Turnover > 10Cr" AND "Past Order > 200MT".
- Entity Scan:
- Entity A: Turnover 50Cr (Pass), Max Order 100MT (Fail).
- Entity B: Turnover 5Cr (Fail), Max Order 300MT (Pass).
- Consortium: Can we bid as Consortium? (System checks tender clause).
- Suggestion:
- "Bid using Entity A (Turnover) but submit Entity B's Technical Credentials as Group Company (requires Manufacturer Authorization Form)."
Success Signals¶
✅ Correctly identifies the strongest eligible entity
✅ Highlights if NO entity qualifies
UC-TND-004: GEM Portal Lifecycle Automation¶
What It Does¶
Automates the specific quirks of the Government e-Marketplace (GEM) flow, including catalogue authorization, order acceptance, and invoice upload.
Who: Bid Coordinator
When: GEM Tenders
How It Works¶
- Catalogue Sync: Auto-updates product pricing on GEM profile.
- Order Sync: Polls GEM dashboard for new "Direct Orders".
- Lifecycle:
- Accept Order: One-click in Pebble dashboard accepts order on GEM.
- Generate Invoice: Creates GST Invoice via Pebble ERP.
- Upload: Pushes Invoice PDF back to GEM portal for payment processing.
Success Signals¶
✅ Syncs orders from GEM every 15 mins
✅ Validates Invoice format before upload to avoid rejection