wowprompt

Supplier comparison sheet for sourcing a new product

Compares supplier quotes for a new product on landed cost, minimum order, lead time and risk, and lists the questions to ask before placing a first order. Use it when an online seller has two or more quotes and needs to choose.

A supplier comparison table with landed cost per unit, minimum order, lead time and risk notes, a weighted score, and a list of questions for each supplier
The output this prompt produced, unedited.

The prompt

Goal

Choose the best supplier for a new product on total cost and reliability, not on unit price alone.

Inputs

  • Product and specification: [e.g. 500 ml steel water bottle, food-grade 304 steel]
  • Quantity planned for the first order: [units]
  • Supplier quotes: [paste for each: unit price, minimum order, packaging, shipping cost or terms, lead time, payment terms, samples, certifications]
  • What matters most: [rank cost, quality, speed, flexibility]
  • Selling price planned: [price]

Steps

  1. Work out landed cost per unit for each supplier: unit price plus shipping, duties if given, and packaging, divided by the order quantity.
  2. Compare minimum order, lead time and payment terms.
  3. Note risks: missing certifications, no samples, advance payment in full, unclear specs.
  4. Score each supplier from 1 to 5 on the priorities, weighted by the ranking given.
  5. Write the questions each supplier must answer before an order.

Output format

| Supplier | Unit price | Landed cost per unit | Margin at planned price | Minimum order | Lead time | Payment terms | Risks | Weighted score |

Recommendation in two lines, then "Ask before ordering" with three to five questions per supplier.

Check before answering

  • Every landed cost shows its calculation.
  • Missing information is marked "not quoted", never guessed.
  • The recommendation suggests a sample or small first order when quality is unproven.
  • No supplier is called certified unless the quote says so.
supplier comparisoncompare supplier quotesproduct sourcing checklistlanded cost calculationwholesale supplier selectionecommerce sourcing

How to run this

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.

Related prompts

All productivity