Use BidMatrix to manage and organize "Big Data"

Situation

  • A global service provider needed to select qualified suppliers for the delivery of Work wear and PPE to several entities in Europe
  • Multiple data needed to be gathered from supplier points across a large number of product lines 
  • Data needed to be collected, organized and analyzed in one place in order to make good sourcing decisions 
  • Customized calculations were needed to improve evaluation, conduct baseline comparisons, and finally select suppliers

Solution

  • The BidMatrix functionality in Scanmarket’s eRFx module was used 
  • Event created in MS Excel including all relevant calculations, saving buying team significant effort
  • Predefined templates ensured a structured process
  • Excel bidding was enabled for suppliers to ensure a smooth bidding process 
  • Project team could easily share data via the event

Result

  • The BidMatrix event collected >3000 data points with write, read-only and hidden columns
  • Output included both online and Excel files with:
    • Predefined baseline calculations
    • Database format ready for pivot table analysis
  • Easy side-by-side comparisons of responses and bids
  • Integrated messaging functionality allowed easy communication with suppliers, handling Q&A

 

Over 3,000 data points collected, organized and analyzed in a single, online view!