Break down the cost of anything using unit metrics. At my CBD store we use this to break down and sort products by cost per milligram and per dose for our customers.

Instructions: Download the PDF and open it. Click the button on the document to open the spreadsheet and make a copy. You must be signed into Google. Google accounts are free.

Columns A through F are for inputting data. Columns G through Q use DIVIDE and MULTIPLY functions to calculate cost per milligram, # of milligrams in 1 mL, etc. Note: Column E (Unit) is just for show and Column F (Unit in mL) is actually used in the formulas. Grayed out squares represent non-applicable data.

For questions or assistance with this tool, contact us.