Commissary & Central Kitchen Cost and Production Model

A practical spreadsheet model and guide to evaluate whether a central kitchen (commissary) will reduce costs and improve operations. Explains required inputs, key formulas (including break-even volume), interpretation of outputs, recommended sensitivity scenarios, utilization targets, common pitfalls, and next steps for piloting and data collection.

Purpose

This model helps you decide whether a central kitchen (commissary) can lower per-unit production costs or improve operational consistency across multiple locations without sacrificing quality or creating excessive complexity. It is designed for operators who want an evidence-based financial and operational comparison between in-store production and centralized production.

When to use it

Use this model when you're considering centralizing prep or full production for menu items across multiple locations, when planning an expansion, or when exploring vendor/contract manufacturing alternatives.

Required inputs (what to collect)

Collect accurate historic or estimated figures for the smallest practical time period (weekly or monthly). Provide units and expected measurement periods.

  • Expected volume — number of portion-equivalents per period (weekly or monthly). Define portion-equivalents consistently (e.g., one served plate, one sandwich, one tray portion).
  • In-store unit production cost — current average fully-burdened cost per portion produced in-store (ingredients, packaging, direct labor, utilities allocated to production, waste).
  • Central kitchen variable cost per unit — ingredients, packaging, direct central-labour per portion (exclude allocated fixed costs).
  • Transport & distribution cost per unit — packaging, delivery labor, vehicle operating cost, route amortization per portion.
  • Fixed monthly central costs — rent, utilities, management salaries, shared services (quality, admin), insurance, cleaning, audit, and equipment depreciation assigned to the central kitchen (sum per month).
  • Equipment and labor capacity — maximum realistic throughput per shift/day/month for major bottleneck resources (mixers, ovens, packaging lines, central prep stations, distribution trucks).
  • Initial setup/one-time costs — kitchen set-up, tooling, training, systems, transport containers, legal/compliance work (amortize separately over a chosen payback period).
  • Quality and product risk factors — shelf-life, hold-time constraints, temperature control needs, travel distance/time, and expected change in food quality.

Key outputs the model should produce

  • Per-unit central cost = central variable cost + transport + (fixed monthly central costs / volume)
  • Per-unit savings (or loss) = in-store unit cost − per-unit central cost
  • Break-even volume — the volume at which per-unit central cost equals in-store cost. Useful formula below.
  • Utilization targets — target production volume to achieve desired utilization of major equipment and labor (usually 70–85% of rated capacity for reliable operations).
  • Sensitivity analysis — per-unit cost under scenario variations: ±10–30% volume, transport cost shocks, labor rate changes, ingredient price swings.

Important formulas (implement these in the spreadsheet)

Use consistent units (e.g., monthly).

  1. Per-unit central cost = VariableCentral + TransportPerUnit + (FixedMonthlyCentral / Volume)
  2. Per-unit savings = InStoreUnitCost − PerUnitCentralCost
  3. Break-even volume (solve for Volume where PerUnitCentralCost = InStoreUnitCost):
    Break-even Volume = FixedMonthlyCentral / (InStoreUnitCost − VariableCentral − TransportPerUnit)

    Interpretation: if denominator ≤ 0, the central model cannot beat current in-store cost at any finite volume (unless you reduce variable/transport costs).

Worked example

Assume monthly numbers for clarity.

  • Expected volume: 10,000 portions/month
  • In-store unit cost: $2.50
  • Central variable cost (ingredients + direct central labor + packaging): $1.40
  • Transport per unit: $0.25
  • Fixed monthly central costs: $8,000

Per-unit central cost = 1.40 + 0.25 + (8,000 / 10,000) = 1.65 + 0.80 = $2.45

Per-unit savings = 2.50 − 2.45 = $0.05 (5 cents per portion). At 10,000 portions that's $500/month.

Break-even volume = 8,000 / (2.50 − 1.40 − 0.25) = 8,000 / 0.85 = 9,412 portions/month. Below that, central costs per unit are higher.

Sensitivity scenarios to run

Run the model across multiple scenarios and present results in a small table or chart:

  • Volume ±20% and ±40%
  • Transport cost increase of 25–50% (fuel, route rework)
  • Variable cost +10% (ingredient price spikes)
  • Fixed cost changes if you add QA staff or lease cheaper/better space
  • Scenario combining lower volume and higher transport cost (stress case)

Utilization & operational considerations

Cost math is necessary but not sufficient. Evaluate:

  • Equipment utilization — target 70–85% of rated capacity for reliable throughput; high peaks require buffer capacity or overtime.
  • Driver and route scheduling — distribution windows must match store receiving hours and labor availability.
  • Shelf-life & quality — ensure centralization doesn't reduce guest satisfaction; shorter hold times may increase waste.
  • Inventory handling — centralizing may increase inventory on-hand at the commissary and in transit; consider working capital impacts.

Common pitfalls & mal-hunger signals

  • Underestimating distribution complexity and cost — small distances can still have high labor or time costs.
  • Ignoring product quality decline — centralized prepped items that travel poorly will generate remakes and complaints.
  • Over-sizing the commissary — building for peak demand without flexible capacity leads to underutilized fixed cost burden.
  • Failing to test recipes at scale — yields and waste rates can change when production moves to larger batches.
  • Not including compliance / food safety overhead — additional QA, documentation, and inspections add cost.

Decision checklist

  1. Have you gathered 3–6 months of reliable volume and cost data by item and location?
  2. Does the model show clear per-unit savings at realistic utilization levels (not just theoretical peaks)?
  3. Are quality and shelf-life constraints acceptable for centralized production and distribution times?
  4. Do you have a plan for logistics (routes, pickup/delivery windows, packaging)?
  5. Have you estimated transition costs and a payback period for start-up investments?
  6. Can you pilot central production with a small subset of items or locations to validate assumptions?

Recommended next steps / how to use the spreadsheet model

  1. Populate the model with your best available data and run base-case per-unit and break-even calculations.
  2. Run the sensitivity scenarios above and identify the range where central production remains attractive.
  3. Identify bottleneck resources and calculate realistic utilization targets rather than relying on theoretical maximums.
  4. Plan a time-boxed pilot (2–4 weeks) with a limited menu and 1–3 locations to measure real-world transport, waste, quality, and labor effects.
  5. Iterate the model using pilot data, update SOPs, training, and packaging before full rollout.

Data sources & assumptions

Prefer observed data over estimates. Use POS for volumes by SKU, inventory system or invoices for ingredient costs, time-and-motion studies for labor, route mapping tools for transport times/distance, and maintenance logs for equipment depreciation and uptime.

Attachments & templates (recommended)

Provide a downloadable spreadsheet template with clearly labeled input cells, scenario tabs, and a results dashboard. Include an assumptions tab and a sensitivity-sheet that produces charts for quick stakeholder review.

Note: This content describes the model and how to use it. A practical next improvement is to provide a downloadable spreadsheet template and/or an interactive calculator that stores scenario runs for comparison. See CapabilityEnhancementNotes for proposals.


Discussion

Comments and conversation will live here.