System and method for use by various departments to prepare a quotation

• US 7,720,716 B2
• Filed: 07/12/2002
• Issued: 05/18/2010
• Est. Priority Date: 07/12/2001
• Status: Active Grant

• Current Assignee: Saphran, Inc.
• Original Assignee: Kqb Holdings, Inc.
• Inventors: Bassey, Kenneth Q., Cerkic, Jasmin
• Primary Examiner(s): Smith; Jeffrey A.
• Assistant Examiner(s): MISIASZEK, MICHAEL
• Application Number:
  US10/483,480
• Publication Number:
  US 20040243473A1
• Time in Patent Office: 2,867 Days
• Field of Search: 705/26, 705/27
• US Class Current: 705/26.4
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/0278 Product appraisal
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0611 Request for offers or quotes
• CPC Class Codes: G06Q 30/0621 Item configuration or customization
• CPC Class Codes: G06Q 30/0641 Shopping interfaces
• CPC Class Codes: G06Q 30/0643 Graphical representation of items or shoppers

Abstract

A quotation system and method are provided (see FIG. 1). A relational database (10) allows various departments (14, 16, 18, 20) to prepare a quotation. The relational database centralizes data to increase efficiency, and the data may be modified, as needed, for particular quotation solutions.

Claims

1. A method for use by various departments to prepare a quotation, the method comprising:

accessing a relational database recorded on a computer-readable medium to assist in preparing the quotation, the relational database being accessed by the various departments and providing centralized data recorded on the computer-readable medium, the centralized data including a plurality of relations to relate manufacturing processes, cost parameters, calculations, and work flows;

wherein each of the various departments, in accordance with the work flows, accesses the relational database through a customized interface configured to allow limited access to the relational database based on the corresponding department;

wherein the plurality of relations includes a first relation including a quotation identification attribute, a second relation including a calculation identification attribute and an equation description attribute, and a plurality of additional relations that dictate the use of the second relation in preparing a quotation identified by data corresponding to the quotation identification attribute of the first relation;

wherein the relational database is configured to allow modification of the second relation to modify data corresponding to the equation description attribute to change the way calculations are performed when preparing the quotation, thereby allowing techniques utilized to perform calculations to be customized as needed for particular applications;

processing information in the relational database to prepare the quotation in accordance with the plurality of relations;

wherein when preparing a quotation identified by data corresponding to the quotation identification attribute of the first relation, the current data corresponding to the equation description attribute of the second relation determine the way calculations are performed when preparing the quotation, and the plurality of relations determines the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation; and

providing the quotation to a user.

2. The method of claim 1 further comprising:

modifying the second relation to modify data corresponding to the equation description attribute to change the way that calculations are performed by the relational database for preparing the quotation.

3. The method of claim 1 wherein the additional relations further comprise:

a third relation including the calculation identification attribute and a process identification attribute, the third relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

4. The method of claim 3 wherein the additional relations further comprise:

a fourth relation including the quotation identification attribute and the process identification attribute, the fourth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

5. The method of claim 4 wherein the additional relations further comprise:

a fifth relation including the process identification attribute and a machine identification attribute, the fifth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

6. The method of claim 5 wherein the additional relations further comprise:

a sixth relation including the machine identification attribute and a machine name attribute, the sixth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

7. The method of claim 4 wherein the additional relations further comprise:

a fifth relation including the process identification attribute and a parameter identification attribute, the fifth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

8. The method of claim 7 wherein the additional relations further comprise:

a sixth relation including the parameter identification attribute and a parameter name attribute, the sixth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

9. The method of claim 4 wherein the additional relations further comprise:

a fifth relation including the quotation identification attribute and a workflow identification attribute, the fifth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

10. The method of claim 9 wherein the additional relations further comprise:

a sixth relation including the workflow identification attribute and a workflow name attribute, the sixth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

11. The method of claim 9 wherein the additional relations further comprise:

a sixth relation including the workflow identification attribute and the process identification attribute, the sixth relation affecting the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation.

12. A system for use by various departments to prepare a quotation, the system comprising:

a relational database recorded on a computer-readable medium to assist in preparing the quotation, the relational database being accessed by the various departments and providing centralized data recorded on the computer-readable medium, the centralized data including a plurality of relations to relate manufacturing processes, cost parameters, calculations, and work flows for the various departments;

wherein the plurality of relations includes a first relation including a quotation identification attribute, a second relation including a calculation identification attribute and an equation description attribute, and a plurality of additional relations that dictate the use of the second relation in preparing a quotation identified by data corresponding to the quotation identification attribute of the first relation;

wherein the relational database is configured to allow modification of the second relation to modify data corresponding to the equation description attribute to change the way calculations are performed when preparing the quotation, thereby allowing techniques utilized to perform calculations to be customized as needed for particular applications;

wherein the relational database is configured to process information in the relational database to prepare the quotation in accordance with the plurality of relations;

wherein when preparing a quotation identified by data corresponding to the quotation identification attribute of the first relation, the current data corresponding to the equation description attribute of the second relation determine the way calculations are performed when preparing the quotation, and the plurality of relations determines the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation;

an interface connected to the relational database and configured to allow access to the relational database; and

a plurality of customizable interfaces corresponding to the various departments, each customized interface being connected to the relational database and configured to allow limited access to the relational database based on the work flow for the corresponding department.

13. A system for use by various departments to prepare a quotation, the system comprising:

a relational database recorded on a computer-readable medium to assist in preparing the quotation, the relational database being accessed by the various departments and providing centralized data recorded on the computer-readable medium, the centralized data including a plurality of relations to relate manufacturing processes, cost parameters, calculations, and work flows for the various departments;

wherein the plurality of relations includes a first relation including a quotation identification attribute, a second relation including a calculation identification attribute and an equation description attribute, and a plurality of additional relations that dictate the use of the second relation in preparing a quotation identified by data corresponding to the quotation identification attribute of the first relation;

wherein the relational database is configured to allow modification of the second relation to modify data corresponding to the equation description attribute to change the way calculations are performed when preparing the quotation, thereby allowing techniques utilized to perform calculations to be customized as needed for particular applications;

wherein the relational database is configured to process information in the relational database to prepare the quotation in accordance with the plurality of relations;

wherein when preparing a quotation identified by data corresponding to the quotation identification attribute of the first relation, the current data corresponding to the equation description attribute of the second relation determine the way calculations are performed when preparing the quotation, and the plurality of relations determines the way that the relational database manipulates data to determine the way that the calculations affect the prepared quotation;

an interface connected to the relational database and configured to allow access to the relational database; and

a plurality of customizable interfaces corresponding to the various departments, each customized interface being connected to the relational database and configured to allow limited access to the relational database based on the work flow for the corresponding department and further based on a user status from a group including contributors and approvers.