How to work out the real cost per vial
If you price research vials from the supplier's invoice alone, every order looks more profitable than it is. The real figure, the loaded cost, adds what it cost to get the lot in and tested, then spreads it over the vials you can actually sell.
Updated November 2026
The formula
Loaded cost per vial = (vials × price per vial + shipping and fees + lab testing) ÷ (vials − vials used up in testing)
- Shipping and fees: freight, customs duties, payment or wire fees on the purchase: anything you paid to get this lot in.
- Lab testing: what third-party testing of the lot cost.
- Vials used up in testing: vials you sent to the lab and can't sell. Their cost doesn't disappear; it's carried by the vials that are left.
A worked example
A lot of 100 vials at $8.50 each costs $850. Shipping and fees were $120 and the lab charged $250, so the lot cost $1,220 in all. Two vials went to the lab, leaving 98 to sell. $1,220 ÷ 98 = $12.45 per vial, not the $8.50 on the invoice. Sold at $45, that's a margin of 72%, not 81%.
Loaded cost per vial calculator
Loaded cost per vial: $12.45 on 98 sellable vials, $1,220.00 in all
Why it matters
- Pricing: a price that looks comfortable at $8.50 a vial may not be at $12.45.
- Profit you can trust: cost of goods on your P&L should be the loaded cost of the vials you sold, lot by lot, so a cheaper lot and a dearer one aren't averaged into a guess.
- Year end: your stock at cost on December 31 is valued the same way, and your accountant needs it.
Doing it for every lot
Worked out by hand, this is fine for a few lots a year. With dozens, it's where spreadsheets drift: a lab fee added after the fact, a lot split across two shipments. Vial Workspace works out the loaded cost on each lot as you enter its cost, fees and test vials, and every order that sells from that lot uses it for its profit.
Questions
Should lab testing be part of the cost of the vials?
Usually yes: testing is part of what it cost to have that lot ready to sell, so it's spread over the lot's sellable vials. Your accountant can confirm how they want it treated.
What about vials that break or go missing later?
Those are written off after the fact, as a loss, rather than raising the cost of the vials left. The loaded cost covers what was known when the lot came in: its price, fees, testing and test vials.
More on this: accounting and profit tracking.
Try Vial Workspace with your own records
Every feature is on for 14 days, with no card or account needed. After that, Standard is $299 a year and Pro is $599 a year, with no automatic renewal.
Download for Windows Download for Mac Compare editions
More guides
- How to track peptide lots and COAs
- Sales tax for an online peptide business
- Spreadsheet or inventory software for a peptide business?
- Year-end checklist for a peptide business
Vial Workspace is record-keeping software for research-use-only businesses. We don’t make, sell or ship peptides or any other product. Nothing here is tax or legal advice.