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](https://youtu.be/8pw_9KiTkZA)

### 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

Purchasing

Reduce Costs, minimise risks and determine savings automatically

Supply Chain & Manufacturing

Desktop