This is one of 4544 IT projects that we have successfully completed with our customers.

How can we support you?

Optimization of the stock levels in machines

Project duration: 1 year, 11 months

Brief description

A technical concept for the optimization of the stock levels in cigarette machines is implemented as a prototype, to allow verification of the mathematical model used in it. This calculation module can then be incorporated into the existing system on the data scanning devices, allowing the optimization to be carried out just in time, i.e. on every delivery trip to the cigarette machine.

Supplement

To calculate the ideal stock levels for a machine, as part of a prototype approach, a program will be created for a notebook, which will receive the latest stock flow data for a machine via an MDE device and provide information on the flow data history. During a later development stage, the logic for updating the flow data will be converted for aggregated data. This reduces the quantity structure in this area by a factor of 40, resulting in shorter processing times. Because the calculation module for the program is provided on an MDE device for later integration with an existing DotNet program environment, it is developed in C# DotNet, exclusively using functions that are available in the Compact Framework of DotNet 2.0. Data is saved in a mobile Oracle Lite 10g database. To enable detailed and easy-to-repeat tests, NUnit is used to create unit tests for the individual processing steps and complex scenarios.

Subject description

Using current flows of packages and previously-saved historic flow data, the minimum stock filling level for each individual type of product in a machine is recalculated, with the secondary condition that the type of product cannot be allowed to be fully used up before the machine is filled again. The result is provided to the field services employee in the form of a fill document. The calculation is based on a statistical model that determines the proposed refill from the updated statistical data while taking into account various safety factors that affect application for individual types of products differently, depending on location, type, installation location and other influencing factors.

Overview

Project period18.04.2006 - 15.03.2008

Have we sparked your interest?

Marcus Rödiger

Retail sector manager

Jetzt Kontakt aufnehmen

Contact now

Download file