Back to ER Diagram
Sourcing & Strategic Procurement

Sourcing & Strategic Procurement

Strategic sourcing processes including RFI management, RFP workflows, supplier selection and award, bid cancellation/re-tender, and spend analysis for category management.

PostgreSQL
6 Tables
Schema: sourcing
Spend Analysis

Strategic Sourcing Process

RFI
RFP
EVALUATION
AWARD
6
Sourcing Processes
RFI+RFP
Multi-Stage
Weighted
Scoring Model
Analytics
Spend Visibility

1. Request for Information (RFI)

1

RFI Management

Gather market intelligence and vendor capabilities before formal bidding. Used for complex purchases or new categories.

sourcing.rfi_headers

  • rfi_number - Unique RFI identifier
  • category_id - Procurement category
  • submission_deadline - Response due date
  • response_format - Required response structure
  • vendor_count / response_count - Tracking

sourcing.rfi_responses

  • capability_summary - Vendor capability overview
  • pricing_indication - Ballpark pricing
  • lead_time_indication - Estimated delivery
  • evaluation_score - Assessment score
  • shortlisted - Selected for RFP flag

2. Request for Proposal (RFP)

1

RFP Management

Formal proposal request with defined scope, evaluation criteria, and commercial requirements.

sourcing.rfp_headers

  • scope_document_path - Detailed requirements
  • evaluation_criteria - Weighted scoring criteria
  • technical_weight / commercial_weight - Score distribution
  • rfi_id - Link to preceding RFI (optional)

sourcing.rfp_responses

  • technical_proposal_path - Technical submission
  • commercial_proposal_path - Pricing submission
  • technical_score / commercial_score - Evaluation scores
  • combined_score - Weighted total
  • rank - Vendor ranking

Evaluation Criteria

  • • Technical Capability: 40%
  • • Price Competitiveness: 30%
  • • Delivery Timeline: 15%
  • • Past Performance: 15%

Proposal Stages

  • OPEN Accepting proposals
  • EVALUATION Scoring underway
  • AWARDED Winner selected

3. Supplier Selection & Award

1

Award Management

Formal supplier selection with justification, approval workflow, and contract/PO generation.

sourcing.supplier_awards

  • award_type - SINGLE, SPLIT, BACKUP
  • award_value - Total award amount
  • justification - Selection rationale
  • selection_criteria_met - Compliance with criteria
  • contract_id / po_id - Resulting documents

Award Types

Single Award: One vendor for entire requirement. Split Award: Multiple vendors share volume. Backup Award: Secondary vendor for risk mitigation.

4. Spend Analysis

1

Strategic Spend Analysis

Comprehensive spend visibility across vendors, categories, and time periods to identify savings opportunities.

sourcing.spend_analyses

  • analysis_type - VENDOR, CATEGORY, DEPARTMENT, PROJECT
  • total_spend / addressable_spend - Spend metrics
  • contracted_spend / maverick_spend - Contract compliance
  • savings_opportunity - Identified savings
  • category_breakdown / vendor_breakdown - Detailed analysis
  • recommendations - Strategic suggestions

Database Schema Summary

TablePurposeKey Columns
sourcing.rfi_headersRFI managementrfi_number, deadline, response_format
sourcing.rfi_responsesRFI responsescapability_summary, shortlisted
sourcing.rfp_headersRFP managementscope, criteria, weights
sourcing.rfp_responsesRFP proposalstechnical/commercial scores, rank
sourcing.supplier_awardsAward recordsaward_type, justification
sourcing.spend_analysesSpend analyticsanalysis_type, savings_opportunity