workdaykit. A little less busywork
Home / Inventory & capacity / Tool 14
INVENTORY & CAPACITY / 14

Batch production sequence

Lay out consecutive production batches, including setup time, on one machine.

Your starting point

LOCAL · PRIVATE

Sample values are filled in. Change them to make this your own.

Keep the header row. Separate values with commas; quote values containing commas.

A little more clarity

RESULT

Your result will appear here.

Run the sample to see how it works.

FROM INPUT TO ANSWER

Use this tool

  1. List batches in the exact sequence you intend to run.
  2. Enter whole units, minutes per unit and setup minutes for each batch.
  3. Calculate the elapsed start and end minutes on one machine.
WHAT THE NUMBERS MEAN

Reading your result

Start minute is measured from zero, not a clock time. End of one batch is the start of the next; setup is included in each duration.

UNDER THE HOOD

How this works

Each batch uses setup + quantity × unit time; batches run in entered order.

Use the units shown beside each field. For monetary amounts, use one currency throughout; calculations do not convert currencies. Results normally display up to two decimal places. Nonzero values below 0.01 use up to six significant digits; values below 0.000001 use scientific notation (for example, 1E-7 means 0.0000001). Rankings use unrounded values, so displayed scores can look equal without being tied. CSV downloads retain numeric precision. Monetary rounding uses half-away-from-zero. Inputs or results beyond supported precision are rejected.

BEFORE YOU USE THE RESULT

Assumptions & limits

One machine, continuous elapsed minutes, no breaks or date calculations. Does not optimize sequence.

CSV inputs support quoted commas, doubled quotation marks and quoted line breaks. Headers are case-sensitive; a maximum of 500 data rows and 200,000 characters applies per table.

Results are planning aids based on the values you enter. Check important decisions and documents before using or sharing them.

Keep things moving.

More in this collection ↗
11 / 30

Inventory days of cover

Estimate how long current usable inventory can serve your average daily demand.

Inventory & capacity
12 / 30

ABC inventory classification

Rank SKUs by annual consumption value and highlight the largest contributors.

Inventory & capacity
13 / 30

Production bottleneck

Compare serial workstation capacities and identify the limiting step.

Inventory & capacity

Take the next step.

Browse practical guides ↗
Warehouse aisles with boxed inventory stored on shelvesPRACTICAL GUIDE

Reorder point and EOQ answer different questions

Keep replenishment timing separate from order quantity, then check packs, lead times and inventory position.

Read the guide Stacks of packaged stock inside a warehousePRACTICAL GUIDE

A net-zero stocktake can still hide a real problem

Read shortages, overages and absolute value variance before adjusting a stock record.

Read the guide