Publication Date: 8/17/2026 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

Set Inventory Levels and EOQ

Settings/ Update/ P/N Master/ Inventory Levels Button

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.

Note: Verify switch setting for switches KFACTROL and RFACTROL. Refer to the Switch and Transaction Code Configuration section of this manual.

Set_PN_PN INV Level 1

Enter/update the following information:

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.

 

logo_X_small editedTo 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 but_new_smallbutton.

 

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 but_reorder_(level)_small 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 but_run (small) 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

INV_opt_scen2

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.

See Also

Re-Order Level Based on EOQ

Review KFACTROL and RFACTROL

Is the Poisson Factor setup?

Are Vendor Lead Days setup?

Do you want to reset the re-order level based on part usage?

Inventory Levels Button

Select Calculate Re-Order Level Button

Run P/N Re-Order Level Detail Selection

Do you need to edit/update the set Re-Order Level with the suggested values?

P/N Re-Order Suggestion Update

Run the Update Re-Order Level

Top of Page Publication Date: 8/17/2026 Share Print