Methods and systems enabling the identification of actual costs in a transaction based financial and manufacturing environment

• US 7,440,909 B2
• Filed: 01/21/1999
• Issued: 10/21/2008
• Est. Priority Date: 01/21/1999
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Vij, Deepak, Patil, Galina Atlas, Puri, Arvind Nath
• Primary Examiner(s): Kazimi; Hani M.
• Application Number:
  US09/235,120
• Publication Number:
  US 20020069103A1
• Time in Patent Office: 3,561 Days
• Field of Search: 705/11, 705/22, 705/23, 705/24, 705/30
• US Class Current: 705/7.37
• CPC Class Codes: G06Q 10/06375 Prediction of business process outcome or impact based on a proposed change
• CPC Class Codes: G06Q 20/203 Inventory monitoring
• CPC Class Codes: G06Q 20/208 Input by product or record sensing, e.g. weighing or scanner processing
• CPC Class Codes: G06Q 20/209 Specified transaction journal output feature, e.g. printed receipt or voice output
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: G06Q 99/00 Subject matter not provided for in other groups of this subclass

Abstract

A computer implemented actual costing method for collecting and presenting an actual cost of performing a business activity includes the steps of carrying a first and/or a second step, the first step including collecting the actual cost of at least one job performed in furtherance of the business activity, the second step including collecting the actual cost of at least one item manufactured in furtherance of the business activity. A unique cost source identifier is created for each collected actual cost and the collected actual cost is stored therein. Each unique cost source identifier is then associated with its corresponding item or job within the business activity. A selected accounting costing method for actual cost collection and a selected accounting costing method for actual cost presentation based upon the stored cost source identifiers may then be implemented. As the actual discrete costs for each item or selected items manufactured and for each job or selected jobs performed in furtherance of the business activity have been collected and stored in respective unique cost source identifiers, the selected accounting costing method for actual cost collection may be different than the selected accounting costing method for cost presentation.

Claims

1. A computer implemented actual costing method for collecting and presenting an actual cost of manufacturing an item or performing a service, comprising the steps of:

collecting actual costs of performing a job, manufacturing an item and/or purchasing an item,

creating a unique cost source identifier data structure for each collected actual cost, each created cost source identifier data structure including a plurality of attribute fields;

populating one the plurality of attribute fields of the created cost source identifier data structure with the collected actual cost;

storing the populated cost source identifier data structure in a memory of a computer;

associating each unique cost source identifier data structure to a step carried out while manufacturing the item or while performing the service; and

organizing and storing the cost source identifier data structures within the computer as a hierarchical structure that is modeled on;

a structure of the item manufactured or

a sequence of operations carried out while performing the service;

implementing a selected accounting casting method for actual cost collection and a selected accounting costing method for actual cost presentation by accessing and selectively traversing the hierarchical structure, the selected accounting costing method for actual cost collection being independent of the selected accounting costing method for cost presentation.

2. The method of claim 1, wherein the accounting costing methods for actual cost collection and for actual cost presentation are selected from among a group including Last In First Out (LEFO), First In First Out (FIFO), Most Expensive First (MEF), Least Expensive First (LEF) and Average costing methods.

3. The method of claim 1, wherein a new unique cost source identifier data structure is created upon each occurrence of a transaction that affects the actual cost of the activity that gave rise to the collected actual cost.

4. The method of claim 1, wherein a new unique cost source identifier data structure is created at least each time an item is manufactured or purchased and each time an item is received into inventory.

5. The method of claim 1, wherein a new unique source identifier data structure is created at least each time a job is performed while manufacturing the item or while performing the service, contemporaneously with a perfomance of the job.

6. The method of claim 1, wherein the unique cost source identifier data structure is further configured to store a pointer to a data structure.

7. The method of claim 1, wherein the plurality of attribute fields are configured to store at least one of an indication of a date at which the collected actual cost was incurred, a quantity of items corresponding to the collected actual cost, a number of unit time periods expended in performance of a job, an indication of labor time, resource time, payroll, resource rate, overhead time, overhead rate, actual cost of purchased material and actual cost of outside processing.

8. The method of claim 1, wherein the hierarchical structure includes a plurality of nodes, each of the stored cost source identifier logical structures being assigned to at least one of the plurality of nodes.

