Method and apparatus for industrial data acquisition and product costing

• US 5,970,476 A
• Filed: 09/19/1996
• Issued: 10/19/1999
• Est. Priority Date: 09/19/1996
• Status: Expired due to Term

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: Manufacturing Management Systems Incorporated
• Inventors: Fahey, Bill G.
• Primary Examiner(s): Peeso, Thomas R.
• Application Number:
  US08/715,552
• Time in Patent Office: 1,125 Days
• Field of Search: 705/28, 705/29, 707/1, 707/10, 707/100, 707/102, 707/200
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/04 Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem" market predictions or forecasting for commercial activities G06Q30/0202
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock 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/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

An information storage, processing, and reporting system (20) for tracing enterprise wide product data, the system comprises a data storage (23, 26, 50) is adapted for storing data (106, 120, 112, 108) entries related to a product family. The data is received in a data warehouse system (42). The data is cataloged (54, 56, 58, 62). Cataloging the related data includes identifying data elements related to selected product families. The system indexes (70, 140, 144, 148, 149, 159, 169, 179) the identified data elements which are related to a selected first product family in accordance with the data representative thereof. Interconnected tables 140, 144, 148, 149, 159, 169, 179 are used for grouping indexed data elements pursuant to data representative of selected criterion. A storage medium (50) is adapted for storing the grouped data elements in a relational database (52). A digital processor (44) processes (36, 38, 116, 128) the grouped data elements in accordance with Activity Based Cost criteria. The memory medium (50) is adapted for storing the processed data (122, 110, 114, 124, 56, 54) in a relational database structure (52).

Claims

1. An information storage, processing, and reporting system for tracing enterprise wide product data, said system comprising:

a data storage adapted for storing data related to a product;

means adapted for receiving related data for a product from said data storage system;

means for cataloging said related data about said product, by product families wherein said means for cataloging related data includes;

means for identifying data elements related to selected product families;

means for indexing said identified data elements which are related to a selected first product family in accordance with data representative thereof;

means for grouping said indexed data elements pursuant to data representative of selected criterion, wherein said means for grouping includes means for grouping said data according to activity centers; and

means adapted for storing said grouped data elements in a relational database;

means for processing said grouped data elements in a digital processor in accordance with Activity Based Cost criteria; and

means adapted for storing said processed data in a relational database structure.

2. The information storage, processing, and reporting system of claim 1 wherein the data storage includes a plurality of discrete data storage sub-systems.

3. The information storage, processing, and reporting system of claim 2 wherein each of said discrete data storage subsystems is adapted for storing a plurality of entries related to said product family in accordance with said data representative thereof.

4. The information storage, processing, and reporting system of claim 1 wherein the indexing means includes means for selecting activity based data elements related to at least one of said product families in accordance with said data representative thereof.

5. The information storage, processing, and reporting system of claim 4 wherein the means for grouping includes means for summing activity based data about said product families in accordance with said data representative thereof.

6. The information storage, processing, and reporting system of claim 1 wherein the means adapted for receiving related data for a product from said data storage stored in said plurality of discrete data storage sub-systems is automated.

7. The information storage, processing, and reporting system of claim 1 wherein the means for processing includes means for summarizing said data over a selected time period.

8. The information storage, processing, and reporting system of claim 1 wherein the means for grouping said related data includes grouping said data according to activity functions.

9. The information storage, processing, and reporting system of claim 1, wherein the means for grouping further includes grouping said data according to activity categories.

10. The information storage, processing, and reporting system of claim 1 wherein the means for processing includes means for determining a value associated with said product families in response to a driver value, said driver value being a measurable value.

11. An information storage, processing, and reporting method for tracing enterprise wide product data, said method comprising the steps of:

storing data entries related to a product family;

receiving the stored related data for a product;

cataloging said related data about said product families wherein said step of cataloging related data includes the steps of;

identifying data elements related to selected product families;

indexing the identified data elements which are related to a selected first product family in accordance with data representative thereof;

grouping said indexed data elements pursuant to data representative of selected criterion, the step of grouping including grouping said indexed data according to activity centers; and

storing said grouped data elements in a relational database;

processing said grouped data elements in a digital processor in accordance with Activity Based Cost criteria; and

storing said processed data in a relational database structure.

12. The information storage, processing, and reporting method of claim 11 wherein the data is storage in a plurality of discrete data storage sub-systems.

13. The information storage, processing, and reporting method of claim 12 wherein each of said discrete data storage sub-systems stores a plurality of entries related to said product family in accordance with said data representative thereof.

14. The information storage, processing, and reporting method of claim 11 wherein the step of indexing includes the step of selecting activity based data elements related to at least one of said product families in accordance with said data representative thereof.

15. The information storage, processing, and reporting method of claim 14 wherein the step of grouping includes summing activity based data about said product families in accordance with said data representative thereof.

