wowprompt

Selling price and MRP from landed cost, GST and target margin

Works out a selling price and a printed MRP for each product from purchase cost, freight, packaging, GST, payment and marketplace fees and the margin wanted, and shows how much room is left for a sale discount. Use it when pricing a new range for a website or marketplace, or when costs went up and prices have not.

A pricing table per product from landed cost to selling price and MRP, with the margin at each discount level and the lowest safe sale price
The output this prompt produced, unedited.

The prompt

What to give

  • Products: [paste rows: name, purchase cost per unit, GST rate]
  • Freight and duty per unit to your warehouse: [paste, or a total to spread by units]
  • Packaging and inserts per unit: [e.g. Rs 18]
  • Shipping cost per order to the customer: [e.g. Rs 60 average]
  • Fees: [e.g. marketplace commission 12%, payment gateway 2%, fixed fee Rs 10]
  • Target margin after all costs: [e.g. 25% of the selling price before GST]
  • Sale discounts you expect to run: [e.g. 10% and 20%]
  • Competitor prices you have checked: [paste, or none]

Check each step

  1. Landed cost includes purchase, freight, duty and packaging.
  2. Fees are applied to the correct base, as given in the inputs.
  3. GST is added on top of the price before GST, and shown separately.
  4. MRP is the highest price the product will be sold at, and the selling price is at or below it.
  5. The sale price keeps a positive margin after every cost.

Output format

  1. | Product | Landed cost | Price before GST | GST | Selling price | MRP | Margin in Rs | Margin % |
  2. | Product | Margin at 10% off | Margin at 20% off | Lowest safe sale price |
  3. Products priced above competitors by more than 15%, with a note.
  4. One worked example showing every step in rupees.

Guardrails

  • Check the arithmetic of the worked example before giving it.
  • Round prices to sensible endings, and say the rounding rule used.
  • This is a pricing estimate; GST rates and MRP labelling rules must be confirmed with an accountant.
product pricingmrp calculationselling price from costgst pricingtarget marginecommerce pricing sheet

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