Rotable Levels Page (Fields)
The following describes each section on the Rotable Levels page. Note that you can expand sections by clicking the Expand button (
) and you can collapse sections by clicking the Collapse button (
).
) and you can collapse sections by clicking the Collapse button ().Click here for more information about levels calculations.
Recommended Actions
The Recommended Actions section lists the actions generated by the Order Plan for the selected part/location SKU. It lists all recommendations Order Plan generates as well as the orders Order Plan did not change. It does NOT list orders not included in Order Plan. Orders are not included in Order Plan when Count In Order Plan is set to No (countInOP flag = n) for the ordering scheme governing the SKU.
Each of the counts displayed in the Recommended Actions section are determined by the associated Action page filter. Note that the filter used for Procurements may be different than that of Repairs.
While these values cannot be changed in this section, the information is presented to help you decide how/if you want to manually adjust optimal levels.
For each recommended action, the following values are listed in the table:
Date: The plan date of the first order for the SKU.
Count: The number of recommended actions of this type for the selected SKU.
Days: The total quantity expressed as Days of Supply.
Units: The sum of the recommended quantity.
The following describes the fields that could appear in this section.
 | Days of Supply = Recommended Procurement Quantity / Average Daily Usage |
Field | Description |
|---|---|
Procurement | The procurement order quantity recommended by Servigistics to be procured for the selected part/location SKU. Reported in number of Days of Supply (Days) and number of units (Units). This field only appears if the part is a procurement part. |
Repair | The quantity of on hand bad parts recommended by Servigistics to be repaired for the selected part/location SKU. Reported in number of Days of Supply (Days) and number of units (Units). This field only appears if the part is a repairable part. |
Replenishment | The quantity of parts recommended by Servigistics to be replenished or balanced for the part/location SKU. Reported in number of Days of Supply (Days) and number of units (Units). |
Critical Shortage | The shortage quantity of parts that are understocked for the selected part/location SKU. Reported in number of Days of Supply (Days) and number of units (Units). Click here for more information about critical shortages. |
Excess | The excess quantity of parts that are overstocked for the selected part/location SKU. Reported in number of Days of Supply (Days) and number of units (Units). Click here for more information about excesses. |
Optimal Levels
The following describes the fields that appear in this section.
Field | Description |
|---|---|
Measure of Effectiveness Used | The measure of effectiveness used to calculate the optimal levels for the SKU. |
Rotable Pool Levels
The Rotable Pool Levels section lists the desired inventory and Safety Stock amounts for the rotable pool.
The following describes the fields that appear in this section.
| | In this section, the Bank Size column corresponds to the Stock Maximum for each row and the Safety Stock column corresponds to the Safety Stock calculated by subtracting the Lead Time Demand from the corresponding Bank Size. |
Field | Description |
|---|---|
Pooled Bank Size | The lowest inventory that needs to be maintained to achieve the contractual service level at the bank level. Calculated as: Pool Level ROP + 1 where Pool Level ROP takes pool level demand, service level, and lead time into consideration. |
Non-Pooled Bank Size | To calculate Non-Pooled Bank Size, the individual ROP at each location needed to meet each location's service level is determined. The calculated value is then rounded and summed across all locations in the bank and incremented by 1. If the Non-Pooled Bank Size is smaller than the Pooled Bank Size, a Review Board record is generated. This event typically happens if the Rotable Bank Demand Satisfaction or Turn Around Time is very high when compared to individual locations. |
Ideal Bank Size | The desired Stock Maximum for the rotable pool derived by comparing the Pooled and Non-Pooled Bank Sizes. The minimum of the two is chosen. |
Bank Size Override | Override amount for Ideal Bank Size. Enter the override amount in the box and click the Save button (  ). |
Effective Demand Satisfaction | The effective Demand Satisfaction for the rotable pool. It is the fill rate achieved if the allotments are made. |
Rotable Pool Lead Time Forecast
The Rotable Pool Lead Time Forecast section lists the contribution of procurement, return, and repair lead time forecast for the rotable pool in units and days of supply.
The following describes the fields that appear in this section.
Field | Description |
|---|---|
Procurement Pipeline Forecast | The sum of Procurement pipeline forecasts for all the procurable locations in the rotable pool for the most recently used part. This field appears only if the primary location is a procurement location. |
Replenishment Pipeline Forecast | The sum of Replenishment pipeline forecasts for all the replenishment locations in the rotable pool for the most recently used part. This field appears only if the primary location is a replenishment location. |
Return Pipeline Forecast | The sum of Return pipeline forecasts for all the locations in the rotable pool for the most recently used part. |
Repair Pipeline Forecast | The sum of Repair pipeline forecasts for all the locations in the rotable pool for the most recently used part. |
Rotable Parameter Details
The Rotable Parameters Details section lists the parameter values for the planning parameters governing the selected SKU.
The following describes the fields that appear in this section.
Field | Description |
|---|---|
Bank DS | The desired Demand Satisfaction for the total Rotable Pool/Bank. |
Scheme Name | The name of the planning scheme governing the selected SKU. |
Scheme Description | The description of the planning scheme governing the selected SKU. |
Exchange Mode | Exchange Mode determines the Repair Turn Around Time. There are two kinds of exchange modes: Normal and Advanced. For Normal Exchange Mode: Repair Turn Around Time = Return Length + Repair Length + Rotable Hold Length - TAT Length For Advanced Exchange Mode: Repair Turn Around Time = Repair Length + Rotable Hold Length - TAT Length |
Rotable Primary Location | Considered the main point of entry of rotables into the Rotable Bank. This location's procurement/replenishment length is used for the Rotable Bank size calculation. |
Rotable Default Repair Location | Considered the main location where the repairs of the rotables happen. This location's repair/return lengths are used for the Rotable Bank level calculations. |
Allot To Pool | If Allot To Pool (a planning parameter) in the planning scheme governing the SKU is set to Yes, then Ideal Bank Size is allotted to the locations in the Rotable Bank in proportion to their individual needs. If Allot to Pool is set to No, then Ideal Bank Size is allotted to the Rotable Primary Location only. |
Use Calculated EOQ | When Yes, the calculated EOQ is used in the Order Plan process. When No, Order Plan uses 1 as the Economic Order Quantity value. |
Part Cost | The amount paid to acquire the part. |
Repair Cost | The cost to repair the part. |
Do not stock if non-ASL at pooled locations | When set to Yes, if all locations in the pool are non-ASL, then the minimum bank size (which is the equivalent of the pool Stock Max) will equal zero (0) (instead of 1). |
Forecasted Demand
The Forecasted Demand graph shows the forecasted demand for the pool by time slice over the period represented by the sum of the EOQ, Safety Stock, and Pipeline Demand quantities expressed in days of supply for the selected part/location SKU.
| | To hide the Forecasted Demand and Rotable Bank Size graphs, click Hide Graphs. |
Rotable Bank Size
The Rotable Bank Size graph shows Rotable Bank Size in relation to Demand Satisfaction.
TIP: To hide the Forecasted Demand and Rotable Bank Size graphs, click Hide Graphs.
Rotable Parameters
The Rotable Parameters section lists parameter values for the planning scheme governing the selected SKU.
To change values in this section, enter the values in the box provided and click the Save button ().
).The following describes the fields that appear in this section.
Field | Description | ||
|---|---|---|---|
Procurement Repair Replenishment Return | Data for the Procurement, Repair, Replenishment, and Return pipelines. Length: The number of days (0-365) in the pipeline. Standard Deviation: The standard deviation of the pipeline length. Effects of adjustment: Raising a pipeline's standard deviation will raise inventory levels by raising Safety Stock (since variability in the supply chain increases risk). | ||
Turn Around Time | [applicable to rotable parts only] Most rotable components take long periods of time to repair. However, customers demand a replacement part in a shorter time frame. Turn Around Time (TAT) is the amount of time that a customer is willing to wait for a replacement. This may be contractually specified or it may be a rule of thumb. Turn Around Time is subtracted from each pipeline length before Safety Stock, ROP and Stock Maximum are calculated. | ||
Hold Length | Time added to the lead time for optimal levels calculations (but not used in Order Plan). Can be a result of paper work, accounting, etc. | ||
Return Wash Rate | Return Wash Rate is a factor (percentage) used to forecast returns. Forecasted returns are normally used in time-phased planning to project on hand bad quantities. It is normally calculated as: Forecast * (1 - Return Wash Rate)
| ||
Repair Wash Rate | Repair recommendation quantities are factored by the Repair Wash Rate (which is a percentage). For example, if the Repair Wash Rate = 10% and 10 good units are required to meet demand, then 11 units of on hand bad will be required and assumed used on the assumption that one unit will wash out during the repair process. | ||
NFF Rate | The No Fault Found Rate. This is the percentage of returned material which, upon inspection, is determined to not need repair and as such is available for immediate use as good inventory. | ||
HistorySD | A measure of historical demand variability over a specified number of time slices, calculated from either the raw demand history as downloaded from the host system or after being de-seasonalized. If the forecast parameter Std Deviation - Use de-seasonalized and de-trended history is set to Yes, History Standard Deviation is computed using deseasonalized/detrended history. Otherwise, raw demand history data is used. HistorySD = SQRT((SUMSQ(values) - (SUM(values)^2)/COUNT(values))/(COUNT(values) - 1))
| ||
Procurement Order Period | The minimum number of days between orders for the procurement pipeline.
| ||
Repair Order Period | The minimum number of days between orders for the repair pipeline.
| ||
Replenishment Order Period | The minimum number of days between orders for the replenishment pipeline.
|
Current Amount
The Current Amount section lists all the bank sizes (meaning the number of parts) for the Rotable Bank.
The following describes the fields that appear in this section.
Field | Description |
|---|---|
Actual Bank Size | The actual bank inventory across all locations. When this value dips below the Ideal Bank Size, a recommendation to procure new parts is generated at the primary location. The comparison between Actual Bank Size and Ideal Bank Size is also used to generate Review Board records to draw your attention to excesses and shortages. Actual Bank Size = Bank On Hand New + Bank On Hand Fixed + Bank On Hand Bad - Bank Backorder - Bank Allocated + Bank On Order + Bank In Repair + Bank In Return |
Bank On Order | Client-driven value - usually means the Bank quantity expected at the location of a given part from a supplier. |
Bank On Hand New | Client-driven value - usually means the number of new parts in the Bank. |
Bank On Hand Fixed | Client-driven value - usually means available stock in the Bank that has previously been repaired (for the purposes of identifying stock that cannot legally be resold as new). |
Bank In Repair | Client-driven value - usually means the number of Bank parts actually in process - also known as Repair WIP (Work in Process). |
Bank In Return | Client-driven value - usually means bad material returned for exchange or repair under an RMA (Return Material Authorization). In some cases, this is the sum of In Return Bad and In Return Good. |
Bank Backorder | A Bank backorder includes quantities committed to another party upon their arrival. |
Bank Allocated | Client-driven value usually meaning that a Bank part is on hand but already committed to another requirement. |
Bank On Hand Bad | Client-driven value - usually means the number of bad parts in the Bank that are awaiting a repair order. |
Custom Fields
The following describes the fields in this section.
Field | Description |
|---|---|
Custom | Custom fields for levels derived from the Part Master, Location Master, Stock Level, and Stock Amount tables. |
Allotments
Current location allotments to locations are listed in the Allotments section.
If Allot To Pool (a planning parameter) in the planning scheme governing the SKU is set to Yes, then Ideal Bank Size is allotted to the locations in the Rotable Bank in proportion to their individual needs. If Allot to Pool is set to No, then Ideal Bank Size is allotted to the primary location only.
Rotable functionality on the Optimal Levels page allows planners to allocate Pool Safety stock to individual locations. That allocated safety stock is then used by the Order Planning engine to do the order planning for those locations. Allocations are based on the amount of Safety stock held at each individual location. When this feature is activated, planners can see allotments and available safety stock on the Rotables page. To enable this feature, set the SL_ROTABLE_ALLOCATION_BY_SS global setting to True.
The following describes the fields that could appear on the page depending on how it is configured.
Field | Description | ||
|---|---|---|---|
Allocated Allocated Original | Client-driven value usually meaning that a part is on hand but already committed to another requirement. Allocated Original is the value from the host system, and Allocated is the rolled up value. | ||
Allotment | The quantity of the Bank Size that is allotted to each location based on the original allotment. | ||
Allotment % | The percentage of the Bank Size that is allotted to each location based on the original allotment. | ||
Allotment Base | ROP based on standard optimal levels calculations. Ideal Bank Size is distributed proportionally based on this ROP value.
| ||
Allotment Override % | Overrides the percentage of allotted units for the location by the specified percentage. | ||
Allotment Override Qty | Overrides the number of allotted units for the location by the specified quantity. | ||
Amount Custom (1-15) | Custom fields for amounts derived from the IPCS_STOCK_AMOUNT table. | ||
Backorder Backorder Original | The original backorder amount that came from the host system. | ||
Effective Allotment | The quantity of the Bank Size that is allotted to each location based on the effective allotment. | ||
Effective Allotment % | The percentage of the Bank Size that is allotted to each location based on the effective allotment. | ||
Effective Demand Satisfaction | Back calculated using the effective bank size for the rotable pool. | ||
In Repair In Repair Original | Client-driven value - usually means the number of parts actually in process - also known as Repair WIP (Work in Process). In Repair Original is the value from the host system, and In Repair is the rolled up value. | ||
In Repair Bad In Repair Bad Original | Client-driven value - usually means material in repair and not yet repaired. In Repair Bad Original is the value from the host system, and In Repair Bad is the rolled up value. | ||
In Repair Good In Repair Good Original | Client-driven value - usually means material still in repair but already repaired. In Repair Good Original is the value from the host system, and In Repair Good is the rolled up value. | ||
In Return In Return Original | Client-driven value - usually means bad material returned for exchange or repair under an RMA (Return Material Authorization). In some cases, this is the sum of In Return Bad and In Return Good. In Return Original is the value from the host system, and In Return is the rolled up value. | ||
In Return Bad In Return Bad Original | Client-driven value - usually means bad material returned for exchange or repair under an RMA (Return Material Authorization). In Return Bad Original is the value from the host system, and In Return Bad is the rolled up value. | ||
In Return Good In Return Good Original | Client-driven value - usually means good material returned for exchange under an RMA (Return Material Authorization). In Return Good Original is the value from the host system, and In Return Good is the rolled up value. | ||
Lead Time Demand | Demand over lead time. | ||
Location | The name of the location. | ||
Location Custom (1-10) | Custom fields for locations derived from the IPCS_LOC_MASTER table. | ||
On Hand Bad On Hand Bad Original | The number of bad parts in stock at this location that are awaiting a repair order. Separate stock from In Repair, for which a repair order is in progress. On Hand Bad Original is the value from the host system, and On Hand Bad is the rolled up value. | ||
On Hand Bad Requested On Hand Bad Requested Original | The number of bad parts in stock at this location that are awaiting a repair order. Separate stock from In Repair, for which a repair order is in progress. On Hand Bad Requested Original is the value from the host system, and On Hand Bad Requested is the rolled up value. | ||
On Hand Fixed On Hand Fixed Original | Client-driven value - usually means available stock that has previously been repaired (for the purposes of identifying stock that cannot legally be resold as new). On Hand Fixed Original is the value from the host system, and On Hand Fixed is the rolled up value. | ||
On Hand Good | Available good stock. | ||
On Hand New On Hand New Original | Available stock that can be legally sold as new. For some customers, this may include On Hand Fixed quantities. On Hand New Original is the value from the host system, and On Hand New is the rolled up value. | ||
On Order On Order Original | Client-driven value - usually means the quantity expected at the location of a given part from a supplier. On Order Original is the value from the host system, and On Order is the rolled up value. | ||
Procurement Requested Amount Procurement Requested Original | Client-driven value - usually means the quantity expected at the location of a given part from a supplier. On Order Original is the value from the host system, and On Order is the rolled up value. | ||
Repair Requested Amount Repair Requested Original | The quantity requested for repair. Repair Requested Original is the value from the host system, and Repair Requested Amount is the rolled up value. | ||
Replenishment Requested Amount Replenish Requested Original | The quantity requested for replenishment. Replenish Requested Original is the value from the host system, and Replenishment Requested Amount is the rolled up value. | ||
Rotable Safety Stock | Rotable Safety Stock. | ||
SKU Custom (1-10) | Custom fields for SKUs derived from the IPCS_SKU table. | ||
Stock Amount Type | a (added) = someone manually added using Servigistics s (synch) = the record was added during the Synchronize Database AutoPilot process | ||
Stock Level Custom (1-5) | Custom fields for levels derived from the IPCS_STOCK_LEVEL table. | ||
Stock Level Custom (1-5) | Custom fields for levels derived from the IPCS_STOCK_LEVEL table. | ||
Stock Out Date | A phase-out date that identifies when you will no longer maintain the part in inventory. | ||
Total Inventory | The sum of the inventory values - On Good + On Hand Bad - Backorder - Allocated + On Order + In Repair + In Return |
Review Board
Journal