Finance AI Skill

Procurement

Manage procurement operations including purchase requisition, vendor selection, RFP/RFQ processes, contract management, spend analysis, maverick spend prevention, and category management. Use when creating purchase orders, running RFPs, managing vendor cont...

Procurement & Vendor Management

Optimize procurement operations, control spending, and build strategic supplier relationships.

Procurement Process

Purchase Requisition to Purchase Order

PROCUREMENT WORKFLOW — Standard Process
════════════════════════════════════════

Step 1: Purchase Requisition (PR)
  Trigger: Department identifies need for goods/services
  Required fields:
    - Item description, quantity, specifications
    - Estimated cost and budget code
    - Required delivery date
    - Business justification
    - Preferred vendor (if applicable)
  
  PR Approval Matrix:
    ┌──────────────────┬──────────────┬────────────────────┐
    │ PR Amount        │ Approver     │ Additional Review  │
    ├──────────────────┼──────────────┼────────────────────┤
    │ <$2,500          │ Dept Manager │ None               │
    │ $2,500-$10,000   │ Dept Manager │ Procurement        │
    │ $10,000-$50,000  │ VP/Director  │ Procurement + Fin. │
    │ $50,000-$100K    │ CFO          │ Procurement + Fin. │
    │ >$100,000        │ CEO + CFO    │ Full procurement   │
    │                  │              │ process + RFP      │
    └──────────────────┴──────────────┴────────────────────┘

Step 2: Sourcing
  Low-value (<$10K): Direct purchase from approved vendor catalog
  Medium-value ($10K-$100K): Request quotes (3 vendors minimum)
  High-value (>$100K): Formal RFP/RFQ process
  Recurring/strategic: Category management + contract negotiation

Step 3: Purchase Order (PO) Creation
  - Generated from approved PR
  - Includes: vendor details, line items, pricing, delivery terms, PO number
  - Matches to approved budget
  - Sent to vendor (electronically or via portal)
  - PO number required on all invoices for 3-way match

Step 4: Goods/Service Receipt
  - Warehouse/department confirms receipt
  - Quality check (for goods)
  - Service acceptance confirmation
  - Discrepancy reporting (short shipment, damage, wrong item)

Step 5: Invoice Processing & Payment
  - Invoice matched to PO and receipt (3-way match)
  - Approval per approval matrix
  - Payment per vendor terms
  - Closed loop — PO fulfilled

RFP/RFQ Process

RFP PROCESS — High-Value Purchases (>$100K)
════════════════════════════════════════════

PHASE 1: PLANNING
  - Define requirements (functional, technical, commercial)
  - Establish evaluation criteria and weighting
  - Identify potential suppliers (market research)
  - Form evaluation team (cross-functional)
  - Set timeline

PHASE 2: RFP PREPARATION
  RFP Contents:
    1. Executive summary and background
    2. Scope of work / requirements
    3. Evaluation criteria and weighting
    4. Submission instructions and timeline
    5. Terms and conditions
    6. Pricing template
    7. Reference material and contacts
  
  Distribution:
    - 5-8 qualified suppliers (competitive market)
    - 2-3 suppliers (limited market, with justification)
    - NDA required before sharing confidential information
    - Response period: 3-4 weeks

PHASE 3: EVALUATION
  Evaluation Scorecard:
    ┌────────────────────────┬──────────┬────────────┐
    │ Criteria               │ Weight   │ Score (1-5)│
    ├────────────────────────┼──────────┼────────────┤
    │ Technical capability   │ 25%      │            │
    │ Pricing / TCO          │ 25%      │            │
    │ References / reputation│ 15%      │            │
    │ Implementation plan    │ 15%      │            │
    │ Support / SLA          │ 10%      │            │
    │ Financial stability    │ 5%       │            │
    │ Innovation / roadmap   │ 5%       │            │
    │ ─────────────────────  │ ──────── │ ────────── │
    │ TOTAL                  │ 100%     │ Weighted   │
    └────────────────────────┴──────────┴────────────┘

  Evaluation process:
    - Independent scoring by team members
    - Consolidated scores and ranking
    - Reference checks for top 2-3 vendors
    - Site visits / demos for top candidates

PHASE 4: NEGOTIATION & SELECTION
  - Negotiation with top-ranked vendor (and 2nd for leverage)
  - Terms, pricing, SLA, contract structure
  - Best and final offer (BAFO)
  - Selection recommendation to steering committee
  - Award notification

PHASE 5: CONTRACT & ONBOARDING
  - Contract execution (standard template or vendor template with review)
  - Vendor onboarding (AP setup, compliance documentation)
  - Implementation kickoff
  - Performance baseline established

Spend Analysis

Category Spend Management

SPEND ANALYSIS — FY2024
════════════════════════

TOTAL ANNUAL SPEND: $18.4M

