Method of conducting online competitive price quoting events

• US 7,571,131 B1
• Filed: 03/21/2000
• Issued: 08/04/2009
• Est. Priority Date: 11/05/1999
• Status: Expired due to Fees

• Current Assignee: Ford Motor Company
• Original Assignee: Ford Motor Company
• Inventors: Gharajanloo, Rahmon, Toothman, Brian M., Lewis, Julie A., Molina, Roxana P.
• Primary Examiner(s): Kramer; James A.
• Assistant Examiner(s): Borlinghaus; Jason
• Application Number:
  US09/532,833
• Time in Patent Office: 3,423 Days
• Field of Search: 705 35- 45, 705 26- 27
• US Class Current: 705/37
• CPC Class Codes: G06Q 10/0833 Tracking
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 20/203 Inventory monitoring
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0609 Buyer or seller confidence or verification
• CPC Class Codes: G06Q 30/0621 Item configuration or customization
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing
• CPC Class Codes: G06Q 30/08 Auctions
• CPC Class Codes: G06Q 40/04 Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange

Abstract

A method of conducting an online competitive price quoting event for at least one commodity includes storing event, commodity data, supplier data, historical data, a default currency, and a preferred currency into the at least one data table. An event token, which grants access authorization to agents representing the plurality of suppliers, is assigned to the event and is provided to the suppliers. A bid entry screen is displayed to the agents. An actual bid from the agent is compared to the current winning bid and a current minimum bid. A minimum bid from the agent is compared to the current winning bid and a current minimum bid. A current winner and a current winning bid are then determined. The bid entry screen is updated with the current winning bid, and each entry is color coded to reflect the current status of the agent'"'"'s bids.

Claims

1. A method of conducting an online competitive price quoting event for at least one commodity, comprising:

storing event data associated with the event into at least one data table;

storing commodity data associated with the at least one commodity into the at least one data table;

storing supplier data associated with a plurality of suppliers who will participate in the event into the at least one data table;

storing historical data associated with past transactions related to the at least one commodity of the plurality of suppliers;

storing a default currency for the event into the at least one data table;

storing a preferred currency for each of the plurality of suppliers into the at least one data table;

assigning an event token to the event and providing the event token to the suppliers;

granting access authorization to agents representing the plurality of suppliers in response to receiving the event token for the event;

displaying a bid entry screen to the agents listing the at least one commodity as at least one entry, a current winning bid in the preferred currencies of the suppliers, a target price in the preferred currencies of the suppliers, status of the agents'"'"' bids, and entry fields for receiving an actual bid and a minimum bid;

comparing the actual bid to the current winning bid and a current minimum bid in response to receiving the actual bid from an agent, the actual bid representing the price at which the supplier is willing to sell the at least one commodity;

comparing the minimum bid to the current winning bid and the current minimum bid in response to receiving the minimum bid from the agent, the minimum bid representing the lowest price the supplier is willing to sell the at least one commodity;

determining a new current winning bid based at least in part on the comparisons of the actual bid and the minimum bid to the current winning bid and the current minimum bid;

updating the bid entry screen with the new current winning bid;

color coding the at least one entry on the bid entry screen to reflect the current status of the agent'"'"'s bids;

computing a total price representative of the winning bid for the at least one commodity;

comparing the total price for the at least one commodity with a historical total for a commodity comparable to the at least one commodity that the supplier of the winning bid supplied in one or more previous events; and

computing a difference between the total price and the historical total.

2. The method, as set forth in claim 1, further comprising generating a bid summary of a supplier including a part number of the at least one commodity, a lot number, a quantity, the target price, the actual bid submitted, the minimum bid submitted, a confirmation identifier, and a confirmation time.

3. The method, as set forth in claim 1, further comprising:

granting access authorization to an event administrator in response to receiving the event token for the event;

generating a savings summary of the event including names of suppliers who has a winning bid for a commodity, a historical value for each supplier representing past sales figures for the commodity, a bid value representing the sales figure for the commodity in the current event, and a change value representing the difference between the historical value and the bid value.

4. The method, as set forth in claim 1, further comprising:

granting access authorization to an event administrator in response to receiving the event token for the event;

generating a savings summary of the event including;

names of suppliers who have a winning bid for the at least one commodity;

