Contract Management
by Tableau
Description
This Tableau Accelerator allows you to:
- Asset & Monitor your Spend under Management
- Maximise costs savings (Cost Reduction & Cost Avoidance)
- Identify the contracts presenting the highest level of risk
- Identify the performance of your buyers and pinpoint development opportunities
- Better plan your resource allocation based on contracts to be renewed in the coming months
- Assess your allocation of spend by supplier
Answer key business questions
- Which volume of activity do we manage?
- What is our exposure to risks?
- How many suppliers and contracts do we manage?
- Which contracts are currently active?
- Who are our top suppliers
- How do our buyers perform?
Monitor and improve KPIs
Spend Under Management
- Spend Under Management: Total value of contracts under management (expressed in currency)
Savings
- Total Cost Savings: Total cost avoidance and cost reduction for all contracts (expressed in currency)
- Cost Savings %: Share of costs savings on total volume managed (expressed in %)
- Total Cost Avoidance: Any cost the organisation should have paid without negotiation (resisting a supplier’s price increase, purchase price that is lower than the original quoted price, value of additional services at no cost, long-term contracts with price-protection provisions) (expressed in currency)
- Cost Avoidance %: Share of costs avoided on total volume managed (expressed in %)
- Total Cost Reduction: Tangible bottom line reductions (i.e. contract renewal cost decrease) (expressed in currency)
- Cost Reduction %: Share of costs reduction on total volume managed (expressed in %)
Risks
- Risk Exposure: Share of contract volume at risk (only for contracts when the risk level is evaluated)
- Contract Risk Index: Average level of risk assessed for the contract
- Contract Risk Amount: Share of contracts amount which are evaluated to be at risk (expressed in currency)
Negotiation
- First to Last Offer %: Average percentage of price difference between the first offer and the negotiated price (expressed in percentage)
- Total Spend under Management (Before Negotiation): Total value of contracts under management before application of the cost reduction (expressed in currency)
Contracts
- Contracts Under Management: Number of ongoing/active contracts
- Avg Contract Size: Average contract amount (expressed in currency)
- Contract Duration: Average duration of the contracts under management (expressed in years)
Suppliers
- Suppliers Under Management: Number of suppliers having an active contract
New Contracts
- New Contracts Amount: Total value of contracts that started over the period (expressed in currency)
- New Contracts: Number of contracts starting over the period
- Cost Savings % (new contracts): Share of costs savings on total volume managed, only for contracts starting over the period (expressed in %)
- Total Cost Savings (new contracts): Total cost avoidance and cost reduction for contracts that started over the period (expressed in currency)
Required attributes
- Contract # (string): Contract unique identifier
- Supplier (string): Supplier name
- Contract Type (string): Type of contract
- Organisation (string): Internal organisation benefiting of the contract
- Contract Owner (string): Budget owner
- Buyer (string): Buyer, Purchaser...
- Contract Start Date (date): Contract Start Date
- Contract End Date (date): Contract End Date
- Contract Amount (numeric): Contract value
- First Offer (numeric): Contract first offer proposed by the supplier
- Cost Reduction (numeric): Contract cost reduction
- Cost Avoidance (numeric): Contract cost avoidance
- Risk % (numeric): Contract risk level: 0.5 for 50% (100% is the highest level of risk)