Research & development
This module is the basic module of the entire system. In addition to the program it includes a pre-loaded database, here after described. This module allows the control of the whole activity of laboratory R&D. The center of this module is the formula, around of which all other data are associated, e.g.: ingredient list for labeling and exportation, stability test, challenge test, linked customers, linked products, product MSDS, etc. The formula can be considered as the basis of the rest of the system.
Pre-loaded Data Base
base contains Manufacturers and Raw Materials, defined as “Source Data Base” to distinguish it from the User’s data base, described later on here. The searching possibilities are wide, easy and complete.
Manufacturers
In addition to the regular data (address, phone, fax, etc.) there is the list of all raw materials manufactured.
Source Raw Material
Each single raw materials presents a preloaded list of data. E.g.:
- INCI Name-US
- INCI Name-EU
- Chemical name
- Technical Name
- Mixture & Components (when a raw material is a mixture)
- Used in mixture (when a raw material is a mixture component)
- Functions
- Other Language: at the moment there are Spanish and Japanese names
- CAS Number(s)
- Color Index
- EINECS Number
Regulatory Information
There are three pre-loaded legislation’s: European Legislation, Japanese Legislation and American FDA regulatory information (in this late case, there is also a list of specification for all regulated raw materials). Anyway, the user is able to insert new legislation’s, new annexes even to modify pre-loaded annexes. The system offers the capability to consult all raw materials regulated by each annex.
User’s data files
Customers
This is a user’s file. It can include all customers for which products are developed and/or manufactured. This data file contains all data necessary to identify the customer, to prepare invoices and associated items, formulae and purchased finished products.
Suppliers
All effective suppliers can be included in this file. This data file contains the list of all items already purchased and provided from each supplier.
User’s Raw Materials
This file includes all raw materials effectively used in the user’s formulae. Starting from a given raw material, automatically it is possible to know all formulae using it along with the relevant percentage. All information related to raw materials are stored in this section. In addition to data already described for the source raw material data file, other data fields are available. A few examples:
- MSDS
- HMIS Label
- Alternative Raw Materials: this entry offers the capability to specify which other raw materials can be considered as alternative by the user for the same products
- Formulae: this entry allows the user to consult which formulae include the raw material, along with the relevant percentage
- Toxicological Data: this entry is reserved to a function which gives the possible toxicological impact of the use of products including the raw material as an ingredient on human body
- Suppliers & Costs: this entry lists all suppliers along with the cost of the current raw material. The cost allows the user to prepare the cost of formulae, the cost of manufactured lots of bulk and finished products
- Notes
- FDA data for CRVP program
- Associated Customers: customer(s) having the property of a stock of the current raw material. This is an entry which is particularly helpful to third party companies
- Maximum employment percentage: when the user sets this limit then the system will control that formulae including the current raw material do not exceed this value
- Related Regulatory Information
Formulae
This can be considered as the main file of the entire system. All user’s formulae are here. All pieces of information regarding the formulae are here, e.g.:
- Ingredient list -which is prepared automatically-
- Manufacturing Instructions
- Formula MSDS
- Stability Tests
- Challenge Tests
- Ingredients, listed in any possible names. 100% is controlled
- Formula ingredient list -product label- in up to 8 formats for EU and US
- Manufacturing Instructions: there is no limit to the number of phases. Each phase contains a list of ingredients and a text to describe the phase operations. Header and trailer texts are available. Manufacturing Instructions are the basis for the Manufacturing Ticket
- Notes
- Analyses
- Derived formulae: this is meaningful for those products belonging to a series diversified only for shades and/or fragrances. This entry can be helpful to obtain a general product label headed to the pilot formula
- Formula derivation: this entry allows to consult the entire history of the previous version of the same formula
- Customers: this entry can be helpful for third party companies to associate a formula to a specific customer
- Products: this entry allows the user to consult all the products using the current formula
- MSDS: this is the MSDS relevant to the formula (not to be confused with Raw Material MSDS). User can insert the MSDS for any formula
- Stability Tests: this entry allows the user to store stability test. The system warns the list of products under test having a date for evaluation. There is a graphic to show the performance of the product. The system recalls the evaluation which are about to expire depending on the calendar of each single test in progress
- Challenge Tests: this is similar to the previous stability test. The challenge test allows the user to store up to 8 bacteria families per single test
- Formula Comparison: this function can compare up to 8 formulae at a time. The comparison is carried out as for percentages of the same ingredient as for the cost
- Batch Reports: a series of reports is available
|