SPEND BY CATEGORY:
  ┌─────────────────────────┬──────────┬──────────┬────────────────────┐
  │ Category                │ Amount   │ % Total  │ Trend (YoY)       │
  ├─────────────────────────┼──────────┼──────────┼────────────────────┤
  │ Technology/Software     │ $4.8M    │ 26.1%    │ ↑ 18%             │
  │ Professional Services   │ $3.2M    │ 17.4%    │ ↑ 12%             │
  │ Travel & Accommodation  │ $2.1M    │ 11.4%    │ ↓ 8%              │
  │ Marketing/Advertising   │ $1.9M    │ 10.3%    │ ↑ 22%             │
  │ Office/Facilities       │ $1.5M    │ 8.2%     │ → flat            │
  │ Consulting/Advisory     │ $1.2M    │ 6.5%     │ ↓ 15%             │
  │ Hardware/Equipment      │ $0.9M    │ 4.9%     │ ↑ 5%              │
  │ Recruiting/Staffing     │ $0.8M    │ 4.4%     │ ↑ 25%             │
  │ Insurance               │ $0.5M    │ 2.7%     │ ↑ 3%              │
  │ Legal                   │ $0.4M    │ 2.2%     │ ↓ 10%             │
  │ Other                   │ $1.1M    │ 6.0%     │ ↓ 5%              │
  └─────────────────────────┴──────────┴──────────┴────────────────────┘

TOP 20 VENDORS (Concentration):
  Top 5 vendors: 38% of total spend
  Top 10 vendors: 54% of total spend
  Top 20 vendors: 67% of total spend
  Long tail (200+ vendors): 33% of total spend

SPEND UNDER MANAGEMENT:
  Contracted spend: 72% ($13.2M)
  PO-based spend: 15% ($2.8M)
  Uncatalogued/maverick: 13% ($2.4M)
  Target: Reduce maverick spend to <5% by end of 2025

SAVINGS OPPORTUNITIES:
  1. Cloud consolidation: $180K/year (consolidate 3 SaaS providers)
  2. Travel program: $120K/year (negotiated hotel rates)
  3. Professional services: $95K/year (panel vendor agreement)
  4. Insurance bundling: $65K/year (multi-policy discount)
  5. Recruiting agency: $45K/year (reduce dependency, direct hiring)
  Total estimated savings: $505K/year (2.7% of total spend)

Maverick Spend Prevention

MAVERICK SPEND MANAGEMENT:
══════════════════════════

Definition: Purchases made outside approved procurement channels
  (no PO, non-contracted vendor, bypassed approval workflow)

Current Maverick Spend: 13% ($2.4M of $18.4M)
Target: <5% by end of 2025

ROOT CAUSES:
  1. Emergency purchases (30% of maverick spend)
  2. Unaware of process (25%)
  3. Vendor not in catalog (20%)
  4. Process too slow (15%)
  5. Personal preference / existing relationship (10%)

PREVENTION STRATEGIES:
  Policy:
    - PO required for all purchases >$500
    - Exception process with manager + procurement approval
    - Quarterly maverick spend report to department heads
    - Incorporate procurement compliance into manager KPIs
  
  Process:
    - Streamlined PR-to-PO process (<24 hour turnaround)
    - Expanded approved vendor catalog (add 20 high-demand vendors)
    - Pre-approved "express purchase" cards for emergencies (with retroactive PR)
  
  Technology:
    - Procure-to-pay platform integration (Coupa/Workday)
    - Auto-block expense reimbursement without PO reference
    - Real-time maverick spend dashboard
    - Chatbot for quick purchases under $500
  
  Education:
    - Procurement process training for all managers (annual)
    - Quick reference guide (1-page summary)
    - Department-level compliance reporting

TRACKING:
  Monthly maverick spend report
  Department-level compliance scores
  Trend analysis (quarterly)
  Management review (quarterly)

Contract Management

Contract Lifecycle Management

CONTRACT MANAGEMENT FRAMEWORK:
══════════════════════════════

CONTRACT INVENTORY:
  Active contracts: 142
  Total contract value: $14.2M/year
  
  By category:
    Software/SaaS: 38 contracts ($4.8M/year)
    Professional services: 25 contracts ($2.4M/year)
    Facilities/office: 12 contracts ($1.5M/year)
    Vendor/supplier: 45 contracts ($3.8M/year)
    Employment/consultant: 15 contracts ($1.2M/year)
    Other: 7 contracts ($0.5M/year)

CONTRACT RENEWAL CALENDAR (next 90 days):
  ┌──────────────────┬────────────┬──────────┬─────────────┐
  │ Vendor           │ Expiration │ Value/Yr │ Action      │
  ├──────────────────┼────────────┼──────────┼─────────────┤
  │ CloudHost Inc    │ Feb 15     │ $320,000 │ Renewal     │
  │                  │            │          │ negotiation │
  ├──────────────────┼────────────┼──────────┼─────────────┤
  │ OfficeSpace Co   │ Mar 1      │ $180,000 │ Auto-renew  │
  │                  │            │          │ (12 months) │
  ├──────────────────┼────────────┼──────────┼─────────────┤
  │ LegalServ LLP    │ Mar 10     │ $95,000  │ Re-bid      │
  │                  │            │          │ (performance│
  │                  │            │          │ review)     │
  └──────────────────┴────────────┴──────────┴─────────────┘

