System and method for managing product development

• US 6,862,585 B2
• Filed: 03/14/2001
• Issued: 03/01/2005
• Est. Priority Date: 12/19/2000
• Status: Expired due to Term

• Current Assignee: The Procter & Gamble Company
• Original Assignee: The Procter & Gamble Company
• Inventors: Deflander, Joseph Fernand, Planalp, John Eugene, Kopcha, Suzanne Miranda
• Primary Examiner(s): Le, Uyen
• Assistant Examiner(s): THAI, HANH B
• Application Number:
  US09/805,791
• Publication Number:
  US 20020143726A1
• Time in Patent Office: 1,448 Days
• Field of Search: 707/1, 707/104.1, 707200-202, 705/7, 705/10
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A system, method, and computer readable storage medium for managing product development include a relational database containing draft, approved, and archived versions of product, package, materials, process, and artwork technical data for use by product development personnel in providing a structured set of data output for use in a supply chain. In one embodiment, the relational database includes objects having data to describe design requirements of a finished product component such as a formula, material, package, and the like. Text documents may be linked to the relational data structure by reference to provide design requirements not amenable to a structured data format, such as test methods, process instructions, and the like. The system, method, and computer readable storage medium provide for electronic communication and electronic approval of data subsets while tracking changes and archiving previous versions for subsequent access or reference. System validation and ongoing change control provide necessary support for products in regulated industries.

Claims

1. A method for managing product development, the method comprising:

storing technical requirements data for a product including product data, material data, and packaging data in a structured relational database;

linking unstructured documents to the technical requirements data within the structured relational database;

grouping technical requirements data into technical requirements summaries to define a finished product;

linking the technical requirements summaries for the finished product to facilitate user navigation and searchability among related technical requirements summaries;

recording changes made to the technical requirements data and associated user identification information;

storing approval information for the technical requirements data in the relational database; and

electronically communicating approved technical requirements data for use in manufacturing and distributing the finished product.

2. The method of claim 1 wherein the step of storing approval information comprises storing an electronic signature which uniquely identifies a user.

3. The method of claim 1 wherein the step of linking unstructured documents comprises associating structured attributes with the unstructured documents and storing the associated structured attributes in the relational database.

4. The method of claim 1 further comprising:

validating the technical requirements data during entry relative to previously entered technical requirements data based on predetermined rules.

5. The method of claim 1 wherein the technical requirements summaries include at least two levels of summaries, the method further comprising:

storing separate approval information for each level of technical requirements summaries.

6. The method of claim 5 wherein the levels of summaries include at least a master level approved by a first user and an individual level approved by the same user or by a different user.

7. The method of claim 5 wherein the levels of summaries include at least a master level and a plurality of individual level summaries associated with at least one master level summary.

8. The method of claim 1 wherein the technical requirements summaries include a formula card, a raw material specification, a packing standard, a packaging material specification, a supplier approval, and an approved country matrix.

9. The method of claim 1 further comprising:

limiting access to subsets of technical requirements data based on a user identification and password.

10. The method of claim 1 wherein the step of grouping technical requirements data comprises grouping data to form different technical requirements summaries based on requirements or practices of a particular geographic region.

11. The method of claim 1 wherein the step of grouping technical requirements data comprises combining different technical requirements data to form technical requirements summaries based on requirements or practices of business units within an organization.

12. The method of claim 1 wherein the step of storing technical requirements data comprises storing draft versions of the technical requirements data.

13. The method of claim 1 wherein the step of storing technical requirements data comprises storing approved technical requirements data.

14. The method of claim 1 wherein the step of storing technical requirements data comprises storing archived technical requirements data.

15. The method of claim 1 wherein the step of storing technical requirements data comprises:

storing draft, approved, and archived versions of the technical requirements data; and

linking the draft, approved, and archived versions of the technical requirements within the relational database.

16. The method of claim 1 wherein the step of grouping technical requirements data into technical requirements summaries comprises grouping product components, product amounts, in-process product measures, and finished product measures into a formula card.

17. The method of claim 1 wherein the step of grouping technical requirements data into technical requirements summaries comprises grouping package components, package amounts, in-process package measures, and finished package measures into a packing standard.

18. The method of claim 17 wherein the packing standard comprises consumer level data, customer level data, and transport level data.

19. The method of claim 18 wherein the consumer level data comprises primary package data and a product formula.

