Gallery
ingredient prices and recipe costs calculator_1.0
Share
Explore
Gallery
ingredient prices and recipe costs calculator_1.0
Multiple pack sizes

icon picker
Template

⁠
Duplicate page
⁠
⁠

This template is set up for 6 pack sizes. If you need more row, add them here.
Set up the template for your products and then duplicate the page as needed.
You will have a unique page for each product that has multiple packs.
Enter the fields in yellow for each page (each product).

template
Product
Cost per batch
Packaged sku weight (oz.)
Batch size
Ingredient costs per sku
Production wage
Staff hours per batch
Material costs per sku
Wages per batch
Wages per sku
Total sku costs
Wholesale price
Wholesale Margin
Wholesale Margin %
Retail price
Retail margin
Retail margin %
1
Pecan granola
$10.50
12
60
$0.18
$6.00
2
$0.35
$12.00
$0.20
$0.73
$2.50
$1.775
71%
$4.00
$3.275
81.87%
2
Pecan granola
$10.50
6
120
$0.09
$12.00
0.5
$0.35
$6.00
$0.05
$0.49
$2.00
$1.512
75.62%
$4.00
$3.512
87.81%
3
Pecan granola
$10.50
3
240
$0.04
$12.00
0.75
$0.44
$9.00
$0.04
$0.52
$2.00
$1.479
73.94%
$4.00
$3.479
86.97%
4
Pecan granola
$10.50
24
30
$0.35
​
​
​
​
$0.00
$0.35
$7.00
$6.650
95%
$13.00
$12.650
97.31%
5
Pecan granola
$10.50
36
20
$0.53
​
​
​
​
$0.00
$0.53
$9.00
$8.475
94.17%
$17.00
$16.475
96.91%
6
Pecan granola
$10.50
48
15
$0.70
​
​
​
​
$0.00
$0.70
​
-$0.700
​
​
-$0.700
​
There are no rows in this table
⁠

Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.