Offer options with margin impact
Festival offer says 20% off. Finance asks 20% off what?
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Prepare offer working
Use SKU, list price, approved cost and proposed discount. Compare before GST, no offer approved by AI.
Privacy Remove personal names, phone numbers, email IDs, photos and customer identifiers. Use approved business facts, anonymous codes or aggregate data.
Basis: [Basis] Review rule: [Review rule] I'm attaching offer-options.xlsx. A. Calculate offer price, profit per unit and margin % for complete rows. B. Compare with list price profit; flag loss and missing input. C. Suggested questions for approval; no publishing or invented discount. Use only supplied facts. No invented statistics, awards, testimonials, customer names, No. 1, guaranteed, health, finance or legal claims. Do not copy competitor copy or use real people's names or photos. Write regional-language versions only if I request them in a box. A person checks before publishing 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 company records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:D SKU, list price, cost, proposed discount %. Basis [Basis], rule [Review rule]. Give formulas for offer price, list and offer unit profit, margin % if offer price positive, loss and missing-data flags. No automatic price approval. 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 the figures and flags against your source records and ask the responsible person to approve before acting.
- P1₹100 profit. ₹1,000 less 10% = ₹900, cost ₹800.
- P2₹50 loss. ₹500 less 10% = ₹450, cost ₹500.
- P4Cost missing. No margin calculation.
Then send this: Recalculate each offer price and profit; hold missing inputs.
Approves offer
Reply: "Scenario only."
Invents cost
Reply: "Hold missing."
Confuses margin
Reply: "Profit / offer price."
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.