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
Prepare product scenario working
Use SKU, unit cost, current price and proposed price. All before GST on same basis.
Privacy Remove personal names where not needed, phone numbers, email IDs, personal records and bank details. Use role, employee code or aggregate business facts.
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.
Keep actual business records in your own workbook; ask AI for the method using column headings and rules only.
Excel A:D SKU, cost, current price, proposed price. Basis [Basis], rule [Review rule]. Give formulas for current and proposed unit profit, margin % only if selling price positive, profit change and loss/missing flags. Scenario only, no pricing decision. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run locally, verify every result against source records, and have the responsible person or professional approve before acting.
- P1₹100 more profit. Price ₹1,000 to ₹1,100; cost ₹700.
- P2₹50 loss. Proposed ₹450 vs cost ₹500.
- P4Cost missing. No margin.
Then send this: Recalculate prices, costs and margins; hold missing rows.
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?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.