Production Planning and Scheduling with Spreadsheets

by Tony Rice

Production Scheduling with Excel

This is an information resource to help you build production planning and scheduling systems with spreadsheets. Here you will find tutorials, templates and downloads that can be used for planning and scheduling of production and materials using Microsoft Excel.

You will see that Excel is a fast and flexible platform for production and material planning.  Operations professionals need to apply logic and rules that fit the business.  There is a gap between packaged software systems and the needs of the company.  We help you apply development principles that give you powerful calculations that are exactly fitted to your production and planning processes.

By following these principles, you can build a planning and scheduling system that integrates perfectly with the host MRP/ERP system. This means you can build worksheets that perform powerful calculations, enable multiple users and a single version of the truth.

The Fast Excel Development Method is a set of techniques to use best practices that avoid many of the problems associated with spreadsheets.  This supports a rapid development to automate many manual Excel jobs and perform fast and simple prediction, modeling and production control.   You can also visit our section on How to Build a System and get practical advice for approaching a development.

We have complete systems that perform planning and scheduling for materials and production in a manufacturing business.  You can download these demos for free.  We have also created a development template that you can use to quick-start the development of a production planning tool.  The template has macros that automate many of the tasks without the need to learn Visual Basic for Applications (VBA).  View tutorials on using this tool.  This is available to download for those who register to our site for free.

This information resource is built and maintained by a group of consultants who help people like you to solve their material and production planning problems.  All using a familiar software that they already own with no licence costs or long, complicated implementations.

Exactly the logic you need for your production and planning processes, implemented in a fast, reliable and familiar environment.

Previous post:

Next post: