Data Analytics
Phase Duration Analysis
Average time spent in each work phase across all projects - helps identify which phase is the bottleneck.
| Phase | Average Days | Fastest (Days) | Slowest (Days) | Projects Analyzed |
|---|
Supplier Performance Trend
Average lead time per month for the selected supplier.
Spending Trend by Year
Total purchase amount compared across years.
Counts every purchase order that is not cancelled — including those with no Project No or no Purchase Order date.
Spending by Month
Total purchase amount for each month of the selected year (cancelled orders not counted).
Unusual Price Alerts
Parts priced significantly higher or lower than their usual average - worth double-checking for data entry errors.
| Project No | Part | Supplier | This Price | Average Price | Deviation |
|---|