TRAX MANUALS > Settings > Settings Module > Settings, Update Menu > P/N Master (General Inventory) > P/N Master (General Inventory) Buttons > Inventory Levels Button, via P/N Master (General Inventory) > P/N Inventory Level, General Tab

The P/N Inventory Level, General tab is used to input inventory level configurations for parts per Location.

The following information/options are available in this window:
_____________________________________________________________________________________

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, transactions, or training events.

Note: Inventory levels cannot be created if the location is a sub location. For additional information, refer to switch SUBLOCATION, via the Settings Switches manual.

Planner

The person responsible for material planning for this part.

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.

Note: 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. The maximum stock level is used by businesses to control the number of goods in a warehouse, which takes into account demand while preventing overstock. This number should be the upper limit for a location to have available before storage costs or loss of value negatively affect expenses.

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. See notes below.

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. (Requisitions are triggered based on whole numbers only.) Purchasing actions 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 (whole number) value specified in the Re-Order Level field, a requisition will automatically be created. If the Reorder Level quantity is less than the Order Minimum Quantity, then the Requisition that is triggered will be for the Order Minimum quantity instead of the Reorder Level quantity. For more information refer to the Order Minimum field. See notes below.

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. If the Order Minimum quantity is greater than the Reorder Level quantity, then the Requisition that is triggered will be for the Order Minimum quantity instead of the Reorder Level quantity. For more information refer to the Reorder Level field. See notes below.

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.

Review Date

The user can select a date by which inventory levels should be checked at individual locations.

_____________________________________________________________________________________

Please note the following switches:

• REOEAUTO (Re-Order Level Automatic Calculation After Issues) - Dynamic Re-Order point calculation is available by switching on the REOEAUTO switch to Yes. This will calculate re-Order point following each subsequent issue of a part (to take surges into account). The Poisson factor allocated on the main P/N window is used for this calculation (they are set up in the System Tran Code Explorer).
• BOCRT - (Create Back Order For Parts Below Re-Order Level) - If set to Yes, the system will create Requisitions for Part Numbers that go below the re-Order level when reserving materials for a Work Order.
• REORLOC (Re-Order Level, Order Computation Omit Location) - If set to Yes, the system will take the total sum of quantities; on Requisitions and Quantity available at the current Location, and on all Orders from all Locations. If the sum is less than the Reorder Level quantity (defined in Settings/Update/P/N/ Inventory Levels button), then the system will create a Requisition. If set to No, the system calculates the total sum per specific Location. If the sum is less than the Reorder Level for a specific Location, the system will create a Requisition for that specific location.
• REORLOPO - (Re-Order Level Using Purchase Orders For Location) - If the REORLOPO switch is Yes when the REORLOC switch is set to No, only Purchase Orders (instead of all Order types) for each specific location will be considered.
• REOREQ_1 - (Inventory Levels of min/max/reorder of 1/1/1. Reorder Qty of 1) - When set to Yes, for parts that have Inventory Levels of min/max/reorder consisting of 1/1/1, the system triggers a Reorder Requisition Quantity of 1. When set to No, for parts that have Inventory Levels of min/max/reorder consisting of 1/1/1, the system triggers a Reorder Requisition Quantity of 2, which is a reorder quantity of +1. (See notes below.)
• REQDATEREO - (Require Date of Reorder Requisitions Postponed by Number of Days Specified by the User) - When set to Yes, the Require Date of the potential Requisition that will be issued once the Reorder Level is reached will be postponed by the number of days specified in the Config Number field of the System Tran Config window. When set to No, the Require Date of the Requisition will be the same as its issue date.
• SUBLOCATION - (Allow Sub Locations On A Location For Grouping Inventory Reordering) -

Note: If entering this Inventory Level information for the first time, the system will create a Requisition upon save if the quantities that are currently in inventory do not meet Stock requirements. The quantity that appears on the Requisition will be equal to ([the greater value of either the Re-Order Level quantity, or the Minimum Stock quantity] + 1). Further, if the Minimum Stock field is set to '0', the Reorder Requisition will not be triggered.

If the Minimum Order quantity is greater than the Reorder Level, then the Requisition Quantity will be the same as the Minimum Order quantity once the available quantity is equal to or less than the Minimum Stock Quantity.

Switch REOREQ_1 set to No: If the Minimum Order quantity is less than the Reorder Level, then the Requisition quantity will equal the Re-Order Level quantity minus the available quantity +1.

Switch REOREQ_1 set to Yes: If the Minimum Order quantity is less than the Reorder Level, then the Requisition quantity will equal the Re-Order Level quantity minus the available quantity.