a historical value for each supplier representing past sales figures for the commodity;

a bid value representing the sales figure for the commodity in the current event;

an adjusted baseline value representing the historical value being adjusted for parts that the suppliers are not invited to bid, new parts without historical value, and parts with historical value that the suppliers have not bid on; and

a change value representing the difference between the historical value and the bid value.

5. The method, as set forth in claim 1, further comprising:

granting access authorization to an event administrator in response to receiving the event token for the event;

generating a detailed event summary of the event, wherein each entry includes;

a bid identifier;

a part number of the at least one commodity;

a quantity;

a supplier identifier of the supplier with the winning bid;

an actual bid;

a minimum bid indicator if a minimum bid was submitted;

a timestamp of the bid; and

a user identifier of the agent who submitted the winning bid.

6. The method, as set forth in claim 1, wherein comparing the actual bid comprises:

comparing the actual bid to a predetermined percentage of the current winning bid;

comparing the actual bid to a predetermined percentage of a target price; and

disallowing the entry of the actual bid in response to the actual bid being less than the predetermined percentage of the current winning bid, or the actual bid being less than the predetermined percentage of the target price.

7. The method, as set forth in claim 1, wherein comparing the actual bid comprises:

comparing the actual bid with a minimum bid of the current winner;

setting the actual bid as the current winning bid in response to the actual bid being less than the minimum bid of the current winner.

8. The method, as set forth in claim 1, wherein comparing the actual bid comprises:

comparing the actual bid with a minimum bid of the current winner;

setting the actual bid minus a predetermined delta value as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner; and

setting the supplier who submitted the actual bid as the current winner.

9. The method, as set forth in claim 1, wherein comparing the actual bid comprises:

comparing the actual bid with a minimum bid of the current winner;

setting the minimum bid of the current winner as the current winning bid in response to the actual bid being equal to the minimum bid of the current winner.

10. The method, as set forth in claim 1, wherein comparing the actual bid and the minimum bid comprise:

comparing the actual bid with a minimum bid of the current winner;

comparing the minimum bid of the current winner to the minimum bid; and

setting the minimum bid of the current winner minus a predetermined delta value as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, and the minimum bid minus the predetermined delta value being greater than the minimum bid of the current winner.

11. The method, as set forth in claim 1, wherein comparing the actual bid and the minimum bid comprise:

comparing the actual bid with a minimum bid of the current winner;

comparing the minimum bid of the current winner to the minimum bid; and

setting the minimum bid of the current winner as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, and the minimum bid being equal to the minimum bid of the current winner.

12. The method, as set forth in claim 1, wherein comparing the actual bid and the minimum bid comprise:

comparing the actual bid with a minimum bid of the current winner;

comparing the minimum bid of the current winner to the minimum bid; and

setting the minimum bid of the current winner minus a predetermined delta value as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, the minimum bid of the current winner being greater than the minimum bid, and the minimum bid of the current winner minus the predetermined delta value being greater than or equal to the minimum bid; and

setting the minimum bid as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, the minimum bid of the current winner being greater than the minimum bid, and the minimum bid of the current winner minus the predetermined delta value being less than the minimum bid.

13. The method, as set forth in claim 1, wherein comparing the actual bid comprises:

comparing the actual bid with an actual bid of the current winner;

setting the supplier submitting the actual bid as the current winner in response to the actual bid being less than the actual bid of the current winner; and

setting the actual bid as the current winning bid in response to the actual bid being less than the actual bid of the current winner.

14. The method, as set forth in claim 1, wherein comparing the minimum bid comprises:

comparing the current winning bid minus a predetermined delta value with the minimum bid;

setting the supplier submitting the minimum bid as the current winner in response to the current winning bid minus a predetermined delta value being greater than or equal to the minimum bid;

setting the current winning bid minus the predetermined delta value as the current winning bid in response to the current winning bid minus a predetermined delta value being greater than or equal to the minimum bid; and

setting the minimum bid as the current winning bid in response to the current winning bid minus a predetermined delta value being less than the minimum bid.

15. The method, as set forth in claim 1, wherein storing event data comprises:

assigning and storing an event identifier into an event table;

storing the event token into the event table;

storing a start date for the event into the event table;

storing an end date for the event into the event table; and

