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).

Error creating thumbnail: File missing

For all the other products, data must be entered on a monthly basis. For greater convenience of plan data entry, it is advisable to switch the vertical and horizontal axes (see illustration).

Error creating thumbnail: File missing

Hint  Instead of monthly data, you can also enter seasonal distributions and enter your plan data in the yearly planning mask. This is recommended when your revenue for different products, profit centres, or countries are largely similar or are distributed over the year in a largely predictable way. If necessary, you can then correct these values in the monthly planning mask.

For yearly and monthly planning masks, please refer to p. 77f.

Input  The number of units (quantity) must be entered for each month. As the price in this example does not vary, it can be entered on the yearly node. It will then be automatically distributed over the months.

[[Image:EE_Revenue planning price.jpg|thumb|center]

The “Sales” field is automatically calculated, so that no input is required here (the field is greyed out). The “VAT rates” column is set to 20% by default. If necessary, you can manually change this value by clicking on a cell with the mouse. The same applies to the “Payment key” column (default = “Immediately”).

[[Image:EE_Revenue planning VAT.jpg|thumb|center]

You can enter any VAT rates and payment keys that you need. How to change these values to fit your requirements is explained in Example 2 (Planning parameters: Payment keys). Data entry for the remaining products is performed in a similar fashion.

Now the plan changes: In September 2010, you sell an additional 30 units of “Aparo 8.28” to a sports school at a unit price of €550. The filter settings (company, PC/CC, types of revenue, and time) remain unchanged.

To enter the additional changes, you need to switch to the detail record mask.

Input  Left-click on the top left corner (the blue triangle) of the column where you want to make the changes. (In this example, the column is “September 2010”.)

[[Image:EE_Revenue planning detail.jpg|thumb|center]

The following window will open:

[[Image:EE_Revenue planning detail record mask.jpg|thumb|center]

The existing plan data record will be visible in the detail record mask (please refer to p. 33f.)

Input  To create a new data record, click the “Create new record” symbol and enter your new plan data.

[[Image:EE_Revenue planning Create new record.jpg|thumb|center]

Input  To exit the detail record view, click “Close”. You will be returned to the planning mask window.