Stock lost to expiry out of the relevant total.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Expiry loss rate
—
Formula
Expired stock (qty or value) ÷ Relevant total (qty or value) × 100
=IFERROR(B2/C2,0)Excel: B2 expired stock (qty or value); C2 relevant total (qty or value)
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.