Production Planning
The SmartFactoryTools Changeover & Setup Planner is a practical Excel template designed for manufacturing teams that need to understand how much production time is consumed by cleaning, setup and product changeovers. Enter your machines, products and standard changeover rules, then arrange your SKUs in production sequence. The template automatically identifies when cleaning, setup, or both are required between consecutive products. It also converts planned non-production time into an estimated production capacity impact, helping you see how changeovers affect your available shift time.
€7.99
SKU: SFT-CHANGEOVER-01 · Digital download (Microsoft Excel)
Purchase and download through Etsy. Opens in a new tab.
▶ Requires Microsoft Excel on a Windows or Mac computer (Excel 2016 or newer). Not for Google Sheets, Apple Numbers or mobile apps.
Changeover & Setup Planner — Excel Template
Reduce guesswork when planning product changeovers.
The SmartFactoryTools Changeover & Setup Planner is a practical Excel template designed for manufacturing teams that need to understand how much production time is consumed by cleaning, setup and product changeovers.
Enter your machines, products and standard changeover rules, then arrange your SKUs in production sequence. The template automatically identifies when cleaning, setup, or both are required between consecutive products.
It also converts planned non-production time into an estimated production capacity impact, helping you see how changeovers affect your available shift time.
Enter:
For each SKU define:
Products belonging to the same Cleaning Group can run without triggering an additional cleaning event.
Products belonging to the same Setup Group can run without triggering an additional format/setup change.
Choose the machine and enter your SKUs in the exact order they will be produced.
The spreadsheet compares every product with the previous product and automatically determines:
The Summary sheet shows:
The template supports:
Up to 30 planned jobs
Up to 9 machines / production lines
Up to 37 SKUs
It analyzes one machine production sequence at a time.
Step-by-step instructions and explanation of the calculation logic.
Machine parameters and Product / SKU Master Data.
Enter your production sequence and automatically calculate changeovers.
Visual overview of planned non-production time and estimated capacity impact.
FAQ and LICENSE
Answers to the most common questions and the terms of use.
The EXAMPLE workbook includes manufacturing data (7 SKUs on one line) so you can immediately see how the template works. The BLANK workbook is ready for your own sequence.
Yellow cells are your inputs. Calculated fields update automatically and are protected against accidental changes (no password).
Suitable for:
Designed for Microsoft Excel.
No macros required.
This is an Excel spreadsheet template and does not require specialized production planning software.
Estimated Lost Production Capacity represents the potential number of units that could have been produced during planned non-production time, based on the machine speed entered by the user.
It does not represent lost revenue, lost profit or financial loss.
This is a digital download.
No physical product will be shipped.
You will receive:
1 × ZIP file with:
After purchase, download the ZIP on a computer, unzip it and open the BLANK file in Excel to enter your own production data.
This focused template is designed specifically for changeover, cleaning and setup analysis.
It does not include full production-order capacity planning, workforce planning, financial analysis or automatic production-sequence optimization.
For full capacity planning by SKU and machine, see our Manufacturing Capacity Planner.
Production PlanningPlan your daily production capacity, identify bottlenecks, and check whether your production plan fits your available machine time before the shift starts. This Excel template goes beyond a simple Quantity ÷ Speed calculation. It includes real manufacturing constraints such as cleaning/changeovers, machine setup time, pallet handling, packaging changes, startup, shutdown, planned stops, and product-specific delays.
€19.99
View details
Production PlanningQuickly check whether your machines have enough available time for planned production. Enter your required quantity, machine speed, available hours, setup time, changeover time and downtime — the template automatically calculates required hours, utilization and overload risk. Designed for production planners, supervisors, operations managers and small manufacturing teams that need a simple capacity planning tool without complex software.
€7.99
View details
Production PlanningTurn your production orders into a clear line-by-line capacity plan. Enter your production orders, assign each order to a production line, add demand quantities, production rates, setup time, changeover time and other planned losses — the workbook automatically calculates the required hours for each order and summarizes the total workload by production line. Quickly see which lines have spare capacity and which lines are becoming bottlenecks before the production plan is released.
€7.99
View details