Batch Size & Setup Optimizer – Best Batch Size, Cost per Item & Setup Savings
Find the Best Batch Size — Setup Cost, Cost per Item, and Monthly Savings
A batch size and setup optimizer for handmade products. Enter your setup minutes and waste, minutes and materials per item, overhead, wage, monthly sales, holding cost, and storage limits, then compare seven batch sizes to get the cost per item, setup share, setup hours per month, months of stock, the economic batch size, the recommended batch, and your monthly savings.
What This Spreadsheet Calculates
- Setup cost per item at each size
- Cost per item at each size
- Setup share of cost
- Setup hours per month
- Months of stock
- Economic batch size
- Recommended batch size
- Monthly savings vs the smallest batch
Making items one at a time repeats setup every time. Making too many ties up cash and shelf space. The right batch size is in between.
Set up once, sell them all.
Each purchase comes with a .xlsx spreadsheet compatible with Microsoft Excel, Google Sheets, and Numbers. Enjoy free updates for every spreadsheet you own. You'll be notified when a file is updated, and you can download the latest version anytime from your account page.
This is a one-time payment, so you pay once and own the spreadsheet forever. You can download the original file anytime, and future updates are included at no extra cost!
We offer a 7-day money-back guarantee. If you feel our spreadsheets aren't providing the pricing calculations you need, we'll refund your purchase—no questions asked!
Need More Than One Spreadsheet?
The Craft Calculators Lifetime Spreadsheet Vault includes 323 spreadsheets across 29 categories — soap and bath, crochet and knitting, machine embroidery, home bakery, candle making, pricing, labor costs, HTV, balloon decor, paper crafts, jewelry, Etsy fees, digital products, and more. One-time payment. Lifetime access. Free future updates.
