Granted Patent B2

US 12,579,146 · App. 18/755,235 · Granted Mar 17, 2026

Inventors: Joseph David Ruth (Louisville, CO); David James Brick (Fort Collins, CO); Matthew Garrett Michnal (Denver, CO)

Assignee: ID Business Solutions, Inc.

G06F16/2455G06F16/24575

Abstract

Claims (14)

1 . A method implemented by a processor, the method comprising:

storing, by the processor, a lot characteristic associated with a first raw material lot including a raw material;

creating, by the processor, tables for producing a product including the raw material, the tables including one or more intermediary tables and a product table;

tracking, by the processor, the first raw material lot during production of the product by recording an amount of raw material from the first raw material lot in at least one of the one or more intermediary tables and the product table; and

generating, by the processor, a product characteristic corresponding to the product by, using the product table, aggregating the lot characteristic of the first raw material lot based on the tracking of the first raw material lot;

wherein generating the product characteristic corresponding to the product by aggregating the lot characteristic of the first raw material lot based on the tracking of the first raw material lot is based on a recursive determination of the recording of the amount of raw material from the first raw material lot used during production of the product.

2 . The method of claim 1 , wherein aggregating the lot characteristic of the first raw material lot based on the tracking of the first raw material lot occurs responsive to a query for the product characteristic of the product.

3 . The method of claim 1 , further comprising:

tracking, by the processor, a second raw material lot of the raw material during production of the product; and

wherein generating the product characteristic further comprises aggregating the lot characteristic of the second raw material lot based on the tracking of the second raw material lot with the aggregated lot characteristic of the first raw material lot.

4 . The method of claim 3 , wherein tracking, by the processor, the second raw material lot during production of the product includes recording an amount of raw material from the second raw material lot used during production of the product in at least one of the one or more intermediary tables and the product table.

5 . The method of claim 4 , wherein aggregating the lot characteristic of the second raw material lot with the lot characteristic of the first raw material lot comprises:

adjusting, by the processor, the lot characteristic of the second raw material lot based on an amount of raw material from the second raw material lot used during production of the product; and

adjusting, by the processor, the lot characteristic of the first raw material lot based on an amount of raw material from the first raw material lot used during production of the product.

Assignments (2)

Continuity (5)

References Cited (28)