new features required for a projects report in a business plan style incl. liquidity reporting #112

tj-advanced-user opened this Issue Apr 17, 2013 · 0 comments


None yet
1 participant

Hi Chris,
according to your suggestion I am putting the idea of a business plan like report as a new feature request

The enclosed file represents a typical business plan. Such a business plan aggregates all activities of an entity such as a company. There are a number of BP tools usually developed under the view of accounting and cost location.

However, modern modellings understand commercial entities as a network of activities bundled in projects with allocated ressources, time frame, responsibilities, and more. Moreover, total quality management systems also describe the activities in a company as a network of different projects/tasks. All these aspects are already available in the taskjuggler tool.

Below I will explain the enclosed BP and understand it as a special type of report. I will also bring in some ideas how the different postions in the tables could be defined using the current tj structure, also providing some ideas about some possible additions.

TJ models the reality based on the concept of projects, tasks and resources. The later has already nice parameters and tools to cover equipment/materials and staff which both spend the resource cash represented by the parameter RATE and related ones. So far, a negative amount of rate which could be used to define a cash producing resource is not available. Such a resource could represent a product but also a payment such as a loan or company investment.

I will try to load a list of a typical BP as attachment. But anyway, lets go through the rows of the BP tables to understand what that would mean.

Profit from turnover (Σ)
Aggregation of the pament resulting from producing-tasks/projects. This could be realized by aggregation of related accounts.

Product 1/ Market 1 / Product 2/ Market 2 / Rendering of services 1 etc.
List of tasks with allocated spending cash ressources but also cash producing resources. Utilisation of this ressouces, i.e. cashing, could be defined at the beginning, along or a the end of a sreies of tasks.
Rent income and Licence refunding are just other exaples of such production tasks.

Interest received
Tasks with a spending resource „Cash Saving“ and a „production“ resource interest can easily reflect money saving and interest income. See also table „iterest and redeption plan“ which just need the definition of money income and interest payment.

Company profit
This position is the sum of the related accounts / account position fro above

  • Cost of materials (Σ) Preproduct 1 / Preproduct 2
    Such costs could be allocated to spending resources defined in the producing tasks and summarized in certain accounts. To keep flexibility and avoid the need to define many different accounts a summary (aggregation) using the flag-system would be helpful (see also personnal costs)
  • Personnel costs(Σ)
    The personnel costs are principally the sum of a certain group of ressources. However, in larger BP proposals an overview of allocatd costs to different units are required.
    Employing of a person can be defined already as a tj project composed of tasks such as hireing, regular payment and education phases in order to reflect activities performed by the human ressources unit. Anticipated gratiications can be also introduced into this task. Social insurance costs are frequently a fraction of the salary. Thus, accounting of a payment fraction would simplify definition. The emplyment task definition would also enable the setting of a milestone „birthday“ which could be send as an alert to the respnsible human resouces person.
  • Depreciation
    Depreciation can be obtained from the investing tasks (see below=
  • Costs of interest
    Costs of interest can be obtained by aggregation of accounts defined in credit tasks (see also below)
  • Other company costs (Σ)
    The positions of other company costs can be defined as ressscources with a regular spending rate or can be defined as task groups with allocated spending.

Trading results
Sum of spending and payment accounts from above

Financial grants (Σ)
Financial grants are a very complex topic because of the large variety of funding roles and usually depend as perentage of the spent costs, the factoring is performed anytime along the time of the project. These roles can be represented in the related spending tasks such as investing and other projects.

Tax on profits
Fraction of the overall profit

Overall outcome
total profit / loss (can be negative)

Investment and Depreciation Plan
The representation of an investment can be defined as a simple or complex task. Depending on the complexity of the investment and the required depth of details, installation, quality control related activities and teaching can be nicely defined as subtasks with alloation of time and resources as well as maintenance activities.

Credit table
The positions in the credit table lists the most important credit types which can also be understood as projects/tasks with time related payments and costs.Currently this topic can be realised by the credit parameters but such could be avoided b the introduction of a positive rate in the resource defiition. Cumulation of individual credit accounts by payment, redemtion and interest would fulfill the needs of this table.

Liquidity planning (Detail planning)
While the profit/loss table provides information about the status of the company for owner and shareholders, the liquidity planning (Detail planning) table is essential for the survaval of an entity such as a company. The liquidity is depending on the actual costs and payments/credits which are the result of the complex network of internal projects. It must be always positive and projected negative figures must be alerted and indicate the need to react.

The required complexity of the project which must be defined for a BP above is quite high and the raw tj-project file will easily have several thousand lines which cannot be handled and maintained. However, there are a few powerful properties of tj which can be used to simplify the programming. By using the macro tool of tj, it is possible to condense the essential informations for resources and tasks to a few parameters which can be stored listwise. The underlying informations of resources can be taken from available lists (e.g. staff, equipment). Tasks are defined usually by parameters such as a topic, start and end time, allocated resources, responsibilities as well as preceding and following tasks. You also can group ressources and tasks, and there is a highly flexible flags system which can be used for selective adressing project data sets.

A taskjuggler based business plan also enables to update the progress of all tasks and evaluate changes in projects on their influence on liquidity in scenarios.

Hope.that the extensive description of these ideas help to interest more people in using tj for advanced project / company management including accounting and to allocate ressources for implementing the required tj modifications.



Example Busines plan - Finanacial planning - 1
Example Busines plan - Finanacial planning - 2
Example Busines plan - Finanacial planning - 3
Example Busines plan - Finanacial planning - 4
Example Busines plan - Finanacial planning - 5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment