With the support of
the Federal Research Centre
"Computer Science and Control" of
the Russian Academy of Sciences
"The more genius plan, the less people will agree with it"
COST PLANNING SERVICE
The widest area of the Service usage is the budgeting, although the Service allows to plan the supplies of any scarce resource flexibly and efficiently.
Income is a variable for millions of individuals and companies. It may depend on the volume of sales, market prices, exchange rates and many other factors. However, even on a state level, expenditures are often planned on the basis of point assumptions about the total income. If such assumptions are wrong, the budget is to be altered. The planning results are also presented by exact value for each expense item, although in practice most of the costs can not be predicted accurately.
To address these shortcomings, we have developed innovative computational methods and implemented them in the proposed Service. It has practical importance for:
We do not offer one more accounting program, where planning is often understood as entering expected revenues and addition of expenses with monitoring of the balance.
We offer the progressive tool for distribution of expected resource amount between expense items, which drastically enhances efficiency and flexibility of planning.
If you specify bounds for resource and requests cautiously and follow the plan prepared with the Service, you drastically reduce the probability of going beyond the budget.
For each expense item you beforehand see the bounds for possible costs, and you narrow them in the course of the plan implementation.
If upper bound is less than minimum request for some item, then you can timely attract investments, or exclude item, or correct other costs.
If the planning results are too "tight", you can temporarily exclude any expense item from consideration: just put a "tick" in the corresponding cell of the table.
You can simulate any real cost: set minimum request equal to maximum, mark it as obligatory, execute the command 'Allocate', and see the changes of bounds for the rest of expense items.
You can manually adjust the planning results. The application will indicate if the entered data is inconsistent.
ANY RESOURCE. APPLICABLE PRECISION.
You can specify any name and units of measure for your resource (USD, thousand euro; tonnes, etc.), and the applied precision for planning. The applied precision is the minimum significant resource amount for the specified units of measure: from 0.0001 to 1 billion. All the data will be rounded to that number. Computation results are rounded with a special algorithm, keeping the right sum, taking into account the requests and priorities. This allows, in particular, to solve the integer problems.
ANY NUMBER OF DETAIL LEVELS.
You can create a separate table of details for each expense item. Amount of the resource allocated to the expense item will be distributed between expense items that form its details.
The number of detail levels is not limited, so you can define a hierarchy of resource consumption. For each table of expense items, you can set its own flag 'Use weighting coef.' and data precision. The 'Allocate' command may be executed for the entire hierarchy or a part of it.
Two examples of the cost planning tasks will be installed on your workplace with client application: business.cpw and family.cpw. You can use them as data sources for your own tasks. The example for small business is used in the video presentation.
Client applications provide a familiar interface for work with spreadsheets of expense items.
Calculations results, erroneous and illogical data are highlighted in color (green, red, blue).
You can specify calendar periods as expense items: the convenient interface is provided.
Each planning task is stored in a separate file, so you can copy it from one workplace to another. In one task, you can plan allocation of several separate resources.
You can copy/paste data between different tables of Cost Planning tasks and Microsoft Excel, OpenOffice Calc, LibreOffice Calc and other spreadsheets. Special import/export operations are provided for files in MS Excel format (XLS, XLSX).
Requests from client application to the Service contain only numbers: names of resources, measure units, expense items are not needed for the calculations, so they are not transmitted through the Internet. The Service just performs calculations, sends the results, and terminates connection. All data of your tasks are stored on your side only. The server stores only registration data of your workplaces.
The basic ideas of algorithm belong to Professor Vladimir D. Ilyin. Alexander V. Ilyin has developed the modified algorithm and described it and the suggested Service in the paper "Method of cost planning and its implementation in online service" which was published in 2014.
If you want to see several screenshots of the client application (resource specification dialog, general view, execution and result of the command 'Allocate', entering actual cost), please follow this link. The screenshots were made using the example of planning costs for a small business (data is random).
Download installer of the client application (version 1.2)
(the installers are digitally signed, please ignore possible warnings from your browser)
Prices for individuals (including support and all application updates)
Prices of versions adapted for organizations
(including support and all application updates)
If you want to use the Service in your own client application, please contact us. We can discuss the terms of agreement, which will allow you to use a simple communication protocol of the Service.
For corporate customers it is possible to develop a multi user version of client application which will use a corporate database management system.
Copyright © 2013-2018 Alexander V. Ilyin, Russia, Individual Entrepreneur's State Registration Number 306770000015343. All rights reserved.
The page contains the image provided by Deleket under the Creative Commons Attribution-No Derivative Works 3.0 Unported license; the image provided by Visual Pharm under the Creative Commons Attribution-No Derivative Works 3.0 Unported license; the image provided by Aha-Soft under the Creative Commons (Attribution-Share Alike 3.0 Unported) license