Process for monitoring production of compositions

• US 7,264,161 B2
• Filed: 12/29/2004
• Issued: 09/04/2007
• Est. Priority Date: 01/14/2004
• Status: Expired due to Fees

• Current Assignee: Axalta Coating Systems Ip Co Llc (Axalta Coating Systems Ltd.)
• Original Assignee: E. I. du Pont de Nemours and Company (Corteva, Inc.)
• Inventors: Polarine, Christine Darlene Ames
• Primary Examiner(s): ST CYR, DANIEL
• Application Number:
  US11/025,128
• Publication Number:
  US 20050156036A1
• Time in Patent Office: 979 Days
• Field of Search: 235/376, 235/385
• US Class Current: 235/385
• 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/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

The present invention is directed to a process for monitoring production of a target composition, such as an automotive paint or an architectural paint and a monitoring device used therein. The process includes (a) identifying one or more formulas associated with identification criteria of the target composition, the formula providing a required inventory for making a desired amount of the target composition; (b) generating a current inventory; (c) comparing the current inventory against the required inventory to ascertain whether said current inventory fulfills said required inventory; (d) generating a supplementary inventory if the current inventory partially fulfills the required inventory; (e) dispensing required items listed in the required inventory from current items listed in the current inventory, supplementary items listed in the supplementary inventory, or a combination thereof to make the desired amount of the target composition; and (f) generating an updated inventory. The process can be also used to control the inventory by shipping just in time any components required to produce target compositions, such as refinish tints used in automotive refinish paints.

Claims

1. A process for monitoring production of a target composition comprising:

(A) identifying one or more formulas associated with identification criteria of said target composition, said formula providing a required inventory that lists required items for making a desired amount of said target composition;

(B) generating a current inventory;

(C) comparing said current inventory against said required inventory to ascertain whether said current inventory fulfills said required inventory;

(D) generating a supplementary inventory if said current inventory partially fulfills said required inventory;

(E) dispensing said required items listed in said required inventory from current items listed in said current inventory, supplementary items listed in said supplementary inventory, or a combination thereof to make said desired amount of said target composition; and

(F) generating an updated inventory.

2. The process of claim 1 comprising:

(a) searching a first database for identifying one or more characteristics associated with said identification criteria of said target composition; and

(b) searching a second database for identifying one or more said formulas associated with said characteristics.

3. The process of claim 2 wherein said formula is a color formula.

4. The process of claim 3 wherein said first database resides on a client computer and said second database resides on a host computer in communication with said client computer, said first and said second database reside on said host computer in communication with said client computer, or said first and said second database reside on said client computer.

5. The process of claim 4 wherein said identification criteria comprise one or more of a manufacturer name, make, model, year of production, color name, paint code, cross reference information, intended use, VIN number, or spectrophotometric data of a vehicle or color of the vehicle.

6. The process of claim 5 wherein said identification criteria resides on an identification criteria identification tag positioned on said vehicle or a color reference chip.

7. The process of claim 6 wherein said identification criteria identification tag is a RFID tag, a bar code tag or a combination thereof.

8. The process of claim 1 wherein said required items in said required inventory comprise:

(a) one or more compositions matching characteristics associated with said identification criteria and quantities thereof required to make said desired amount of said target composition;

(b) target components and quantities thereof listed in said formula that are required to make said desired amount of said target composition;

or

(c) a combination of (a) and (b).

9. The process of claim 1 wherein said current items in said current inventory comprise:

(a) one or more stock compositions matching characteristics associated with said identification criteria and quantities thereof required to make said desired amount of said target composition;

(b) stock target components and quantities thereof listed in said formula that are required to make said desired amount of said target composition;

or

(c) a combination of (a) and (b).

10. The process of claim 9 wherein said step (B) comprises:

(a) reading with one or more identification tag interrogators;

(i) stock composition information on stock composition identification tags affixed to stock composition containers that contain said stock composition,

(ii) stock component information on stock components identification tags affixed to stock component containers that match said target components, or

(iii) a combination of (i) and (ii); and

(b) storing said current inventory.

11. The process of claim 10 wherein said current inventory is stored on a client computer, on a host computer in communication with said client computer, or on said client computer and said host computer.

12. The process of claim 10 wherein said stored inventory is stored on a client computer, on a host computer in communication with said client computer, or on said client computer and said host computer.

13. The process of claim 12 wherein said supplementary items in said supplementary inventory comprise:

(a) additional quantities of said stock compositions required to produce said desired amount of said target composition,

(b) any missing stock components that match said target components listed in said formula in sufficient quantities required to produce said desired amount of said target composition, or

(c) a combination of (a) and (b).

14. The process of claim 13 wherein said step (D) comprises:

(a) reading with one or more said identification tag interrogators;

(i) additional stock composition information on additional stock composition identification tags affixed to additional stock composition containers that contain said stock composition,

(ii) missing stock component information on missing stock components identification tags affixed to missing stock component containers, or

(iii) a combination of (i) and (ii); and

(b) storing said supplementary inventory.

