computeABCXYZAnalysis {matman}

Performs an ABC/XYZ analysis

Description

Divides a given data frame into 3 classes, A, B, C, according to the value of one column (e.g., revenue).

Usage

computeABCXYZAnalysis(
  data,
  value,
  item,
  timestamp,
  temporalAggregation = c("day", "week", "month", "quarter", "year"),
  AB = 80,
  BC = 95,
  XY = NA,
  YZ = NA,
  ignoreZeros = FALSE
)

Arguments

data

Data frame or matrix on which the ABC analysis is performed.

value

Name of the column variable that contains the value for the ABCXYZ analysis.

item

Names of the columns including the item names or identifiers (e.g., product name, EAN).

timestamp

Name of the column including the timestamp. This column should be in POSIX or date-format.

temporalAggregation

Temporal aggregation for the XYZ-analysis (i.e., "day", "week", "month", "quarter", "year").

AB

Threshold (in percent) between category A and B.

BC

Threshold (in percent) between category B and C.

XY

Threshold (in percent) between category X and Y.

YZ

Threshold (in percent) between category Y and Z.

ignoreZeros

Whether zero values should be ignored in XYZ-analysis.

Value

Returns an ABCXYZData object. Only positive values are displayed

Author(s)

Leon Binder [e-mail]

Bernhard Bauer [e-mail]

Michael Scholz [e-mail]

See Also

ABCXYZData summary

Examples

# ABC Analysis
data("Amount")
abcResult = computeABCXYZAnalysis(data = Amount,
    value = "value",
    item = "item",
    timestamp = "date")

# ABC/XYZ Analysis
data("Amount")
abcxyzResult = computeABCXYZAnalysis(data = Amount,
    value = "value",
    item = "item",
    timestamp = "date",
    temporalAggregation = "week",
    XY = 0.3, YZ = 0.5)