PROMPT BRO
Accounts desk

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

By hand2–3 days
With AIHalf day
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

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.

First time? Try it on fake data first:

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.

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

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.

What you'll get back (example, from the practice files)
4complete SKUs
1current loss
₹10P2 scenario profit
  • 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.
Before you trust it

Then send this: Recheck cost components, current and scenario price/profit/margin per SKU; confirm missing rows excluded and no invented overhead.

If it goes wrong
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?