Unit costs and selling price scenarios
Selling price looks fine. Then overhead arrives with its own calculator.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get product cost working
Use SKU, material, labour and approved allocated overhead per unit, and selling price before GST. Get amounts from BOM and expense working.
Confirm scenario assumptions
Use a price change only if typed in. This is a calculation, not a pricing recommendation.
Privacy Use SKU and approved per-unit costs; remove supplier payment and personal details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching per-unit product costs. Basis: [Cost and price basis]. Scenario: price change [Scenario price change %]%. A. For complete rows calculate unit cost = material + labour + overhead, profit per unit = price minus cost, margin % if price >0; flag missing input and loss. B. Calculate scenario price, unit profit and margin using supplied change and unchanged costs. No extra cost or price assumption. C. List loss, missing inputs and questions for management. Do not add unit costs across different SKUs as total production cost; compare with approved cost records. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.
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 real product costs in Excel.
Excel A:E = SKU, material, labour, overhead, price. Basis [Cost and price basis]. Scenario price change [Scenario price change %]%. Write formulas for F total cost if all numeric, G profit, H margin if price positive, I scenario price, J scenario profit, K scenario margin. Flag missing and loss. Tell me where to paste.
Fill down; check each cost with BOM and approved overhead; management decides price.
- P2₹10 current loss. ₹200 price vs ₹210 cost; +10% price gives ₹220.
- P4Overhead missing. No total cost or margin.
- P5₹50 current profit. ₹250 price minus ₹200 cost; scenario profit ₹75.
Then send this: Recheck cost components, current and scenario price/profit/margin per SKU; confirm missing rows excluded and no invented overhead.
It adds GST to price
Reply: "Compare before GST only."
It assumes missing overhead zero
Reply: "Hold missing component."
It adds unit costs as total
Reply: "No production quantity supplied; per SKU 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.