Rows
of the Part Form |
Quantity |
Explanation |
Gross Requirements |
This is the sum of all the independent
demand and dependent demand required for the production
of other parts. P-400 has only independent demand obtained
directly from the MPS. PP has only dependent demand.
Its Gross Requirements come from the Planned Order Releases
of P-400. The add-in places formulas in this row of the
form so the numbers automatically adjust when the MPS
is changed. |
Level |
This is the maximum number of production
steps between the part and a finished good. P-400 is
at level 0 and PP is at level 1. |
Unit Cost |
This is the accumulated value of
the costs added by all the component parts lower in the
process structure. |
Projected on Hand |
This projects the on-hand inventory
without additional production. The values are computed
with formulas that take into account the initial inventory,
gross requirements and scheduled receipts. |
Net Requirements |
The requirements that cannot be
met with on-hand inventory or scheduled receipts are
the net requirements. These must be satisfied from production
during the time horizon. They are computed with formulas
entered by the add-in. |
Planned Order Receipts |
These are computed based on the
net requirements and the lot sizing method. In the case
of P-400 which uses a fixed order period of 3, the planned
order receipts are based on the requirements in the next
three periods. |
Planned Order Releases |
This row is the same as the planned
order receipts except it is offset by the lead time for
the part. This row becomes a portion of the Gross Requirements
for parts in the BOM. If a number other than 0 appears
as the first entry of this row (cell F15 for P-400),
the number indicates the planned order receipts cannot
be satisfied with the current lead time. The number indicates
the total shortage. |
Inventory on Hand |
This row computes the number of
complete units available in inventory in each period. |
Work in Process |
This row computes the number of
units in the production process, but not yet received. |