Track inventory value using weighted average purchase costs. Estimate COGS, ending inventory, and profit margins. Built for accountants needing faster, clearer stock valuation decisions.
| Item | Units | Unit Cost | Extra Cost | Total Cost |
|---|---|---|---|---|
| Beginning Inventory | 120 | $15.50 | $0.00 | $1,860.00 |
| Purchase 1 | 80 | $16.20 | $45.00 | $1,341.00 |
| Purchase 2 | 100 | $17.10 | $60.00 | $1,770.00 |
| Purchase 3 | 60 | $16.80 | $30.00 | $1,038.00 |
| Units Sold | 220 | — | — | Used for COGS |
Weighted Average Cost per Unit = Total Cost of Goods Available ÷ Total Units Available
COGS = Units Sold × Weighted Average Cost per Unit
Ending Inventory Value = Ending Units × Weighted Average Cost per Unit
Gross Profit = Sales Revenue − COGS
This calculator applies the periodic weighted average costing method. It pools beginning inventory and all entered purchases, then divides total available cost by total available units. Any extra landed cost entered for a batch is added to that batch before averaging.
Weighted average costing blends beginning inventory and purchase costs into one average unit cost. That average is then used to value COGS and ending inventory for the period.
This version uses periodic weighted average costing. It calculates one average after combining beginning inventory and all purchase batches entered for the selected period.
Yes. Each purchase row includes an extra landed cost field. Use it for freight, duties, handling, or other direct costs tied to that purchase batch.
The page validates the entry and stops the calculation. Units sold cannot be greater than total units available from beginning stock plus purchases.
Yes. Enter a selling price per unit and the calculator will estimate sales revenue, gross profit, and gross margin percentage using the calculated COGS.
New purchases change the pooled average cost. Since ending inventory is valued with that updated average, its value changes even if ending units remain the same.
It is useful for planning, review, and reconciliation. For final reporting, compare results with your ERP, accounting policy, and supporting inventory records.
Yes. After calculation, use the export buttons to save the summary as CSV or PDF. The export is based on the results table shown above the form.
Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.