中彩网|首页|官网电脑版

                                How to Build Your Own Material and Production Planning and Scheduling Tools in Excel

                                Our Fast Excel Development Methodology is designed for rapid building of planning and scheduling tools in Excel.

                                We have been using this to build the material and production planning and scheduling tools in Excel that you see on this site

                                Now, we have a webinar to show you how the Fast Excel Development Methodology works, using a material planning tool as an example.

                                Before I invite you to join, here is some background.

                                Our Most Popular Video…

                                Some time back, we recorded a video called Build a Material Planning Tool in 10 Minutes. It showed us using the method to create a simple material planning tool that took demand, purchase orders and inventory and calculated the availability or shortages of all materials needed for each sales order.

                                The video was so popular that we had to upgrade our hosting account to be able to handle the traffic!

                                We want to expand the learning and download resources on this site. We are now working on a revamp and there is lots of new content coming. The webinars we offer are part of this.

                                Webinars help us to do two things:

                                • Provide interactive teaching through screen-share and video about building and using Excel Planning Tools
                                • Get feedback from the subscribers and visitors to this site about what problems they are trying to solve so we can better help them

                                Fast Excel Demonstrations are back!

                                We are starting to run some more demonstrations, showing how to quickly develop planning and scheduling tools for a variety of applications. These include Material Planning, Capacity Planning and Inventory Analytics.

                                Rather than just rattling off a ten minute demonstration, this time we are going to take an hour to explain each step and use the build as a teaching example for the principles that we use to build the material and production planning and scheduling tools in Excel that you see on this site.

                                The resulting Material Planning tool will be a little more comprehensive than the “Ten Minute” version. We will explode Demand through the BOM and then compare with supply from Inventory and Purchase Orders. There is a a graphical view of the inventory projection.

                                Webinar – How to Build Your Own Planning and Scheduling Tools in Excel

                                Learn how to create your own Excel planning and scheduling tools for a manufacturing business. Some people want a spreadsheet tool so that it will solve their planning problems at the push of a button.

                                Others want to take it apart. Figure out how it works. Adapt it and build their own. If you’re like them, then this webinar is for you.

                                Webinar Times

                                4 March

                                Wednesday

                                We will run two live sessions at:

                                1:00pm
                                GMT
                                8:00am
                                EASTERN
                                7:00pm
                                GMT
                                2:00pm
                                EASTERN

                                What you will get from this webinar:

                                • The key principles to build your own Excel planning tools in minutes.
                                  (Or for that matter, any other Excel-based tool used in business operations…)
                                • A step-by-step guide to the logic that will identify material shortages – using demand, BOMs, inventory and purchase orders. How to process thousands of data rows in seconds… at the push of a button!
                                • A full version of our Development Template and the knowledge of how to get started with it.
                                  Plus a copy of the fully-functioning material planning tool that we build – live on the webinar.

                                Leave a Comment

                                Scroll to Top

                                                              mailbox

                                                              aviation

                                                              video

                                                              Finance

                                                              culture

                                                              aviation

                                                              Variety show

                                                              mailbox

                                                              the weather