Icon

ABC_​Analysis_​Coefficient_​of_​Variability_​Approach

This workflow implements ABC analysis by factoring in the demand uncertainty. The uncertainty measure used here is called the coefficient of variation (CV). Through CV, items can now be classified not only with respect to Pareto’s principle but also with respect to demand.

Read Sales DataCompute Meanand SDCompute Coefficient ofVariability (CV)Split into Class X, Yand Z based onCV threshholdSum up number of iems sold in the yearNormalize for a smoothsummationSplit items in categoryA, B, CSort total salesTotal SalesRunning sumPivot with item countAggregate on total salesthrough each categoryExcel Reader Column Aggregator Math Formula Rule Engine Column Aggregator Math Formula Rule Engine Sorter Math Formula Moving Aggregation Joiner Pivoting Pivoting Read Sales DataCompute Meanand SDCompute Coefficient ofVariability (CV)Split into Class X, Yand Z based onCV threshholdSum up number of iems sold in the yearNormalize for a smoothsummationSplit items in categoryA, B, CSort total salesTotal SalesRunning sumPivot with item countAggregate on total salesthrough each categoryExcel Reader Column Aggregator Math Formula Rule Engine Column Aggregator Math Formula Rule Engine Sorter Math Formula Moving Aggregation Joiner Pivoting Pivoting

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Ali.Marvi
Created at: 2023-01-03
On NodePit since: 2023-12-19
Last update: 2024-05-01
Created with KNIME version: v4.7.1
Tags: abcabcanalysissupplychaininventoryoptimization

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!