Computation Section
Materials Requirement Planning
 -Entering the Data
With the MRP form constructed and the data available, it is time to enter the data on the worksheet. The worksheet portion shown below shows the worksheet for the master production schedule and the first part after the data has been entered.
First enter the names and projected requirements for the MPS. Note that the names of the products entered into the first column of the MPS must correspond exactly to the names of the parts entered as the part number, cell C9 for part P-400 for example. The demand column is automatically computed in column S as the average per period demand over the 12 periods of the time horizon.

Now enter the data for each part. We illustrate the data entry for part 400, but each part must be similarly entered. The Part No. is P-400. The BOM, bill of materials, is a list of the parts that go into making the P-400. For the example this is PP, 300 and 350. Again, the names in the BOM region must agree with the part numbers defined for the process. Associated with each part number listed in column B is a part quantity listed in column C, 1 for each part in the example. The lot sizing option for P-400, FOP, is in cell B15, and its parameter is in C15. The unit cost is in C16. The current inventory on hand, 130 for P-400 is placed in cell E12. The setup cost for the part is in cell S11. Scheduled Receipts for the part are entered in row 11 of the form. The part data takes the default values when first entered, but may be changed to reflect differences between the parts.
Return to Top

tree roots

Operations Management / Industrial Engineering
by Paul A. Jensen
Copyright 2004 - All rights reserved

Next Page