15. The process of claim 14 wherein said supplementary inventory is stored on said client computer, on said host computer, or on said client computer and said host computer.

16. The process of claim 15 wherein step (F) comprises:

(a) deducting from said current inventory dispensed quantities of said stock composition, said stock components, or a combination thereof to generate an adjusted current inventory;

(b) deducting from said supplementary inventory dispensed additional quantities of said stock composition, dispensed quantities of said missing stock components, or a combination thereof, to generate an adjusted supplementary inventory; and

(c) adding said adjusted current inventory and said adjusted supplementary inventory.

17. The process of claim 16 wherein said updated inventory is stored on said client computer, on said host computer, or on said client computer and said host computer.

18. The process of claim 10 wherein said stock composition information comprises:

(a) identity of said stock composition, compositional structure of said stock composition, quantity of said stock composition contained in said stock composition container, price of said stock composition contained in said stock composition container, serial number of said stock composition container, place of manufacture of said stock composition, location of said stock composition container, date of manufacture of said stock composition, date of expiration of said stock composition, toxicity information of said stock composition, MSDS of said stock composition, manufacturer of said stock composition and contact information thereof;

or a combination thereof; and

wherein said stock component information comprises;

(b) identity of said stock component, compositional structure of said stock component, quantity of said stock component contained in said stock component container, price of said stock component contained in said stock component container, place of manufacture of said stock component, location of said stock component container, date of manufacture of said stock component, serial number of said stock component container, date of expiration of said stock component, toxicity information of said stock component, MSDS of said stock component, manufacturer of said stock component and contact information thereof;

or a combination thereof.

20. The process of claim 14 wherein said additional stock composition information comprises:

(a) identity of said additional stock composition, compositional structure of said additional stock composition, quantity of said additional stock composition contained in said additional stock composition container, price of said additional stock composition contained in said additional stock composition container, place of manufacture of said additional stock composition, location of said additional stock composition container, date of manufacture of said additional stock composition, serial number of said additional stock composition container, date of expiration of said additional stock composition, toxicity information of said additional stock composition, MSDS of said additional stock composition, manufacturer of said additional stock composition and contact information thereof;

or a combination thereof; and

wherein said missing stock component information comprises;

(b) identity of said missing stock component, compositional structure of said missing stock component, quantity of said missing stock component contained in said missing stock component container, price of said missing stock component contained in said missing stock component container, place of manufacture of said missing stock component, location of said missing stock component container, serial number of said missing stock component container, date of manufacture of said missing stock component, date of expiration of said missing stock component, toxicity information of said missing stock component, MSDS of said missing stock component, manufacturer of said missing stock component and contact information thereof;

or a combination thereof.

21. The process of claim 18 or 20 wherein said identification tag is a RFID tag, a bar code tag or a combination thereof.

22. The process of claim 21 wherein said identification tag interrogator is a RFID tag interrogator.

23. The process of claim 22 wherein said identification tag is a passive or active RFID tag.

24. The process of claim 23 wherein said passive or said active RFID tag is disposed on an insulated substrate.

26. The process of claim 16 wherein said updated inventory is stored on a storage identification tag.

27. The process of claim 26 wherein said storage identification tag is a RFID tag, a bar code tag or a combination thereof.

28. The process of claim 27 comprising writing said updated inventory to said storage identification tag.

29. The process of claim 1 or 17 wherein said required items from said inventory are dispensed in an identified target composition receiver.

30. The process of claim 29 comprises supplying some or all of said required items to augment said updated inventory.

31. The process of claim 29 said identified target composition receiver is provided with a target composition identification tag.

32. The process of claim 31 wherein said target composition identification tag is a RFID tag, a bar code tag or a combination thereof.

33. The process of claim 32 comprising writing to said target composition identification tag a target composition information comprising identity of said target composition, compositional structure of said target composition, quantity of said target composition contained in said target composition content receiver, price of said target composition contained in said target composition content receiver, place of manufacture of said target composition, location of said target composition content receiver, date of manufacture of said target composition, serial number of said target composition content receiver, date of expiration of said target composition, toxicity information of said target composition, MSDS of said target composition, manufacturer of said target composition and contact information thereof;

or a combination thereof.

34. The process of claim 33 wherein said target composition information is written to said target composition identification tag with said identification tag interrogator.

35. The process of claim 34 wherein said identification tag interrogator is a RFID interrogator or a bar code interrogator.

36. The process of claim 1 wherein said target composition is an OEM automotive paint, refinish automotive paint, architectural paint, industrial coating composition, fragrance, dye, printing ink, ink jet ink, lubricant, cement, nail polish, flavor, food colorant, eye shadow, deodorant, shampoo, hair conditioner, adhesive, perfume, caulk, masonry wall repair kit, catalyst blend, pharmaceutical drug, food additive, polymer blend, blend of reactants;

blends of food products;

or a point-of-purchase consumer product.

19. The process of 10 wherein said stock composition containers, said stock component containers, or a combination thereof are positioned in one or more stock racks of a device for monitoring production of said target composition.

