Kien Leong

The Biggest Production Planning Mistake with Excel

Excel is the most widely used software for production planning. Production planning is one of the most common applications for Excel in manufacturing. Yet, there is one common mistake that people make when production planning in Excel. Avoid doing this one thing and you will save yourself hundreds of hours of unnecessary and repetitive work with production planning data. The mistake:..

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.

The Seven Deadly Spreadsheet Sins

Business has a love-hate relationship with spreadsheets. Widely used, accessible and essential to running the business. They are also unsecure, error-prone and scatter silos of data across the enterprise.

Depending on your point of view, spreadsheet use can be a users’ paradise or a necessary evil. Excel is the daily work-horse to over 500 million users, yet many IT departments seem hell-bent on stamping out spreadsheets and migrating everyone to business intelligence, budgeting and ERP applications.

Here at Production-Scheduling.com, we are in the business of taming spreadsheets. You might suspect that we always come down in favour of using spreadsheets for business applications. The truth is that there is only ever one answer to the question:

Should we be using Excel to ………….. (insert your business function here)

The answer is:

Run Macros with Excel 2007 and above

Many of the tools, templates and systems that we build use macros in Excel.  Some of you will be quite capable and experienced with Excel macros and VBA.  Others could be coming across Excel macros for the first time. Excel 2007 upwards has some additional security for running macros.  If

Scroll to Top