GL Budget N/A

Date.Date YQMD 2013

Forecast Amount ACY1 NAV Column Labels

Row Labels January February March April May June July August September October November December Grand Total

5 - KLASA: RASHODI -92.781 0 0 0 0 0 0 0 0 0 0 0 -92.781PROJEKAT A -40.500 -40.500

PROJEKAT B -32.000 -32.000

-18.000 -18.000

-2.281 -2.281

0 0

6 - KLASA: PRIHODI 132.600 0 0 0 0 0 0 0 0 0 0 0 132.600PROJEKAT A 0 0

PROJEKAT B 112.000 112.000

13.000 13.000

0 0

2.400 2.400

5.200 5.200

0 0

Grand Total 39.819 0 0 0 0 0 0 0 0 0 0 0 39.819

GL Budget (Multiple Items)

Date.Date YQMD 2013

Forecast Amount ACY1 NAV Column Labels

Row Labels January February March April May June July August September October November December Grand Total

5 - KLASA: RASHODI -51.881 -15.886 -5.079 -3.055 -19.343 -38.359 -1.394 -1.500 -23.867 -3.696 -1.393 -43.600 -209.052PROJEKAT A 0 -1.200 -1.200 0 -2.400

PROJEKAT B -8.291 -8.291

PROJEKAT C -1.301 -1.301

a -3.277 -3.277

a -800 -600 -600 -600 -600 -600 -600 -600 -600 -600 -600 -13.200 -20.000

a -28.220 -28.220

a -2.272 -2.272

a -2.123 -2.123

a -2.610 -4.796 -7.406

a -4.837 -4.837

a -12.960 -2.729 -15.689

a -2.123 -2.123

a -15.853 -14.624 -30.477

a -576 -576

a -576 -1.814 -2.390

a -1.670 -2.337 -4.007

a -550 -550 -550 -550 -550 -550 -550 -550 -550 -550 -550 -550 -6.600

a -1.301 -1.301

a -88 -234 -4.510 -244 -350 -732 -243 -3.065 -9.465

a -798 -798

a -23.486 -23.486

a -1.028 -1.028

a -2.623 -2.623

a -960 -960

a -4.946 -4.946

a -951 -951

a -1.300 -1.300

a -14.070 -14.070

a -6.138 -6.138

6 - KLASA: PRIHODI 131.912 97.091 43.923 29.182 52.526 80.156 17.512 14.934 42.024 24.472 21.212 53.602 608.546PROJEKAT A 0 0 0 0

PROJEKAT B 2.300 1.100 1.100 1.100 1.100 12.155 1.100 1.100 1.100 1.100 1.100 1.100 25.455

PROJEKAT C 0 0 1.734 1.734

a 500 500

a 12.600 11.500 8.695 1.000 5.520 520 520 520 520 520 520 520 42.955

a 3.449 3.449

a 34.300 300 300 300 300 300 300 300 300 300 300 300 37.600

a 100 100 100 100 100 100 100 100 100 100 100 100 1.200

a 450 300 300 300 300 300 300 300 300 300 300 3.329 6.779

a 3.305 325 325 325 325 325 325 325 325 325 325 325 6.880

a 23.180 27.130 3.680 9.100 300 300 300 300 6.694 300 300 300 71.884

a 300 300 300 300 6.749 300 300 300 300 300 300 300 10.049

a 21.600 4.549 26.149

a 1.000 400 400 400 400 3.231 400 400 400 400 400 400 8.231

a 2.500 2.000 1.000 1.000 1.000 22.137 1.000 1.000 20.499 1.000 1.000 1.000 55.136

a 150 918 150 150 150 150 150 150 150 150 150 150 2.568

a 100 100 100 100 100 100 100 100 100 100 100 100 1.200

a 750 200 200 200 200 968 200 200 200 2.618 200 200 6.136

a 7.400 7.400 4.176 3.116 22.092

a 1.200 1.200 1.200 1.200 1.200 1.200 1.200 1.200 1.200 1.200 1.200 1.200 14.400

a 1.734 1.734

a 818 300 300 917 8.527 300 787 1.889 300 1.764 922 6.254 23.078

a 1.597 7.680 5.400 3.000 3.900 5.100 3.180 300 300 9.155 9.155 500 49.267

a 450 450 450 450 450 450 450 450 450 450 450 450 5.400

a 5.362 5.162 1.800 1.800 1.800 1.800 1.800 1.800 1.800 1.800 1.800 33.114 59.838

a 1.370 1.370

a 3.915 380 4.295

a 2.982 1.280 4.262

a 50 50

a 9.025 4.116 4.116 4.340 6.594 10.269 38.460

a 200 200 200 200 200 1.468 200 200 200 200 200 200 3.668

