Skip to content
Shop | Excel tracker

Capacity and Sequence Planner

Load per week and resource, the bottleneck, sequencing rules, lead time and delivery performance in one planner.

Screenshot of the Capacity and Sequence Planner workbook with example data
Example data from the workbook.

How it works

  1. Open 02 Setup. Enter your work centers with shift model and losses, up to five product families, and the standard and setup minutes per family and work center.
  2. Enter the quantity per family for the next six weeks in 03 Load. Load, utilization and the bottleneck calculate. Level weeks above 100 percent before release.
  3. Use 04 Sequence for the queue at the bottleneck: compare first in first out, shortest processing time and earliest due date, then write your rule on the board.
  4. Count work in progress per stage once a month and enter it in 05 Lead Time. Little’s Law shows the lead time today and with your limit.
  5. Every week: enter shipped order lines and bottleneck adherence in 06 Delivery, read 07 Status in the weekly planning review.

Definitions used in the workbook

  • Available hours: Nominal hours of all resources minus breaks, planned maintenance, meetings and start-up, and typical absence.
  • Load: Quantity times standard minutes plus setups times setup minutes, in hours per week.
  • Bottleneck: The work center with the highest average utilization in the period. Confirm it on the floor: it has a queue in front and idle time behind.
  • Lead time: Work in progress divided by output per day (Little’s Law), in working days.

Sheets in the workbook

  1. Start
  2. Setup
  3. Load
  4. Sequence
  5. Lead Time
  6. Delivery
  7. Status

Who it is for

Production planners and supervisors.

The method behind the numbers

This workbook is part of the Production Planning and Control toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.