PPUT

Everyday Calculators

Price per Unit Target Calculator

Solve the maximum shelf price or required rebate that meets a target cost per usable quantity after tax, shipping, pack size, and expected loss.

Current usable-unit cost
Maximum landed cost at target
Maximum shelf price at target
Required shelf-price reduction
Required total rebate
Expected usable quantity
Cost improvement required
Target decision

Negotiation target map

Current landed-cost bridge, target corridor, and allowable shelf-price gate

A stacked cost bridge shows where the current unit cost comes from. The target corridor then marks the exact shelf-price or rebate change needed without hiding tax, freight, or expected loss.

Current landed-cost bridge, target corridor, and allowable shelf-price gateUpdates with every input

Live decision table

Target sensitivity by expected loss

See how spoilage, defects, or unusable yield change the allowable shelf price and rebate requirement.

Live analysis based on the current calculator inputs
Unusable rateUsable quantityCurrent unit costMaximum shelf priceRequired rebateTarget status

Target definition

Define the service quantity before setting a price target

  1. Use the unit actually consumed or delivered.
  2. Separate pack count from size per item.
  3. Estimate normal spoilage or defect loss.
  4. Include only rebates that are certain and collectible.

Backward pricing logic

A unit-cost target is a landed-cost constraint

The same headline pack price can miss the target when freight is high or usable yield is low. Solving backward converts the target into a concrete negotiating number.

A negative shelf-price ceiling means the target cannot be reached even if the merchandise is free because fixed delivery cost exceeds the landed-cost allowance.

Calculation method

Convert the usable-unit target into a maximum landed cost and shelf-price ceiling

The target applies to usable quantity, not nominal package count. Expected loss reduces the denominator first; the target unit cost is then multiplied by usable quantity to establish a landed-cost ceiling. Fixed freight and rebates are separated before solving backward through tax for the allowable shelf price.

Detailed calculation process and general formulas

Q_u = N x q x (1 - w)L_current = P x (1 + t) + S - RC_current = L_current / Q_uL_target = C_target x Q_uP_max = (L_target - S + R) / (1 + t)R_required = max(P x (1 + t) + S - L_target, 0)

Symbols, meanings, and units

N
nominal units in the packitems
q
quantity delivered by each nominal unitquantity/item
w
expected unusable sharedecimal
Q_u
expected usable quantityquantity
P
current shelf or quoted pack pricecurrency
t
sales-tax rate on pack pricedecimal
S
allocated shipping and handlingcurrency
R
certain rebate or creditcurrency
C_target
maximum acceptable cost per usable quantitycurrency/quantity
P_max
highest shelf price consistent with the targetcurrency

The worked calculation below substitutes the live inputs in formula order, names each intermediate result, and reconciles the headline result with the visual and decision table.

Negotiation use

Choose the lever the supplier can actually change

Use the shelf-price ceiling for a quoted-price negotiation, the rebate result for a post-purchase credit, or the loss sensitivity table for a quality guarantee.

Do not treat a larger pack as cheaper unless the additional quantity will be usable.

Evidence checklist

Document the target before asking for a concession

  • Save the unit specification.
  • Record freight and tax treatment.
  • Use observed yield where available.
  • Set a validity date for the price target.

Target feasibility diagnostic

What must change to reach the requested usable-unit cost?

The target is split into quantity, fixed-cost, and shelf-price constraints so the result supports a specific action rather than a generic cheaper-is-better conclusion.

Current usable cost

Landed cash divided by expected usable quantity.

Allowable landed cost

Maximum all-in cost compatible with the entered unit target.

Negotiated shelf ceiling

Pre-tax pack price that preserves freight and the entered rebate.

Required improvement

Percentage reduction in current usable-unit cost.

Decision takeaway: Negotiate against the solved shelf-price ceiling or rebate requirement, not against an arbitrary percentage discount.

Practical applications

Decisions this calculator is designed to support

Restaurant ingredient specification

A kitchen prices a case by usable kilograms after trim loss, freight, and an invoice rebate.

What the result clarifies: The allowable case quote tightens when observed trim loss rises even though nominal case weight is unchanged.

Workshop consumable pack

A maintenance team targets a maximum cost per serviceable abrasive disc and records normal defects.

What the result clarifies: A quality credit can meet the target even when the supplier cannot reduce the list price.

Worked example

Current-input substitution and reconciliation

This live example works backward from the target usable-unit cost through expected loss, pack size, shipping, and tax, then reconciles the allowable shelf price with the required rebate or concession.

Important note

This target model assumes the entered loss rate and rebate are expected values. It does not include financing, inventory holding, expiration, or tier-dependent freight unless those amounts are included in shipping or the quoted price.

Price per Unit Target Calculator FAQ

Why is the target based on usable quantity?

Nominal quantity does not create value when part of the pack is spoiled, defective, or otherwise unusable.

Can the maximum shelf price be negative?

Yes. That means fixed shipping net of the rebate already exceeds the total landed-cost allowance, so the target is infeasible under the entered logistics.

Should a mail-in rebate be entered at face value?

Only if collection is sufficiently certain. Otherwise use an expected rebate equal to face value multiplied by the realistic redemption probability.

Does the calculator round to supplier price increments?

No. Treat the exact ceiling as a boundary, then round downward to the supplier's permitted quote increment.