a 100 100 100 100 1.833 100 100 100 100 100 100 100 2.933

a 2.330 2.330

a 18.760 500 1.300 6.510 5.450 3.200 2.400 790 790 790 790 41.280

a 400 400 400 400 400 8.584 400 400 400 400 400 400 12.984

a 1.100 1.100 1.100 1.100 1.100 1.100 1.100 1.100 1.100 1.100 1.100 1.100 13.200

Grand Total 80.030 81.205 38.844 26.127 33.183 41.797 16.119 13.434 18.157 20.777 19.819 10.002 399.494

GL Budget (Multiple Items)

Date.Date YQMD 2013

Forecast Amount ACY1 NAV Column Labels

Row Labels January February March April May June July August September October November December Grand Total

5 - KLASA: RASHODI -1.840 -2.295 -5.003 -3.903 -13.200 -960 -27.201CRM_AA - Plan prodaje - početak zbira -1.840 -2.295 -5.003 -3.903 -13.200 -960 -27.201

CRM - PROJ 1 -2.295 -1.500 -3.795

CRM - PROJ 2 -1.200 -1.200

a -3.503 -3.503 -960 -7.966

a -400 -400

a -12.000 -12.000

a -1.840 -1.840

6 - KLASA: PRIHODI 2.960 7.100 16.157 14.257 42.250 20.750 4.550 4.550 5.330 5.330 1.920 125.154CRM_AA - Plan prodaje - početak zbira 2.960 7.100 16.157 14.257 42.250 20.750 4.550 4.550 5.330 5.330 1.920 125.154

CRM - PROJ 1 2.700 3.000 4.500 10.200

CRM - PROJ 2 7.500 7.500

a 3.700 8.757 8.757 2.750 2.750 4.550 4.550 5.330 5.330 1.920 48.394

a 1.000 2.000 3.000

a 30.000 18.000 48.000

a 2.960 700 4.400 8.060

Grand Total 1.120 4.805 11.154 10.354 29.050 20.750 4.550 4.550 5.330 5.330 960 97.953

Date.Date YMD 2013

Sell-to Out No

Receivables Balance ACY Column Labels

Before

due

Before due

Total Overdue

Overdue

TotalGrand

Total

Row Labels

Before

due over

91 days

Before

due 61 -

90 days

Before

due 31 -

60 days

Before

due

under 30

Overdue

under 30

days

Overdue

31 - 60

days

Overdue

61 - 90

days

Overdue

91 - 120

days

Overdue

121 - 150

days

Overdue

151 - 180

days

Overdue

181 - 365

days

Overdue

1 - 2

years

KUPAC X 5.100 5.100 5.100 5.100 20.400 8.976 3.956 5.225 3.954 4.177 5.154 27.696 59.140 79.540

KUPAC Y 44.005 44.005 88.010 950 1.918 17.304 8.735 28.908 116.918

KUPAC Z 9.057 216 10.874 6.663 26.809 26.809

a 3.937 9.740 13.677 13.677

a 8.097 4.470 12.567 12.567

a 11.052 98 11.150 11.150

a 3.880 1.991 5.870 5.870

a 3.637 739 743 724 5.843 5.843

a 1.596 638 1.284 488 1.069 308 5.384 5.384

a 5.367 5.367 5.367

a 4.247 4.247 4.247

a 1.768 1.177 1.184 4.129 4.129

a 1.016 102 1.016 296 1.016 102 3.547 3.547

a 746 739 743 751 2.979 2.979

a 2.607 2.607 2.607

a 2.487 2.487 2.487

a 124 123 1.078 750 2.076 2.076

a 2.038 2.038 2.038

a 610 610 610 1.829 1.829

a 1.318 119 1.436 1.436

a 1.244 1.244 1.244

a 372 368 371 1.111 1.111

a 975 975 975

a 626 244 870 870

a 763 763 763

a 13.775 13.775 13.775 41.326 373 370 743 42.069

a 124 312 436 436

a 366 366 366

a 152 152 305 305

a -179 346 167 167

a 149 149 149

a 302 151 452 452

a -910 -910 -910

KUPAC K -2.640 -2.640 -2.640

Grand Total 5.100 18.875 63.182 63.031 150.188 62.672 22.464 50.995 21.110 7.012 5.564 33.815 2.038 205.670 355.858

Date YQMD 2013

Payables Balance ACY Column Labels

Before due

Before

due Total Overdue

Overdue

Total

Grand

Total

Row Labels

Before due 61

- 90 days

Before due

31 - 60 days

Before

due

under

30 days

Overdue

under 30

days

Overd

ue 31 -

60

days

Overd

ue 61 -

90

days

Overd

ue 91 -

120

days

Overd

ue 181

- 365

days

Over

due 1

- 2

years

