Here are five things you need to know about forecasting.
This is a statistics-free zone. Five forecasting principles for demand planning.
{ 12 comments }
Continue ReadingBusiness Intelligence
Five Things You Need To Know About Forecasting
on October 9, 2011
Get an Instant Rating for your Excel Planning
on October 4, 2011
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.
{ 3 comments }
Continue ReadingA Two-Letter Word Will Change The Way You Look At Scheduling
on September 19, 2011
Is the purpose of production scheduling to feed MRP and execution?
If you’re satisfied with this answer, then you’re missing something. A small, two-letter word will change the way you look at scheduling.
{ 6 comments }
Continue ReadingHow to Share Excel Data in the Cloud
on August 1, 2011
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.
{ 3 comments }
Continue ReadingHow To Plan for Long Lead-Time Materials
on July 27, 2011
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.
{ 12 comments }
Continue ReadingThe Reality of Your Manufacturing World
on May 17, 2011
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.
{ 12 comments }
Continue Reading
ERP often fails to give you the flexibility and visibility that you need.
Excel use has its own problems with spreadmarts and spreadsheet sin.
Apply this technique and take control over your planning and reporting. Getting Excel to perform like a business system.
{ 7 comments }
Continue Reading
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
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:
{ 17 comments }
Continue Reading