The long term lasting project contains support and implementation works for the clients planning systems
Supplement
During the project different tasks have to be done. For the development Oracle SQL / PL-SQL and the SQL Navigator are used.
Subject description
The planning system contains modules for price calculation, quantities planning and revenue estimation. The pricing module includes contract master data and price formulas for gas shipping constracts. Using these data and external price indices sales prices are calculated. The quantities planning module uses contract data for the corresponding year to derive sales quantities from the delivery quantities. The results of price calculation and quantities planning are used to estimate the total revenue.