DOBAVLJAČ X 5.714 5.655 11.369 11.369

DOBAVLJAČ Y 292 396 688 688

DOBAVLJAČ Z 332 332 332

a -32 161 22 150 150

a 33 0 33 33

a 7 7 7

a 0 0 0

a 0 0 0

a 2.610 2.610 2.610

a 518 -518 0 0

a 0 0 0

a 0 0 0

a 374 76.939 1.995 79.307 79.307

a -31 -36 -67 -67

a -76 -76 -76

a -89 -89 -89

a -94 -94 -94

a -156 -156 -156

a -198 -198 -198

a -263 -263 -263

a -518 -518 -518

a -1.446 -1.446 -1.446

DOBAVLJAČ K -1.585 -1.585 -1.585

Grand Total 374 76.939 4.604 81.917 2.594 5.101 -358 396 354 0 8.087 90.004

Forecast

RealizacijaGK (od početka godine do poslednjeg dana u prošlom mesecu) + BudgetGK_All (do kraja godine)

Prodaja 132.600 100.091 49.923 38.182 64.526 103.156 45.512 30.934 75.024 56.472 44.212 173.602

Kumulativ prodaje 132.600 232.691 282.614 320.796 385.322 488.478 533.990 564.924 639.948 696.420 740.632 914.234

Januar Februar Mart April Maj Jun Jul Avgust Septembar Oktobar Novembar Decembar UKUPNO

Rezultat GK: 39.819 0 0 0 0 0 0 0 0 0 0 0 39.819Troškovi -92.781 0 0 0 0 0 0 0 0 0 0 0 -92.781

Prihodi 132.600 0 0 0 0 0 0 0 0 0 0 0 132.600

NAV Backlog: 0 56.205 13.844 1.127 5.183 13.797 -11.882 -14.566 -9.843 -16.528 -9.181 -24.998 3.159Trošak redovnog poslovanja 0 -25.000 -25.000 -25.000 -28.000 -28.000 -28.000 -28.000 -28.000 -28.000 -29.000 -35.000 -307.000

Troškovi 0 -15.886 -5.079 -3.055 -19.343 -38.359 -1.394 -1.500 -23.867 -13.000 -1.393 -43.600 -166.475

Prihodi 0 97.091 43.923 29.182 52.526 80.156 17.512 14.934 42.024 24.472 21.212 53.602 476.634

CRM plan: 0 1.160 3.705 3.997 8.097 9.800 6.000 4.000 26.000 8.000 15.000 68.000 153.759Troškovi 0 -1.840 -2.295 -5.003 -3.903 -13.200 -22.000 -12.000 -7.000 -24.000 -8.000 -52.000 -151.241

Prihodi 0 3.000 6.000 9.000 12.000 23.000 28.000 16.000 33.000 32.000 23.000 120.000 305.000

Forecast: 39.819 57.365 17.549 5.124 13.280 23.597 -5.882 -10.566 16.157 -8.528 5.819 43.002 196.738Kumulativni rezultat 39.819 97.184 114.733 119.857 133.137 156.734 150.852 140.287 156.444 147.916 153.735 196.738

Očekivana korekcija

CashFlow

BankRac i CF 50.994 50.994 315.734 360.133 396.348 388.447 449.056 415.474 358.849 367.640 356.612 319.508 315.814 315.814

CF bilans perioda 0 264.740 44.399 36.215 -7.901 60.609 -33.581 -56.625 8.791 -11.028 -37.105 -3.694 264.820

Potraživanja 228.000 94.758 28.000 5.100 355.858

Forecast dod. Potraživanja 134.706 77.726 41.315 31.919 95.993 19.762 15.734 43.634 24.472 21.212 53.602 560.076

Dugovanja -4.604 -76.939 -374 -8.087 -90.004

Forecast dod. dugovanja -68.361 -20.147 -1.726 -2.833 -1.384 -19.343 -38.359 -844 -1.500 -23.317 -16.296 -194.109

Trošak redovnog poslovanja -25.000 -25.000 -25.000 -28.000 -28.000 -28.000 -28.000 -28.000 -28.000 -29.000 -35.000 -307.000

Rezervisanja 0 0 -6.000 -6.000 -6.000 -6.000 -6.000 -6.000 -6.000 -6.000 -6.000 -6.000 -60.000

Januar Februar Mart April Maj Jun Jul Avgust Septembar Oktobar Novembar Decembar

Rezultat perioda 39.819 57.365 17.549 5.124 13.280 23.597 -5.882 -10.566 16.157 -8.528 5.819 43.002

Kumulativni rezultat 39.819 97.184 114.733 119.857 133.137 156.734 150.852 140.287 156.444 147.916 153.735 196.738

-50.000

0

50.000

100.000

150.000

200.000

250.000

EUR