Fast Excel Workshop

To survive in today’s environment, world class manufacturers need to be lean and very responsive. You can re-schedule within a few seconds in response to changes in customer demand with a planning and scheduling system that tells you what to make and what to buy. Make reliable and achievable delivery promises to your customers and keep your delivery performance high whilst keeping your inventory and work-in-progress at a minimum. Anticipate supply chain problems before they happen and avoid expensive overtime and emergency airfreight bills.

Previously this was possible only by implementing a complex ERP package, costing millions and taking years to implement. But now more and more companies throughout the world are achieving world class supply chain management by building their own systems in Excel. This workshop is very focused and skills based. It is aimed at people who already understand planning and scheduling and who already have some Excel skills and the workshop helps them put the two together. It does not teach planning and scheduling and it is NOT A BEGINNERS COURSE IN EXCEL.

Target Audience

Excel literate people from manufacturing and distribution companies who already understand the principles of Supply Chain Management but who want to automate their planning and scheduling processes without the need for programming skills.

Outcome

At the conclusion of the workshop each delegate will have the opportunity to reinforce what they have learned in the workshop with the e-learning modules and then adapt the model system for their own manufacturing company. By selecting only the functionality required, and by integrating Excel with an existing external data source, implementation and training times can be dramatically less than with an ERP package.

Objectives of the Workshop

  • Presentation of Model System (P-S Cycles Inc.)
  • Discussion on supply chain principles illustrated by the Model System
  • Close Integration
  • Fast response to change
  • Theory of Constraints
  • Demand pull
  • Vendor Managed Inventory

Fast Excel Development Methodology (FEDEM)

  • Design Principles
  • Structure and discipline
  • Custom vs. Package
  • Data capture and storage outside Excel (in ERP)
  • VBA free – native Excel functionality
  • Change compliance – prototyping
  • Documentation and naming conventions
  • Separation of input-process-report
  • Normalised data tables

Overview of Excel Techniques Modules

  • Dynamic named ranges
  • Recording a paste down macro
  • Joining tables
  • Pivot Tables
  • Working with dates
  • Importing text files
  • Exporting text files
  • Linking workbooks
  • Matrix to normalised table
  • Multiple macros
  • Exploding Tables
  • Stacking Tables
  • Advanced filter
  • Microsoft Query
  • Pivot Charts
  • Making a menu

Model System Analysis

Analysis of the Model System to illustrate the application of the Fast Excel Development Methodology to planning and scheduling:

  • Sales forecasts
  • Initial replenishment of
  • distribution depots
  • Projected Replenishment
  • Sales orders
  • Bill of Material
  • Material Requirement
  • Planning (MRP1)
  • Routings
  • Set-up reduction
  • Rough-cut capacity
  • planning
  • Finite scheduling
  • Purchasing
  • Conclusion and wrap-up