Tutorial:Planning turnover on monthly basis

To enter domestic revenues from merchandise for the year 2010 for the cost centre “E-Bike KTM” of the company Bike GmbH:

First, you must enter the desired filter and column settings.

Error creating thumbnail: File missing

In general, you can enter your sales either in terms of quantity and price or in terms of absolute sales. The “Sales” column is an automatically calculated field (greyed out and not editable).

To plan revenues for the “E-Bike KTM” product group:

The annual and monthly columns contain numbers of units. The price is planned per unit, in Euros, excluding VAT.

Name	Year	J	F	M	A	M	J	J	A	S	O	N	D	Price	Addit. sales
eRace	24	2	2	2	2	2	2	2	2	2	2	2	2	1.500	45.000 p.a
eCross	150	3	4	12	25	30	25	18	10	4	5	12	2	900	15.000 in May
eTrail	40	0	0	3	4	9	15	4	1	0	4	0	0	1.300
eFun	244	5	7	23	27	45	55	42	37	29	12	13	4	600
Aparo 8.28	197	1	4	12	35	40	34	29	12	7	16	4	3	650

In the case of the most expensive model, eRace, the customer has a special option to pay 50% of the price immediately and the balance in the following month. All other models must be paid for immediately (payment key: 15 days).

Hint  The product “eRace” is planned in a linear fashion (the same number of units sold each month). Thus the total quantity (25 units) is entered on the yearly node and distributed in linear fashion across the months.

Input  For the product “eRace”, you can enter all your plan data in the year 2010 (node).