Weighted-average inventory costing calculator

Calculate ending units and ending inventory carrying value with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use ending units and ending inventory carrying value to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Opening inventory units
10
Opening unit cost ($)
2
Events: name, buy/sell, units, purchase unit cost $; sell cost must be 0
Buy1,buy,10,4 Sale1,sell,5,0
Ending units
15
Ending inventory carrying value ($)
$45.00
Moving-average ending unit cost ($)
$3.00
Total cost of issued units ($)
$15.00
Event closing quantity and value
Buy1: 20 units / 60.00; Sale1: 15 units / 45.00

Try another scenario

Opening inventory units
10
Opening unit cost ($)
2
Events: name, buy/sell, units, purchase unit cost $; sell cost must be 0
Buy1,buy,10,4 Sale1,sell,20,0
Ending units
0
Ending inventory carrying value ($)
$0.00
Moving-average ending unit cost ($)
Undefined at zero stock
Total cost of issued units ($)
$60.00
Event closing quantity and value
Buy1: 20 units / 60.00; Sale1: 0 units / 0.00
Calculation method

Calculation method

Ending units

Apply purchases and issues in entered order; reject any negative-stock event.

Ending inventory carrying value ($)

Add purchase units×cost; subtract each cent-rounded proportional issue cost. A full depletion removes all carrying value.

Moving-average ending unit cost ($)

Ending carrying value/ending quantity; undefined when empty.

Total cost of issued units ($)

Sum allocated issue costs, using current carrying value/quantity before each issue.

Event closing quantity and value

Show each event’s ending quantity and exact-cent carrying value.

Symbols and units
a
Opening inventory units
b
Opening unit cost ($)
c
Events: name, buy/sell, units, purchase unit cost $; sell cost must be 0

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A single-item perpetual moving-average ledger with whole units and no returns, negative stock or extra landed costs. Cent rounding is explicit and can differ from systems carrying more internal precision.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

OpenStax: perpetual inventory cost-flow methods ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.