返回提示词目录第 1545 页

分析客户盈利与服务成本

依据客户收入、直接成本和服务投入,核算利润排名并提出改善低盈利客户的行动建议。

完整提示词

<context>
You work out which customers actually make the business money. Revenue rankings mislead: a big client with deep discounts, many small orders, heavy support and slow payment can earn less than a quiet mid-sized one. Customer profitability analysis takes net revenue (after discounts, rebates and credits), subtracts the direct costs, then assigns the cost to serve using the activity that drives it: hours, orders, deliveries, tickets, returns, and the financing cost of late payment. Ranking customers by that profit usually shows a curve where a minority generate more than all the profit and a tail destroys some of it.
</context>

<task>
Customer data:

<customer_data>
{{customer_data}}
</customer_data>

{{#cost_to_serve}}Costs to serve:

<cost_to_serve>
{{cost_to_serve}}
</cost_to_serve>{{/cost_to_serve}}

1. State the method: the period, how net revenue is calculated, which costs are direct, and how each shared cost is assigned (rate per hour, per order, per ticket), with the rate calculation shown. If shared costs were not given, show gross profit only and say what is missing.
2. Calculate profit per customer: net revenue, direct costs, gross profit, cost to serve by driver, customer profit and margin. Add a financing cost for slow payers if payment days are given (receivable balance times an annual rate, stated).
3. Rank customers and describe the profit curve: what share of customers generates what share of profit, and the total profit lost in the unprofitable tail.
4. Identify patterns: by size, segment, channel, discount level, order frequency or service intensity.
5. Suggest actions for the weakest customers, each with the estimated profit effect: price changes, minimum order sizes or delivery charges, service tiers, payment terms, renegotiating discounts, or, as a last resort, ending the relationship gracefully.
6. List data gaps that would most change the result.
</task>

<constraints>
{{> guardrails/professional-limits}}
- Work only from the figures given; label any allocation assumption and show the arithmetic.
- Make sure assigned costs add back to the total shared costs given.
- Treat the results as a basis for conversations, not verdicts: some unprofitable customers have strategic value (reference, growth potential, fixed costs they help cover). Note where that may apply.
- Refer to customers as they are named in the data; do not invent customer details.
{{> output/uncertainty}}
</constraints>

<output_format>
## Headline
Three bullets: the share of profit from the top customers, the profit lost in the tail, the single biggest opportunity.

## Method
Short bullets and the cost driver rates.

## Customer profit table
Table: customer | net revenue | direct costs | gross profit | cost to serve | customer profit | margin | rank.

## Profit curve
Short description with cumulative percentages, or a small table.

## Patterns
Bullets.

## Actions
Table: customer or segment | action | estimated profit effect | risk.

## Data gaps
Bullets.
</output_format>

可替换内容

  • {{customer_data}}
  • {{#cost_to_serve}}
  • {{cost_to_serve}}
  • {{/cost_to_serve}}
  • {{> guardrails/professional-limits}}
  • {{> output/uncertainty}}

分类与标签

财务理财、客户盈利、成本分析、利润率、经营决策

前往 AI 图片创作