• Example Systems

    Download free P-S Cycles Integrated Planning System

    The P-S Cycles system is a comprehensive integrated planning system. The data model is based
    on a manufacturer and distributor of bicycles. It manages forecasts, sales orders, production,
    puchases and inventory across an integrated planning process.

    • Consolidating demand
    • Conditioning forecasts
    • Processing sales orders
    • Calculating distribution center replenishment
    • Projecting future replenishment
    • Rolling up costs
    • Material requirements planning
    • Routing explosion and setup optimization
    • Rough-cut capacity planning
    • Finite scheduling
    • Purchase and stock management
    • Projected inventory and sales reporting

    The complete model is available to download, free of charge. Members can access the download
    together with companion tutorial and support material.

    Registered users can use a download link below. Register for free here.? If you are registered, you can log in to the right>>>

    Download free Material Requirements Planning (MRP) System

    This system is an example of a typical MRP system.

    3g.playerauctions.com.cn assists manufacturers to develop their own finite scheduling systems
    in Excel, and will also custom develop scheduling systems for them. Most of these systems are
    interfaced to a host MRP/ERP system, which acts as a repository for demand and inventory data,
    and will perform Material Requirements Planning (MRP1) calculations.

    However, many clients have approached us to develop MRP within Excel, because either:

    • they do not have an MRP system, or
    • having generated scheduled dates within Excel, they are unable to upload them to their
      MRP system
    • their MRP systems are just too cumbersome and unresponsive

    The Excel-Based MRP system has the following features:

    • VBA free, no macros, it is all formulas and PivotTables, and nothing is hidden
    • demand is generated by a make-to-inventory Finite Schedule, but may also be from another source
    • a single level Bill of Material structure
    • inventory of raw material and components is allocated to the earliest scheduled product first,
      and will be dynamically re-allocated as the schedule changes
    • a Purchase Action Report identifies purchase orders which must be placed or chased to meet
      the schedule

    Registered users can use a download link below. Register for free here.? If you are registered, you can log in to the right>>>

    Leave a Reply

    Scroll to Top
  • 红树林的彩的登陆