KPI option

Module Structure

Command execution authority


Overview

KPI option calculates KPI (Key Performance Indicators) based on the scheduling results. As a tool for preparing long-term business plans, greater implementation returns can be achieved than is possible with traditional production schedulers.


Characteristics

Based on the scheduling results, KPI option calculates period KPI, order KPI, operation KPI, resource KPI and item KPI.
The value of KPI will be calculated as the "Evaluate KPI" command is executed.

Settings

In order to calculate KPI, the following properties need to be specified.

Factory calendar resource

Specify the resource for which the working time is calculated to the "Factory calendar resource" in the "Settings" tab of the project settings.

KPI calculation start time

Specify the time to start KPI calculation to the "KPI calculation start time" in the "KPI" tab of the "Evaluate KPI" command. The scheduling basis time is set by default.

KPI calculation time span

Specify the time period for which KPI is calculated to the "KPI calculation time span" in the "KPI" tab of the "Evaluate KPI" command. "30d" is set by default.

Item type

Specify the "Item type" of the item. Select what is appropriate from: finished item; manufactured part; intermediate item; purchased part.

Unit price of item

Specify the "Unit price" of the item.

Outsourcing price of item

Specify the "Outsourcing price" of the item. This will be used to calculate the outsourcing cost.

Cost type of resource

Specify the "Cost type" of the resource. "Hourly cost" will be used to calculate the labor cost; "Outsourcing price" will be used to calculate the outsourcing cost.

Hourly cost of resource

Specify the "Hourly cost" of the resource. This will be used to calculate the labor cost.


KPI evaluation steps

The following calculation steps are standard KPI features.

Period KPI

Calculate the earnings, costs, inventory quantities and inventory values for a specified period.
They can be confirmed in the KPI evaluation result table, which is displayed from the menu [Table View] - [Evaluation Result] - [KPI].

EarningsTotal monetary value of sales orders with due dates within the specified period.
Material costTotal monetary value of purchase orders with due dates within the specified period.
Outsourcing costTotal outsourcing cost for operations during the specified period.
Labor costTotal labor cost for operations during the specified period.
Total costMaterial cost + outsourcing cost + labor cost
ProfitEarnings - total cost
Profit ratioProfit / Earnings
Sales order due date achievementThe due date achievement rate for sales orders assigned within the specified period.
Purchase order due date achievementThe due date achievement rate for purchase orders assigned within the specified period.
Finished item inventoryTotal monetary value of finished item inventory for the calculation start time of the specified period. * Item type: "finished item" or "intermediate item."
Parts inventoryTotal monetary value of parts inventory for the calculation start time of the specified period. * Item type: "manufactured part" only.
Purchased item inventoryTotal monetary value of purchased item inventory for the calculation start time of the specified period. * Item type: "purchased item" only.
Total inventoryFinished item inventory + parts inventory + purchased item inventory
Finished item inventory qtyTotal quantity of finished item inventory for the calculation start time of the specified period. * Intermediate item will also be added.
Parts inventory qtyTotal quantity of parts inventory for the calculation start time of the specified period. * Item type: "manufactured part" only.
Purchased item inventory qtyTotal quantity of purchased item inventory for the calculation start time of the specified period. * Item type: "purchased item" only.
Total inventory qtyFinished item inventory qty + parts inventory qty + purchased item qty
ROAProfit / Total inventory

Order KPI

KPI by order.

Cumulative material costTotal cumulative material cost for operations in the final process.
Cumulative outsourcing costTotal cumulative outsourcing cost for operations in the final process.
Cumulative labor costTotal cumulative labor cost for operations in the final process.
Cumulative total costCumulative material cost + cumulative outsourcing cost + cumulative labor cost
EarningsQuantity of sales order * unit price of item
ProfitEarnings - cumulative total cost
Profit ratioProfit / earnings

Operation KPI

KPI by operation.

Material costQuantity of purchase order * unit price of item
Outsourcing costNumber of operations * outsourcing price of item * Cost type of resource: "outsourcing price" only
Labor costTotal production hours * hourly cost of resource
Total costMaterial cost + outsourcing cost + labor cost
Cumulative material costCumulative material cost of previous process + material cost
Cumulative outsourcing costCumulative outsourcing cost of previous process + outsourcing cost
Cumulative labor costCumulative labor cost of previous process + labor cost
Cumulative total costCumulative material cost + cumulative outsourcing cost + cumulative labor cost

Resource KPI

KPI by resource.

Outsourcing costNumber of operations within the specified period * total outsourcing price of item * Cost type of resource: "outsourcing price" only.
Labor costTotal production time for operations within the specified period * total hourly cost of resource * Cost type of resource: "hourly cost" only.
Setup timeTotal setup time within the specified period.
Production timeTotal production time within the specified period.
Teardown timeTotal teardown time within the specified period.
Working timeTotal working time within the specified period.
Load (including setup)(Setup time + production time + teardown time) / working time
Load (excluding setup)Production time / working time

Item KPI

KPI by item.

Inventory qtyThe quantity of inventory for the calculation start time of the specified period.
Inventory valueInventory qty * unit price
Consumption qtyTotal quantity of consumption within the specified period. * Excluding sales orders and purchase orders.
Consumption valueConsumption qty * unit price
Production qtyTotal quantity of production within the specified period. * Excluding sales orders and purchase orders.
Production valueProduction qty * unit price
Daily demand qtyConsumption qty / working days of factory calendar resource
Inventory turnover daysInventory qty / daily demand qty
EarningsQuantity of sales order within the specified period * unit price * Only when the corresponding item is the sales order item.
Material costQuantity of purchase order within the specified period * unit price * Only when the corresponding item is the purchase order item.

Relations among KPI evaluation steps

KPI expressions specified for the "Evaluate KPI" command are supposed to work in order from the top. There are cases in which the result of an expression specified at top will be used by a subsequent KPI expression; thus, the order of specified expressions has a significant meaning.
The relations among KPI evaluation steps set by default are shown below (referred to according to the arrow's direction.):

Item KPI and resource KPI


Operation KPI, order KPI and period KPI


Labor cost of operation stretched by time wise load leveling

The time wise load leveling command stretches operations according to their load. However, performing KPI calculation in the stretched state will result in a larger labor cost for operations. Therefore, KPI expressions use the expansion rate of operations to obtain correct calculation results.

ME.LaborCost=Sum(ME.ProductionTask.UseInstruction,(TARGET.TotalUseTime/TARGET.'Order/Operation/Task'.ExpansionRate)*TARGET.Resource.HourlyCost/1h)

However, the operation's expansion rate will be reset by executing the following commands:

Adjustment
Assign MRP
Assign / peg orders
Assign manufacturing orders
Assign purchase orders
Assign sales orders
Assign privileged operations
Assign time fixed operations
Sequence control

Therefore, when calculating KPI of operations stretched by the time wise load leveling command, make sure to enter the "Evaluate KPI" command immediately after the time wise load leveling command.



HelpNo.:3160
© 2016 Asprova Corporation, All rights reserved.