Capacity Planning Tool

April 5, 2011
Capacity Planning Tool Download

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.

Read the full article →

How Calendars Fix Your Capacity in Planning and Scheduling

Thumbnail image for How Calendars Fix Your Capacity in Planning and Scheduling March 31, 2011

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.

Read the full article →

Easy Date Calculations When Planning With Excel

February 1, 2011
Thumbnail image for Easy Date Calculations When Planning With Excel

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.

Read the full article →

A Simple Truth About Capacity Planning

January 21, 2011
Capacity Planning Measures

“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.

Read the full article →

Seven Habits for Highly Effective Excel Planning

January 1, 2011
Excel Planning Habits

Happy new year! A time for planning and new year resolutions.

Ouch. The word “Resolutions” doesn’t give you good feelings, does it?

I prefer habits -form them and it takes effort to break them. Here are seven good habits for using Excel for planning.

Read the full article →

Excel Demand Analytics – Fast Formulas on 65K+ Rows

November 29, 2010
Demand Analytics Chart Thumb

Analytics for demand planning in Excel usually involves big tables of data.

To understand the demand for a product, you need to look into its history. An order history can easily have 100K+ records.

Here is a technique to perform fast analytical formulas on many thousand rows.

Read the full article →

The Demand Planning Dilemma – Setting a Service Level

November 29, 2010
Demand Analytics Techniques Excel Thumb

The dilemma of demand planning: to use a forecast or history.

We cannot expect history to repeat itself, yet every day we are reminded of inaccuracy and bias in the forecast.

How to combine the forecast and history to get a true measure of demand.

Read the full article →

Is MRP Your Business Constraint?

November 14, 2010
bottleneck constraint mrp thumb

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.

Read the full article →

The Biggest Production Planning Mistake with Excel

November 8, 2010
Thumbnail image for 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:..

Read the full article →

Build a Material Planning Tool in 10 Minutes

October 18, 2010
Thumbnail image for Build a Material Planning Tool in 10 Minutes

I have demand, on-hand inventory and open purchase orders.  What orders can I cover with materials and which orders are going to be short? This is a simple question in material planning.  We frequently get asked by clients to build spreadsheet tools that can provide an answer.  You can download

Read the full article →

How Scheduling Can Co-Exist with Lean

September 20, 2010
Thumbnail image for 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.

Read the full article →

The Seven Deadly Spreadsheet Sins

August 29, 2010
Excel 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:

Read the full article →

Production Planning and Scheduling with Spreadsheets

June 28, 2010
Thumbnail image for Production Planning and Scheduling with Spreadsheets

This is an information site to help you build planning and scheduling systems with spreadsheets. Here you will find tutorials, templates and downloads that can be used to create advanced planning and scheduling system using Microsoft Excel.

Read the full article →

Run Macros with Excel 2007/2010

June 14, 2010
Excel Macros

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

Read the full article →

Using Text Files to Connect Excel with Systems Data

June 14, 2010
Thumbnail image for Using Text Files to Connect Excel with Systems Data

Excel-based planning and scheduling systems need data.   Best practices in developing Excel systems say:  “Separate data storage, calculation and reporting.” A database the best place to store data.  Our Excel tool needs to bring it in, perform calculations and then send it back out.  The output tables can

Read the full article →