How do you calculate canning line capacity?

Work out the seamer's output (rated speed × production minutes × availability) and the retorts' capacity (retorts × whole loads in the shift × cans per load), and take the smaller. 300 cans a minute at 85% for 450 minutes is 114,750; 7 retorts × 5 loads × 3,600 is 126,000, so 114,750 cans go through, the Canning Line Capacity calculator's own example.

Why round retort loads down?

A load that cannot finish its process in the shift does not produce cans in that shift. 450 minutes on an 85-minute cycle is 5 full loads; the remaining 25 minutes count for nothing.

How do I know whether the seamer or the retorts are the bottleneck?

The Sets the pace column names the smaller of the two. When the retorts set the pace, a faster seamer adds nothing; shortening the cycle, adding retorts or putting more cans in each load does.

Where does the retort cycle come from?

The product's scheduled process from your process authority, plus loading, come-up, cooling and unloading time from your own records. Use the full cycle from load to load.

Does it check labelling and packing?

No. It covers closing and thermal processing. Labelling, casing and palletising after the retorts need their own capacity check.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test runs and shows Self-check: PASS.

Production and Throughput

Canning Line Capacity Excel Template

Cans through a canning line = the smaller of the seamer's output (rated speed × minutes × availability) and the retorts' capacity (retorts × whole loads in the shift × cans per load). Give every shift run a row and see which one sets the pace, how many retorts would match the seamer, and whether the run covers its demand.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This canning line capacity template is a working Excel workbook for cannery production planners, plant managers and thermal process supervisors. Each shift run is one row with the seamer it uses, the product, the production minutes, the share of that time the seamer is closing cans, the cans in one retort load for the can size, the full retort cycle for the product's scheduled process, the retorts available and the cans the plan needs; each seamer's rated speed comes from Setup. The workbook gives the seamer's output, the whole retort loads that fit in the shift and the cans they process, the cans through the line, whether the seamer or the retorts set the pace, how many retorts would match the seamer, and the run's demand against what it can put through. It ships with eight runs at a fictional cannery, so every tile and chart is filled in when you open it.

In the example seamer 1 closes 300 cans a minute at 85% over 450 minutes: 114,750 cans. Seven retorts on an 85-minute chicken soup process fit 5 loads of 3,600 each, 126,000 cans, so the seamer sets the pace and 110,000 cans of demand fill 96% of the run. Baked beans in 28 oz cans on a 110-minute process fit only 4 loads of 2,100, so the retorts take 58,800 cans against the 178,200 seamer 2 could close, and matching the seamer would need 22 retorts. With one retort down on a short shift, chicken soup falls 8,600 cans short of its 95,000.

Retorts only count whole loads, and cans waiting between stages at the start and end of a shift are not modelled. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your plant and near-capacity threshold, and the seamers with their rated speed
Runs table, one row per run: seamer, product, production minutes, seamer availability, cans per retort load, retort cycle, retorts and demand, with a Check column
Per run: seamer output, loads per retort, retort capacity, cans through, which sets the pace, retort capacity above the seamer, retorts to match the seamer, load and a status in words
Dashboard with four tiles (runs, cans through, demand, runs over capacity), cans through against demand, seamer output against retort capacity, and the run table
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Canning Line Capacity calculator (Self-check: PASS)
CSV with live formulas for the Runs table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to check a week's canning schedule before it starts, to see which products are retort-bound, or to work out what a retort out of service does to a run.

How to use it

On Setup, type your plant and the near-capacity threshold, and list your seamers with their rated speed.
On Runs, give each run a row: seamer, product, production minutes, availability, cans per retort load, retort cycle, retorts and demand.
Fix anything the Check column names.
Open the Dashboard: cans through against demand, and whether the seamer or the retorts hold each run back.

Frequently Asked Questions

How do you calculate canning line capacity?: Work out the seamer's output (rated speed × production minutes × availability) and the retorts' capacity (retorts × whole loads in the shift × cans per load), and take the smaller. 300 cans a minute at 85% for 450 minutes is 114,750; 7 retorts × 5 loads × 3,600 is 126,000, so 114,750 cans go through, the Canning Line Capacity calculator's own example.
Why round retort loads down?: A load that cannot finish its process in the shift does not produce cans in that shift. 450 minutes on an 85-minute cycle is 5 full loads; the remaining 25 minutes count for nothing.
How do I know whether the seamer or the retorts are the bottleneck?: The Sets the pace column names the smaller of the two. When the retorts set the pace, a faster seamer adds nothing; shortening the cycle, adding retorts or putting more cans in each load does.
Where does the retort cycle come from?: The product's scheduled process from your process authority, plus loading, come-up, cooling and unloading time from your own records. Use the full cycle from load to load.
Does it check labelling and packing?: No. It covers closing and thermal processing. Labelling, casing and palletising after the retorts need their own capacity check.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test runs and shows Self-check: PASS.