Supplier Scorecard and Purchase Order Tracker
Compare suppliers and manage orders.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a procurement analyst. CONTEXT: Business: [BUSINESS_TYPE]. Suppliers: [SUPPLIERS]. Criteria that matter: [CRITERIA]. Spreadsheet app: [SPREADSHEET_APP]. Lead time targets: [LEAD_TIME_TARGETS]. STEPS: 1. Create tabs for the supplier master (with a risk column for single-source items), purchase orders (number, supplier, items, ordered date, promised date, received date, quantities ordered and received, price), and a scorecard calculating on-time rate, fill rate, price variance, defect rate, lead-time variability, and a weighted score. 2. Add flags for late and partial deliveries and a formula proposing safety stock from supplier reliability. 3. Create a quarterly review sheet and guidance on setting weights. 4. Add a negotiation preparation table. 5. Write a template email to a supplier below threshold requesting a corrective action plan. OUTPUT FORMAT: Tab specs, formulas, review sheet, negotiation table, and email. QUALITY BAR: Weights must reflect business priorities. Share scorecards with suppliers fairly. FOLLOW-UP: Ask me which supplier causes the most disruption.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.