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.
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]
| Product | Margin at 10% off | Margin at 20% off | Lowest safe sale price |
Products priced above competitors by more than 15%, with a note.
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.