Finance & Accounting · Manufacturing

Calculate true product costs with activity-based costing

Find which products really make money once overheads are spread fairly. An expert, step-by-step prompt with inputs, method, deliverables, rules and a quality check.

Your prompt is ready 5 brackets to fill
You are a cost accountant.
I work in Manufacturing: a manufacturing plant running shift-based production lines. This work matters to plant managers, line operators and procurement teams.

## Goal
Find which products really make money once overheads are spread fairly.

## What matters in Manufacturing
- Numbers that matter: OEE; first-pass yield; defect rate in PPM; scrap and rework cost; on-time delivery; unplanned downtime; inventory turns; lost-time injury rate.
- Rules and standards that usually apply: ISO 9001 quality management; worker-safety law (OSHA in the US, the Factories Act and labour codes in India) and ISO 45001; lockout/tagout and machine guarding; ISO 14001 and pollution-control consents; product marks such as CE or BIS certification.
- Common risks to plan for: machine breakdowns; supplier delays and raw-material price swings; quality escapes reaching customers; worker injuries; errors at shift handover.
- Timing and seasons: shift patterns; planned maintenance shutdowns; monthly production targets; annual customer and supplier audits.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## What I will give you
- Products and volumes: [PRODUCTS]
- Direct material and labour costs: [DIRECT]
- Overheads by type: [OVERHEADS]
- Activity data such as set-ups, orders and inspections: [ACTIVITIES]
- Anything else you should know: [EXTRA CONTEXT, or "none"]

## How to work through it
1. Restate the financial question, the period, the currency and the accounting basis (cash or accrual). List the figures you need that I have not given.
2. Find the 5 to 8 activities that drive most overhead.
3. Assign each overhead cost to activities.
4. Pick a cost driver for each activity.
5. Calculate a rate per driver unit.
6. Cost each product using its actual driver use.
7. Compare the result with the current costing method.
8. Recommend price, mix or process changes.
9. Show sensitivity: what happens to the result if the key assumptions are 10% to 20% worse.
10. List what a qualified accountant or tax adviser should review before I act.

## What to deliver
- Activity list
- Driver rates
- Product costs
- Comparison
- Actions

## Expert rules
- Show every calculation step and formula so I can check it in a spreadsheet.
- Keep numbers consistent: same currency, units and period throughout; round only at the end.
- Do not give tax or legal positions as certain; note the country and rules they depend on.
- Respect safety rules, ISO 9001 quality standards and fixed production schedules. If anything in my plan or inputs conflicts with them, say so plainly and suggest a fix.
- Do not invent facts, figures, laws, sources or quotes. Label anything you had to assume with "Assumption:" and tell me how to check it.

## Format
- Use tables for all figures, with totals and clear labels.
- Give spreadsheet formulas in fenced code blocks.
- Summarise the answer in plain language for a non-finance reader first.

## Before you answer
Check your draft against this list and fix anything that fails:
- Calculations are shown step by step so I can check them, and nothing reads as personal investment or tax advice.
- Every item under "What to deliver" is complete, specific to my inputs and usable as it is, with no placeholders left for me to guess.
- Where it applies, it shows the likely effect on OEE and defect rate.

If something essential is missing, ask me up to 3 short questions first. Otherwise, start.
Open in ChatGPT Claude Perplexity

How to use this prompt

  1. Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
  2. Fill the brackets. Use the form above, or replace [PRODUCTS], [DIRECT], [OVERHEADS], [ACTIVITIES], [EXTRA CONTEXT, or "none"] with your own details.
  3. Paste and send. Paste it into ChatGPT, Claude, Gemini and Microsoft Copilot and send. Ask follow-up questions to refine the answer.

Why this prompt works

The “Calculate true product costs with activity-based costing” prompt tells the assistant exactly what to hand back: activity list; driver rates; product costs; comparison; and actions. It makes the assistant work through 10 steps in order, starting with "restate the financial question, the period, the currency and the accounting basis (cash or accrual). List the figures you need that I have not given", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 3 tests and fixes anything that fails.

If an important detail is missing, the assistant asks you up to 3 short questions before it starts, so it does not build on guesses.

How to get the best answer

  1. Fill every bracket with real detail: [PRODUCTS], [DIRECT], [OVERHEADS] and the rest should hold real names, numbers and dates, not placeholders.
  2. Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
  3. Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
  4. Check the result: test what it builds or writes before you rely on it.

FAQ

Frequently asked questions

Which AI assistant works best with the “Calculate true product costs with activity-based costing” prompt?

The “Calculate true product costs with activity-based costing” prompt works in any chat assistant and suits ChatGPT, Claude, Gemini and Microsoft Copilot best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.

What do I fill in before sending the “Calculate true product costs with activity-based costing” prompt?

Replace the 5 highlighted brackets – [PRODUCTS], [DIRECT], [OVERHEADS], [ACTIVITIES], [EXTRA CONTEXT, or "none"] – with your own details. The more specific you are, the better the answer.

Who is the “Calculate true product costs with activity-based costing” prompt for?

Anyone who wants a complete, working result from an AI assistant. Replace the brackets with your own project details.

Is the “Calculate true product costs with activity-based costing” prompt free to use?

Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.

Can I trust the answer the “Calculate true product costs with activity-based costing” prompt gives?

Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.

Keep exploring

Browse more Manufacturing prompts