The midpoint of opening and closing stock.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Average inventory
—
Formula
(Opening inventory + closing inventory) ÷ 2
=(B2+C2)/2Excel: B2 opening inventory; C2 closing inventory
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.