|
|
 |
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. |
| |
|
|
