Core Balancing and Trading Tool

Target

Core management. Creating prognosis for reflow and sales from two different stocks. Stocks will be balanced, thereafter needs will be listed for differential buying

Responsibility

Process modeling, definition and optimization of workflow,
programming and user interface in updateable tool

Tasks

Mathematic modeling due to Holt-Winters
Iterative Clearing of prognosis (ex-post)
Interface to PDM-Systems
Qualifying of stocks Buy/Sell
Evaluation of buying lists based on cheapest offer

Realisation

Combination of huge database (10.000 articles with In/Out of the last two years) in combination with iterative calculation
Data is hosted in access, parameters and modular calculations executed in Excel
recordsets are exported sequential, prognosis are calculated by iteration, results are visualized by excerpts and graphics.
Key results are listed in database by reimport
After completition of calculations KPIs are determined automatically for survey
Automatic ranking and update of cross-Listing
Automatic classification of In/Out articles to assure integrity

Summary

Reduction of stocks rd. 1 Mio. Cores
Production assured for long term
Prize ratio due to vorausschauend buying
Buying ratio through balancing of two plants
Monthly controlling and optimization by KPI Charts