CASPIAN JOURNAL

MANAGEMENT AND HIGH TECHNOLOGIES

Application of linear optimization for offsetting of money balances in accounts during utility billing process

Read Fedosin Aleksandr S. Application of linear optimization for offsetting of money balances in accounts during utility billing process // Caspian journal : management and high technologies. — 2015. — №1. — pp. 155-166.

Fedosin Aleksandr S. - post-graduate student, Mordovia State University, 39 B. Khmelnitskiy St., Saransk, 430005, Russian Federation, nsdfxela@gmail.com

The article describes an approach for solving payments “distribution costs” problem that takes place in process of utility billing for citizens, with using of large billing systems. The detailed description of problem and some of its hypothetical consequences is presented. Described method is based on linear programming techniques usage. Much attention is given to the formulation of optimization problem. The technical details of propsed method implementation designed for billing system of LLC "Saransk Clearing Centre" are provided. The general descriptions of used software and modelling tools are noted. Attention is drawn to the questions of using the Microsoft Solution Framework with RDBMS Microsoft SQL Server which is the basement of said billing’s storage subsystem. Data are given about results of built solution applying for money balances offsetting in accounts of given set of apartment houses in given settlement period.

Key words: линейная оптимизация, модель, симплекс-метод, ЖКХ, биллинг, взаимозачет, клиринг, выравнивание остатков, издержки расщепления, OML, linear optimization, model, simplex-method, utility services, billing, netting, clearing, offsetting of money balances, dis