storing an end date for overtime for the event into the event table.

16. The method, as set forth in claim 1, wherein storing commodity data comprises:

storing a lot identifier for the at least one commodity into a lot table;

storing an item identifier for at least one item in the lot into the lot table;

storing an event identifier of the event into the lot table;

storing a quantity for each item in the lot into the lot table;

storing a starting bid amount for each lot into the lot table; and

storing a target price for each lot into the lot table.

17. The method, as set forth in claim 16, further comprising:

storing a current winning bid for the lot into the lot table; and

storing a minimum bid of the supplier who submitted the current winning bid.

18. The method, as set forth in claim 1, further comprising:

assigning and storing a bid sequence number for a bid submitted for a lot in the event into a bid table;

storing a lot identifier for the submitted bid into the bid table;

storing a supplier identified of the supplier who submitted the bid into the bid table;

storing a user identifier of the agent who submitted the bid into the bid table;

storing the submitted actual bid into the bid table, if applicable;

storing the submitted minimum bid into the bid table, if applicable;

setting a flag indicative of a manual submission of the actual bid or an actual bid automatically submitted based on the minimum bid into the bid table; and

storing a date and time of bid submission into the bid table.

19. The method, as set forth in claim 1, wherein storing supplier data and historical data comprise:

storing a supplier identifier of a supplier into a supplier event table;

storing an event identifier into the supplier event table; and

storing a historical dollar amount representing past business of the supplier for the at least one commodity in the event in the supplier event table.

20. The method, as set forth in claim 1, wherein storing historical data comprises:

storing a supplier identifier of a supplier into a supplier history table;

storing an item identifier of the at least one commodity into the supplier history table;

storing an old part number of an old item comparable to the at least one commodity into the supplier history table, the old item being previously supplied by the supplier;

storing an old price of the old item into the supplier history table;

storing an old quantity of the old item the supplier previously supplied into the supplier history table.

21. The method, as set forth in claim 1, further comprising:

computing a total price representative of the winning bid for the at least one commodity;

comparing the total price for the at least one commodity with a historical total for the at least one commodity; and

computing a difference between the total price and the historical total.

22. The method, as set forth in claim 1, wherein color coding the at least one entry comprises:

showing an entry of a commodity where a bid submitted by the agent in green if it is the current winning bid;

showing an entry of a commodity where a bid submitted by the agent in red if it is not the current winning bid; and

showing an entry of a commodity where a bid has not been submitted by the agent in a neutral color.

23. The method, as set forth in claim 1, further comprising:

coupling a web server having access to the at least one data tables and a bid entry web page for displaying the bid entry screen with a user terminal via the Internet; and

transmitting the web page and data between the web server and the user terminal via the Internet.

24. A method of conducting an online competitive price quoting event for at least one commodity, comprising:

storing event data associated with the event into at least one data table;

storing commodity data associated with the at least one commodity into the at least one data table;

storing supplier data associated with a plurality of suppliers who will participate in the event into the at least one data table;

storing historical data associated with past transactions related to the at least one commodity of the plurality of suppliers;

storing a default currency for the event into the at least one data table;

storing a preferred currency for each of the plurality of suppliers into the at least one data table;

providing an event token to the suppliers;

granting access authorization to agents representing the plurality of suppliers in response to receiving the event token for the event;

transmitting a bid entry web page to the agents over the Internet, the bid entry web page listing the at least one commodity as at least one entry, a current winning bid in the preferred currencies of the suppliers, a target price in the preferred currencies of the suppliers, status of the agents'"'"' bids, and entry fields for receiving an actual bid and a minimum bid;

comparing the actual bid to the current winning bid and a current minimum bid in response to receiving the actual bid from an agent and transmitted over the Internet, the actual bid representing the price at which the supplier is willing to sell the at least one commodity;

comparing the minimum bid to the current winning bid and the current minimum bid in response to receiving the minimum bid from the agent, the minimum bid representing the lowest price the supplier is willing to sell the at least one commodity;

determining a new current winning bid based at least in part on the comparisons of the actual bid and the minimum bid to the current winning bid and the current minimum bid;

computing a total price representative of the winning bid for the at least one commodity;

comparing the total price for the at least one commodity with a historical total for a commodity comparable to the at least one commodity that the supplier of the winning bid supplied in one or more previous events; and

