# Consumption Manager

The Consumption Manager is a specialized feature in the Stock module that allows automatic creation of consumption records based on component's operating hours. For each component spare part an estimated consumption (quantity per running hours) can be defined. This information is used during the lifetime of the component for automatically reducing the quantity of spare parts in stock without manual reporting of spare part consumption. Necessary restocking of spare parts can be tracked via a dedicated report.

# Preparation

The estimated spare part consumption can be defined in the Component Details editor, in the Spare Parts tab. Here you can add the spare parts to be managed and in columns Consumption and Hours the estimated consumption can be defined.

In addition to a manual definition of the basic values you can also use an Excel file with a special format that allows an comfortable initialization of the automatic tracking (contact support@zeeborn.net for details).

# Initialization via Excel file

If you want to use an Excel file for defining the basic data of the automatic spare part consumption tracking, a related Excel file can be imported in the Stock module via More Actions > Stock Reset (with Excel file).

All spare parts used in the Excel file must be added before to a catalog in the system. The import feature takes care that spare parts to be tracked will be added from catalog to the stock database of the related vessels/sites. Article details will be copied/updated, the spare part will be moved to the location defined in the Excel file and the current quantity will be set to 0. If the spare part already exists in the stock module of the vessel/site, the current quantity will be reset to 0 and a related tracking record will be created for the spare part.

# Start Tracking

The automatic tracking will be initialized by manually restocking the spare parts. The Manual Restock function available in the Consumption Manager is used for reporting the initial quantity in stock. Based on the running hour counter of the related component at the time of restocking, the stock quantity will be automatically reduced when the component's running hour counter reaches the defined interval.

# Daily Check

The daily check if a component has accumulated enough running hours that would trigger an automatic consumption of spare parts is usually included in the running hours interface. If such an automatic check is not established yet, the same check can also be started manually within the Consumption Manger in menu More Actions > Check Automatic Consumption.

# Monitoring

The current status of the automatic consumption can be found in the Consumption Manager if data are loaded including component details. For all vessels/sites in the system it will show the defined values for automatic consumption, current stock quantities and info about last automatic consumption triggered by each component.

# History Records

An overview about changes in stock quantities can be found in the article's details page. This page can be reached from various locations in the system, e.g. via Show Info function in Stock module.

Beside general article details the page also shows all components where the spare part is used, including defined consumption estimates, date/counter at last automatic spare part consumption and a detailed tracking record of all quantity changes caused by stock resets, manual restocking and automatic consumption.