9. The method of claim 7, wherein the implementing step is carried out at a selected node level by rolling up all actual costs within the cost source identifiers assigned to nodes hierarchically below the selected node level.

10. The method of claim 1, further comprising the step of storing a standard cost within the cost source identifier when an actual cost of one of a job performed and an item manufactured is unknown.

11. A computer system to compute an actual cost of manufacturing an item or performing a service from collected actual costs incurred while manufacturing the item or performing the service, comprising;

at least one processor;

at least one data storage device coupled to the at least one processor;

a plurality of processes spawned by said at least one processor, the processes including processing logic for;

collecting actual costs of performing a job, manufacturing an item and/or purchasing an item,

creating a unique cost source identifier data structure for each collected actual cost, each created cost source identifier udata structure including a plurality of attribute fields;

populating one of the plurality of attribute fields of the created cost source identifier data structure with the collected actual cost;

storing the populated cost source identifier data;

associating each unique coat source identifier data structure to a step carried out while manufacturing the item or while performing the service; and

organizing and storing the cost source identifier data structures as a hierarchical structure tat is modeled on;

a structure of the item manufactured, or

a sequence of operations carried out while performing the service;

implementing a selected accounting costing method for actual cost collection and a selected accounting costing method for actual cost presentation by accessing and selectively traversing the hierarchical structure, the selected accounting costing method for actual cost collection being independent of the selected accounting costing method for cost presentation.

12. The computer system of claim 11, wherein the hierarchical structure includes a plurality of nodes, each of the stored cost source identifiers being assigned to at least one of the plurality of nodes.

13. The computer system of claim 12, wherein said at least one processor implements the selected accounting method for actual cost presentation and the selected accounting method for actual cost collection by rolling up all actual costs within the cost source identifiers assigned to nodes hierarchically below the selected node level.

14. The computer system of claim 11, further comprising processing logic for storing said cost source identifier data structures in one of a relational or an object-oriented database.

15. A machine readable medium having stored thereon data representing sequences of instructions which, when executed by a computer system, causes said computer system to perform the steps of:

collecting, in substantially real time, an actual cost of each of a plurality of constituent items or operations affecting a cost of manufacturing an item or performing a service;

creating a unique cost source identifier data structure for each collected actual cost, each created cost source identifier data structure including a plurality of attribute fields;

populating one of the plurality of attribute fields of the created cost source identifier data structure with the collected actual cost;

assigning each collected actual cost to a unique logical structure associated with a corresponding one of said items or operations;

storing each populated cost source identifier data structure to create a hierarchical organization of cost source identifier data structures configured to allow the actual cost of the activity to be ascertained at any stage of a performance thereof, the hierarchical organization being modeled on a structure of the item manufactured or a sequence of steps carried out while performing the service.

16. The machine readable medium of claim 15, further comprising sequences of instructions for performing the step of creating a new unique cost source identifier data structure for each constituent item or operation that affects the cost of manufacturing the item or performing the service.

17. The machine readable medium of claim 15, wherein one of the plurality of attribute fields is configured to store a pointer to a data structure.

18. The machine readable medium of claim 15, wherein the sequences of operations further cause said computer system to carry out a step of storing a date in which each collected actual cost is incurred.

19. The machine readable medium of claim 15, wherein the sequences of operations further cause said computer system to carry out a step of storing a standard cost when an actual cost cannot be ascertained.

20. The machine readable medium of claim 15, wherein the sequences of operations further cause said computer system to carry out a step of storing a standard cost when a transaction cost of collecting the actual cost for any one of said constituent items or operations is excessive relative to a value thereof.

21. The machine readable medium of claim 15, wherein the storing step stores the hierarchical organization of cost source identifier data structures in one of a relational and an object-oriented database.

22. The machine readable medium of claim 15, further comprising sequences of instructions for performing the step of:

accessing the hierarchical organization of cost source identifier data structures, and

implementing a selected actual cost collection accounting method and a selected actual cost presentation accounting method based on the accessed hierarchical organization of cost source identifier data structures, the selected actual cost collection accounting method being independent of the selected actual cost presentation accounting method.