FOLIO MANAGEMENT

MNCC Ships Inventory Control System


Introduction

The following presentation is designed to explain how the MNCC Ships' Inventory Control (SIC) system can help you manage the charts and publications on-board your vessels with the least possible effort.

We believe the SIC system is simple to operate and flexible, thereby allowing it to be easily integrated with your own current working practices.

Two areas are covered by this presentation:

1. A summary of how the system works.
2. Technical data relating to design method and structure.

The MPH SIC system was designed to keep chart and publication information fully up-to-date. Information is entered from weekly notices to mariners and from information obtained through regular contact with the various publishers.

Key Benefits

ü Instant access to complete chart and publication database

ü Instant access to ships indexes and folios

ü Instant access to correction information

ü Ability to print ad-hoc reports

ü Huge time-saving on manpower

ü System meets with ISM requirements
Plus
ü The system runs under Microsoft Windows95
or Windows NT Workstation

ü The system can be tailored to include individual
customer requirements

BENEFITS

MNCC is offering this system as a read-only database giving MNCC maintained security of data, with regular MNCC generated updates. The MNCC single data source prevents duplication of both records and effort, and negates the need for data synchronisation.

In essence, the MPH (SIC) system provides MNCC's customers with up-to-date information relating to their fleet documentation.
System Operation

The system is primarily designed to manage and maintain vessel/office chart and publication inventory.

Charts

The SIC database contains all British Admiralty, U.S., Canadian and Australian charts. The database stores the following key information against each chart record:

¨ Source
¨ Chart Reference
¨ Chart Title
¨ Chart Edition Date

The system can display a list of all vessels carrying a specified chart, along with the ship's folio number containing the chart, and the chart's consecutive number within the folio.



Publications

The MNCC SIC database contains around 1,000 Hydrographic and Technical publications such as:

British Admiralty
U.S.
Canadian
IMO
OCIMF/ICS
Nautical Institute
ITU
HMSO (TSO)
Lloyds

Publication information can be viewed on screen in the following row/column format:


Customers and Ships

The MPH SIC database contains a full list of MPH customers and customer vessels.
A full list of customer vessels may viewed from this screen by clicking the Customer Ships button.


A complete list of Chart Folios and Publication Sections carried on-board each vessel can be obtained from the Browse Customer Ships display.

Folios

The MNCC SIC database stores information relating to individual chart folios held on-board each vessel.

Chart information can be added, edited or deleted from a selected folio.

Publications

The MNCC SIC database stores information relating to publication sections held on-board each vessel.


Publication information can be added, edited or deleted from a selected section.

Report Options

The MNCC SIC is provided with several standard report formats.


Print Options


¨ Complete Indexes
¨ Individual Folios
¨ Publication Sections
¨ Correction Lists


Reports can be displayed to the screen or output directly to a printer or electronic mail system.


Technical Data

The MNCC Ship's Inventory Control System was developed in collaboration with Croydon based application's development company, Scott's Marketing & Systems Limited.

The application has been developed under Microsoft Access v8.0, and will run under Microsoft Windows95, 98 or Windows NT Workstation v4.0.

The application is 'network-ready' which means it can be installed and operational in both stand-alone and networked environments.

The application is supplied with three files, described as follows:

MPHDat97.MDB: the backend .MDB database file contains the database tables that stored raw data. In a network environment, this file would be situated on a shared network directory for multi-user access.

MPHApp97.MDB: the frontend .MDB application file contains the forms, reports, queries and code that control the operation of the system. This file is normally situated on the local hard disk of each user. The frontend file has table attachment links to the backend database file.

MPHSys97.MDW: the security .MDW file contains user permissions for each object contained within both .MDB database files.

The application is supplied with a free-of-charge runtime version of Microsoft Access v8.0 and full installation instructions.