In the P/N Inventory Level window, enter the location to establish a minimum, maximum and designate the Economic Order Quantity (EOQ) for part quantities.
Release
|
Field
|
Function
|
|
P/N
|
The Part Number reference for the aircraft part. This is the Part Number to set levels for.
|
|
Location
|
The Location for maintenance events, inventory stores, orders, or training events.
|
|
Planner
|
The person responsible for material planning for this part. The Planner appears on the Requisition Prints as the "Requester".
|
|
Buyer
|
The person responsible for buying this part. The Buyer will also automatically appear in association with the part when the part is placed on a Requisition (via Requisition/Update/ Requisition/Requisition Detail/Optional Tab/Assign To field).
|
|
Group
|
The group responsible for buying this part.
For information regarding how to set up a Group, refer to Buyer Group Explorer via Requisition, Explorer Menu, which can be found in the Requisition Training manual.
Note: When the Import option is used, the Group field will auto populate with the Group specified in the import file. For additional information refer to the Import Button, via the Standard Button which can be found in the System Standard Training Manual.
To assign a Group via P/N Inventory Level, select into the field and select from the Drop Down Selection pop-up the desired group or create a new group by selecting the New button.
|
|
Stock Maximum
|
The maximum in stock quantity allowed.
|
|
Stock Minimum
|
The minimum in stock quantity required (Safety Stock). The minimum stock level can be used to report on items that require urgent action.
|
|
Re-Order Level
|
The Re-Order point for the Part. The Re-Order point is established so that the system can automatically create Requisitions for parts that have reached a certain stock quantity level. Purchasing action can then be considered. Please refer to the Inventory manual (section “P/N Re-Order Level”) for additional related information. The Re-Order Level button is used to reset the Re-Order Level based on past usage (the system automatically calculates this figure). This field triggers a Re-Order Level Requisition. Once the available parts in inventory are less than the value specified in the Re-Order Level field, a requisition will automatically be created. Please read the immediate text below this table for switches which affect the Re-Order Level.
|
|
Order Maximum
|
The maximum quantity allowed on a Purchase Order. This information may appear on certain Prints.
|
|
Order Minimum
|
The minimum quantity allowed on a Purchase Order.
|
|
POU checkbox
|
Point Of Use. When this checkbox is selected, the system will validate against the location set up in the P/N Inventory Level, General tab when a P/N is being added to a Task Card or a Picklist.
|
|
Trigger Requisition checkbox
|
Select this checkbox to have Requisitions triggered by the system after the import process has been completed.
|
|
Calculate Reorder Level button
|
Select this button to calculate the reorder level and EOQ once all criteria has been selected. This calculation can be done multiple times for optimal results.
|
|
EOQ
|
The “Economic Order Quantity” field is used to store a value that is calculated outside of the system. The value is usually calculated by materials managers and used to determine the quantity that is the optimum (lowest) total variable cost (unit costs that depend on volume) required to Order and hold inventory.
The following switches are used to auto-populate the EOQ with the completion of P/N issue transactions:
KFACTROL - (Carrying Cost Factor for EOQ Calculation) - If KFACTROL and RFACTROL are both set to Yes, TRAX will use the amount entered for KFACTROL as the Carrying Cost Value (K-Factor) in the equation to calculate the Economic Order Quantity (EOQ). The EOQ will be displayed in P/N Master, Inventory Levels. The decimal field is used to enter the Carrying Cost of the part number. (Enter as decimals, e.g. 0.15 for 15% carrying cost value). For more information about the EOQ Formula please click on the above link. RFACTROL - (Replenishment Cost Factor for EOQ Calculation) - If KFACTROL and RFACTROL are set to Yes, TRAX will use the amount entered for RFACTROL as the Replenishment Cost (R-Factor) in the equation to calculate the Economic Order Quantity (EOQ). The EOQ will be displayed in P/N Master, Inventory Levels. The decimal field is used to enter the Replenishment Cost of the part number. For more information about the EOQ Formula please click on the above link.
|
|
Service Level % drop down

|
Select from one of the following Service Level percentages. This is the most acceptable Service Level which is defined by a companies business processes.
This defaults to 95%.
|
|
Factor
|
The Service Level Factor. The Inverse Normal Distribution formula along with the selected Service Level % equals the Factor variable.
(i.e. The Factor for a 95% Service Level = 1.64)
|
|
Replenishment Lead Time
|
The amount of time to have the part brought into the specified location.
|
Save the record.