CONTRACT TERMS — Standard Clauses:
  Pricing: Fixed fee / T&M / volume-based / index-linked
  Term: 1-3 years (with renewal options)
  SLA: Defined uptime, response times, penalties
  Termination: 30-90 day notice; cause/for-convenience
  Data: Ownership, security, return/destruction
  Liability: Cap at 1x annual contract value (standard)
  Insurance: Min. $2M general, $5M professional liability
  Subcontracting: Prior written consent required
  Audit rights: Annual audit of vendor compliance

CONTRACT RISK ASSESSMENT:
  High-risk contracts: 8 (>$500K/year or critical dependency)
  Auto-renewal risk: 12 contracts auto-renew within 90 days
  Single-source vendors: 5 (no viable alternative)
  Expiring insurance: 3 vendors (renewal due within 60 days)

Supplier Relationship Management

Supplier Performance Scorecard

SUPPLIER SCORECARD — Q4 2024
════════════════════════════

EVALUATION DIMENSIONS:
  Quality (30%): Defect rate, service level compliance, rework
  Delivery (25%): On-time delivery, lead time adherence
  Cost (20%): Pricing competitiveness, cost reduction initiatives
  Service (15%): Responsiveness, communication, issue resolution
  Innovation (10%): Process improvements, technology advancement

TOP VENDOR PERFORMANCE:
  ┌──────────────────┬────────┬────────┬────────┬────────┬────────┐
  │ Vendor           │ Quality│ Deliv. │ Cost   │ Service│ Overall│
  ├──────────────────┼────────┼────────┼────────┼────────┼────────┤
  │ CloudHost Inc    │ 95     │ 98     │ 88     │ 92     │ 93 A   │
  │ StaffAgency Pro  │ 88     │ 92     │ 75     │ 85     │ 85 B   │
  │ OfficeSupply Co  │ 98     │ 95     │ 92     │ 90     │ 94 A   │
  │ TravelCo Global  │ 90     │ 85     │ 80     │ 88     │ 86 B   │
  │ LegalServ LLP    │ 92     │ 95     │ 70     │ 78     │ 83 C   │
  └──────────────────┴────────┴────────┴────────┴────────┴────────┘

  Rating: A = 90-100 (Strategic Partner)
          B = 80-89 (Preferred)
          C = 70-79 (Acceptable — improvement plan)
          D = <70 (At Risk — review/replacement)

ACTION ITEMS:
  LegalServ LLP (Rating C):
    - Cost increase 15% above market benchmark
    - Response time declined (avg 48 hours vs. 24 target)
    - Action: Issue performance improvement notice; begin alternative search
  
  StaffAgency Pro (Rating B, trending down):
    - Quality score dropped from 92 to 88
    - New consultant onboarding issues
    - Action: Quarterly business review; discuss quality standards

VENDOR TIER STRUCTURE:
  Strategic (5 vendors): Quarterly business reviews, innovation partnership
  Preferred (15 vendors): Semi-annual reviews, preferred pricing
  Standard (60 vendors): Annual reviews, standard terms
  Transactional (62 vendors): As-needed, catalog pricing

Output

Procurement Dashboard View

PROCUREMENT DASHBOARD — Week of Jan 27, 2025
══════════════════════════════════════════════

Procurement Pipeline:
  Open PRs: 28 ($420K total)
  Active RFPs: 3 (Cloud migration, office space, recruiting)
  POs issued (MTD): 67 ($1.2M total)
  Average PO cycle time: 2.1 days

Spend Metrics:
  MTD spend: $1.2M (24% of monthly budget)
  YTD spend: $3.8M (32% of annual budget)
  Contracted spend: 74% (↑ 2% vs last quarter)
  Maverick spend: 11% (↓ 2% vs last quarter)
  Savings captured (YTD): $185K

Vendor Performance:
  Average scorecard: 87 (B rating)
  Vendors at risk: 2 (below 70 score)
  Contracts expiring (30 days): 3
  Contracts expiring (90 days): 8

Approval Queue:
  Pending PR approvals: 8
  Pending PO approvals: 3
  Overdue approvals: 1 (escalated)

Savings Tracking:
  YTD identified savings: $340K
  YTD realized savings: $185K
  Pipeline savings (negotiation): $120K
  Total annualized savings: $505K (2.7% of spend)

Key Actions:
  1. CloudHost renewal negotiation (due Feb 15)
  2. LegalServ replacement RFP (initiate Feb 1)
  3. Maverick spend reduction campaign (launch Feb 15)
  4. Vendor catalog expansion (add 15 vendors by Mar 1)

Integration Points

Edge Cases