20. The method of claim 18 wherein a single business group develops the consumer level data, the customer level data, and the transport level data.

21. The method of claim 18 further comprising creating and approving each level of data within a different business group.

22. The method of claim 1 wherein the step of grouping technical requirements data into technical requirements summaries comprises grouping product constituents and associated levels for a given raw and packaging material into a raw and packaging material specification.

23. The method of claim 22 further comprising:

separating the raw and packaging material specification into a master level and an individual level, the master level including technical information and the individual level containing logistical and shipping information.

24. The method of claim 1 wherein the step of grouping technical requirements data into technical requirements summaries comprises grouping packaging constituents and associated levels for a given packaging material into a packaging material specification.

25. The method of claim 24 further comprising:

separating the packaging material specification into a master level containing technical information and an individual level containing logistical and shipping information.

26. The method of claim 1 wherein the step of grouping technical requirements data into technical requirements summaries comprises grouping raw material data by approved supplier.

27. The method of claim 1 wherein the step of grouping technical requirements data into technical requirements summaries comprises grouping finished products by approved country of sale.

28. The method of claim 1 wherein the step of linking unstructured documents comprises linking text documents to the technical requirements data.

29. The method of claim 28 wherein the text documents specify test methods, process standards, general standards, standard operating procedures, or recommended procedures.

30. The method of claim 1 wherein the step of linking unstructured documents comprises linking artwork for product packaging to the technical requirements data.

42. The system of claim 31 method of claim 1 wherein the module for grouping technical requirements data into technical requirements summaries groups product components, product amounts, in-process product measures, and finished product measures into a formula card.

31. A system for managing product development, the system comprising:

a technical requirements data module for a product including product data, material data, and packaging data in a structured relational database;

a module for linking unstructured documents to the technical requirements data within the relational database;

a module for grouping technical requirements data into technical requirements summaries to define a finished product;

a module for linking the technical requirements summaries for the finished product to facilitate user navigation among related technical requirements summaries;

a module for recording changes made to the technical requirements data and associated user identification information;

a module for storing approval information for the technical requirements data in the relational database; and

a module for electronically communicating approved technical requirements data for use in manufacturing and distributing the finished product.

32. The system of claim 31 wherein the module for storing approval information stores an electronic signature which uniquely identifies a user.

33. The system of claim 31 wherein the module for linking unstructured documents associates structured attributes with the unstructured documents and stores the associated structured attributes in the relational database.

34. The system of claim 31 wherein the technical requirements summaries include at least two levels of summaries, the system further comprising:

means for storing separate approval information for each level of technical requirements summaries.

35. The system of claim 34 wherein the levels of summaries include at least a master level approved by a first user and an individual level approved by a second user.

36. The system of claim 34 wherein the levels of summaries include at least a master level and a plurality of individual level summaries associated with at least one master level summary.

37. The system of claim 31 wherein the technical requirements summaries include a formula card, a raw material specification, a packing standard, a packaging material specification, and a supplier approval and approved country matrix.

38. The system of claim 31 further comprising:

a module for limiting access to subsets of technical requirements data based on a user identification and password.

39. The system of claim 31 wherein the module for grouping technical requirements data groups data to form different technical requirements summaries based on requirements or practices of a particular geographic region.

40. The system of claim 31 wherein the technical requirements data module includes draft versions of the technical requirements data.

41. The system of claim 32 wherein the technical requirements data module includes draft, approved, and archived versions of the technical requirements data;

wherein the draft, approved, and archived versions of the technical requirements are linked within the relational database.

43. The system of claim 31 wherein the module for grouping technical requirements data into technical requirements summaries groups package components, package amounts, in-process product measures, and finished package measures into a packing standard.

44. The system of claim 43 wherein the packing standard comprises consumer level data, customer level data, and transport level data.

45. The system of claim 44 wherein the consumer level data comprises primary package data and a link to a product formula.

46. The system of claim 31 wherein the module for grouping technical requirements data into technical requirements summaries groups product constituents and associated levels for a given raw material into a raw material specification.

47. The system of claim 46 wherein the module for grouping technical requirements data creates a master level raw materials specification and an individual level raw materials specification, the master level including technical information and the individual level containing logistical and shipping information, the master and individual levels being individually reviewed and approved.

48. The system of claim 31 wherein the module for grouping technical requirements data into technical requirements summaries groups raw and packaging constituents and associated levels for a given raw and packaging material into a packaging material specification.

