TriFoil System Overview From Global Directions, Inc'

1
TriFoil System OverviewFrom Global
Directions, Inc.

• Software Designed for theFlavors and Fragrance
  Industries

2
Three Basic Components
FormulaManagement
ProjectManagement
RegulatoryReview
3
Formula Management

• AromaCISPerfumery formula creation and
  management system.
• FlavorCISFlavor formula creation and management
  system.

4
Project Management

• ProCISFormula library system and project
  tracking system. Both Flavor and Fragrance
  versions.
• SamTrackSample tracking system with labeling,
  packing lists, and basic inventory.

5
Regulatory Review

• CheckCISUser interface program for maintaining
  the regulatory data.
• ICheckA background program that uses the data in
  CheckCIS to do the actual checking of formulas.

6
Data Base

• Oracle 9i is being used for all server based
  applications (ProCIS, CheckCIS, and SamTrack)
• Personal 9i for the AromaCIS and FlavorCIS
  applications

7
Development Environment

• Oracle Forms for ProCIS, SamTrack, and CheckCIS.
• Microsoft Visual C for AromaCIS, FlavorCIS, and
  ICheck.

8
AromaCIS Highlights

• Formula Management
• Formula Editing
• Multiple Formula Viewing
• Temporary Sub Formulas
• True Sub Formulas at any number of levels
• What If Costing
• Show Multiple Columns of Additional Data
• Classic PerForm view of formulas or new
  multiple formula view.

9
AromaCIS Highlights

• Project Information Tracking
• Personal Notes on Formulas and Ingredients
• Send Formulas To
• Other Users Using AromaCIS Locally
• Server for Registration
• Off Site via Email (Encrypted data)
• Aroma Dictionary
• Multiple Methods for Dilution Support
• Corporate Wide Standard Dilutions Only
• Temporary Dilutions

10
AromaCIS Highlights

• Global Replace items are now stored on the server
  and the global replace is done whenever a formula
  is opened in the editor or in a batch mode.
• Where Used is integrated with the editor
• Multiple Level search is supported.
• Convenient Tree View is used.
• Can open a formula with a double click on the
  entry in the tree listing.

11
Screen Shot of AromaCIS Editor
12
Easy To Use Lookup

• AromaCIS supports lookup views of the data.
• Lookup Views can be customized as to data
  displayed.
• Dynamic Lookup similar to the XICIS software.
• The next view shows the formula lookup view.

13
AromaCIS Formula Lookup
Dynamic Lookup
Sort ByField
Columns CanBe ChangedBy User.
14
ProCIS Highlights

• Complete Profile Tracking System
• Multiple formula types per profile
• Any number of submission requirements
• Reference to previous work done
• Centralized Customer Data
• Multiple locations for a single customer
• Standard submission requirements

15
ProCIS Highlights

• Formula Evaluation Library
• Multiple descriptors per formula
• Multiple application test results
• Linked to the AromaCIS database
• Submission History
• Cross reference to selling number
• Snapshot of quoted price and formula cost

16
ProCIS Highlights

• Sample Tracking Module
• Local sample inventory
• Tracks all samples sent to a customer
• Packing slips and label printing
• Compounding requests generated directly from the
  ProCIS system.
• All sample requests and sample preparation are
  archived for historical review.

17
ICheck/CheckCIS Highlights

• Multiple equivalency files allows formulas to be
  exploded in any number of ways.
• Batches of formulas can be queued up for review.
• Easy user interface from AromaCIS or the ProCIS
  system.

18
ICheck Interface from AromaCIS
19
ICheck/CheckCIS Highlights

• Any number of criteria can be added by the
  regulatory data manager
• Supports generic items
• Supports special groups of items
• Supports quenching
• Supports photo toxins
• Does full explosion of the formula

20
ICheck Features

• ICheck runs as a separate program on the server
  or any workstation.
• User interface show current status and allows for
  dynamically changing of ICheck parameters.
• ICheck writes results to data tables that are
  archived for retrieval at any future date thus
  giving full audit capabilities.
• Reports are generated as needed.

21
ICheck User Interface
22
TRIFOIL ADVANTAGES

• Standard Relational Database
• Lower Support Requirements
• More Functionality built into the System
• Consistency Enforced by Database
• Business Rules Built Into Database
• Reports Can Be Built External to the Application.

23
ADVANTAGES (continued)

• Remote Support of Database as needed
• World Wide Data Sharing
• Excellent Development Tools
• Easily Extended for Future Expansion

24
Benefits of TriFoil

• Flexibility in development
• Faster formula development
• Preparation of only sellable formulas
• Faster response to customer requests
• Elimination of paperwork, label preparation,
  duplication
• Statistics for customer success rates

25
Current Status of Development

• Fragrance Software is complete with three
  customer using the new system and the fourth to
  go live by April, 2004.
• Flavor Software will be ready for full
  implementation by the end of May, 2004.

26
Contact Information

• Global Directions, Inc.
• William E. Bruggeror Midge Barron
• Phone [phone]Email
  www.bruggercis.com