planning

Demand Planning Sales Forecasting

Here are five things you need to know about forecasting.

This is a statistics-free zone. Five forecasting principles for demand planning.

{ 15 comments }

Continue Reading
Excel Planning Rating

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.

{ 4 comments }

Continue Reading
Excel Data Cloud

We build planning and scheduling systems in Excel.

Some systems like this material planning example have more than one user, in different locations.

Here is a way to share Excel data across multiple users by using a simple cloud service.

{ 4 comments }

Continue Reading
Shipping supply chain material planning shipping

The biggest headache in material planning is long lead-time materials.

Here is a simple tool that gives visibility between a buyer and a factory separated by a lot of water.

Also see an easy trick to connect multiple Excel users on different continents with free data integration over the cloud.

{ 17 comments }

Continue Reading
Predictive operations 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.

{ 26 comments }

Continue Reading
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.

{ 113 comments }

Continue Reading
Post 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

{ 23 comments }

Continue Reading