Your Planning System Needs a Check Up: Material and Capacity Planning | Fast Excel Development Template and Power Query.
Do a check up to your planning system: learn how to do it by the Fast Excel Development Template and Power Query.
Do a check up to your planning system: learn how to do it by the Fast Excel Development Template and Power Query.
The finite scheduling calculates the exact begin and end of each job considering routing and quantity for the workload and work center availability by a calendar for the capacity.
In the standard Fast Excel Development Methodology this requires smart and complicated formulas to deal with dates and time, and this is needed even in the simplest push only scheduling form. Of course you can copy and adapt the formulas from other examples and let the Fast Excel Development Template do the automation and the VBA coding for you.
This article is about making finite capacity scheduling simpler by an algorithm based on cumulation and sorting, and by some Power Query use. And as always there is a companion tool that implements the logic of the article in a fully automated tool.
How to build a complete material and capacity planning tool, with finite production scheduling and purchased materials constraints by Excel and the Fast Excel Development Template.
This is a story from Gabriele Tettamanzi. Gabriele is a new contributor to the site. In this article, he shares his experience from using the Fast Excel Development Method in his previous company. At the beginning of the 2000s, I worked in the Automotive business. I was leading the supply chain department for a component
Case Study – Why Did I Start Production Planning By Spreadsheets? Read More »
How Excel-based modules can combine for a flexible planning system.
A Flexible Supply-Chain System Using Excel-Based Modules Read More »
We are launching webinars to help you with planning and scheduling in Excel.
Here is how you can watch us build, set up and use these free downloadable tools.
Pre-register for our first webinar coming up soon!
Helping You With Production Scheduling – New Webinars Read More »
Our new Capacity Planning Tool gets you halfway to production scheduling.
This article will help you understand how it calculates dates and working days in the calendar. It will go a long way towards that scheduling goal.
How Capacity Planning Gets You Halfway to Production Scheduling Read More »
We have a new capacity planning tool for you.
Download it for free to get better visibility on production load and capacity.
Download Our Capacity Planning Tool – Version 2.0 Read More »
Job shop production is a challenge for scheduling.
Three ideas to job shop scheduling and other customized products when you have no standard process data.
Scheduling Job Shops and Engineer-to-Order – Three Alternatives that can Work Read More »
The most common mistake that planners make with capacity planning, and how to fix it.
Some tips on how to get good visibility on capacity in a high-mix production factory.
Download our free Capacity Planning Tool and load it with your own production data.
Kick-Start Your Capacity Planning Read More »
Predictive planning provides a way to manage uncertainty. Planning can resolve the dilemma between schedule-push and demand-pull.
How an Excel-based predictive planning tool can work alongside the business transaction system.
Uncertainty and the Predictive Power Of Planning Read More »
Here is a Capacity Planning Tool to download, test and run with your own data.
You can see your work orders from sales, compare with available capacity. Gives you instant visibility on production capability and constraints.
Capacity Planning Tool Read More »
This is a guide to help you use calendars in planning and scheduling.
Production capacity starts with calendars – here’s how to make a calendar and calculate in Excel.
How Calendars Fix Your Capacity in Planning and Scheduling Read More »
Capacity planning compares minutes of production with days of resources. Here is an easy way to convert minutes to days over any working calendar.
This technique also helps to simplify many Excel date calculations for working days and times.
Easy Date Calculations When Planning With Excel Read More »
“It was easy to see where they were going wrong…”
A short story and a simple truth about capacity planning.
Also a chance to give us feedback and get free access to the right capacity planning tool for your business.
A Simple Truth About Capacity Planning Read More »