25. The process of 14 wherein said additional stock composition containers, missing stock component containers, or a combination thereof are positioned in one or more stock racks of a device for monitoring production of said target composition.

37. A process for monitoring production of a target composition comprising:

(A) entering identification criteria of said target composition on a client computer or on a host computer in communication with said client computer;

(B) searching a first database residing on said client computer or on said host computer for identifying one or more characteristics associated with said identification criteria;

(C) searching a second database residing on said client computer or said host computer for one or more formulas associated with said characteristics, said formula providing a required inventory that lists required items for making a desired amount of said target composition;

(D) generating a current inventory;

(E) storing said current inventory on said client computer or on said host computer;

(F) comparing said current inventory against said required inventory to ascertain whether said current inventory fulfills said required inventory;

(G) generating a supplementary inventory if said current inventory partially fulfills said required inventory wherein said supplementary inventory stored on said client computer or on said host computer;

(H) dispensing said required items listed in said required inventory from current items listed in said current inventory, supplementary items listed in said supplementary inventory, or a combination thereof to make said desired amount of said target composition;

(I) generating an updated inventory; and

(J) storing said updated inventory on said client computer or on said host computer.

38. The process of claim 37 wherein said second database is stored on said host computer.

39. The process of claim 38 wherein said stored inventory is stored on said host computer.

40. The process of claim 39 wherein said updated inventory is stored on said host computer.

41. The process of claim 37 or 40 further comprising supplying some or all of said required items to augment said updated inventory.

42. A process for monitoring production of a target composition comprising:

(A) receiving identification criteria of said target composition from a client computer in communication with a host computer;

(B) searching a first database for, identifying one or more characteristics associated with said identification criteria, said first database residing on said host computer;

(C) searching a second database residing on said host computer for one or more said formulas associated with said characteristics, said formula providing a required inventory that lists required items for making a desired amount of said target composition;

(D) receiving a current inventory from said client computer;

(E) comparing said current inventory against said required inventory to ascertain whether said current inventory fulfills said required inventory;

(F) generating a supplementary inventory if said current inventory partially fulfills said required inventory wherein said supplementary inventory stored on said client computer or on said host computer;

(G) dispensing said required items listed in said required inventory from current items listed in said current inventory, supplementary items listed in said supplementary inventory, or a combination thereof to make said desired amount of said target composition;

(H) generating an updated inventory; and

(I) storing said updated inventory on said client computer or on said host computer.

43. The process of claim 42 further comprising supplying some or all of required items in said required inventory to augment said updated inventory.

44. A process for monitoring production of a target composition comprising:

(A) receiving identification criteria of said target composition from a client computer in communication with a host computer;

(B) searching a first database for identifying one or more characteristics associated with said identification criteria, said first database residing on said host computer;

(C) searching a second database residing on said host computer for one or more said formulas associated with said characteristics, said formula providing a required inventory that lists required items for making a desired amount of said target composition;

(D) receiving a current inventory from said client computer;

(E) sending to said client computer said formulas;

(F) receiving from said client computer an updated inventory; and

(G) storing said updated inventory on said host computer.

45. The process of claim 44 further comprising supplying some or all of required items in said required inventory to augment said updated inventory.

46. A process for monitoring production of a target composition comprising:

(A) identifying one or more formulas associated with identification criteria of said target composition, said formula providing a required inventory that lists required items for making a desired amount of said target composition;

(B) generating a current inventory wherein said step (B) comprises;

(B1) reading with one or more identification tag interrogators;

(i) stock composition information on stock composition identification tags affixed to stock composition containers that contain said stock composition,

(ii) stock component information on stock components identification tags affixed to stock component containers that match said target components, or

(iii) a combination of (i) and (ii); and

(B2) storing said current inventory;

(C) comparing said current inventory against said required inventory to ascertain whether said current inventory fulfills said required inventory;

(D) generating a supplementary inventory if said current inventory partially fulfills said required inventory;

(E) dispensing said required items listed in said required inventory from current items listed in said current inventory, supplementary items listed in said supplementary inventory, or a combination thereof to make said desired amount of said target composition;

wherein said current items in said current inventory comprise;

(E1) one or more stock compositions matching characteristics associated with said identification criteria and quantities thereof required to make said desired amount of said target composition;

(E2) stock target components and quantities thereof listed in said formula that are required to make said desired amount of said target composition;

or

(E3) a combination of (E1) and (E2); and

(F) generating an updated inventory.

47. A process for monitoring production of a target composition comprising:

(A) identifying one or more formulas associated with identification criteria of said target composition, said formula providing a required inventory that lists required items for making a desired amount of said target composition;

(B) generating a current inventory;

(C) comparing said current inventory against said required inventory to ascertain whether said current inventory fulfills said required inventory;

(D) generating a supplementary inventory if said current inventory partially fulfills said required inventory;

(E) dispensing in an identified target composition receiver said required items listed in said required inventory from current items listed in said current inventory, supplementary items listed in said supplementary inventory, or a combination thereof to make said desired amount of said target composition and

(F) generating an updated inventory.