How-To Tutorials

A New, Simpler Finite Scheduling Algorithm – In 14 Minutes You Can Understand How It Works and Download A Working Example in Excel

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.

A New, Simpler Finite Scheduling Algorithm – In 14 Minutes You Can Understand How It Works and Download A Working Example in Excel Read More »

How To Measure Variability in Demand…. And Why You Should Think Twice Before Using it For Sizing Inventory

Here is a story about an attempt to size inventory buffers, by measuring demand variability. It is based on a true story and there are lessons learned from real experience.
I’ll tell you the story in both words and data. I have compiled a dataset and will share it here.

How To Measure Variability in Demand…. And Why You Should Think Twice Before Using it For Sizing Inventory Read More »

How to Build Your Own Material and Production Planning and Scheduling Tools in Excel

Learn how to create your own Excel planning and scheduling tools for a manufacturing business. Some people want a spreadsheet tool so that it will solve their planning problems at the push of a button.

Others want to take it apart. Figure out how it works. Adapt it and build their own. If you’re like them, then this webinar is for you.

How to Build Your Own Material and Production Planning and Scheduling Tools in Excel Read More »

Scroll to Top