Material Cost Behavior & Supplier Performance Analysis

📦 Item Description & Number

Unique identifier for the item. Used to track and analyze inventory at the item level.

📊 Coefficient of Variation

Measures the relative variability of the unit price over time.
Formula: (Std Dev / Mean) × 100

📈 Trend Indicator

Indicates cost trends comparing the last price to the mean price.
Formula: ((Last Price - Mean Price) / Mean Price) × 100

💰 Average Yearly Cost

The average annual total cost of the item across all years in the dataset.

🛒 Purchase Order Count

Total number of purchase orders for the item, tracking purchasing frequency.