All scenarios

Wholesale frozen cookie dough manufacturing · fictional example

Juniper Batch Foods

USD 2.16M annualized revenue · 10 core staff plus a typical 2-person flexible crew · Columbus, Ohio

Juniper Batch Foods is a fictional bakery supplying frozen cookie dough to cafés and regional retailers; all financial figures below are illustrative assumptions, not researched prices. In a representative 30-day month with 20 production days, it sells 12,000 cartons for USD 180,000, but packing is fully booked and finished-goods storage is nearly full. A regional retailer buys one-third of the cartons, requires longer storage, and pays more slowly than other customers. The owner is considering dropping that account or expanding production, although neither decision necessarily solves the actual constraints.

The owner's question

Should we renegotiate the retailer's price, payment terms, and pickup schedule, replace its volume, or invest in more capacity?

What the analysis finds

The retailer has an allocated loss but still contributes toward fixed costs

Monthly retailer revenue is 4,000 cartons × USD 12 = USD 48,000; other customers generate 8,000 × USD 16.50 = USD 132,000. Direct, avoidable costs average USD 8 per carton: USD 4.80 ingredients, USD 1.20 packaging, USD 0.80 outbound freight, and USD 1.20 flexible labor that can actually be canceled with volume. Total direct costs are USD 96,000, leaving USD 84,000 contribution, or 46.7% of revenue. Fixed monthly overhead is USD 72,000: USD 52,000 core payroll, USD 16,000 occupancy and administration, and USD 4,000 depreciation. Operating profit is therefore USD 12,000 before interest and tax. Allocating overhead by carton assigns USD 24,000 to the retailer, creating an USD 8,000 account-level deficit. However, dropping it without replacement sales or fixed-cost reductions removes USD 16,000 of contribution and turns company operating profit into a USD 4,000 loss.

Packing and storage constrain growth before mixing does

At the current product mix, staffing, sanitation schedule, and operating calendar, practical monthly capacities are 16,000 carton-equivalents for ingredient staging and mixing, 14,000 for portioning, 13,000 for freezing, 12,000 for packing and labeling, and 13,000 for dispatch. Finished-goods storage holds 2,200 cartons. Assuming reasonably even production and collections, the retailer's 10-day average dwell and other customers' 3-day dwell create average inventory of approximately (4,000 × 10 + 8,000 × 3) ÷ 30 = 2,133 cartons. That leaves only 67 cartons of average headroom, with pickup delays capable of exceeding capacity. A faster mixer alone would not increase shipments.

Slow collections tie up cash independently of reported profit

Assuming even credit sales and on-time payment, the retailer's net-60 terms create approximately USD 96,000 of receivables, while other customers' net-15 terms create USD 66,000, totaling USD 162,000. Ingredients, packaging, freight, and flexible labor are paid within 15 days, so the retailer requires funding well before collection. Moving it to net-30 could eventually release approximately USD 48,000 from receivables, but would not increase profit and would not produce an immediate cash windfall. The USD 12,000 monthly operating profit plus USD 4,000 noncash depreciation equals USD 16,000 before working-capital changes, interest, taxes, capital spending, and owner distributions; ingredient inventory and supplier payables must also enter the cash forecast.

The moves we'd make

Test a retailer renewal package before exiting

Propose an illustrative USD 1-per-carton increase, net-30 payment, and scheduled pickups that reduce average finished-goods dwell from 10 days to 5. At unchanged volume and direct unit cost, the price change would add USD 4,000 monthly contribution, while shorter dwell would reduce average stored inventory by approximately 667 cartons. These are separate profit, cash, and capacity hypotheses—not guaranteed benefits. Model rejection, lower order volume, discounts, and collection delays before agreeing to terms.

Validate the full workflow before buying equipment

Run a four-week packing trial using standardized labels, pre-staged cartons, and a revised task sequence. Measure sustainable cartons per labor hour, sanitation time, labeling errors, overtime, freezer queues, storage peaks, and dispatch reliability. Raising packing capacity from 12,000 to 13,000 cartons would merely bring freezing and dispatch to their current limits, and storage would still need relief. If the trial supports evaluating a carton-sealing and label-application cell, specify an incremental practical target of 1,000 packed cartons per month under the actual staffing plan. Obtain comparable supplier quotes separating machine-only pricing from the installed project, including electrical work, installation, conveyors, guarding, integration, and training; no equipment price is assumed here.

Gate customer replacement and expansion on contribution and cash

Build a weekly 13-week cash forecast and track customer contribution per packing hour and storage-day. At the existing other-customer contribution of USD 8.50 per carton, replacing the retailer's USD 16,000 monthly contribution requires approximately 1,883 additional cartons per month, assuming the same product mix, avoidable costs, and no new fixed costs. Treat that as a sales hurdle, not evidence that replacement demand exists. Do not terminate the account solely because of allocated overhead; first validate replacement orders, an executable fixed-cost reduction, or another reason that justifies accepting lower profit.

Tools that would do this work

This company and its numbers are invented for illustration.