||This becomes the name
of the worksheet and the prefix to a number of ranges on
the worksheet. The name should be chosen carefully following
the Excel rules for naming regions and worksheets. Once
chosen it cannot be changed.
||The number of periods to be considered
by the analysis. The meaning of a time period, day, week
or month, is the choice of the analyst. Again the number
of periods cannot be changed.
|Number of MPS
||This is the number of finished goods
to be scheduled. This number can be changed with the Change
|Number of Parts
||This is the number of parts to be
entered. Here we use the total number of parts in the process.
The data could be entered as one or a few parts at a time.
New parts are added at the bottom of the current worksheet.
|Interest Rate per Period
||This is an interest rate used for
time value of money calculations. It is used to compute
the cost of holding inventory for one period.
||This is a selection of the method
for computing the lot size for the parts. The four alternatives
are: LFL, lot of lot, FOP, fixed order period, FOQ, fixed
order quantity and WW, Wagner Whiten optimum policy. All
parts entered will be assigned this method but the method
may be changed by changing a cell on the worksheet.
||The default value for the number
of periods for the FOP method.
||The default value for the lot size
quantity for the FOQ method.
||The default value of the cost of
setting up the production process for a manufactured part
or to place an order for a purchased part. It may be changed
on the worksheet.
||The default value of the lead time
for producing or ordering a part. It may be changed on
|Number in BOM
||This is the number of rows allowed
for the Bill of Materials for a part. It affects the worksheet
and cannot be changed for a particular part. Parts may
be entered one at a time to provide different numbers of
||The default value of the initial
inventory for a part. It may be changed on the worksheet.