千亿|国际娱乐电脑网站

      <address id="1d5d5"></address>
        <noframes id="1d5d5">

            <address id="1d5d5"></address>
            <address id="1d5d5"><nobr id="1d5d5"><progress id="1d5d5"></progress></nobr></address>

            <address id="1d5d5"><form id="1d5d5"></form></address>

              <form id="1d5d5"><nobr id="1d5d5"><meter id="1d5d5"></meter></nobr></form>

              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

              Leave a Reply

              Scroll to Top

                  <address id="1d5d5"></address>
                    <noframes id="1d5d5">

                        <address id="1d5d5"></address>
                        <address id="1d5d5"><nobr id="1d5d5"><progress id="1d5d5"></progress></nobr></address>

                        <address id="1d5d5"><form id="1d5d5"></form></address>

                          <form id="1d5d5"><nobr id="1d5d5"><meter id="1d5d5"></meter></nobr></form>

                          Premier League

                          aviation

                          Super League

                          Super League

                          Mobile phone

                          culture

                          Real estate

                          aviation

                          Buy a car