Price/Spend Analysis

[Texas Tech University]

Summarize how your institution handles price/spend analysis for your contracted vendors.

[krist...@gmail.com]

Iowa State University

ISU’s Response: Iowa State University queries contract volume and item spend detail, particularly from its e-procurement (e-pro) system to determine major contract spend and develop strategies for strategically sourcing major contract commodities. It also uses data from both the purchase order (P.O.) and procurement card (p-card) systems to identify trends and develop new contract opportunities. We query the three systems (P.O., p-card and e-pro), looking at vendors by dollar volume, transaction volume, invoice volume, product category spend, total vendor spend, and spend by purchasing transaction type. We can then drill down to item detail if needed to create item categories and core lists to include in bid packages. When needed we compare this information to vendor reports on similar data.

As part of its contract management approach, ISU also performs price analysis by auditing its e-procurement vendors on a regular basis, pulling a sampling of items purchased and checking for list price, contract discount and contract price. The pricing is then compared with the price shown in the e-pro catalog and the price charged on recent orders. This technique is used to make sure the vendor is in compliance with the contracted price. When material discrepancies have been found we have required the vendor to conduct a full blown audit of all contract sales to ISU and provide supporting data of list price and discounts taken.

[Katrina Yoakum]

University of Kansas:

The University of Kansas Strategic Data Analysts utilize EAB Spend Compass Tool plus history from PeopleSoft and SciQuest to analyze university spend.

 

Resource Contact:

Rick Beattie, Director of Procurement, rbea...@ku.edu

[fwillbrant]

Kansas State University Response:

K-State does not have any formal processes for analyzing our prices or spending patterns.  

-Contract pricing is the responsibility of the paying end-users.  Purchasing will manually spot audit payments as they come through the system.

-As for spend analysis, Purchasing will pull vendor reports to see how much money is spent with a specific vendor, but are unable to determine similar items across multiple vendors.  There is no detail in our databases.  

[kathy.kam...@gmail.com]

Oklahoma State University

We run monthly reports on the contract enabled suppliers in SciQuest. The reports include number of transactions, number of PO lines, and amount for each campus (OSU and the A&M Colleges).. In addition, for the same supplier set, data is run for non-catalog purchases and pcard purchases. Totals are calculated, percentage of spend (punch-out, non-catalog, pcard), year to date spend, projected 12 month spend. This information is compared to the prior fiscal year spend.
We use this information when reviewing these contracts with the suppliers and for negotiating terms.

I’m not exactly sure what they were looking for, but we can send a copy of the spreadsheet.