Business

Inventory Pricing Calculator

The calculator avoids comparing list price directly with supplier cost. It first estimates realized cash revenue per gross sold unit, builds landed inventory cost from purchase, freight, duty, and packaging, and then tests whether monthly volume covers fixed inventory overhead.

Customer-facing list price per unitAverage discount from list price (%)Expected return or refund rate (%)Payment and marketplace fee on retained sales (%)Supplier purchase cost per unitInbound freight per unitDuty applied to purchase cost (%)Packaging and inspection per unitOutbound fulfillment per retained unitGross units sold per monthMonthly storage, software, and inventory overheadTarget contribution margin on net cash revenue (%)

Average selling price after discount-

Revenue retained after returns-

Payment and marketplace fee per gross sold unit-

Net cash revenue per gross sold unit-

Duty per purchased unit-

Purchase, inbound freight, duty, packaging-

Landed inventory plus outbound fulfillment-

Net cash revenue less variable cash cost-

Contribution as share of net cash revenue-

Contribution before fixed monthly cost-

Contribution after fixed monthly cost-

Gross monthly units needed for break-even-

Net revenue required for target margin-

List-price share retained after discounts, returns, and fees-

List price required for target contribution margin-

Landed inventory represented by monthly gross units-

Decision view

List-price leakage and unit-contribution waterfall

List-price leakage and unit-contribution waterfallList price moves through discounts, returns, fees, landed cost, and fulfillment before break-even units and target-margin price are compared.

Exact scenario comparisonCustomer-facing list price per unit changes while all other entered assumptions remain constant.

Customer-facing list price per unit	Average selling price after discount	Revenue retained after returns	Payment and marketplace fee per gross sold unit	Net cash revenue per gross sold unit	Duty per purchased unit	Purchase, inbound freight, duty, packaging	Landed inventory plus outbound fulfillment	Net cash revenue less variable cash cost	Contribution as share of net cash revenue	Contribution before fixed monthly cost	Contribution after fixed monthly cost	Gross monthly units needed for break-even	Net revenue required for target margin	List-price share retained after discounts, returns, and fees	List price required for target contribution margin	Landed inventory represented by monthly gross units

How to use Inventory Pricing Calculator

Enter the customer-facing price and observed average discount, return, and fee rates.
Build landed unit cost from supplier price, inbound freight, duty, packaging, and outbound fulfillment.
Enter gross monthly unit volume, fixed inventory overhead, and the desired contribution margin.

Calculator guide

Understanding Inventory Pricing Calculator

Trace one SKU from list price through discounts, returns, payment fees, landed cost, fulfillment, unit contribution, monthly fixed overhead, break-even volume, and the minimum list price needed for a target contribution margin.

List price is not realized cash Discounts, returns, and fees reduce the amount retained.

Landed cost is broader Supplier price alone omits freight, duty, and packaging.

Fixed overhead needs volume Positive unit contribution can still produce a monthly operating loss.

Target margin solves backward The required list price is derived after all leakage factors.

Detailed calculation process

Build a SKU price waterfall and solve break-even and target price

The default uses a $95 list price, 10% average discount, 8% returns, 3% payment fees, $42 supplier cost, $3.50 freight, 5% duty, $1.50 packaging, $6 fulfillment, 500 units, $18,000 fixed cost, and a 40% target margin.

General formula: P_disc = P_list(1 - d/100)R_rec = P_disc(1 - r/100)F_pay = R_rec f/100R_cash = R_rec - F_payD = C_buy u/100C_land = C_buy + C_freight + D + C_packC_var = C_land + C_fulfillU = R_cash - C_varM = U/R_cash × 100C_month = Q U - F_fixedQ_BE = ceil(F_fixed / max(U, epsilon))k = (1-d/100)(1-r/100)(1-f/100)R_target = C_var/(1-m/100)P_target = R_target/max(k, epsilon) Every leakage rate uses an explicit base. Duty applies to supplier cost, payment fees apply to retained revenue, and the target price reverses discount, return, and fee leakage after solving the net revenue required for the target margin.

What each symbol means

P_list, d, r, f List price ($/unit), discount, return, and payment-fee rates (%).

