Skip to content
All resources
PDFFree — no email required

Small-Batch Production Planning Playbook

Small-batch production planning is the practice of sizing each production run to the smaller of two ceilings: the units that will sell before the earliest-expiring component fails, and the batch size where per-unit fully-loaded cost stops dropping meaningfully. The framework re-anchors batch sizing on demand and shelf life rather than equipment capacity, which frees working capital and reduces shelf-life write-offs.

A six-page PDF playbook for batch-production makers — bakers, soap and candle makers, hot-sauce and condiment producers, chocolatiers, kombucha brewers, and anyone who pours, bakes, or blends in runs and has to decide how many to make this week. Page 2 lays out the five principles of demand-driven small-batch planning (pull don't push, respect shelf life, cost labor honestly, manage WIP, use the smallest batch that still earns). Page 3 walks the demand-driven sizing formula — target batch = (weekly run rate × weeks of cover) + safety stock − on-hand, capped by the smaller of the shelf-life ceiling and the cost-curve elbow — with a worked candle example and a printable Batch Sizing Worksheet. Pages 4–6 are the printable worksheets that turn the framework into a weekly habit: a Production Run Log (mise en place, run timing, yield variance, notes), a Weekly WIP Tracker (finished on-hand by SKU with days-of-cover and reorder flags), and a Post-Run Audit (sell-through, profit per hour, and a six-line diagnostic for the "I made 200, sold 30" trap). Built to take a maker from equipment-driven over-pours to demand-driven runs without buying any software.

  • The five principles of demand-driven small-batch planning — the framework that flips batch sizing from "how much fits in the equipment" to "how much will sell before it spoils"
  • The demand-driven batch-sizing formula written out plainly: target = (weekly run rate × weeks of cover) + safety stock − on-hand, capped by min(shelf-life ceiling, cost-curve elbow) — with a worked 8 oz lavender candle example showing why the elbow caps the math, not the shelf life
  • A printable Batch Sizing Worksheet — fill once per planned run, walks the inputs and computes Target, Cap, and Final Batch Size in three labeled boxes
  • A printable Production Run Log — mise en place table for ingredient draw with lot/batch IDs, four time captures (setup start, active start, active end, cleanup end), planned-vs-produced yield with variance %, and a ruled notes block for substitutions and surprises
  • A printable Weekly WIP Tracker — SKU rows with finished on-hand, WIP finishing this week, daily run rate, days of cover, a flag column (RUN / HOLD / PAUSE / STOP), and a next-run flag — the one-page Sunday-night batch decision
  • A printable Post-Run Audit — sell-through fields (units produced, units sold, weeks to sell, units remaining), the honest profit-per-hour calculation including setup and cleanup, and a six-line diagnostic checklist for the "I made 200, sold 30" trap
  • Plain-English page-by-page guidance — read pages 2–3 once, print pages 3–6 as worksheets and use them every week

Educational tool only — not legal, tax, food-safety, or accounting advice. Shelf-life and process-safety decisions for cottage food, cosmetics, soap, candles, and other regulated products are the maker's responsibility; consult your supplier SDS sheets, the relevant IFRA / FDA / state cottage-food guidance, and a qualified professional before scaling production. Cost, yield, and profit-per-hour outputs are estimates from the inputs you write in; actual material draw, labor, and sell-through will vary batch to batch and channel to channel.

Why most small-batch plans drift toward over-production

Three forces pull batch sizes upward: equipment capacity ("the wax melter holds 12 lb, may as well fill it"), supplier MOQs ("the case of 64 jars was cheaper per jar"), and the "while we're set up" argument ("the kitchen is already messy"). All three are about producer convenience, not customer demand. Each one, taken alone, is reasonable. Stacked together every week, they produce a freezer of unsold buttercream cakes, a shelf of candles that lost throw at month seven, and a 200-bar soap run that the soap-of-the-month subscriber base will work through over fourteen months — long after the cure-rack space could have been earning new revenue.

The playbook re-anchors the planner on demand. Demand sets the ceiling; shelf life sets the cap; honest labor cost picks the smallest batch worth running; WIP discipline keeps the next batch from compounding the miss on the last one. The five principles on page 2 turn each of those into one decision the demand-driven planner makes differently than the equipment-driven planner.

How the demand-driven batch-sizing formula works

The formula on page 3 is intentionally arithmetic, not algebra: Target batch = (weekly unit run rate × weeks of cover) + safety stock − on-hand inventory. Weekly run rate is a trailing 4–8 week average pulled from sales records. Weeks of cover is "how long until I run this SKU again" plus a small buffer. Safety stock absorbs a sales spike or a missed cycle. On-hand inventory is the count of finished units (plus any WIP that will finish in time to sell) on hand the day the production run posts.

Then the cap: take the smaller of (units saleable before the earliest-expiring component fails) and (the batch size where per-unit fully-loaded cost stops dropping meaningfully — what the Recipe Scaling and Soap Cost-Per-Bar calculators in this resource library both call the batch-curve elbow). The shelf-life ceiling is non-negotiable. The cost-curve elbow is where the per-unit savings from another doubling shrink to a small fraction of what the previous doubling delivered — the playbook calls this "the elbow" to make it nameable and uses the worked candle example on page 3 to illustrate the diminishing-returns shape with one set of inputs (your numbers will differ, so plot your own curve in the linked Excel calculators).

In the worked candle example on page 3, the math says target 45 units and cap 36 units. Run the cap. The remaining 9 units of demand get covered by the next run in roughly three weeks rather than by oversizing this run and tying up wax, jars, and shelf space for a month and a half.

Why WIP discipline matters more than finished-goods discipline

Cured-but-unwrapped soap, cooled-but-unfrosted cakes, bottled-but-unlabeled hot sauce — work in progress sits between "the run is done" and "units are saleable." It ties up cash and storage without earning anything until it crosses the finish line. Most makers track finished goods carefully and ignore WIP entirely; the playbook treats them as one bucket on the Weekly WIP Tracker on page 5 because, from the customer's perspective, an unwrapped bar of soap is an unsold bar of soap.

The discipline: plan finishing labor for every run before the run starts, and don't pour or bake a second batch until the first is shipped or shelved. The WIP Tracker on page 5 surfaces the SKUs where WIP has piled up — finished on-hand at zero, WIP at twelve, days of cover at eight — so the next decision is "spend Saturday morning wrapping the cured batch," not "schedule another pour day."

How the Post-Run Audit closes the loop

The "I made 200, sold 30" trap is real. It usually has one of six causes: demand was overestimated; the batch oversized vs. shelf life (the cap on page 3 was ignored); pricing crowded out demand; channel mismatch (the SKU sold elsewhere, not here); seasonality miss; or quality drift. The Post-Run Audit on page 6 walks each one as a checkbox so the diagnosis names a specific recovery action — recompute the run rate from a fresh trailing eight weeks, run the pricing review, mark the seasonal calendar — instead of a vague "we made too many."

The single most clarifying number on page 6 is profit per hour worked. Revenue from units sold to date, minus total batch ingredient and packaging cost, divided by every hour spent on the batch (setup, active production, cleanup, finishing, packing). Compare against your target hourly rate. If the number is below your floor, the batch sized you out of the rate the rest of the business is supposed to support — and that is information you can act on for the next run, not just lament about this one.

Or skip the spreadsheet entirely

A playbook tells you what to plan for. Ardent Seller does the planning continuously — pulls weekly run rate from your actual sales, holds the shelf-life ceiling against your batch lots, decrements raw materials and stamps a batch ID the moment a production run posts, and surfaces days-of-cover by SKU on the dashboard so the WIP Tracker on page 5 becomes a live screen instead of a Sunday-night clipboard exercise. The framework on page 2 is unchanged; the bookkeeping on pages 4–6 just stops being yours.

Production runs & batch traceability

Post a production run and the system decrements raw materials, stamps a batch lot, and rolls actual labor and yield into per-unit cost — the Run Log on page 4, but live.

Recipe costing

Build a recipe once with materials, labor, and packaging — per-unit cost updates automatically when an ingredient price moves, so the cost-curve elbow on page 3 reflects today's numbers, not last quarter's.

Multi-location inventory & reports

Finished-goods on hand by SKU and location, with sales velocity and reorder-point flags — the Weekly WIP Tracker on page 5 turned into a dashboard widget that refreshes itself.

Frequently asked questions

How do I decide how many units to make in a small-batch production run?

Use the demand-driven formula on page 3: target batch = (weekly unit run rate × weeks of cover) + safety stock − on-hand inventory, capped by the smaller of the shelf-life ceiling and the cost-curve elbow. Pull weekly run rate from a trailing 4–8 week average of actual sales. Pick weeks of cover based on how often you can realistically run the SKU again. Cap the result at the units that will sell before the earliest-expiring component fails AND at the batch size where per-unit cost stops dropping meaningfully. Run the smaller of target and cap — never the equipment maximum unless demand and shelf life both support it.

What is the cost-curve elbow and how do I find it for my recipe?

The cost-curve elbow is the batch size where doubling production stops yielding meaningful per-unit cost savings — typically the point where the per-unit drop from one doubling falls to roughly a quarter of the drop from the previous doubling. Setup labor is the lever: a 12-cookie batch and a 60-cookie batch share most of the same mise en place, so the per-unit drop is steep at first. By 250 cookies the setup is fully amortized and another doubling barely moves per-unit cost. Use the Batch Pricing tab in the free Product Pricing Calculator (or the Batch Cost & Yield tab in the free Recipe Scaling Calculator) to plot per-unit cost across 5 / 10 / 25 / 50 / 100 / 250-unit batches and find your specific elbow.

How do I track work-in-progress (WIP) inventory for handmade goods?

Treat WIP as a separate column on the Weekly WIP Tracker (page 5 of this playbook): for each SKU, log finished on-hand AND WIP that will finish in time to sell this cycle. Compute days of cover from the sum of both. The discipline that goes with the tracking: plan the finishing labor for every batch before the batch starts, finish the first batch before pouring the next one, and audit weekly. WIP that has been sitting for two weeks is a process problem (not enough finishing time scheduled) or a planning problem (the batch was too large for the labor available downstream).

What does "days of cover" mean and how do I calculate it?

Days of cover = on-hand inventory ÷ daily run rate. Pull on-hand from an actual count (or the WIP Tracker on page 5 of this playbook). Pull daily run rate by dividing the SKU's recent weekly sales pace by 7 (or the trailing 30-day units-sold count by 30). The flag thresholds the playbook recommends as a starting point — adjust to your own production cycle: below 7 days of cover = run a batch this week; 7–21 days = run on the next normal cycle; above 21 days = skip this cycle and reassess demand. Add a STOP flag for any SKU whose shelf life will expire before the on-hand inventory depletes at the current sales pace.

How do I avoid producing more than I can sell?

Three habits, in order: (1) Size every run from a demand-driven formula instead of an equipment-driven default — the Batch Sizing Worksheet on page 3 of this playbook walks the inputs and outputs Target, Cap, and Final Batch Size. (2) Cap every run at the smaller of the shelf-life ceiling and the cost-curve elbow — never run the equipment maximum unless both ceilings support it. (3) Run a Post-Run Audit (page 6) on every finished batch to surface sell-through and profit per hour worked, then diagnose the miss against six common causes (demand overestimate, shelf-life cap ignored, pricing, channel mismatch, seasonality, quality drift) so the next run plans against the actual cause, not a vague feeling.

How long should a small batch take to sell?

It depends on the SKU, the channel, and the maker's sales pace, so the right answer is "track your own normal and run against that, not a generic benchmark." As a starting heuristic, the playbook treats a 4–8 week sell-through window as a reasonable planning target for most handmade-goods batches running through Etsy, craft fairs, or a small wholesale account — long enough to absorb a slow week, short enough to leave shelf-life headroom. Anything past your own normal window risks shelf-life pressure (fragrance throw decay, cottage food best-by, finish curing) and ties up cash that could fund the next run's materials. The Weekly WIP Tracker on page 5 surfaces the SKUs trending past their normal sell-through window so you can pull pricing or marketing levers before the batch turns into a write-off.

Should I track labor hours separately for setup, production, and cleanup?

Yes — the Production Run Log on page 4 of this playbook captures setup start, active start, active end, and cleanup end as four separate time stamps for exactly this reason. Setup and cleanup are roughly fixed per batch; active production scales (mostly) linearly with batch size. Lumping them as a single "batch hours" number hides the fixed-cost lever you actually have. Track them separately and the cost-curve elbow on page 3 falls out naturally — you can see the batch size where the fixed setup and cleanup cost is spread across enough units to stop dominating per-unit cost.

How do I calculate profit per hour worked on a production batch?

Profit per hour = (revenue from units sold − total batch ingredient and packaging cost) ÷ total hours worked. Total hours worked must include setup, active production, cleanup, finishing, and packing — not just "the batch." The Post-Run Audit on page 6 of this playbook walks the math line by line. Compare against your target hourly rate (the rate the rest of the business is supposed to support). Numbers below your floor are information about how you sized or priced the batch, not a verdict on the recipe.

Recipe Scaling & Batch Calculator

A working Excel recipe scaler — enter a base recipe, set a target yield, and every ingredient auto-scales with unit conversions (oz/g/lb/ml/cups). Plus a batch-cost tab and a unit-conversion reference.

Soap Maker's Cost-Per-Bar Calculator

A working Excel cost-per-bar calculator for cold-process and melt-and-pour soap. Oils, lye (auto-calculated from SAP values), fragrance, colorants, mold and packaging in; per-bar fully-loaded cost out — with cure-weight loss baked into the bar count.

Product Pricing Calculator

A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.

Inventory Tracker Starter Kit

A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.

Monthly Inventory Count Sheet

Three sections, one page. Print, count, and reconcile raw materials, finished goods, and packaging — with expected, actual, and variance columns.

End-of-Month Closeout Checklist

Seven steps to a clean monthly close — sales reconciliation, inventory counts, expense review, P&L, planning, reordering, and backup. Print one each month.

Home Baker's Order & Delivery Tracker

A working Excel order book for custom-cake and cookie bakers. Customer, items, dietary, deposit, balance, and a production calendar that rolls bake / decorate / shop dates backwards from each delivery.

Candle & Soap Fragrance Load Calculator

Pick a wax or soap base, enter your batch size, and get the exact fragrance oil weight — plus the typical and max load for that medium and the cost per unit.

Craft Show Prep and Profit Tracker

Pre-show break-even math, a packing and booth-setup checklist, in-show data to track, and a post-show reconciliation page — one printable per event.