Production Scheduling

How to Model Demand Uncertainty in Excel without Complicated Maths?

By Kien Leong Introduction When we make a plan in supply chain, we like single numbers. After all, a plan needs to be executed. When placing a purchase order, we need an exact quantity to order. Production needs to know exactly how many parts to produce. We cannot use ranges or probabilities in execution.

What Is an Excel-based Modular System? How to Build Your Own? And, More Importantly, Why?

By Kien Leong Our latest version of the Fast Excel Development Template fully supports modular systems. We have written here and there about modular systems. But, up until now, we have yet to provide in-depth content on how modules work and why you would use them instead of a single workbook.

Demand Forecasting – History as a Guide to the Future?

By Kien Leong The demand history can’t tell us everything about the future, but it can tell us some things. This article and video outlines exactly what and shows an example of automated forecasting in an Excel tool.

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

By Kien Leong 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….