Skip to content
Shop | Excel system

Factory Layout Planning System

Products and routings, from-to matrix, four layout grids, relationship rating with shared borders, space balance, utility analysis, business case, move plan and audit.

Screenshot of the Factory Layout Planning System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: hall, grid, parameters, rating limits and the list of areas. 03 Products: families, load units and routings.
  2. 04 Flows and 05 From-To: transports per day between areas, checked against the routings, as a list and as a matrix.
  3. 06 Layouts: the grid of today and up to three variants. 04 Flows shows distance and transport effort for each.
  4. 07 Relationships and 08 Space: rated pairs with their shared borders, and the space balance per variant.
  5. 09 Variants and 10 Business Case: utility analysis, facts per variant, investment, benefit and the alternative.
  6. 11 Move Plan for the chosen variant. 12 Audit before and after the project. 13 Status in every review.

Definitions used in the workbook

  • Transport effort: Transports per day x distance in meters, added over all flows.
  • Distance: Between the centers of two areas along the aisle directions: east-west distance plus north-south distance.
  • Shared border: Two areas touch along at least one side of a grid cell.
  • Rating: 4 essential, 3 important, 2 useful, 1 minor, 0 none, X keep apart. The flow rating follows from the limits in 02 Setup.
  • Weighted score: Sum of weight x score over all criteria. Weights add up to 100, scores run from 1 to 5.

Sheets in the workbook

  1. Start
  2. Setup
  3. Products
  4. Flows
  5. From-To
  6. Layouts
  7. Relationships
  8. Space
  9. Variants
  10. Business Case
  11. Move Plan
  12. Audit
  13. Status

Who it is for

Planning teams and plant managers who compare layout variants and prepare the move.

The method behind the numbers

This workbook is part of the Factory Layout Planning 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 two weeks.