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.

Production-Scheduling.com 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>>>