Purchasing

This Tableau Accelerator allows you to:

• Automatically determine savings (by measuring the difference between the current purchase price and the average purchase price computed over the previous 12 months. This difference is then multiplied by the current quantity purchased)
• Minimise risks
  • Highlight items with high purchasing volume and high price volatility
  • Pinpoint single supplier dependencies
• Identify new savings opportunities
  • For certain items, consolidate purchasing contracts with fewer suppliers
    • Negotiate better purchasing conditions
    • Reduce administrative workload
  • Highlight items for which the Unit Purchasing Price increased while the Purchasing Volume also increased
• Identify best suppliers
  • For each item, identify the best suppliers to work with

Demo video

Answer key business questions

• What is our purchasing volume?
• How do we make savings?
• What are our top purchasing categories?
• What are our top purchased products? Did we purchase them at the right price?
• For which products do we have a single supplier dependency?
• For which products do we have too many suppliers and potentially savings opportunities?
• How many suppliers do we work with?

Monitor and improve KPIs

• Purchasing Volume: Total purchased volume over the period (expressed in currency)
• Total Purchase Quantity: Total purchased quantity, in units, over the period
• Average Buying Price: Average price at which items were bought (expressed in currency)
• Savings / Losses: Estimate the additional cost or reduction in cost of purchasing an item by comparing it to the average cost of purchasing that same item over the previous 12 months
• Price Volatility: Determines how much and how quickly purchase prices move over time
• Suppliers: Total number of active suppliers over the period

Required attributes

• PO Number (string): Purchase unique identifier
• PO Date (date): Purchase date
• Supplier (string): Supplier, Vendor...
• Purchasing Category (string): Type of goods purchases
• Buyer (string): Internal person or organisation responsible for the purchase
• Item (string): Product or service purchases
• UOM (string): Unit of measure of the purchased item
• PO Quantity (numeric): Number of units of item purchased
• PO Amount (numeric): Amount of the purchase