QAD 2017 Enterprise Edition > User Guides > Lean Manufacturing > Using Kanban Workbenches > Workbench Data > Analyst Data
  
Analyst Data
Analyst data is designed to help planners make decisions by providing summary-level information about kanban loops. You can update the Average Inventory Calculation Method field to view the effects of changing the method; all other fields are display only.
The columns in the Analyst Data frame include standard identification data about each loop, including the item, step, source type, source, supermarket, and site. Analyst Data Fields describes the additional fields.

Analyst Data Fields
 
Field
Description
Actual Run Interval
The system bases this calculation on the value of Fixed Interval in the Sizing Data frame. When Fixed Interval is 0, the system divides Order Quantity (Revised) by Average Daily Demand and displays the result in Actual Run Interval. When Fixed Interval is greater than 0, the system compares Order Quantity (Revised) with Fixed Interval multiplied by Average Daily Demand and determines the value of Actual Run Interval as follows:
• When Order Quantity (Revised) is greater, divide Order Quantity (Revised) by (Fixed Interval * Daily Demand) and round up to the next whole number. Multiply by Fixed Interval and display result in Actual Run Interval.
• When (Fixed Interval * Daily Demand) is greater, display Fixed Interval in Actual Run Interval.
The system displays Actual Run Interval based on the EPEI display option for the process.
Cost Allocation Percent
The system displays the percentage of the overall item cost allocated to this loop in Kanban Item Master Maintenance.
Kanban Item Cost
The system calculates this value by multiplying the item master cost for the cost set specified in the Process Option Panel by Cost Allocation Percent. This field displays in the base currency, which is shown in the column heading.
Average Inventory Calculation Method
This is the method the system uses for calculating average inventory for a kanban loop. It defaults from Kanban Master Maintenance. If you change it to view the effects of a different calculation method and save your changes, the system updates the loop record. The following methods are available.
• Standard. Average inventory is calculated as follows:
If Order Quantity is greater than 0, then Average Inventory = (Order Quantity * 0.5) + (Average Daily Demand * FIFO Time) + Safety Stock + Container Size Safety Stock
If Order Quantity is 0, then Average Inventory = ((Fixed Interval Time * Average Daily Demand) * 0.5) + (Average Daily Demand * FIFO Time) + Safety Stock + Container Size Safety Stock
If Order Quantity and Fixed Interval are both 0, then Average Inventory = (Kanban Quantity * 0.5) + (Average Daily Demand * FIFO Time) + Safety Stock + Container Size Safety Stock
• Mfg1. Average inventory is calculated as follows:
1/4 * (3 * Order Quantity Revised + Average Daily Demand * Run Time in Days) + Total Safety Stock Units + ((FIFO Time in Days * Average Daily Demand) rounded up to the kanban quantity) + Container Size Safety Stock
In this calculation, Run Time in Days = (Loop Order Quantity Revised * Cycle Time) / Process Time in a Day + (Item Setup Time / Process Time in a Day)
Note: Method Mfg1 is designed for loops that have Source Type set to Process.
Average Inventory Units
The system displays the average inventory level based on the specified calculation method, including the unit of measure from Item Master Maintenance.
Average Days of Supply
The system calculates the number of days of demand that can be met out of inventory by dividing Average Inventory Units by the value of Daily Demand (Revised) from the sizing data frame.
Average Inventory Value
The system calculates the base-currency value of the average inventory quantity by multiplying Average Inventory Units by Kanban Item Cost.
FIFO Stock
The system calculates the average amount of inventory that is in production at a first-in, first-out (FIFO) process:
FiFO Stock = FIFO Time In Days * Daily Demand
where:
FIFO Time in Days = (External FIFO/day) + (Internal FIFO / Internal Hours Per Day [using Available Time Per Day when source type is Process]
Run Time Days
The system calculates this value as follows:
Run Time Days = (Revised Order Quantity * Revised Cycle Time) / Revised Total Time Available Per Day + (Revised Setup Time / Revised Total Time Available Per Day)
This field is relevant only to loops supplied by a process. It is set to 0 for other source types.
Total Safety Stock plus Safety Time
The system displays the safety stock for the item from the Sizing Data frame.
Container Size Safety Stock
The system displays the amount of safety stock that results from the container size. For example, sizing calculations that round up to a container size may result in additional inventory that should be considered safety stock. This field is calculated using values from the sizing data frame:
Container Size Safety Stock = Order Point (Revised) – Order Point (Preliminary)
Safety Factor Percent
• For process loops on Kanban Sizing Workbench:
Safety Factor Percent = ((Total Safety Stock Plus Safety Time + Container Size Safety Stock) / (Daily Demand (Revised) * max ((Fixed Interval Time/ Standard Hours per Day), EPE Interval in days or 1))) * 100
• For process loops on Kanban Process Workbench:
Safety Factor Percent = ((Total Safety Stock Plus Safety Time + Container Size Safety Stock) / (EPE Interval * Daily Demand (Revised)) + (1 - Current Load Percent) / Current Load Percent) * 100
• For supplier and inventory loops on both workbenches:
Safety Factor Percent = ((Total Safety Stock Plus Safety Time + Container Size Safety Stock) / (Daily Demand (Revised) * max ((Fixed Interval Time/ Standard Hours per Day), 1))) * 100
Total Safety Stock Value
The system calculates the base-currency value of the safety stock by adding Total Safety Stock Plus Safety Time to Container Size Safety Stock and multiplying the result by Kanban Item Cost.
Total Cycle Time/Day (theoretical)
For loops with a source type of Process, the system displays the result of multiplying Daily Demand (Revised) by Cycle Time (Revised).
For other source types, this field is 0.
Setup Time Per Standard EPEI
For loops with a source type of Process, the system displays the result of dividing EPEI (Revised) for the process by the actual Run Interval.
For other source types, this field is 0.
Setup Time Per Day
For loops with a source type of Process, the system displays the result of dividing Setup Time Per Standard EPEI by EPEI (Revised) for the process, then multiplying by Total Time Available Per Day (Revised). Both EPEI-related values are converted to days before this calculation.
For other source types, this field is 0.
Load Percent
The system displays the load percentage of total available time represented by the individual process item. It uses the following calculation:
Item Total Cycle Time/Day (Theoretical) + Item Setup Time Per Day / Total Cycle Time/Day (Theoretical) for all process items + Setup Time Per Day for all process items