16. The information storage, processing, and reporting method of claim 11 wherein the step of receiving related data for a product from said data storage stored in said plurality of discrete data storage sub-systems is automated.

17. The information storage, processing, and reporting of claim 11 wherein the step of processing includes the step of summarizing said data over a selected time period.

18. The information storage, processing, and reporting method of claim 11 wherein the step of grouping related data includes grouping said data according to activity functions.

19. The information storage, processing, and reporting method of claim 11, wherein the step of grouping further includes grouping said data according to activity categories.

20. The information storage, processing, and reporting method of claim 11 wherein the step of processing includes the step of determining a value associated with said product family in response to a driver value, said driver value is a measurable value.

21. An information storage, processing, and reporting method according to claim 11, wherein said method further comprises the step of:

transferring said processed data to at least one of;

a spreadsheet subsystem, and one or more multidimensional databases.

22. An industrial data acquisition and product costing system comprising:

means adapted for acquiring product data representative of at least one product, the product data including a data field representative of a product family to which each of an associated product belongs;

a data storage adapted for storing acquired product data;

comparison means adapted for isolating groups of product families in accordance with a testing of the product data against at least one of other product data and data representative of a family standard;

means adapted for selectively retrieving data representative of isolated groups of product families in accordance with tested product data;

means for retrieving preselected data representative of activity based costing data;

means for retrieving product data for each product of an isolated group of products; and

means for outputting data representative of the activity based costing data having been applied to retrieved product data on an isolated group of products.

23. The industrial data acquisition and product costing system of claim 22 wherein the means for acquiring product data includes means for acquiring the product data over a selected product data acquisition period.

24. The industrial data acquisition and product costing system of claim 23 wherein the comparison means further includes means for isolating groups of product families in accordance with at least one of:

data representative of activity categories, data representative of activity functions, and data representative of activity centers.

25. An information storage, processing, and reporting system for tracing enterprise wide product data, said system comprising:

a data storage adapted for storing data related to a product;

means adapted for receiving related data for a product from said data storage system;

means for cataloging said related data by product families, wherein said means for cataloging related data includes;

means for identifying data elements related to selected product families;

means for indexing said identified data elements which are related to a selected first product family in accordance with data representative thereof;

means for grouping said indexed data elements pursuant to data representative of selected criterion; and

means adapted for storing said grouped data elements in a relational database;

means for processing said grouped data elements in a digital processor in accordance with Activity Based Cost criteria, said means for processing including means for determining a value associated with said product families in response to a driver value, said driver value being a measurable value; and

means adapted for storing said processed data in a relational database structure.

26. An information storage, processing, and reporting method for tracing enterprise wide product data, said method comprising the steps of:

storing data entries related to a product family;

receiving the stored related data for a product;

cataloging said related data about said product families wherein said step of cataloging related data includes the steps of;

identifying data elements related to selected product families;

indexing the identified data elements which are related to a selected first product family in accordance with data representative thereof;

grouping said indexed data elements pursuant to data representative of selected criterion; and

storing said grouped data elements in a relational database;

processing said grouped data elements in a digital processor in accordance with Activity Based Cost criteria, wherein the step of processing includes the step of determining a value associated with said product family in response to a driver value, said driver value being a measurable value; and

storing said processed data in a relational database structure.

27. An information storage, processing, and reporting system for tracing enterprise wide product data, said system comprising:

a data storage adapted for storing data related to a product;

means adapted for receiving related data for a product from said data storage system;

means for cataloging said related data by product families wherein said means for cataloging related data includes;

means for identifying data elements related to selected product families;

means for indexing said identified data elements which are related to a selected first product family in accordance with data representative thereof;

means for grouping said indexed data elements pursuant to data representative of selected criterion; and

means adapted for storing said grouped data elements in a relational database;

means for processing said grouped data elements in a digital processor in accordance with activity based cost criteria; and

means adapted for storing said processed data in a relational database structure, wherein said processed data takes the form of a multi-field data structure including;

(1) business unit data identifying one or more business units of an organization,

(2) activity data representative of activities of the one or more business units, and

(3) accounting data associated with the one or more business units.

28. An information storage, processing, and reporting system according to claim 27, wherein said business unit data includes at least one of:

data identifying the largest business unit that provides services that affect cost for a product, geographic identifier, legal entity identifier, data identifying the highest unit within a business operation, data identifying the highest unit of organization within a group, and data identifying facilities within an organization.

29. An information storage, processing, and reporting system according to claim 27, wherein said activity data includes at least one of:

data identifying related groupings of activities performed within a business function, related grouping of activity centers within an activity category, data identifying a highest level of activity to which people and equipment are assigned.

30. An information storage, processing, and reporting system according to claim 27, wherein said accounting data includes at least one of:

data identifying accounting categories to designate costs, data identifying costs and expenses associated with a resource category, and data identifying costs incurred in each resource category.