Page 1: Procurement OverviewPurpose: Provides a high-level summary of procurement activities, trends, and financial scale.KPIs:Total Number of POsTotal Released Purchase Order Value (USD)Number of PO Breakdown (e.g., Agreement, Spot, Street Buying)Total Spend Breakdown (USD)Quarterly PO TrendsVisualizations:KPI Cards: Total Number of POs, Total Released PO Value.Pie Charts: Number of PO Breakdown, Total Spend Breakdown.Stacked Bar Chart: Quarterly PO Trends (segmented by procurement type).Page 2: Agreement ManagementPurpose: Focuses on tracking and analyzing agreements, including new contracts and materials.KPIs:Active Material (L/I)New Material Added (L/I)Agreement (L/I Previous Year)New Material Additions by YearNumber of AgreementsNumber of Agreements by MonthVisualizations:KPI Cards: Active Material (L/I), New Material Added (L/I).Bar Chart: New Material Additions by Year.Line Chart: Number of Agreements by Month.Table: Agreement (L/I Previous Year) for year-over-year comparison.Page 3: Agreement Status and Utilization (Updated)Purpose: Combines contract status and utilization metrics to ensure agreements are effectively managed and utilized.KPIs:Contract Status:Total Active ContractsTotal Expired ContractsTotal Expiring Soon Contracts (e.g., within 90 days)Utilization Metrics:Number of Agreements with ≥80% UtilizationNumber of Agreements with ≥90% UtilizationAgreement Target Value (USD)Visualizations:KPI Cards: Total Active Contracts, Total Expired Contracts, Total Expiring Soon Contracts, Agreements with ≥80% Utilization.Bar Chart: Utilization Distribution (grouped into buckets: 0–50%, 51–79%, ≥80%).Matrix: Agreement Target Value by Vendor and Contract Type.Table: Detailed Agreement Status (Contract ID, Vendor, Validity Dates, Status, Utilization Percentage).Page 4: Agreement Expiration and RenewalPurpose: Focuses on contracts nearing expiration or those already expired to ensure proactive renewals.KPIs:Agreements Expiring within Current YearAgreements Expiring within 90 DaysDeleted ContractsVisualizations:KPI Cards: Agreements Expiring within Current Year, Agreements Expiring within 90 Days.Bar Chart: Monthly trend of expiring agreements.Pie Chart: Deleted Contracts by reason or vendor.Table: Detailed breakdown of deleted contracts (Contract ID, Vendor, Target Value, Deletion Reason, Utilization).Page 5: Vendor ManagementPurpose: Tracks vendor engagement and contributions through active contracts.KPIs:Vendors with Active ContractsVisualizations:KPI Card: Total Vendors with Active Contracts.Bar Chart: Vendor Contributions (grouped by active contracts).Table: Vendor-Level Details (Vendor Name, Number of Contracts, Total Value).Page 6: Procurement Type AnalysisPurpose: Analyzes procurement methods and their utilization trends over time.KPIs:Procurement Type DistributionMonthly PO BreakdownVisualizations:KPI Card: Procurement Type Distribution.Stacked Bar Chart: Procurement Type Trends (segmented by Agreement, Spot, Street Buying).Table: Monthly PO Breakdown (PO ID, Vendor, Type, Value, Status).