About this calculator

Reconcile non-overlapping pallet issue cohorts at a cutoff, keeping returned, confirmed lost, retired and still-pending statuses exclusive. Optional pending exposure is a separate cost provision.

Inputs

How to use this calculator

Non-overlapping issue cohort

  1. Pallet issues in this cohortCount once per issued movement/cohort, not repeated inventory snapshots.
  2. Returned and closed issuesMutually exclusive status at the cutoff; do not also count these as retired or lost.
  3. Confirmed lost issuesConfirmed write-off only; pending returns are not automatically lost.
  4. Other approved non-return / retirement closuresExclusive of returned/lost. Includes only this defined cohort status.

Shared inputs

  1. Cost per confirmed lost issue (USD)Entered replacement/loss charge basis.
  2. Cost per retirement closure (USD)Your disposal/closure cost; no replacement is assumed for retirement.
  3. Cost per returned closed issue (USD)Only handling not already included in batch logistics.
  4. Total additional cohort logistics cost (USD)Added once across all entered non-overlapping cohorts.
  5. Total recovery credit (USD)Subtracted once. Do not double count credits already netted in other rates.
  6. Expected loss probability for pending issues (%)Optional assumption entered as 0–100; zero adds no pending provision. It does not close or reclassify issues.

Enter the shipment or scenario values, then select Calculate result.

Method

Formula and variables

Pending issues = issued − returned − confirmed lost − retirement closures. Confirmed net cost = lost × loss cost + retired × closure cost + returned × return cost + total logistics − total credit. Separate pending provision = pending × entered expected loss% × loss cost. Expected net cost adds that provision without changing status counts.

Pallet issues in this cohort
Count once per issued movement/cohort, not repeated inventory snapshots.
Returned and closed issues
Mutually exclusive status at the cutoff; do not also count these as retired or lost.
Confirmed lost issues
Confirmed write-off only; pending returns are not automatically lost.
Other approved non-return / retirement closures
Exclusive of returned/lost. Includes only this defined cohort status.
Cost per confirmed lost issue (USD)
Entered replacement/loss charge basis.
Cost per retirement closure (USD)
Your disposal/closure cost; no replacement is assumed for retirement.
Cost per returned closed issue (USD)
Only handling not already included in batch logistics.
Total additional cohort logistics cost (USD)
Added once across all entered non-overlapping cohorts.
Total recovery credit (USD)
Subtracted once. Do not double count credits already netted in other rates.
Expected loss probability for pending issues (%)
Optional assumption entered as 0–100; zero adds no pending provision. It does not close or reclassify issues.

Interpret the result

Pending issues remain open even when a loss provision is entered. Confirmed net cost and expected net cost therefore answer different questions.

Outputs: Confirmed losses, pending exposure and provision cost

A cohort cost worksheet, not asset tracking or automatic loss attribution. Statuses must be exclusive; closed counts cannot exceed issues. Cohorts must not overlap. Expected pending exposure is not an invoice or confirmed loss. No ownership, pool contract or recovery probability is inferred.

Worked example

Check the arithmetic

This example uses the starting values shown above. The arithmetic below is calculated independently of the interactive result.

Work through the calculation

  1. Pending = 100 − 85 − 7 − 5 = 3 issues.
  2. Confirmed net cost = 7 × 20 + 5 × 2 + 85 × 1.5 + 100 − 50 = $327.50.
  3. Default pending loss probability is 0%, so provision = $0 and expected net cost remains $327.50.

Compare the displayed result

Expected displayed result: $327.50 net cost

FAQs

Are all unreturned pallets treated as lost?

No. After subtracting confirmed closures, the remainder stays pending. A probability-based provision changes expected cost without changing status counts.

Example inputs and options

Starting values are examples unless a field identifies a dated rule. Unit selectors convert only fields marked for conversion. Rates and model options keep the units and basis shown in their labels.

Pallet issues in this cohort
Example: 100
Returned and closed issues
Example: 85
Confirmed lost issues
Example: 7
Other approved non-return / retirement closures
Example: 5
Cost per confirmed lost issue (USD)
Example: 20
Cost per retirement closure (USD)
Example: 2
Cost per returned closed issue (USD)
Example: 1.5
Total additional cohort logistics cost (USD)
Example: 100
Total recovery credit (USD)
Example: 50
Expected loss probability for pending issues (%)
Example: 0