Portfolio / Case study 02
A weighted-average inventory and COGS model that gave the business product margins based on real landed costs.

Project walkthrough

$ start project "COGS and inventory valuation model"
✓ Brief agreed with Vankea
✓ Collected purchase, freight and duty data by shipment
✓ Built a weighted-average costing model at SKU level
✓ Reconciled stock movements against sales records
→ Review with the client…
● Delivered and handed over
The project
Product margins were estimated from supplier prices alone. Freight, duties and batch-to-batch price changes were not reaching the cost of goods sold.
Margins by product were based on landed cost, which made pricing and reorder decisions far easier to defend.
The model uses weighted-average costing at SKU level. For every shipment I collected the purchase price, the freight and the duties, and added them together to get a landed cost per unit. When new stock arrives at a different price, the model blends it with the stock already on the shelf in proportion to quantity, so the average cost moves smoothly instead of jumping with each batch.
Each sale is then costed at the current average, which means the cost of goods sold follows what the business really paid to get the product into the warehouse. I reconciled the stock movements against the sales records so that any difference between what the books said and what was physically sold could be traced back to a shipment or an entry.
A product that looks profitable on the supplier invoice can look very different once the freight and duties for that shipment are added. For an e-commerce business that imports its materials, those extra costs change from batch to batch, so estimating margin from the supplier price alone slowly drifts away from reality. The model tracks the items that usually get missed:
With margins based on landed cost, the conversation about pricing becomes much easier to defend. You can see which products carry the business and which ones only look good on paper, and you can decide what to reorder with real numbers in front of you.
If you import stock or buy through several suppliers, a good first step is simply recording freight and duty against each shipment rather than as a monthly lump. It is a small habit that makes every later report more reliable.
Gallery and links
Figures are anonymised. Click an image to enlarge it.



Services used
Let's connect
Book a free 30-minute call on Google Meet, or reach me directly.
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
You can find more information in our Privacy Policy and .