R_rec, R_cash Recognized revenue and net cash revenue per gross sold unit ($).

C_buy, C_land, C_var Supplier, landed, and total variable cash costs per gross unit ($).

U, M Unit contribution ($) and contribution margin on net cash revenue (%).

Q, F_fixed, Q_BE Gross monthly units, fixed monthly overhead ($), and break-even units.

m, k, P_target Target margin (%), price-realization factor, and required list price ($).

Worked substitution with the default inputs

1. Convert list price to retained cash P_disc = $95×0.90 = $85.50R_rec = $85.50×0.92 = $78.66F_pay = $78.66×3% = $2.3598R_cash = $76.3002 Discounts, returns, and payment fees reduce list price in sequence.

2. Build landed and fulfilled cost D = $42×5% = $2.10C_land = $42 + $3.50 + $2.10 + $1.50 = $49.10C_var = $49.10 + $6 = $55.10 Supplier price is only one component of the cash cost tied to each gross sale.

3. Calculate unit and monthly contribution U = $76.3002 - $55.10 = $21.2002C_month = 500×$21.2002 - $18,000 = -$7,399.90 The SKU is contribution-positive per unit but does not cover the entered monthly fixed overhead at 500 units.

4. Solve break-even volume Q_BE = ceil($18,000 / $21.2002) = 850 units Break-even rounds upward to the first whole gross unit that covers fixed cost.

5. Solve the target-margin list price k = 0.90×0.92×0.97 = 0.80316R_target = $55.10/0.60 = $91.8333P_target = $91.8333/0.80316 = $114.34 The target list price compensates for the same discount, return, and fee leakage.

The default retains about $76.30 cash per gross unit, earns $21.20 unit contribution, breaks even at 850 units, and needs about a $114.34 list price for a 40% contribution margin under the entered leakage rates.

Purpose-built visual

Price-to-contribution waterfall with break-even marker

A live waterfall bridges selling price to unit contribution, then compares gross opening volume with break-even and target volume.

List-to-cash waterfall The entered list price steps through discount, return allowance, and transaction fee to reach net cash revenue per gross unit.

Unit contribution split Landed inventory and fulfillment costs remain separate from price leakage before they reduce net cash revenue to SKU contribution.

Target price threshold The minimum list price for the requested margin is shown beside current contribution and break-even unit volume, not substituted for either result.

Worked situations

Practical examples

The default $95 list price becomes $85.50 after discount and $76.30 of net cash revenue after returns and payment fees.
Landed cost is $49.10 and fulfillment adds $6, leaving about $21.20 contribution per gross sold unit before fixed overhead.

Better inputs

Useful tips

Build landed unit cost from purchase price, inbound freight, duty, packaging, inspection, and expected shrink.
Use the realized selling price after discounts, returns, marketplace fees, and outbound fulfillment.
Test whether demand and stock turnover support the calculated price; a strong unit margin alone does not guarantee inventory profit.

Before relying on the result

Limitations and common mistakes

Return rate is modeled as lost revenue without separate recovery value, return freight, refurbishment, or disposal cost.
Payment fees are applied to retained post-return revenue; channel contracts may use a different fee base.
Unsold inventory, stockouts, aging, markdown schedules, purchase minimums, taxes, storage tiers, and cash timing are excluded.

Reference

Key terms

Net cash revenue per gross unit: List price after average discount, returns, and payment or marketplace fees.
Landed unit cost: Supplier cost plus inbound freight, duty, packaging, and inspection allowance.
Unit contribution: Net cash revenue less landed inventory and outbound fulfillment cost.

Important note

Validate the waterfall using actual settlement reports and SKU-level landed-cost records; channel fee bases and return losses often differ from headline percentages.

Frequently asked questions

Why are returns applied to price instead of unit count?

The model reports economics per gross sold unit; the return rate reduces retained revenue for that gross unit.

Why can monthly contribution be negative when unit contribution is positive?

Gross unit contribution may be insufficient to cover fixed storage, systems, and inventory overhead.

Does the target price predict demand?

No. It only solves the entered margin equation; market response must be tested separately.

Should fulfillment be included in landed cost?

It is kept separate in the inputs but combined into total variable cash cost for contribution.