Spreadsheets
Supplier Price Comparison
Compare quotes from multiple vendors to find the best deal.
Updated: January 26, 2026
What does this AI prompt do?
This AI prompt helps UK SMEs by providing a ready-to-use template for compare quotes from multiple vendors to find the best deal.. Simply copy the template below, customize the variables for your business, and paste into any AI tool like ChatGPT or Claude.
AI Prompt Template
Act as a specialist consultant. Here is the improved business prompt template, maintaining the exact structure and variables while maximizing clarity, persuasiveness, and results: **Objective: Crucial Vendor Selection Analysis** I am currently conducting a rigorous comparative analysis to select the optimal vendor for **[Product/Service]** and have solicited binding quotes from three distinct suppliers. Generate a professional, comprehensive comparison matrix to facilitate immediate, data-driven decision-making. **Matrix Specification:** * **Rows (Key Evaluation Criteria):** Unit Price, Delivery Cost, Bulk Discount Threshold, Payment Terms, Lead Time. * **Columns (Vendors & Output):** Supplier A, Supplier B, Supplier C, **Optimal Selection Score (Formula-Driven)**. **Required Actions:** 1. Construct the comparison matrix using the specified rows and columns, clearly labeling all cells. 2. Integrate a conditional formatting logic (or explicit notation) within the 'Unit Price' row to automatically flag the **absolute lowest numerical price** (e.g., using a visual indicator or the MIN function output).
How to use this prompt:
- Copy the template above
- Customize the variables in brackets [like this] with your business details
- Paste into ChatGPT, Claude, or your preferred AI tool
- Get professional results in minutes
Why this works:
This prompt uses proven business frameworks and UK-specific requirements. It's designed to give you professional results that comply with local regulations and industry best practices.