2 Replies Latest reply on Jul 29, 2010 3:11 PM by Chris Uriarte

    Sourcing "non-defined" items via Ariba RFP.

    Krishna Newbie

      Hello -

       

      In our MRO category, we use about 1200 different items. All these 1200 items fall into about 50 categories. Some examples of those 1200 items are: hammer size 1, hammer size 2, hammer size 3.....hammer size 50; screw-driver size 1, screw-driver size 2, screw-driver size 3.....screw-driver size 50; scissors size 1, scissors size 2 etc [please note these examples are for illustration only....there is not intention to mean: size 1 < size 2 < size 3 etc]....Some examples of the categories are "hammer-category", "screw-driver category", "scissors category" etc.

       

      Now, using this RFP, we would like to go for item consolidation and also seek pricing info.....by which we mean....all of the 50 different types of hammers we use, *may* be replaced by 5 different types of hammers (or) 10 diff types of hammers (or) 15 diff types of hammers [we do not know how many].  The idea is - there might be "n" different types of hammers that does all the functionality(s) that is currently being performed by "m" different types of hammers.

       

      We would like each of our suppliers to review all of our items under each category and then come-up (for each category), with a list of their "n" items that can replace all/some of our items in that category.

       

      So, you see, we do not have a "defined" item to seek pricing info for. We would like the suppliers to tell us their item, which all items (in the MRO-list) it replaces, and the item price.

       

      An additional complexity:

      Supplier1 may have "n" different types of hammers that does all the functionality(s) that is currently being performed by "m" different types of hammers.

      Supplier2 may have "x" different types of hammers that does all the functionality(s) that is currently being performed by "m" different types of hammers.

      Supplier3 may have "y" different types of hammers that does all the functionality(s) that is currently being performed by "m" different types of hammers.

       

      Is it possible to build such an RFP in Ariba? I mean, without asking the suppliers to key-in their item-info in an excel and asking that excel be uploaded?

       

      Thanks.

        • Re: Sourcing "non-defined" items via Ariba RFP.
          David Morel Master
          You mention that this could be done in Excel, then I would suggest using the new feature coming in 10s2, Offline Custom Response Sheet.  This allows you to make your own version of the offline bidsheet.  You create what ever you want in Excel, and then map fields to the standard offline bidsheet included.  When the supplier responds to the event, they download the sheet, fill in your values, those values or a formula result maps to the the items/lots/questions you created in Ariba.  A little hard to describe in this response, but you can access the Early Access demo's available on Connect.
          • Re: Sourcing "non-defined" items via Ariba RFP.
            Chris Uriarte Novice

            I most recently did this with our lighting MRO program .

            My suggestion is to narrow down the field prior to doing a RFX.

            The best way to do this is work with your current supplier(s) to determine what would work best in consolidating your items.

            After you have done this, use the list of consolidated items to execute your RFP/Reverse Auction.

            In the event, allow your participants to quote comparable items.

             

            Good luck!