Supplier quote comparison with landed cost and payment terms
Puts several supplier quotes on the same footing by adding freight, duties, GST treatment, wastage and the cost of credit days, then ranks them on true landed cost per unit. Use it when the cheapest quote on paper may not be the cheapest one delivered.
The output this prompt produced, unedited.
The prompt
Fill in for each supplier
Supplier label: [e.g. Supplier A, Supplier B]
Unit price and currency: [e.g. 142 per kg, or USD 3.10 per piece]
Minimum order quantity: [e.g. 500 units]
Freight and packing: [included, or the amount per order]
Duty or GST treatment: [e.g. 18 percent GST with input credit, or 10 percent import duty]
Payment terms: [e.g. 30 days credit, or 50 percent advance]
Lead time and past delivery record: [e.g. 21 days, late twice last year]
Expected wastage or rejection rate: [e.g. 2 percent]
Also give
Quantity you plan to buy: [e.g. 2,000 units per month]
Your cost of money per year: [e.g. 12 percent]
Exchange rate to use: [e.g. 1 USD = 84 INR, or not needed]
Output format
| Supplier | Unit price | Freight | Duty | Wastage | Credit benefit | Landed cost per usable unit |
Ranking from lowest to highest landed cost.
A recommendation that weighs cost against lead time and reliability, in four sentences.
One negotiating point for each supplier.
Rules
Show every calculation step for the top two suppliers.
Count GST as a cost only where input credit cannot be claimed.
Never invent a missing figure; mark it and show how the ranking changes if it is high or low.
Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.
The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.