49. The system of claim 48 wherein the module for grouping technical requirements creates a master level material specification containing technical information and an individual level containing logistical and shipping information.

50. The system of claim 31 wherein the module for grouping technical requirements data into technical requirements summaries groups raw material data by approved supplier.

51. The system of claim 31 wherein the module for grouping technical requirements data into technical requirements summaries groups finished products by approved country of sale.

52. The system of claim 31 wherein the module for linking unstructured documents links text documents to the technical requirements data by reference to a stored file containing at least one text document.

53. The system of claim 52 wherein the text documents specify test methods, process standards, general standards, standard operating procedures, or recommended procedures.

54. The system of claim 31 wherein the module for linking unstructured documents links artwork for product packaging to the technical requirements data by reference to a stored file containing associated artwork specifications or graphics.

55. A computer readable storage medium having stored data representing instructions executable by a computer to manage product development, the computer readable storage medium comprising:

instructions for storing technical requirements data for a product including product data, material data, and packaging data in a structured relational database;

instructions for linking unstructured documents to the technical requirements data within the structured relational database;

instructions for grouping technical requirements data into technical requirements summaries to define a finished product;

instructions for linking the technical requirements summaries for the finished product to facilitate user navigation among related technical requirements summaries;

instructions for recording changes made to the technical requirements data and associated user identification information;

instructions for storing approval information for the technical requirements data in the relational database; and

instructions for electronically communicating approved technical requirements data for use in manufacturing and distributing the finished product.

56. The computer readable storage medium of claim 55 wherein the instructions for storing approval information comprise instructions for storing an electronic signature which uniquely identifies a user.

57. The computer readable storage medium of claim 55 wherein the instructions for linking unstructured documents comprise instructions for associating structured attributes with the unstructured documents and storing the associated structured attributes in the relational database.

58. The computer readable storage medium of claim 55 further comprising:

instructions for validating the technical requirements data during entry relative to previously entered technical requirements data based on predetermined rules.

59. The computer readable storage medium of claim 55 wherein the technical requirements summaries include at least two levels of summaries, the computer readable storage medium further comprising:

instructions for storing separate approval information for each level of technical requirements summaries.

60. The computer readable storage medium of claim 59 wherein the levels of summaries include at least a master level approved by a first user and an individual level approved by the first user or a second user.

61. The computer readable storage medium of claim 59 wherein the levels of summaries include at least a master level and a plurality of individual level summaries associated with at least one master level summary.

62. The computer readable storage medium of claim 55 wherein the technical requirements summaries include a formula card, a raw material specification, a packing standard, a packaging material specification, a supplier approval, and an approved country matrix.

63. The computer readable storage medium of claim 55 further comprising:

instructions for limiting access to subsets of technical requirements data based on a user identification and password.

64. The computer readable storage medium of claim 55 wherein the instructions for grouping technical requirements data comprise instructions for grouping data to form different technical requirements summaries based on requirements or practices of a particular geographic region.

65. The computer readable storage medium of claim 55 wherein the instructions for grouping technical requirements data comprise instructions for combining different technical requirements data to form technical requirements summaries based on requirements or practices of business units within an organization.

66. The computer readable storage medium of claim 55 wherein the instructions for storing technical requirements data comprise instructions for storing draft versions of the technical requirements data.

67. The computer readable storage medium of claim 55 wherein the instructions for storing technical requirements data comprise instructions for storing approval information associated with the technical requirements data.

68. The computer readable storage medium of claim 55 wherein the instructions for storing technical requirements data comprise:

instructions for storing draft, approved, and archived versions of the technical requirements data; and

instructions for linking the draft, approved, and archived versions of the technical requirements within the relational database.

69. The computer readable storage medium of claim 55 wherein the instructions for grouping technical requirements data into technical requirements summaries comprise instructions for grouping product components, product amounts, in-process product measures, and finished product measures into a formula card.

70. The computer readable storage medium of claim 55 wherein the instructions for grouping technical requirements data into technical requirements summaries comprise instructions for grouping package components, package amounts, in-process product measures, and finished package measures into a packing standard.

71. The computer readable storage medium of claim 70 wherein the packing standard comprises consumer level data, customer level data, and transport level data.

72. The computer readable storage medium of claim 55 wherein the instructions for grouping technical requirements data into technical requirements summaries comprise instructions for grouping product constituents and associated levels for a given raw or package material into a raw or package material specification, respectively.