National Food Services Management System

1
National Food Services Management System

• Unitrak
• Presented by Captain J. Denny-McKinstry,
  DLBM/Food S 5-3
• for CFICSE

2
Outline.

• How Unitrak Came to Be
• Concerns/Competence/Success Potential

3
Project Background
4
Project Background

• Working group formed in November 1999
• Comparative Analysis Study
• Technical Feasibility Study

5
Comparative Analysis
Conduct an objective functional and
technical analysis
6
Potential Options

• ADRA current current ADRA application (reverse
  engineering, MS Access 97, stand-alone).
• ADRA enhanced Status quo changes/
  enhancements (reverse engineering, MS Access 97)
• ADRA enhanced- web  ADRA enhanced 
  accessible through the web (reverse engineering,
  conversion)

7
Potential Options (continued)

• ADRA Re-engineered ADRA rewritten with
  enhancements from Ships Program, CAFACS and
  Combat Ration program. In a distributed
  client-server environment using proper Project
  Methodology
• ADRA Re-engineered - Web ADRA rewritten with
  enhancements from Ships Program, CAFACS and
  Combat Ration program. Accessible through the
  web using proper Project Methodology

8
Options Considered (continued)

• FoodTrak customised Client-server
  architecture (SQL servers) (could be web-enabled)
  
• proVision customised Microsoft Access
  97/Microsoft SQL servers (no roll-up to central
  database), has been customised for the British
  Royal Navy
• CBORD Each module is considered a system on its
  own, client-server architecture (Sybase SQL
  server), used by the United States Army, no
  individual software customisation

9
Evaluation Criteria

• Three types of criteria
• Functional
• Technical
• Reporting

10
Evaluation Criteria (continued)

• Functional Criteria
• Must be bilingual
• Must respond to the needs of users
• at all levels of management
• in all elements
• in all situations
• Must have proper project documentation

11
Evaluation Criteria (continued)

• Technical Criteria
• Must be able to roll-up data
• Reporting Criteria
• Must have graphs and charts

12
Cost and Effort Analysis

• Development/customisation

• Estimated implementation cost

• Estimated maintenance cost

13
Assumptions Used in Cost Estimates

• National system
• 30 screens, 25 reports
• 500 end-users
• 90 kitchens, 32 bases, 33 ships, 4 submarines
• Competitive process
• DND Translation bureau will perform all
  translation
• Only course Train-the-Trainers

14
Trade-off Summary
15
Final Decision
ADRA Re-engineered - Web
16
Sequence of EventsApproval, Funding and Name

• Business Plan and Final approval from J4 Mat/DG
  Log in March 2000 for project, funding and
  official name  Unitrak 

17
Platform -Technical Feasibility Study

• Oracle Database (Back-end)
• Oracle J Developer or Visual Studio 6 (Front-end)

18
Situation...

• Lowest Compliant Bid
• Fixed Firm Rate
• Phased Approach
• 11 month timeline

19
Proposed Timeline(11 months)
20
Sequence of Events (contd)

• User Acceptance Testing
• Note WRITTEN ACCEPTANCE OF EACH MODULE FOR
  CONTRACTOR PAYMENT
• Translate User Manual screens (DND Translation
  Bureau)
• Train-the-Trainers Course (CFSAL)
• Released after each Phase

21
Future...

• FMAS interface
• Integrated Program Management team in J4 Mat/DG
  Log for Help Desk/Maintenance

22
Concerns

• Project as a Priority
• budget
• personnel
• user feedback/acceptance

• Stakeholder Expectations
• contractor
• Sr management
• Users

• Maintainability
• Training
• Sr Food Svcs mgt
• continual

23
Competence
Acquirer
Competent
Incompetent
Competent
Developer
Incompetent
Compliments of Maj. R. Smith, CFICSE
24
Success Potential Chart

• Taken from the Standish Group Report, Chaos, 1995

25

• Questions ??