Developing a MPS


The objectives in developing an MPS are as follows:
- To maintain the desired level of customer service by maintaining finishedgoods inventory levels or by scheduling to meet customer delivery requirements;
- To make the best use of material, labor and equipment;
- To maintain inventory investment at the required levels.

To reach this objectives, there are 3 steps in preparing a MPA:

- Develop a preliminary MPS,
  (1) calculating the projected on-hand inventory and
  (2) determining the timing and size of the production quantities of specific products.
- Check the preliminary MPS against available capacity,
- Resolve differences between the preliminary MPS and available capacity.

In some weeks, there may be no MPS quantity for a product because sufficient inventory already exists. For the projected requirements for this week, the scheduler uses whichever is larger—the forecast or the customer orders booked—recognizing that the forecast is subject to error. If actual booked orders exceed the forecast, the projection will be more accurate if the scheduler uses the booked orders because booked orders are a known quantity. Conversely, if the forecast exceeds booked orders for a week, the forecast will provide a better estimate of requirements for that week because some orders are yet to come in.

Preliminary Master Production Schedule

Part Number ITEM001
Lot Size 30
On Hand 20
               
  Period 1 2 3 4 5 6
  Sales Forecast 60 40 60 70 60 50
Proj Avail Balance (PAB) 20            
  Master Production Schedule            

To show the process of developing a MPS, an example is used that assumes the product is made to stock, an inventory is kept and the product is made in lots. This process of building an MPS occurs for each item in the family. If the total planned production of all items in the family and the total ending inventory do not agree with the PP, some adjustment to the individual plans must be made so the total production is the same.
Part Number ITEM001
Lot Size 30
On Hand 20
               
  Period 1 2 3 4 5 6
  Sales Forecast 60 40 60 70 60 50
Proj Avail Balance (PAB) 20 20 10 10 0 0 10
  Master Production Schedule 60 30 60 60 60 60

Once the preliminary mater production schedules are made, they must checked against the available capacity. This process is called rough-cut capacity planning.