Our Favourite formula is INDEX. Here’s How Microsoft Changed It In 2020 With Dynamic Arrays
An update to Excel 365 in January 2020 means INDEX might work more slowly. Here is how to fix it so it works faster than ever.
Optimisation
Setting Customer Service Levels… Without Managing Stock Levels
Setting service levels usually starts with inventory.
Here’s a way to improve supply for important customers, that doesn’t involve inventory sizing.
And it doesn’t involve production either…
Setting Customer Service Levels… Without Managing Stock Levels Read More »
Get an Instant Rating for your Excel Planning
How does your Excel planning measure up?
Are you getting the best results or are you suffering from Excel hell?
Here is a simple measurement and a download tool that can give you an instant rating on your planning tools built with spreadsheets.
Get an Instant Rating for your Excel Planning Read More »
The Reality of Your Manufacturing World
Represent your manufacturing business using master data. Link the planning and scheduling system to the real world.
Excel-based planning systems give you more flexibility. Flexibility within the realms of the possible. Here are the essentials of master data and how they map onto your business.
The Reality of Your Manufacturing World Read More »
Uncertainty and the Predictive Power Of Planning
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 »
A Simple Truth About Capacity Planning
“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 »
Is MRP Your Business Constraint?
If you do not know your supply constraints, then it is likely your constraint is the MRP system.
How to use constraints-based planning and overcome the limitations of MRP logic.
Is MRP Your Business Constraint? Read More »
How Scheduling Can Co-Exist with Lean
Today, manufacturing excellence is built on execution. Lean manufacturing places emphasis on daily execution to customer demand. It favours a system of visual signals on the factory floor to replace computer planning and paper reports. Does this mean that production scheduling is in conflict with best practices of lean and demand-driven production? Certainly not. Scheduling goes far beyond Master Production Scheduling, is an essential part of integrated planning and a powerful way to model real-world constraints in a supply chain.
How Scheduling Can Co-Exist with Lean Read More »