Costing worksheet
Ingredient Cost Per Serving Calculator
Enter grams per serving and your own unit cost per kilogram for the magnesium ingredient and up to three other ingredients. If the unit cost you enter is already a landed cost, freight is included; do not add freight again. The worksheet returns cost per serving, cost per 1,000 servings, each row's share and the magnesium ingredient's cost per gram of elemental magnesium. No supplier figures are built in.
Calculated result
Enter the values above to calculate. Results appear here.
Arithmetic on the values you enter. No supplier figures are built in. The result is only the ingredient cost from the rows above.
How the cost is calculated
For each row, cost per serving = grams per serving ÷ 1,000 × unit cost per kilogram. The total is the sum of the rows and cost per 1,000 servings is that total × 1,000. If you enter 1.25 g at a unit cost of 40 per kg, the row cost is 0.05 per serving; 0.5 g at 8 per kg is 0.004; the total is 0.054 per serving, or 54 per 1,000 servings, in whatever currency you entered. These figures are arithmetic examples only; they are not supplier prices or market prices.
Row 1 is the magnesium ingredient. Elemental magnesium per serving = grams × 1,000 × assay % ÷ 100, so 1.25 g at 8% supplies 100 mg. Dividing the row cost by the grams of magnesium gives the cost per gram of elemental magnesium, which is the fair basis for comparing two magnesium ingredients for beverages with different assays. Use as-is assays on both sides of a comparison.
What the number leaves out
Ingredient cost is only part of the cost of a serving. Process loss, rejected batches, testing, flavor changes needed to cover a mineral note and packaging can change which option costs less in practice. This worksheet does not convert process loss, testing, packaging or similar costs into grams per serving; account for them separately, and rerun the calculation whenever a unit cost, assay or serving size changes.
