Why you need this
Waste is not only trash; it is unsold revenue. Skipping the rate as 'a little spoilage' hides monthly loss.
This tool derives wasted units from purchases, then shows cost loss at unit cost and opportunity loss at selling price.
How it is calculated
Wasted units = purchase quantity x waste rate. Cost loss = wasted units x unit cost. Opportunity loss = wasted units x selling price.
How to read the result
Cost loss is inventory damage. Opportunity loss is the sales that never happened. A high waste rate points to portioning, storage and ordering.
This tool is for information only.