RFQ Report
π RFQ (Request for Quotation) Reportβ
The RFQ Report provides a consolidated view of all Requests for Quotation sent to vendors, allowing procurement teams to track, compare, and evaluate supplier quotations before making purchase decisions.
It helps purchasing departments manage the vendor selection process, ensure competitive pricing, and maintain a transparent audit trail for procurement activities.
π― Purpose of the Reportβ
-
Track all RFQs issued to suppliers within a given time frame.
-
Compare vendor responses in terms of price, delivery time, and terms.
-
Monitor pending RFQs that need follow-up.
-
Maintain a history of procurement inquiries for audit and compliance.
-
Support decision-making for purchase order creation.
π Key Data Fieldsβ
| Field | Description |
|---|---|
| RFQ Number | Unique identifier for the RFQ document. |
| RFQ Date | Date the RFQ was issued. |
| Vendor Name | Supplier to whom the RFQ was sent. |
| Contact Person | Vendor contact for follow-up. |
| Item Code / Name | Products or services requested. |
| Quantity Requested | Required quantity in specified UOM. |
| Quoted Price | Vendor's price per unit. |
| Currency | Currency used for the quotation. |
| Delivery Lead Time | Vendorβs promised delivery time. |
| Status | Open, Quotation Received, Shortlisted, Rejected, Converted to PO. |
| Comparison Score (if applicable) | Evaluation score based on price, quality, and lead time. |
| Remarks / Notes | Internal comments or vendor-specific notes. |
π Filter & Search Optionsβ
-
RFQ date range.
-
Vendor name.
-
Status (Open, Received, Closed, Cancelled).
-
Item code / category.
-
Currency.
-
Delivery time range.
π Insights Providedβ
-
Number of RFQs sent vs. responses received.
-
Price comparison for the same product across vendors.
-
Pending RFQs that need supplier follow-up.
-
Supplier performance trends (e.g., response speed, pricing competitiveness).
-
Procurement cycle efficiency.
π€ Export & Integrationβ
-
Export to Excel, CSV, or PDF.
-
Linked to Purchase Orders for tracking RFQ-to-PO conversion.
-
Integrated with Vendor Management and Product Pricing modules.
β Benefitsβ
-
Ensures procurement is based on competitive pricing and quality assessment.
-
Improves vendor negotiation leverage by having clear price comparisons.
-
Reduces procurement cycle time through better tracking.
-
Maintains an audit trail for compliance and transparency.
π Example Layoutβ
| RFQ No. | RFQ Date | Vendor Name | Item Code | Item Name | Qty | UOM | Quoted Price | Currency | Lead Time (Days) | Status | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|
| RFQ-102 | 01-08-2025 | ABC Supplies | ITM-001 | Printer Cartridge | 50 | Nos | 25.00 | USD | 5 | Quotation Received | Competitive pricing |
| RFQ-103 | 03-08-2025 | XYZ Traders | ITM-009 | Steel Rod 10mm | 200 | Kg | 1.20 | USD | 12 | Open | Awaiting vendor reply |