What is the basis of the method of C2BII? Part 3: Event Type & Impact Group

The “Event Type” is the main guiding tool, thru which forecasts are entered into the system. For set-up purposes, think of “Event Types” as simply a title, under which we will create and associate the elements of the next level.

The “Impact Groups” represent the ledger entries (Accounting and Warehouse Item) that are needed to depict the transaction according to the rules of “Accounting 101”. Each “Impact Group” contains information about :

  • the value that will be handled by it, in most cases expressed as a percentage of the sum of the value of the entry
  • whether it is debit or credit
  • its “Time Orientation” (whether it is a concentrated monthly entry, or a weekly entry etc), that determines the number of “Analytical Lines” under that specific “Impact Group”
  • info about the date, on which the “Analytical Lines”  are expected to occur
  • plus other relevant info.

On the basis of the previous example, the “Event Type – Impact Groups” structure will look like this:

The way that the two structures relate to each other is the following:

Stick around, as we are going to see the third and final level, which is the “Analytical Lines”.

Posted in Budget, Budgeting, C2BII Instructions, CashFlow, Financial Analysis, Financial Analysis Method, Investment Plan Evaluation | Tagged , , , , , , , , | Leave a comment

What is the basis of the method of C2BII? Part 2: “Accounting 101” on steroids

A few articles ago, we discussed about the fact that the “Double Entry bookkeeping system” has been in use for centuries to calculate “Profit & Loss”. Since we are going to tweek “Accounting 101” in order to make it able to handle data in a concentrated form, let us first see what entries would have taken place, if we were addressing individual invoices. We will work with an example of sales.

Since lines 1 and 5 cancel each other (over time), we are going to forget them and concentrate on lines 2,3 and 4, plus the entry in the “Warehouse Item Ledger” (since at Fiscal Year End we must be able to perform a valuation of “Residual Stocks of Goods” in order to establish the “Cost of Goods Sold”).

Stick around, as we are going to see how we are to see the first two levels of the three level hierarchy (Event Type – Impact Groups – Analytical Lines).

Posted in Budget, Budgeting, C2BII Instructions, CashFlow, Financial Analysis, Financial Analysis Method, Investment Plan Evaluation | Tagged , , , , , , | Leave a comment

What is the basis of the method of C2BII? Part 1: Finding the right questions

A few articles ago, we discussed about the fact that the “Double Entry bookkeeping system” has been in use for centuries in order to calculate “Profit & Loss”, but traditional Accounting and ERPs cannot be used to calculate “Profit & Loss” in Financial Analysis scenarios. However, if we manage to tweek “Accounting 101” and put it on steroids, we will have a method that will leapfrog anything that currently exists, and solve all those unsolvable problems we have mentioned. In order to do that, first we must ask ourselves the correct questions, and then we must come up with the answers to them. Here is a small starting list of some relevant questions. They are about the nature of concentrated data, or in other words, of Budgeting forecasts.

When we say that “we are expected to sell X value of goods”, what is the time dimension of the word “sell”? In most cases, we forecast sales on a monthly basis of period. However, that is not the rule. For example, supermarkets create Budget projections for sales on a weekly basis, which is the buying pattern of their main customer, which is the housewife. In other cases, we might have completely user defined periods, like periods of 37 days (example: a ship that makes the trip from port A to port B in 37 days) etc.

On which days of the period do we sell? Most companies sell from Monday to Friday. In Greece, supermarkets sell from Monday to Saturday. Hotels sell every day of the week. Theaters sell Wednesday to Sunday. And so on …..

Every day of the period, is not equal to the others. Let’s take the example of a supermarket. On Friday afternoons and on Saturdays, the check-out lines are enormous, and so are the sales volumes. On Mondays the check-out lines are tiny. On Tuesdays there’s a little more traffic, and so on. So we see that seasonality exists within the days of a period.

Stick around, as we are going to see how we are going to tweek “Accounting 101” and put it on steroids, in order to handle those challenges.

Posted in Budget, Budgeting, C2BII Instructions, CashFlow, Financial Analysis, Financial Analysis Method, Investment Plan Evaluation | Tagged , , , , , , | 1 Comment