computing a difference between the total price and the historical total.

25. The method, as set forth in claim 24, further comprising:

updating the bid entry web page with the current winning bid; and

color coding the at least one entry on the bid entry screen to reflect the current status of the agent'"'"'s bids.

26. The method, as set forth in claim 24, further comprising generating a bid summary of a supplier including a part number of the at least one commodity, a lot number, a quantity, the target price, the actual bid submitted, the minimum bid submitted, a confirmation identifier, and a confirmation time.

27. The method, as set forth in claim 24, further comprising:

granting access authorization to an event administrator in response to receiving the event token for the event;

generating a savings summary of the event including names of suppliers who has a winning bid for a commodity, a historical value for each supplier representing past sales figures for the commodity, a bid value representing the sales figure for the commodity in the current event, and a change value representing the difference between the historical value and the bid value.

28. The method, as set forth in claim 24, further comprising:

granting access authorization to an event administrator in response to receiving the event token for the event;

generating a savings summary of the event including;

names of suppliers who have a winning bid for the at least one commodity;

a historical value for each supplier representing past sales figures for the commodity;

a bid value representing the sales figure for the commodity in the current event;

an adjusted baseline value representing the historical value being adjusted for parts that the suppliers are not invited to bid, new parts without historical value, and parts with historical value that the suppliers have not bid on; and

a change value representing the difference between the historical value and the bid value.

29. The method, as set forth in claim 24, further comprising:

granting access authorization to an event administrator in response to receiving the event token for the event;

generating a detailed event summary of the event, wherein each entry includes;

a bid identifier;

a part number of the at least one commodity;

a quantity;

a supplier identifier of the supplier with the winning bid;

an actual bid;

a minimum bid indicator if a minimum bid was submitted;

a timestamp of the bid; and

a user identifier of the agent who submitted the winning bid.

30. The method, as set forth in claim 24, wherein comparing the actual bid comprises:

comparing the actual bid to a predetermined percentage of the current winning bid;

comparing the actual bid to a predetermined percentage of a target price; and

disallowing the entry of the actual bid in response to the actual bid being less than the predetermined percentage of the current winning bid, or the actual bid being less than the predetermined percentage of the target price.

31. The method, as set forth in claim 24, wherein comparing the actual bid comprises:

comparing the actual bid with a minimum bid of the current winner;

setting the actual bid as the current winning bid in response to the actual bid being less than the minimum bid of the current winner.

32. The method, as set forth in claim 24, wherein comparing the actual bid comprises:

comparing the actual bid with a minimum bid of the current winner;

setting the actual bid minus a predetermined delta value as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner; and

setting the supplier who submitted the actual bid as the current winner.

33. The method, as set forth in claim 24, wherein comparing the actual bid comprises:

comparing the actual bid with a minimum bid of the current winner;

setting the minimum bid of the current winner as the current winning bid in response to the actual bid being equal to the minimum bid of the current winner.

34. The method, as set forth in claim 24, wherein comparing the actual bid and the minimum bid comprise:

comparing the actual bid with a minimum bid of the current winner;

comparing the minimum bid of the current winner to the minimum bid; and

setting the minimum bid of the current winner minus a predetermined delta value as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, and the minimum bid minus the predetermined delta value being greater than the minimum bid of the current winner.

35. The method, as set forth in claim 24, wherein comparing the actual bid and the minimum bid comprise:

comparing the actual bid with a minimum bid of the current winner;

comparing the minimum bid of the current winner to the minimum bid; and

setting the minimum bid of the current winner as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, and the minimum bid being equal to the minimum bid of the current winner.

36. The method, as set forth in claim 24, wherein comparing the actual bid and the minimum bid comprise:

comparing the actual bid with a minimum bid of the current winner;

comparing the minimum bid of the current winner to the minimum bid; and

setting the minimum bid of the current winner minus a predetermined delta value as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, the minimum bid of the current winner being greater than the minimum bid, and the minimum bid of the current winner minus the predetermined delta value being greater than or equal to the minimum bid; and

setting the minimum bid as the current winning bid in response to the actual bid being greater than the minimum bid of the current winner, the minimum bid of the current winner being greater than the minimum bid, and the minimum bid of the current winner minus the predetermined delta value being less than the minimum bid.

