Finance & Accounting · Logistics & Supply Chain

Calculate cost to serve by customer

Find which customers are profitable once delivery and handling are counted. 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 logistics finance analyst.
I work in Logistics & Supply Chain: a logistics company running warehouses and a delivery fleet. This work matters to shippers, carriers and warehouse teams.

## Goal
Find which customers are profitable once delivery and handling are counted.

## What matters in Logistics & Supply Chain
- Numbers that matter: on-time delivery rate; OTIF; cost per shipment; fleet utilisation; order accuracy; damage rate; dock-to-stock time.
- Rules and standards that usually apply: driver working-hours limits; road safety and vehicle fitness; customs and trade paperwork (HS codes, e-way bills and GST in India); dangerous-goods rules; insurance and liability terms in contracts.
- Common risks to plan for: missed delivery windows; fuel price swings; damage and theft; customs holds; driver shortages.
- Timing and seasons: festive and year-end peaks; monsoon and weather disruption; the month-end dispatch rush.
- 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
- Customers and revenue: [CUSTOMERS]
- Order profile: drops, lines and sizes: [ORDERS]
- Warehouse and transport costs: [COSTS]
- Contract terms: [CONTRACTS]
- 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. Map the activities each order uses: picking, packing, transport, returns and admin.
3. Assign warehouse and transport costs to those activities.
4. Calculate the cost to serve and the margin for each customer.
5. Rank customers by margin and by total profit.
6. Find the causes of low margins, such as small drops or rush orders.
7. Recommend changes to minimum orders, delivery days or prices.
8. Plan conversations with the customers most affected.
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
- Cost model
- Customer margins
- Ranking
- Recommendations
- Talk plan

## 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 delivery windows, customs rules and driver-hours limits. 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 on-time delivery rate and cost per shipment.

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 [CUSTOMERS], [ORDERS], [COSTS], [CONTRACTS], [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 cost to serve by customer” prompt tells the assistant exactly what to hand back: cost model; customer margins; ranking; recommendations; and talk plan. 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: [CUSTOMERS], [ORDERS], [COSTS] 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 cost to serve by customer” prompt?

The “Calculate cost to serve by customer” 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 cost to serve by customer” prompt?

Replace the 5 highlighted brackets – [CUSTOMERS], [ORDERS], [COSTS], [CONTRACTS], [EXTRA CONTEXT, or "none"] – with your own details. The more specific you are, the better the answer.

Who is the “Calculate cost to serve by customer” prompt for?

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

Is the “Calculate cost to serve by customer” 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 cost to serve by customer” 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 Logistics & Supply Chain prompts