Product Oil Second Distribution System
一、 Summary
Distribution is considered to be the third profit source of enterprises. It’s a link between vendor and market requirement. It’s an important means for

enterprise to improve production efficiency and service quality. But for the reasons of distribution network complexity, distribution method variety,

resource restriction and market requirement dynamic change, it’s quite a difficult issue for petroleum industry to schedule distribution and sales. Product

Oil Second Distribution System Solution is going to optimize Northwest Sales Company resource and distribution. Reduce production cost and distribution cost,

thereby maximize distribution profit and distribution ability. This helps PetroChina Regional Sales Company in:
●  Predict based on requirement. Improve prediction precision.
●  Resource optimization in each region
●  Optimize distribution, reduce cost in order to achieve optimization scenario.
●  Oil product resource automatic configuration
●  Optimize schedule through oil product and inventory configuration.
●  Integrate distribution requirement, transfer and exist business modules as well as ERP.
●  Use united PetroChina standard EIP for business running.
二、System construction
Construction modules contain:
● Market Demand predictive
●  Second Distribution Schedule Optimization
●  Second Distribution Coordination
Second Distribution Scheduling module creates market demanding data based on Market Predict module. Thereby create monthly/yearly sales schedule. These data

is used by coordination module to plan daily/weekly/monthly coordination.。
Second Distribution System also contains a vendor data base to store distribution network, sales business principle and some formulas. It gets data from ERP

and other systems via interfaces. Then it would transform these data and store it in the database.
三、 System function
1、 Market prediction
 Use all kinds of calculation to make prediction

 Define collection levels in system

 Generate predictive result in all levels

 Predictive data can be collective and analyzed in different levels. User can modify these data.

 Support ABC user classification. User can define other classifications.

 User can check and modify offline data.

 Define GUI based on user requirement(i.e.sales representative can use different GUI from manager.

 System can correct wrong distribution record: illogical distribution or package.

 Support predictive flow control.
 
2、 Schedule Optimization

 Distribution schedule module takes all refinery factory and depots into consideration.

 Schedule modules schedule various kinds of distribution methods including road, railway, pipeline and the connections.

 All fuel grades sales are considered.

 Multi-cycle scheduling and inventory scheduling. If ERP is integrated with vendor database, it can take data from the data sources.

 Support minimum cost and maximum profit scheduling.

 Sales Scheduling take refinery factory minimum production plan into account.

 Module contains vendor, distribution module and distribution ability restrict.

 SAND can establish Ethanol blending module, quality upgrade module and octane enhancing module.

 If sales system has additional product, SAND can help decide where to sell these products.
 
3、 Second Distribution Dispatch

 Generate period dispatch plan(daily plan, weekly plan – the period can be set as customer required), then arrange unloading place.

 Dispatch system is using data of monthly distribution mode of every product and distribution terminal.

 Predict in certain period, the dynamic change of product stock.
  Based on graphic
  Process stock types:
1）total stock
2）dead stock
3） confirmed stock

 Flexibly check available product quantity.

 It tells how much time the terminal depot stock can be used.

 Based on quantity already been sent, adjust predictive quantity.

 Provide gap between planed quantity and actual quantity, and selection mode to satisfy user.

 Flexibly define all kinds of user graphics.

 Organize multi-product distribution for railway distribution needs.

 Dispatch system is not only based on user order, but also order and predictive quantity. System manages the relationships between order quantity and

predictive quantities.

 Provide simulator for vendor chain to analyze events on line.

 Provide alarms for over stock, out of stock, late delivery and so on.