37. The method, as set forth in claim 24, wherein comparing the actual bid comprises:

comparing the actual bid with an actual bid of the current winner;

setting the supplier submitting the actual bid as the current winner in response to the actual bid being less than the actual bid of the current winner; and

setting the actual bid as the current winning bid in response to the actual bid being less than the actual bid of the current winner.

38. The method, as set forth in claim 24, wherein comparing the minimum bid comprises:

comparing the current winning bid minus a predetermined delta value with the minimum bid;

setting the supplier submitting the minimum bid as the current winner in response to the current winning bid minus a predetermined delta value being greater than or equal to the minimum bid;

setting the current winning bid minus the predetermined delta value as the current winning bid in response to the current winning bid minus a predetermined delta value being greater than or equal to the minimum bid; and

setting the minimum bid as the current winning bid in response to the current winning bid minus a predetermined delta value being less than the minimum bid.

39. The method, as set forth in claim 24, wherein storing event data comprises:

assigning and storing an event identifier into an event table;

storing the event token into the event table;

storing a start date for the event into the event table;

storing an end date for the event into the event table; and

storing an end date for overtime for the event into the event table.

40. The method, as set forth in claim 24, wherein storing commodity data comprises:

storing a lot identifier for the at least one commodity into a lot table;

storing an item identifier for at least one item in the lot into the lot table;

storing an event identifier of the event into the lot table;

storing a quantity for each item in the lot into the lot table;

storing a starting bid amount for each lot into the lot table; and

storing a target price for each lot into the lot table.

41. The method, as set forth in claim 40, further comprising:

storing a current winning bid for the let into the lot table; and

storing a minimum bid of the supplier who submitted the current winning bid.

42. The method, as set forth in claim 24, further comprising:

assigning and storing a bid sequence number for a bid submitted for a lot in the event into a bid table;

storing a lot identifier for the submitted bid into the bid table;

storing a supplier identifier of the supplier who submitted the bid into the bid table;

storing a user identifier of the agent who submitted the bid into the bid table;

storing the submitted actual bid into the bid table, if applicable;

storing the submitted minimum bid into the bid table, if applicable;

setting a flag indicative of a manual submission of the actual bid or an actual bid automatically submitted based on the minimum bid into the bid table; and

storing a date and time of bid submission into the bid table.

43. The method, as set forth in claim 24, wherein storing supplier data and historical date comprise:

storing a supplier identifier of a supplier into a supplier event table;

storing an event identifier into the supplier event table; and

storing a historical dollar amount representing past business of the supplier for the at least one commodity in the event in the supplier event table.

44. The method, as set forth in claim 24, wherein storing historical data comprises:

storing a supplier identifier of a supplier into a supplier history table;

storing an item identifier of the at least one commodity into the supplier history table;

storing an old part number of an old item comparable to the at least one commodity into the supplier history table, the old item being previously supplied by the supplier;

storing an old price of the old item into the supplier history table;

storing an old quantity of the old item the supplier previously supplied into the supplier history table.

45. The method, as set forth in claim 24, further comprising:

computing a total price representative of the winning bid for the at least one commodity;

comparing the total price for the at least one commodity with a historical total for the at least one commodity; and

computing a difference between the total price and the historical total.

46. The method, as set forth in claim 45, further comprising:

computing a total price representative of the winning bid for the at least one commodity;

comparing the total price for the at least one commodity with a historical total for a commodity comparable to the at least one commodity that the supplier of the winning bid supplied in a previous year; and

computing a difference between the total price and the historical total.

47. The method, as set forth in claim 24, further comprising generating an event report containing a log of all bids placed in the event, the event report including, for each bid, a bid identifier, a part number, a lot number, a quantity, a supplier identifier, the actual bid, the minimum bid, a time and date the bid was submitted, and a user identifier of the agent of the supplier that submitted the bid.

48. The method, as set forth in claim 24, wherein color coding the at least one entry comprises:

showing an entry of a commodity where a bid submitted by the agent in green if it is the current winning bid;

showing an entry of a commodity where a bid submitted by the agent in red if it is not the current winning bid; and

showing an entry of a commodity where a bid has not been submitted by the agent in a neutral color.