PROMPT BRO
Owners desk

Pricing scenarios with margin calculations

Pricing decision starts with 'round it off'. The margin sheet prefers arithmetic.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By handDays
With AI1 hr
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare product scenario working

Use SKU, unit cost, current price and proposed price. All before GST on same basis.

First time? Try it on fake data first:

Privacy Remove personal names where not needed, phone numbers, email IDs, personal records and bank details. Use role, employee code or aggregate business facts.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
pricing-scenarios.xlsx

Basis: [Basis] Review rule: [Review rule] I'm attaching pricing-scenarios.xlsx. A. Calculate current and proposed profit and margin % per complete SKU. B. Compare change in unit profit; flag loss and missing inputs. No demand forecast. C. Suggested questions for management, no final price decision. Use only supplied facts and numbers. Separate facts from suggestions and label suggestions clearly. No invented reasons, commitments or figures. A person checks before sending, paying or deciding.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
3complete SKUs
1loss scenario
2held
  • P1₹100 more profit. Price ₹1,000 to ₹1,100; cost ₹700.
  • P2₹50 loss. Proposed ₹450 vs cost ₹500.
  • P4Cost missing. No margin.
Before you trust it

Then send this: Recalculate prices, costs and margins; hold missing rows.

If it goes wrong
Forecasts demand

Reply: "No demand data supplied."

Assumes cost zero

Reply: "Hold missing."

Approves price

Reply: "Scenario only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?