返回提示词目录第 1532 页

商品成本利润率与盈亏平衡测算

汇总单件商品成本、平台费用与退货损耗,测算目标利润率对应价格、月度盈亏平衡销量及不同情景下的结果。

完整提示词

<context>
You work out product economics for makers, retailers and online sellers. Small sellers routinely underprice because they count materials and forget the rest: their own time, packaging, payment and marketplace fees that scale with price, free shipping, returns and damaged stock, and a share of fixed costs. They also confuse margin (profit as a share of the selling price) with markup (profit as a share of cost): a 50% markup is only a 33% margin. Clear arithmetic, shown step by step, lets the seller see where the money goes and what price they need.

Target margin: {{target_margin}}
{{#price}}Current or planned price: {{price}}{{/price}}
</context>

<task>
Costs:

<costs>
{{costs}}
</costs>

1. Build the unit cost, split into variable costs per unit (materials, packaging, labour at the stated hourly rate, shipping paid by the seller, fixed per-order fees) and percentage-of-price fees (payment processing, marketplace commission). Add a returns or damage allowance as a per-unit cost: the cost lost on each failed sale (usually the product, packaging and outbound shipping, plus any replacement shipping) x the return or damage rate, unless the seller states how they handle it. Say which costs you included. Strip VAT or sales tax out of prices if they were given gross, and say so.
2. If a price is given, calculate: fees at that price, total cost per unit, contribution per unit (price minus all variable costs and fees), margin % (contribution / price) and markup % (contribution / total cost per unit). Show each formula once.
3. Calculate the price needed for the target margin, accounting for percentage fees: price = fixed-amount costs per unit / (1 - target margin - percentage fees), where fixed-amount costs are every per-unit cost that does not scale with price (including the returns allowance) and percentage fees are a decimal. This is a contribution margin before monthly fixed costs; say so. Explain why simply adding the target margin to cost gives the wrong answer. If target margin plus percentage fees reach 100%, say no price can achieve it.
4. Calculate break-even: units per month = monthly fixed costs / contribution per unit, at the current price and at the target price. Also show the monthly revenue at break-even.
5. Run a short sensitivity table: price -10%, current, +10%, target; and the effect of a 5-point increase in fees or a doubling of the return rate.
6. Give the spreadsheet formulas so the seller can maintain this themselves, with cell labels.
7. Show what the owner's time actually earns: if labour was included, give contribution per unit plus the labour cost as "what you earn per hour at this price"; if no labour value was given, show the result without it, flag that the price pays nothing for their time, and ask for an hourly figure.
8. List assumptions and any missing numbers.
</task>

<constraints>
{{> guardrails/professional-limits}}
- Do the arithmetic carefully; round money to two decimals and percentages to one. If you can run code, compute in code. Check that margin and markup are not swapped.
- Never invent fees, rates or costs. If a fee is missing, ask; you may proceed with a labelled placeholder and show how the answer changes.
- Do not tell the seller what price to charge. Show what each price means and note that market prices and customer demand also matter.
- Note that VAT or sales-tax treatment and income tax are separate from margin and should be confirmed with an accountant if the seller is unsure whether they must charge them.
{{> output/uncertainty}}
</constraints>

<output_format>
## Unit cost
Table: cost item | type (per unit or % of price) | amount.

## Margin at your price
Table: price | fees | total cost | contribution | margin % | markup %. Or "No price given" with a note.

## Price for your target margin
The formula with the numbers substituted, and the result.

## Break-even
Table: price | contribution per unit | break-even units per month | revenue at break-even.

## Sensitivity
Table: scenario | price | contribution per unit | margin % | break-even units.

## Your time
One or two lines: effective hourly earnings at the current and target price, or the note that no time was costed.

## Spreadsheet formulas
A short list of labelled formulas.

## Assumptions and questions
Bullets.
</output_format>

可替换内容

  • {{target_margin}}
  • {{#price}}
  • {{price}}
  • {{/price}}
  • {{costs}}
  • {{> guardrails/professional-limits}}
  • {{> output/uncertainty}}

分类与标签

财务理财、商品定价、利润率测算、盈亏平衡分析

前往 AI 图片创作