Tabel 1.2 pag 7 De introdus valorile lui T

model previziunepreviziuni t+2 t+3 t+4

t+1 t+2 t+3 t+4 t+5 t 10 11 121 140.46 145.3484978842 153.039965625 161.22595306 169.927253061 putere t -0.06542 -0.06542 -0.065422 133.71 138.26 142.80 147.35 151.90 putere e 0.578 0.6358 0.69363 134.97 0 0 0 0

valori pentru t 9 10 11 12 13 De completatt+2 t+3 t+4

Tabel 1.3 pag 7 n 1 1 1

model previziunepreviziuni k 1 1 1

t+1 t+2 t+3 t+4 t+5 Y11 1002 100 Tabel 1.4 Obiective strategice pag 7

3100 110 136 120 105

Obiectiv UM Valori anul tNiveluri previzionate

100 110 149.6 179.52 188.496 t+1Cifra af

Tabel 1.6 pag 11 Producti

Produsul Rata prof in t Obiectiv profit Pret calculatRata prof

C 1,478.95 13.58% 17% 1,730.37 valori ciudate, tab 1.8 pag 13D 1,710.61 - 10% 1,881.67 Criteriu Articol Valoare t pondere

0 1 2 3Tabel 1.7 pag 12 - comun 1 654 40.47%

Criteriu Articol Valoare t pondere Ip g*ip 2 294.12 18.20%0 1 2 3 4 5 3 85.29 5.28%

1 240 18.30% 1.04 19.03% Total ch directe 1033.41 63.95%2 122.5 9.34% 1.05 9.81% 4 582.53 36.05%3 40.43 3.08% 1.05 3.24% 5 - -

Total ch directe 402.93 30.72% - - 6 - -4 206.11 15.71% 1.05 16.50% Cost sectie - -5 64.22 4.90% 1.05 5.14% 7 - -6 326.38 24.88% 1.05 26.12% Cost productie 1616 100.00%7 150.99 11.51% 1.05 12.09% 8 - -

Cost sectie 1150.63 87.72% - - 9 1,745 -9 161.15 12.28% 1.05 12.90% Rata profitului(prof/cost)% - -

Cost productie 1311.78 100.00% - 104.82%10 178.23 pagina 14 sus11 1490 C 1311.78 104.82% 1374.96912 283.1 D 1616 101.80% 1645.066513 1773.1 C pret negociat

Rata profitului(cost/prof)% 13.59% D pret negociat

Cost unitar previzionat

Tabel 2.1 pagina 15 Tabel 2.2 pagina 16

Nr crt ProdProd plan Pret unitar

Indice Nr crt ProdProductie

t t+1 t t+1 t2 S1 50,000 29,468 - - 58.94% 1 B 10,0003 S2 15,000 44,464 - - 296.43% 2 C 15,0004 R1 100,000 118,396 - - 118.40% 3 D 05 R2 70,000 29,468 - - 42.10% totaluri6 R3 35,000 44,464 - - 127.04% pret Po pret Ppl7 B 10,000 - 1400 1200 0.00% B 1400 12008 C 15,000 14,734 1490 1600 98.23% C 1490 16009 D 0 14,865 - 1800 #DIV/0! D 1676.25 1800

indice pret pentru C

Vm baza 276190 pagina 17personal baza 1352 Indicatori Incasari Cheltuieli adaospersonal plan 913 Vanzari 485,835 373,719 adaos valindice marguri 1.05 Prestari - -Vanzari previzionate de marfuri 485,835

Tabel 3.1 pagina 18Produse Stoc initial Productie Stoc final Vanzari Pret Incasari

1 2 3 4 5 6 7 ritm mediu 103.06%B 2300 0 0 2,300 1,200 2,760,000C 900 14,734 423 15,211 1,600 24,337,600D 0 14,865 402 14,463 1,800 26,033,400Total 3200 29,599 825 31,974 - 53,131,000

Tabel 3.2 pagina 18an t-3 t-2 t-1 t t+1 t+2 t+3 t+4 t+5C 30.60% 32.60% 32.80% 33.50% 34.53% 35.58% 36.67% 37.80% 38.96%D - - - - 17% 21.00% 25.00% 29.00% 33.00%

n+k-1= 4 5 6 7 8

Tabel 3.3 p19 Vanzari la EXPORT Tabel 3.4 pag19 Vanzari la internprodus volum vanzari p extern chelt suplim incasari exp eur Pod Volum Pret Incasari

1 2 3 4 5 1 2 3 4C 5,252 440 73.95 2,310,880 B 2,300 1,200 2,760,000D 2,459 510 136.85 1,254,090 C 9,959 1,600 15,934,400

5,251.826 3,564,970 D 12,004 1,800 21,607,200 TOTAL

2,458.710Tabel 3.6 p20 Chelt a prod exportate

Produs Cantit exp Cost unit Cost total Chel exp u Ch ex TOT Cost exp U Cost ex TC 5,252 1,478.95 7,767,456.78 73.95 388,372.8 1,552.90 8,155,829.6D 2,459 1,710.61 4,206,392.63 136.85 336,511.4 1,847.46 4,542,904.0Total 7,711 - 11,973,849.41 724,884.2 12,698,733.7

Tabel 3.7 Valoarea prod exportateProdus Cantit exp V int U V int TOT V ext V ext TT V ext EUR V ex EUR T

C 5,252 1,600 8,403,200 1606 8,434,712.0 440 2,310,880D 2,459 1,800 4,426,200 1861.5 4,577,428.5 510 1,254,090Total 7,711 - 12,829,400 - - 3,564,970

Tabelul 3.8 pag 20 Calcul curs revenire BRUTProdus Cantit exp C pr ex Cpr exp T V pr in U V pr in TOT C rev U C rev TOT

C 5,252 1,552.90 8,155,829.62 1,600 8,403,200 3.8044 3.804D 2,459 1,847.46 4,542,904.04 1,800 4,426,200 3.7977 3.798Total 7,711 - 12,698,733.66 - 12,829,400 - 3.8021

Tabel 3.9 p 21 Calcul curs de revenire CorectatProdus Cantit exp C pr ex Cpr exp T V prod exp V prod exp Crc Un Crc TOT

C 5,252 1,552.90 8,155,829.62 440 2,310,880 3.5293 3.5293D 2,459 1,847.46 4,542,904.04 510 1,254,090 3.6225 3.6225Total 7,711 - 12,698,733.66 - 3,564,970 - 3.5621

Table 3.10 p21 Valoarea materialelor importate si exportabileLEI EURO V mat exportabile

Produs Cantit exp V mat imp V mat imp TO V mat imp V mat impT unit totalC 5,252D 2,459Total 7,711

V prod exp Ch spec exp Curs revenire netProdus Cantit exp U TOT U TOT U TOT

C 5,252 73.95 388,372.84D 2,459 136.85 336,511.41Total 7,711 - - 724,884.25 -

Tabel 3.14 Sezonalitatea la intern

AnulSubperioada TOTAL suma aia

1 2 3 41 100% 95.00% 124.00% 118.00% 437% 4.372 105% 98.00% 126.00% 125.00% 454% 9.083 112% 108.00% 135.00% 141.00% 496% 14.884 117% 113.00% 140.00% 152.00% 522% 20.88

total 434% 414.00% 525.00% 536.00% 1909% 49.21coeficient -10.81% -15.81% 11.94% 14.69%grad 90.94% 86.75% 110.01% 112.31%

m 4n 4

tabel 3.16 p25, Previziunea la intern

An TrimestruMedia1 2 3 4

Grad 91% 87% 110% 112% 9,959 2,490Vanz tr 2,264 2,160 2,739 2,796 9,959

2,264.12 2,159.78 2,738.86 2,796.24Tabel 3.14 Sezonalitatea la export

AnulSubperioada TOTAL suma aia

1 2 3 41 100% 96.00% 75.00% 80.00% 351% 3.512 115% 105.00% 96.00% 98.00% 414% 8.283 118% 106.00% 103.00% 108.00% 435% 13.054 110% 95.00% 90.00% 95.00% 390% 15.6

total 443% 402.00% 364.00% 381.00% 1590% 40.44coeficient 11.38% 1.12% -8.37% -4.12%grad 111.45% 101.13% 91.57% 95.85%

Tabel 3.17 p25 Previziunea la exportAn Trimestru

Media1 2 3 4Grad 111% 101% 92% 96% 5,252 1313Vanz tr 1,463 1,328 1,202 1,259 5,252

1,463.29 1,327.86 1,202.34 1,258.50

Vanzari tot intern

Vanzari tot intern

Tabel 4.1 pag 31 previziune stocuri analitic stoc cost unit val stoc

Crt ElemValoare

Zile StocR1 450 56.18 25280.445112801

total zilnic R2 120 16.98 2037.420 1 2 3 4 5 R3 70 23.64 1654.485

1 stoc - - - 915,978.98 total repere 28972.3501128012 prod curs 47,219,114.82 129,367.44 5.00 646,837.19 S1 125 169.08 21135.277637463

total in curs exec - - - 1,562,816.17 S2 400 152.12 60846.6649007323 repere - - - 28,972.35 total subansamble 81981.942538195

subansamb - - - 81,981.94 B 423 1,478.95 625596.76655256prod fin - - - 1,313,262.42 D 402 1,710.61 687665.65177944

total produse 1,424,216.71 total produse finite 1313262.42total stocuri 2,987,032.88

Tabel 4.2 pag 31 Previziune datorii exploatare analogic simplificat TVA

Crt ElemValoare

Zile Valoare pasiveVanzari 53,799,579 10,221,920.10

total zilnic ch mat 21,983,495.46 4,176,864.141 salarii 16,126,192.19 44,181.35 6 265,088.09 terti 37,146.20 7,057.782 cas 4,676,595.73 12,812.59 12 153,751.09 protocol 22,130.36 4,204.773 energie el 3,893,241.86 10,666.42 6 63,998.50 deplasari 252,780.00 48,028.204 impoz prof 1,052,874.34 2,884.59 12 34,615.05 investitia 12,294,090.10 1,962,921.955 TVA 4,022,843.26 11,021.49 12 132,257.86 4,022,843.26

TOTAL 649,710.59

Tabel 4.3 pag 32 Previziunea creantelor NFR t-1Creante T-1 T T+1 NFR t -184,986Cr comerciale 262,386.49 295,078.27 442,188.32 NFR t+1 2,791,510.62CA 31,923,690.00 35,901,190.00 53,799,579.46Dmed cred cl 3 3 3 NFR t+1 - NFR t 2,976,496.62Alte creante 10420 12050 12000

TOTAL 272,806.49 307,128.27 454,188.32

Tabel 4.4 Calcul dobanda pt credit INVESTITIIRata dobanzii 14% Credit 12,295,000 Rata cred 204,916.67

ANULNumar zilet+1 t+2 t+3 t+4 t+5

Ianuarie 146,192.60 116,954.08 87,715.56 58,477.04 29,238.52 31Februarie 129,844.18 103,435.20 77,026.21 50,617.22 24,208.24 28Martie 141,319.52 112,081.00 82,842.47 53,603.95 24,365.43 31Aprilie 134,402.88 106,107.53 77,812.19 49,516.85 21,221.51 30 Dobanda totalaMai 136,446.43 107,207.91 77,969.39 48,730.87 19,492.35 31 4,372,023.40Iunie 129,686.99 101,391.64 73,096.30 44,800.96 16,505.62 30Iulie 131,573.34 102,334.82 73,096.30 43,857.78 14,619.26 31August 129,136.80 99,898.28 70,659.76 41,421.24 12,182.72 31Septembrie 126,700.26 97,461.74 68,223.21 38,984.69 9,746.17 31Octombrie 120,255.21 91,959.86 63,664.52 35,369.18 7,073.84 30Noiembrie 121,827.17 92,588.65 63,350.13 34,111.61 4,873.09 31Decembrie 115,539.32 87,243.97 58,948.63 30,653.29 2,357.95 30TOTAL AN 1,562,924.68 1,218,664.68 874,404.68 530,144.68 185,884.68 365

Tabelul 4.5 Calcul dobanda la credit exploatareDobanda 15% Credit 2,977,000.00 Rata 248,083.33 2,976,496.62

Dobanda zile luna rataIanuarie 2,977,000.00 37,926.16 31 248,083.33Februarie 2,728,916.67 31,401.23 28 248,083.33 Tabel 4.6 p 35Sinteza ch cu dob si rate la crediteMartie 2,480,833.33 31,605.14 31 248,083.33 Categorii de credite Dobanzi prev Rate la credAprilie 2,232,750.00 27,527.05 30 248,083.33 Credit investitii 1,562,924.68 2459000Mai 1,984,666.67 25,284.11 31 248,083.33 Credit fond rulment 241,116.61 2,977,000.00Iunie 1,736,583.33 21,409.93 30 248,083.33 Credit anterior 0 0Iulie 1,488,500.00 18,963.08 31 248,083.33 TOTAL 1,804,041.29 5,436,000.00August 1,240,416.67 15,802.57 31 248,083.33Septembrie 992,333.33 12,642.05 31 248,083.33Octombrie 744,250.00 9,175.68 30 248,083.33Noiembrie 496,166.67 6,321.03 31 248,083.33Decembrie 248,083.33 3,058.56 30 248,083.33 Tabel 4.7 p35 Program restituire credite in T+1TOTAL AN 19,350,500.00 241,116.61 365 2,977,000.00 rate la credite

categ 1 2 3 4 total aninvestitii 614,750.00 614,750.00 614,750.00 614,750.00 2,459,000.00fond rulment 744,250.00 744,250.00 744,250.00 744,250.00 2,977,000.00cred anterior 0.00 0.00 0.00 0.00 0.00cred restant 0.00 0.00 0.00 0.00 0.00TOTAL 1,359,001.00 1,359,002.00 1,359,003.00 1,359,004.00 5,436,010.00

sold credit inceput luna

Tabel 4.8 pag 38

IndicatoriExercitiul financiar

IndicatoriExercitiul financiar

Precedent Viitor Precedent Viitor1.CA neta 35,901,190 53,799,579 Cheltuieli privind dobanzile 535,060 1,804,041

Prod vanduta 35,625,000 53,313,745 Alte chelt financiare 40,850 0Venituri vanzarea marfurilor 276,190 485,835 IV.Chelt financiare-total 575,910 1,804,041

2. Variatia stocurilor-creditor 572,206 741,056 Rezultatul financiar - profit 0 0Sold debitor 0 0 - pierdere 455,336 1,790,591

3.Productia imobilizata 86,030 0 Rezultatul curent - profit 1,728,590 4,711,6274.Alte venituri din exploatare 0 0 - pierdere 455,336 1,790,591I.Venituri din exploatare 36,559,426 54,540,636 15. Venituri extraordinare 34,020 4,730,378

5a)Ch mat prime si mat cons 10,290,864 17,998,427 16. Cheltuieli extraordinare 84,050 2,838,227Alte cheltuieli mater 8,200 0 Rezultatul extraordinare -profit 1,892,151

b)Alte ch terti(apa,energie) 3,925,854 3,985,068 - pierdere 50,030 0Ch cu marfurile 193,330 373,719 V.Venituri totale 36,714,020 59,284,464

6.Ch cu personalul 19,329,382 20,802,788 VI.Cheltuieli totale 35,490,796 54,471,278a)Salarii 14,533,370 16,126,192 REZULTATUL BRUT 1,223,224 4,813,187

b)Ch cu asig si prot soc 4,796,012 4,676,596 - pierdere 0 07a)Ajust val imob 830,024 4,069,316 Impozitul pe profit 166,916 731,604

A1)cheltuieli 830,024 4,069,316 Ch impozit profit curent 0 0B1)venituri 0 0 Ch impozit profit amanat 0 0

7b)Ajust activ circulare 0 0 Venituri impozit profit amanat 0 0Cheltuieli 0 0 Alte ch cu impozite 0 0

Venituri 0 0 REZULTATUL NET AL EX 1,056,308 4,081,5828)Alte chelt exploatare 253,182 2,599,691 - pierdere 0 08.1. Chelt privind prest ext 218,017 1,036,9418.2 Ch impozite,taxe+varsam 35,165 36,9238.3 Ch despagubiri,donatii 0 1,511,3129. Ajust privind provizioane 0 0

Cheltuieli 0 0Venituri 0 0

II.Ch de exploatare 34,830,836 49,829,009Rezultatul din exploatare 1,728,590 4,711,627

pierdere 0 0Venituri din interese part 3,524 0Venit din alte inv fin 0 0Venituri din dobanzi 54,030 13,450 0.6Alte venituri financiare 63,020 0 1%Venituri financiare-total 120,574 13,45012.Ajust val im financ 0 0

Cheltuieli 0 0Venituri 0 0

Tabelul 4.9 pag 41 Previziune incasari C

Specificatie TOTAL ANdin care

TRIM 1 TRIM 2 TRIM 3 TRIM 4Sez vanz la intern 90.94% 86.75% 110.01% 112.31%Vanzari la intern 9,959.0 2,264.0 2,160.0 2,739.0 2,796Pret mediu la intern 1,600 1,600 1,600 1,600 1,600Incasari la intern 15,934,400 3,622,400 3,456,000 4,382,400 4,473,600Sezonalitatea vanz la export 111.45% 101.13% 91.57% 95.85%Vanzari la export 5,252 1,463 1,328 1,202 1,259Pret mediu la export 440 440 440 440Cursul de schimb 3.65 3.65 3.65 3.65Incasari la export 8,434,712 2,349,578 2,132,768 1,930,412 2,021,954

TOTAL INCASARI 24,369,112 5,971,978 5,588,768 6,312,812 6,495,554

Tabelul 4.9 pag 41 Previziune incasari D

Specificatie TOTAL ANdin care

TRIM 1 TRIM 2 TRIM 3 TRIM 4Sez vanz la intern 100% 100% 100% 100%Vanzari la intern 12,004 3,001.0 3,001.0 3,001.0 3,001.0Pret mediu la intern 1,800 1,800 1,800 1,800 1,800Incasari la intern 21,607,200 5,401,800 5,401,800 5,401,800 5,401,800Sezonalitatea vanz la export 100% 100% 100% 100%Vanzari la export 2,459 615.0 615.0 615.0 614.0Pret mediu la export 510 510 510 510Cursul de schimb 3.65 3.65 3.65 3.65Incasari la export 4,577,429 1,144,823 1,144,823 1,144,823 1,142,961

TOTAL INCASARI 26,184,629 6,546,623 6,546,623 6,546,623 6,544,761

Tabel 4.11 pagina 42 Previziune profit pe trimestre

Specificatie TOTAL ANdin care

TRIM 1 TRIM 2 TRIM 3 TRIM 4Total incasari 53,799,579 12,231,020 11,667,379 14,795,589 15,105,592Venituri din interese part 0 0 0 0 0Venit din alte inv fin 0 0 0 0 0Venituri din dobanzi 13,450 3,058 2,917 3,699 3,776Alte venituri financiare 0 0 0 0 0Venituri financiare-total 13,450 3,058 2,917 3,699 3,776II.Ch de exploatare 49,829,009 11,328,334 10,806,291 13,703,630 13,990,754Rezultatul din exploatare

profit 4,711,627 1,071,161 1,021,799 1,295,759 1,322,908pierdere 0 0 0 0 0

Ch prvind dobanzi 1,804,041 410,138 391,238 496,135 506,530Alte chelt financiare 0 0 0 0 0Total ch financiare 1,804,041 410,138 391,238 496,135 506,530Rezultatul financiar

profit 0 0 0 0 0pierdere 1,790,591 407,080 388,321 492,436 502,754

Venituri exceptionale 4,730,378 1,075,424 1,025,865 1,300,916 1,328,173Ch exceptionale 2,838,227 645,254 615,519 780,550 796,904Rez exceptional

profit 1,892,151 430,170 410,346 520,366 531,269pierdere 0 0 0 0 0

VENITURI TOTALE 59,284,464 13,477,977 12,856,872 16,304,004 16,645,612CHELTUIELI TOTALE 54,471,278 12,383,727 11,813,048 14,980,315 15,294,188REZULTATUL BRUT

profit 4,813,187 1,094,250 1,043,824 1,323,689 1,351,424pierdere 0 0 0 0 0

Impozitul pe profit 731,604 166,326 158,661 201,201 205,416REZULTATUL NET AL EX

profit 4,081,582 927,924 885,162 1,122,489 1,146,007pierdere 0 0 0 0 0

Tabel nr 4.12 Repartizarea profitului net previzionat

Specificatie TOTAL ANdin care

TRIM 1 TRIM 2 TRIM 3 TRIM 4Profit net repartizat pentru: 4,081,582 927,924 885,162 1,122,489 1,146,007rezerve 240,659 54,712 52,191 66,184 67,571fond participare a salariatilor 408,158 92,792 88,516 112,249 114,601fond de dezvoltare 0 0 0 0 0cota managerului 15,000 3,410 3,253 4,125 4,212dividende cuvenite 0 0 0 0 0alte repartitii legale 0 0 0 0 0

k= 3.1394Sectia I

Denumire NrVi Vra

Unitar Total Unitar TotalCladire 1 1,883,639.66 1,883,640 1,092,511 1,092,511c 80 43,952.00 3,516,160 21,976 1,758,080d 30 50,231.11 1,506,933 22,604 678,120e 15 62,786.67 941,800 9,418 141,270f 20 78,485.00 1,569,700 15,697 313,940Alte mijlc - 3,566,358 3,566,358 1,961,497 1,961,497TOTAL 5,685,453 12,984,591 3,123,703 5,945,418

Sectia II

Denumire NrVi Vra

Unitar Total Unitar TotalCladire 1 1,255,760 1,255,760 602,765 602,765f 20 78,485 1,569,700 15,697 313,940g 17 37,673 640,438 18,836 320,219sa1 30 78,485 2,354,550 27,470 824,093sa2 10 94,182 941,820 56,509 565,092sa3 15 109,879 1,648,185 60,433 906,502Alte mijlc - 470,910 470,910 259,001 259,001TOTAL 2,125,374 8,881,363 1,040,711 3,791,610Atelier mecano energetic

Denumire NrVi Vra

Unitar Total Unitar TotalCladire 1 119,298 119,298 57,263 57,263Utilaje 1 414,401 414,401 227,920 227,920TOTAL 533,699 533,699 285,183 285,183

Administratie generala

Denumire NrVi Vra

Unitar Total Unitar TotalCladire 1 2,665,351 2,665,351 2,265,548 2,265,548Microcal 32 43,952 1,406,451 21,976 703,226 Masini Intrari mas,ut Iesiri mas,utAutoturisme 2 87,903 175,806 21,976 43,952 I 1,120,000 160,000 1,758,080Autocamioane 3 141,273 423,819 35,318 105,955 480,000 3,000,000 67,812Alte mijlc 1 612,183 612,183 153,046 153,046 300,000 1,020,000 141,270TOTAL 3,550,661 5,283,610 2,497,864 3,271,726 500,000 3,516,128 627,880

II 500,000 216,000 320,212Tabel 5.2 pagina 47 204,000 200,000 466,990

DenumireVi Vra 750,000 40,000 565,090

Unitar Total Unitar Total 300,000 40,000Sectia I 5,685,453 12,984,591 3,123,703 5,945,418 525,000 55,000Sectia II 2,125,374 8,881,363 1,040,711 3,791,610 Rep 132,000 300,000Atelier mec 533,699 533,699 285,183 285,183 4,811,000 520,000 3,947,334Admin gen 3,550,661 5,283,610 2,497,864 3,271,726 9,067,128TOTAL 11,895,187 27,683,263 6,947,461 13,293,937 1,136,000

Tabel 5.3 pagina 47 Din si structura an la Vinlocuire 150,000

Categorieexistent inceput perioada

Intrari Iesirisfarsit perioada 1,286,000 490,374

Valoare % Valoare % 64,750Cladiri 5,924,048 21.40% 0 0 5,924,048 lei 16.81% 227,920Constr spec - - - - - - 783,044Masini,util 15,103,687 54.56% 9,067,128 3,947,334 20,223,481 lei 57.38% 2,000,200Ap si instal mas 4,037,268 14.58% 1,009,318 0 5,046,586 lei 14.32% 4,811,000Mijlc transp 599,625 2.17% 1,090,000 0 1,689,625 lei 4.79% 1,286,000Unelte,disp 1,406,451 5.08% 10,000 0 1,416,451 lei 4.02% 191,000Alte active 612,183 2.21% 1,117,645 783,044 946,783 lei 2.69% 448,000TOTAL 27,683,263 100.00% 12,294,090 4,730,378 35,246,974 100.00% 70493949 195,000

Tabel 5.4 pagina 48 Din si structura anuala mijlc fixe la Vra 8,931,200

Categorieexistent inceput perioada

Intrari Iesirisfarsit perioada difer reeval 0

Valoare % Valoare %Cladiri 2,000,200 22.40% 0 2,000,200 lei 12.13% 0Constr spec - - - - - - -Masini,util 4,811,000 53.87% 9,067,128 3,947,334 9,930,794 lei 60.21% 0Ap si instal mas 1,286,000 14.40% 1,009,318 0 2,295,318 lei 13.92% 0Mijlc transp 191,000 2.14% 1,090,000 0 1,281,000 lei 7.77% 0Unelte,disp 448,000 5.02% 10,000 0 458,000 lei 2.78% 0Alte active 195,000 2.18% 1,117,645 783,044 529,600 lei 3.21% 0TOTAL 8,931,200 100.00% 12,294,090 4,730,378 16,494,912 100.00%

4,362,737.49

Tabel 5.5 pagina 49 Dinamica inzestrarii tehniceIndicator UM t t+1 Modificare IndiceVal mij exploat Lei 6,931,000.00 14,494,711.61 7,563,711.61 209.13%Nr dir prod numar 869.00 577.00 -292.00 66.40%Grad inz th Lei/pers 7,975.83 25,120.82 17,144.98 314.96%

Tabel 5.6 pagina 51 Utilizarea capacitatii de productieUtilaj

Qpl Nt Nte Ke Qe Td Cpe gu2schCod NRSECTIA If R1 48 118,396 1.6 1.6 1.00 118,396 4000 120,000 0.99e R2 4 29,468 0.5 0.5 1.00 29,468 4000 32,000 0.92d R3 27 44,464 2 2 1.00 44,464 3400 45,900 0.97M S1 18 29,468 2.4 2.4 1.00 29,468 4000 30,000 0.98M S2 34 44,464 3 3 1.00 44,464 4000 45,333 0.98SECTIA IISA1 C 13 14,734 3 3 1.00 14,734 3500 15,167 0.97SA3 C 15 14,734 5 5 1.00 14,734 3700 15,046 0.98 43.26% D 32 14,865 6.5 5 1.30 19,325 3700 19,734 0.75 56.74%TOTAL SA3 47 34,059 34,780f D 12 14,865 3.2 3.2 1.00 14,865 4000 15,000 0.99m D 17 14,865 4.3 4.3 1.00 14,865 3800 15,023 0.99M C 37 14,734 10 10 1.00 14,734 4000 14,800 1.00M D 44 14,865 11.6 11.6 1.00 14,865 4000 15,172 0.98

Tabelul 5.7 pagina 52 Dinamica productiei

SpecificatieProductie Preturi Incasari

t t+1 t t+1 t t+1Prod B 10,000 0 1400 1,200 14,000,000 0Prod C 15,000 14,734 1490 1,600 22,350,000 23,574,400Prod D 0 14,865 0 1,800 0 26,757,000TOTAL 25000 29,599 - - 36,350,000 50,331,400

Tabelul 5.7 pagina 53 Dinamica profitului

SpecificatieProductie Profit unitar Profit total

t t+1 t t+1 t t+1 Cost Pret 14000000Prod B 10,000 0 -89.39 0 -893,900 0 1,200 22350000Prod C 15,000 14,734 178.22 121.05 2,673,300 1,783,519 1,478.95 1,600 0Prod D 0 14,865 0 89.39 0 1,328,766 1,710.61 1,800 36350000TOTAL 25,000 29,599 - - 1,779,400 3,112,285

productia exercitiului - banuiescq pret

Tabelul 5.9 pagina 53 Dinamica ef utilizarii cap fix C 14,734 1600 23574400

SpecificatieProductie

Modificare Indice %D 14,865 1800 26757000

t t+1 50331400Productie 36,350,000 50,331,400 13,981,400 138.46%Profit 1,056,308 4,081,582 3,025,274 386.40%Capital fix 6,931,000 14,494,712 7,563,712 209.13%Cifr Afaceri 35,901,190 53,799,579 17,898,389 149.85%Active imob n 8,931,200 16,494,912 lei 7,563,712 184.69%Kp 5.2446 3.4724 -1.77 66.21%Kpr 0.2567 0.2147 -0.04 83.64%Prc 4.0197 3.2616 -0.76 81.14%

Tabelul 5.10 pagina 54 Asigurarea cu personalCateg pers t t+1 Diferenta Indice %

Muncitori 1111 757 -354 68.14%Maistri 55 25 -30 45.45%Ingineri 85 49 -36 57.65%Economisti 33 29 -4 87.88%Juristi 7 4 -3 57.14%Pers admin 61 50 -11 81.97%TOTAL 1352 914 -438 67.60%

Tabelul 5.11 pagina 57 Econ relativa personal aferenta red normelor de timpCAI Masuri Produse t0 t1 Qpl Er

Perfect tehn …. r1 4 1.6 118,396 -159 -159.366461Organiz polis …. r3 2 0.67 44,464 -33 -33.16720135Modern util …. c 8 6 14,734 -17 -16.52720135

Utilaj noie r2 1 0.5 29,468 -8 -8.263600673f r1 1.6 0.8 118,396 -53 -53.12215367

Organ muncii …. s1 4 2.4 29,468 -26 -26.44352215…. s2 5 3 44,464 -50 -49.87549075

Innoirea prod d 26 25.2 14,865 -7 -6.66965788TOTAL - - - - - -353

Tabel 5.12 pagina 57 Fundam cresterii W pe fct influenta Tabel 5.13 pagina 59 Dinamica productivitatii munciiNr Factorii crest Er I delta W

IndicatorVALORI

Modificare IndiceI …… -353 38.62% t t+11 …… -7 0.77% Prod ex 36,350,000 50,331,400 13,981,400 138.46%2 …… -137 14.99% CA 35,901,190 53,799,579 17,898,389 149.85%3 …… -159 17.40% Val adaug 22,562,131 28,164,136 5,602,005 124.83%4 …… -33 3.61% Ch salar 19,329,382 20,802,788 1,473,406 107.62%5 …… -17 1.86% Nr pers 1352 914 -438 67.60%

II …… 0 Nr dir product 869 577 -292 66.40%1 …… 0 W / CA 26,554 58,862 32,308 221.67%2 …… 0 W / val adaugata 16,688 30,814 14,126 184.65%

III …… 0 W/ prod exercit 41,830 87,229 45,400 208.53%IV …… 0 Remunerea fct m 0.54 0.39 -0.15 71.82%V …… -158 17.29% -158.2562613VI …… 0VII …… -14 1.53% -13.75696525

TOTAL -525 57.44% qpl*t0 q0*t0 q0473584 400,000 100,000

Tabelul 5.14 pagina 60 Dinamica salariilor si W muncii 88928 70,000 35,000

IndicatorVALORI

Modificare Indice117872 120,000 15,000

t t+1 29468 70,000 70,000CA 35,901,190 53,799,579 17,898,389 149.85% 189433.6 160,000 100,000Fond sal an 14,533,370 16,126,192 1,592,822 110.96% 117872 200,000 50,000Fond sal lun 1,211,114 1,343,849 132,735 110.96% 222320 75,000 15,000Nr pers 1352 914 -438 67.60% 0Salar mediu 895.79 1,470.29 575 164.13% 1,239,478 1,095,000w la CA 26,554 58,862 32,308 221.67% negociatSalarii 1 leu CA 0.405 0.300 -0.105 74.04% tpl 1783

t0 1748.4 1820iQ 138.46%qpl*t0/T0 708.92q0*t0/T0 626.29

s indirecte s directe

sectia 1 1,334,664 2,480,461Tabel 5.15 pagina 63 Salarii pe produs la nivelul sectiilor sectia 2 2,889,632 5,753,201

Salarii totale total soc 3,668,233 8,233,662Produse Productie Salarii directe S indir sectie S indir gen Unitare TOTALE sal indirecte totale

R1 118,396 5.87 3.16 2.62 11.65 1,378,781 309,676R2 29,468 2.34 1.26 1.04 4.63 136,488 suma societat 30,655R3 44,464 4.92 2.65 2.19 9.75 433,662 suma sectia 1 97,401S1 29,468 17.61 9.48 7.85 34.94 1,029,509 suma sectia 2 231,229S2 44,464 22.02 11.85 9.81 43.68 1,942,125 k sectia 1 0.5381 436,204C 14,734 171.65 86.21 76.47 334.33 4,926,089 k sectia 2 0.5023 1,126,745D 14,865 216.88 108.93 96.62 422.43 6,279,495 k societate 0.4455 1,436,310Total 16,126,149 3,668,222

fond salarii proiect 1= 16,126,192 -11.24

Tabel 5.16 pagina 64 Sal directe cumulate pt prod fin -42.74Produs Componente Sal pe comp Sal directe/prod

C

R1 4 buc 5.87 23.48 4R2 2 buc 2.34 4.67 2R3 1 buc 4.92 4.92 1S1 2 buc 17.61 35.23 2S2 1 buc 22.02 22.02 1Prel C 171.65 171.65 1

Total C 224.40 261.97

D

R1 4 buc 5.87 23.48 4R3 2 buc 4.92 9.83 2S2 2 buc 22.02 44.04 2Prel D 216.88 216.88 1

Total D 249.69 294.24

Tabel 5.17 Evolutia salariilor pe unitatea de produs

Produs S unitare direct S unit indirectSalarii totale pe produs

Modificare Indicet t+1C 261.97 410.81 672.77 672.772522829 #DIV/0!D 294.24 519.06 0 813.30 813.296062349 #DIV/0!

Tabel 5.18 pagina 67 Previziune ch cu mat prime pt CComp Mat prim Consum Consum /C Pret unitar ValoareR1 4 buc m5 4 16 7 112R2 2 buc m2 7 14 2.08 29.12R3 1 buc m3 5 5 3.12 15.6S1 2 buc m4 6 12 5.2 62.4S2 1 buc m4 2 2 5.2 10.4C m4 60 60 5.2 312TOTAL - - - - 541.52

Tabel 5.19 pagina 67 Previziune ch cu mat prime pt DComp Mat prim Consum Consum /C Pret unitar ValoareR1 2 buc m5 4 16 7 112R3 2 buc m3 5 10 3.12 31.2S2 2 buc m4 2 4 5.2 20.8D m4 25 25 5.2 130D m6 18 18 20 360TOTAL - - - - 654

Tabelul 5.20 pagina 67 Dinamica ch cu mat prime unitare

Den produsConsum cumulat mat prime

Modificare Indicean T an T+1B 397.8 0 -397.8 -C 394.9 541.52 146.62 137.13%D 0 654 654 -

Tabelul 5.21 pagina 67 Dinamica ch cu materiile prime totale

SpecificatieCostul materiilor prime

Modificare Indicean T an T+1Mat prime 9,901,500 17,700,466 7,798,966 178.77%Cost product 34,637,506 47,219,115 12,581,609 136.32%Val productie 36,350,000 50,331,400 13,981,400 138.46%% mat prime 28.59% 37.49% 0.089 131.13%Ch mat prime 0.2724 0.3517 0.079 129.11%

kwh 0.473Tabelul 5.22 pagina 68 Previziune consum energie pe unit produs C

Comp op Operatii Utilaj Putere Timp unitar kwh Cost energR1 4 buc I f 3 1.6 19.2 9.0816R2 2 buc I e 4 0.5 4 1.892R3 1 buc I d 6 2 12 5.676 bucatiS1 2 buc Montaj banda 5400 0.37 0.17 29,468S2 1 buc Montaj banda 5400 0.12 0.06 44,464

CI sa1 10 3 30 14.19II sa3 10 5 50 23.65

TOTAL - - - - 115.69 54.72

Tabelul 5.23 pagina 68 Previziune consum energie pe unit produs DComp op Operatii Utilaj Putere Timp unitar kwh Cost energ

R1 4 buc I f 3 1.6 19.2 9.08R3 2 buc I d 6 2 24 11.35S2 2 buc Montaj banda 5400 0.24 0.11 44,464

D

IV f 6 3.2 19.2 9.08V m 5 4.3 21.5 10.17VI sa3 10 6.5 65 30.74

Montaj banda 5400 0.36 0.17 14,865TOTAL - - - - 149.51 70.72

Tabel 5.24 pagina 68 Evolutia consumurilor energetice pe unitatea de produs

ProdusConsum cumulat energie

Modificare Indicet t+1kwh lei kwh lei kwh lei kwh lei

B 178 0 0 -178 0 0.00% #DIV/0!C 174 115.69 54.72 -58.31 54.72 66.49% #DIV/0!D 0 0 149.51 70.72 149.51 70.72 - -

Tabelul 5.25 pagina 69 Dinamica chelt totale cu energia

SpecificatieCostul

Modificare Indicet t+1Consum enrg 8,694,000 8,230,955 -463,045 94.67%Cost energ 3,825,360 3,893,242 67,882 101.77%Val productie 36,350,000 50,331,400 13,981,400 138.46%% energie cost 11.04% 8.25% -0.0280 74.66%Energ/1leu pr 0.1052 0.0774 -0.0279 73.50%

Tabel 5.26 pagina 70 Cost unitar al D Tabel 5.28 pagina 71 Costul unitar al produsului CNr crt Articol valoare pondere

ArticolAnul t Previziuni t+1

Indice1 Mat prime 490.00 28.08% 1 valoare % valoare %2 Salarii directe 216.88 12.43% 2 Mat prime 240 16.11% 312.00 19.56% 1.33 Asigurari 62.90 3.60% 3 Salarii directe 122.5 8.22% 171.65 10.76% 1.401

Total cheltuieli directe 769.78 44.11% Asigurari 40.43 2.71% 49.78 3.12% 1.2314 Ch indirecte 315.74 18.09% 4 Ch directe total 402.93 27.04% 533.43 33.44% 1.3245 R1 din I 112.36 6.44% 5 Ch indirecte 206.11 13.83% 218.80 13.72% 1.0626 Sub S2 304.23 17.43% 6 R1 din I 64.22 4.31% 56.18 3.52% 0.875

Cost de sectie 1,502.11 86.08% 7 S1 326.38 21.90% 338.16 21.20% 1.0367 Ch generale 208.51 11.95% S2 150.99 10.13% 152.12 9.54% 1.007

Cost productie 1,710.61 98.03% 9 Cost sectie 1150.63 77.22% 1,298.68 81.42% 1.1298 Profit 34.39 1.97% 161.15 10.82% 180.27 11.30% 1.1199 Pret 1745 100.00% 10 Cost productie 1311.78 88.04% 1,478.95 92.72% 1.127

ch la 1 leu 0.9803 11 Profit 178.22 11.96% 116.05 7.28% 0.651R profit 2.01% Pret 1490 100.00% 1595 100.00% 1.070R rentabilitate 1.97% ch la 1 leu 0.88 0.93 1.053

R profit 0.14 0.08 0.578Tabel 5.27 pagina 70 Eficienta fabricare B R rentab 0.12 0.07 0.608

Nr ct Articol Valoare Pondere1 Cost 1489.39 106.38%2 Pret 1400 100.00%3 Ch la 1 leu 1.063854 R profit -6.00%5 R rentabilitate -6.39%

Tabel 5.29 pagina 72 Costul total pe elemente de cheltuieliNr crt Articol t-1 t t+1 t/t-1 t+1/t

A B 1 2 3 4 51 Ch mat prime 9,504,058 9,901,500 17,700,465.68 104.18% 178.77% 99.17%2 Ch mat consu 79,244 159,582 147,584.91 201.38% 92.48%3 Comb si apa 65,004 100,494 91,826.37 154.60% 91.37% 2.30%

3,985,068 2821040Ch energie 2,756,036 3,825,360 3,893,241.86 138.80% 101.77% 97.70%4 Ch piese 10,717 42,247 36,635.40 394.19% 86.72%5 Ch ob inventar 23,719 93,497 31,450.00 394.19% 33.64%6 Ch uzura 23,856 94,038 82,291.24 394.19% 87.51%7 Ch alte m cons 0 8,200 0.00 0.00% 0.00%8 Tot ch materiale 12,462,634 14,216,718 21,983,495.46 114.07% 154.63%9 Ch cu terti 11,105 20,374 37,146.20 183.47% 182.32%

10 Ch protocol 4,041 15,928 22,130.36 394.19% 138.94%11 Ch deplasari 42,751 168,520 252,780.00 394.19% 150.00% terti 218017 7605812 Ch impozite 32,580 35,165 36,923.25 107.93% 105.00% alte 253182 4347813 Ch remuneratii 12,942,943 14,533,370 16,126,192.19 112.29% 110.96% 471,199 11953614 Ch asigurari 4,271,171 4,796,012 4,676,595.73 112.29% 97.51% 25.37%15 Alte ch expl 3,347 13,195 14,514.50 394.19% 110.00% 237,982 58,29216 Ch amortizare 728,030 830,024 4,069,315.68 114.01% 490.26% 204,822 57,896

Total cost prod 30,498,602 34,629,306 47,219,093.37 113.54% 136.36% 13,195 3347.3702618214455,999 119,536

05936

Tabel 5.30 pagina 73 Costul total pe articole de calculatieNr crt Articol t-1 t t+1 t/t-1 t+1/t t-1 t

1 Materii prime 9,504,058 9,901,500 17,700,466 104.18% 178.77% sal totale 12,942,943 14,533,3702 Salarii directe 6,907,907 7,756,750 8,233,677 112.29% 106.15% sal directe 6,907,907 7,756,7503 Asigurari 2,003,293 2,559,727 2,387,766 127.78% 93.28% 53.37% 53.37%4 Total ch direct 18,415,258 20,217,977 28,321,909 109.79% 140.08%5 Ch comune 7,498,718 8,232,787 5,224,479 109.79% 63.46% tot ch directe 18,415,258 20,217,9776 Cost sectie 25,913,976 28,450,764 33,546,388 109.79% 117.91% ch comune 7,498,718 8,232,7877 Ch generale 3,875,736 4,255,142 5,755,507 109.79% 135.26% 40.72% 40.72%8 Cost productie 29,789,712 32,705,906 47,219,115 109.79% 144.37%9 Valoare prod 31,644,500 36,350,000 50,331,400 114.87% 138.46% cost sectie 25,913,976 28,450,764

10 CA 31,923,690 35,901,190 53,799,579 112.46% 149.85% ch generale 3,875,736 4,255,14211 Ch 1 leu prod 0.9414 0.8997 0.9382 95.58% 104.27% 14.96% 14.96%12 Rata prof 3.63% 3.23% 8.64% 89.06% 267.64%13 Rata rentabil 3.41% 2.91% 8.11% 85.12% 279.06%14 R rent comerc 3.38% 2.94% 7.59% 86.95% 257.85%

profit bilant 1,080,261 1,056,308 4,081,582

Tabel 5.31 pagina 73 Eficienta utilizarii fondului de rulmentElement um existent t previziuni t+1 indice %1Tot f rulment mii lei 467.15 520.94 111.51%2Ch exploat mii lei 34,830.84 49,829.01 143.06%3 F rul nec mii lei -184.99 2,791.51 -1509.04%4 CA mii lei 35,901.19 53,799.58 149.85%5 Coef rot f rn nr rot 0.013012131353 0.00968294546 74.41%6 Durata rot zile 27,666.49 37,178.77 134.38%7 F r recalc mii lei -2.40706213042 27.0300450529 -1122.95%8 Econ rel f r mii lei -469.56 -493.91 105.19%

Tabel 6.1 pagina 74Anul Inflatie C D

t+1 107% 1,600 1,800t+2 106% 1,712 1,926t+3 105% 1,815 2,042t+4 104% 1,906 2,144t+5 102% 1,982 2,230

11376 asta e cantitatea pt C din proiect 1,pagina 58,anul t-7Tabelul 6.2 pagina 75 Previziunea vanzarilor medii din C Tabelul 6.3 pagina 75 Previziunea vanzarilor medii din D

Anul Crestere/t+7 cantitate pret valoare Anul Crestere/t+7 cantitate pret valoaret+1 133.71% 15,211 1,600 24,337,600 t+1 100.00 14,463 1,800 26,033,400t+2 138.26% 15,728 1,712 26,926,336 t+2 110.00 15,909 1,926 30,640,734t+3 142.80% 16,245 1,815 29,484,675 t+3 149.60 21,637 2,042 44,182,754t+4 147.35% 16,763 1,906 31,950,278 t+4 179.52 25,964 2,144 55,666,816t+5 151.90% 17,280 1,982 34,248,960 t+5 188.50 27,262 2,230 60,794,260

Tabel 6.4 pagina 75 Ponderea exportului in total vanzari%ANUL t+1 t+2 t+3 t+4 t+5C 34.52650% 35.58% 36.67% 37.80% 38.96%D 17.00% 21.00% 25.00% 29.00% 33.00%

5% 8%Tabel 6.5 pagina 76 PRODUSUL C 5% Tabel 6.5 pagina 76 PRODUSUL D

Anul Vanzari Pret extern E Ch suplim exp Incasari E Anul Vanzari Pret extern E Ch suplim exp Incasari Et+1 5,252 440 73.31 2,310,880 t+1 2,459 510 137.85 1,254,090t+2 5,597 440 76.42 2,462,680 t+2 3,341 515 89.81 1,720,615t+3 5,958 440 75.59 2,621,520 t+3 5,409 520 88.84 2,812,680t+4 6,336 440 76.17 2,787,840 t+4 7,530 525 89.52 3,953,250t+5 6,732 440 78.19 2,962,080 t+5 8,996 530 91.89 4,767,880

Tabel 6.6 pagina 76 Incasari totale previzionateAnul t+1 Anul t+2

Produs Vanzari intern Incasari intern Incas export TOTAL Produs Vanzari intern Incasari intern Incas export TOTALB 2,300 2,760,000 0 2,760,000 C 10,131 17,344,272 8,988,782 26,333,054C 9,959 15,934,400 8,434,712 24,369,112 D 15,394 29,648,844 6,280,245 35,929,089D 12,004 21,607,200 4,577,429 26,184,629 TOTAL 46,993,116 15,269,027 62,262,143TOTAL 40,301,600 13,012,141 53,313,741

Anul t+3 Anul t+4Produs Vanzari intern Incasari intern Incas export TOTAL Produs Vanzari intern Incasari intern Incas export TOTALC 10,287 18,670,905 9,568,548 28,239,453 C 10,427 19,873,862 10,175,616 30,049,478D 16,228 33,137,576 10,266,282 43,403,858 D 18,434 39,522,496 14,429,363 53,951,859TOTAL 51,808,481 19,834,830 71,643,311 TOTAL 59,396,358 24,604,979 84,001,337

Anul t+5Produs Vanzari intern Incasari intern Incas export TOTALC 10,548 20,906,136 10,811,592 31,717,728D 18,266 40,733,180 17,402,762 58,135,942TOTAL 61,639,316 28,214,354 89,853,670

Tabel 6.7 pag 78 Prev ch fixe totale Tabel 6.8 pag 78 Prev ch var din CAnul Inflatie Ch fixe previzionate Anul Inflatie Cantitate Ch var unit Ch var totale

t+1 107% 18,897,203 t+1 107% 15,211 879.46 13,377,410t+2 106% 20,220,008 t+2 106% 15,728 941.02 14,800,336t+3 105% 21,433,208 t+3 105% 16,245 997.48 16,204,053t+4 104% 22,504,868 t+4 104% 16,763 1047.35 17,556,784t+5 102% 23,405,063 t+5 102% 17,280 1089.25 18,822,197

Tabel 6.9 pag 78 Prev ch var din D K Cost total C Cost total DAnul Inflatie Cantitate Ch var unit Ch var totale t+1 0.6671 1,466.17 1,723.10

t+1 107% 14,463 1033.57 14,948,504 t+2 0.6242 1,528.39 1,796.21t+2 106% 15,909 1105.92 17,594,058 t+3 0.5156 1,511.79 1,776.71t+3 105% 21,637 1172.27 25,364,485 t+4 0.4545 1,523.38 1,790.33t+4 104% 25,964 1230.89 31,958,759 t+5 0.4357 1,563.81 1,837.85t+5 102% 27,262 1280.12 34,898,708

Tabel 6.10. pag 78 Prev rezultatului din exploatareSpecificatie T+1 T+2 T+3 T+4 T+51.Ch var tot 28,325,915 32,394,394 41,568,538 49,515,543 53,720,905Ch fix tot 18,897,203 20,220,008 21,433,208 22,504,868 23,405,0633.Cost total 47,223,118 52,614,401 63,001,746 72,020,411 77,125,9684.Incas total 53,313,741 62,262,143 71,643,311 84,001,337 89,853,6705.Rez explo 6,090,622 9,647,742 8,641,565 11,980,925 12,727,702

AnulRata de actualizare %

5 10 15 20 25 30 35t+1 0.9524 0.9091 0.8696 0.8333 0.8000 0.7692 0.7407 1t+2 0.9070 0.8264 0.7561 0.6944 0.6400 0.5917 0.5487 2t+3 0.8638 0.7513 0.6575 0.5787 0.5120 0.4552 0.4064 3t+4 0.8227 0.6830 0.5718 0.4823 0.4096 0.3501 0.3011 4t+5 0.7835 0.6209 0.4972 0.4019 0.3277 0.2693 0.2230 5

rata actualizare 14%

Tabelul 6.12 pag 81 Sinteza fluxurilor financiare previzionateSpecificatie t+1 t+2 t+3

1. Venituri exploatare 54,540,636 62,262,143 71,643,3112. Venituri financiare 13,450 15,566 17,9113. Venituri exceptionale 4,730,378 0 04. Disponibilitati incep per 652,137 0 4,263,775 ??5. Rezerve si alte fonduri 240,659 422,232 389,254 aici punem doar rezervele pt anul in curs sau adunam cu cat erau pe anii precedenti tot??6. Imprumuturi 15,272,000 0 07. Alte venituri 0 0 0 4,734,223TOTAL SURSE 75,449,261 62,699,940 76,314,2508. Ch de exploatare 49,829,009 52,614,401 63,001,7469. Ch financiare 1,804,041 1,218,665 874,40510. Ch exceptionale 2,838,227 0 0 rezerve t= 244,00011. Finantarea imobiliz corp 12,295,000 0 012. Cresterea fondului rulm 2,976,497 0 0 t+2 t+313. Impozit profit 731,604 1,351,143 1,990,096 profit brut= 8,866,875 12,438,100 CS14. Majorarea rezervelor 240,659 422,232 389,254 rezerve totale 906,891 1,296,145 2,878,59515. Participarea sal la profit 408,158 354,675 502,93816. Cota managerului 15,000 16,050 17,013 rezultat exploat 9,647,742 8,641,56517. Plata dividendelor 0 4,263,775 7,079,800 rez financiar -1,203,099 -856,49418. Restituire credite 5,436,000 2,459,000 2,459,000 rez exceptional 0 019. Alte repartizari/cheltuieli 0 0 0 profit brut 8,444,642 7,785,072TOTAL DESTINATII 76,574,196 62,699,940 76,314,250

excedent/deficit -1,124,936 0 0

ALTE FONDURI

Indicator Sold t+1 Indicator Sold t+1A.Active imobilizate J.Capital si rezerve 3,119,254I.Imob necorporale I.Capital 2,878,595 2,646,724II.Imob corporale II.Prime de capital 0 12,425,596 01.Terenuri si constructii 1,899,748 0 deci am gandit asa : daca pun imobilizari la valorile reevaluate este2.Instalatii tehnice si masini 8,129,521 -debitor normal sa pun si faptul ca le-am reevaluat,adik diferente din reevaluare,si am calculat cat erau 3.Alte instalatii 2,396,327 IV.Rez legale 240,659 imobilizari la inceput fata de cat sunt reevaluate4.Avansuri si imob in curs 0 0 V.Rezultatul exercitiului 4,081,582 deci Vra total la inceputul perioadei - V initiala care am fost luat-o noi din datele din pr I si pusTOTAL 12,425,596 TOTAL CAP PROPRII 3,119,254 in tabele alea cu intrari si iesiri de utilajeIII.Imob financiare 8,720 TOTAL CAPITALURI 3,119,254 totusi imi pare ca au crescut cam mult imobilizarile,cu 14 mil mai exact,deci peste valoarea investitiei…..adik e gresit….Active imob-TOTAL 12,434,316 asa k am pus totusi cu valorile alea mici,cum am pus la inceput,si s-a anulat dif din reevaluareB.Active circulante Terenuri+cladiri Inst tehn Alte instalat Avansuri TOTALI.Stocuri Si 2,000,200 4,811,000 2,120,000 45,010 8,976,210 8,976,2101.Mat prime si mat cons 915,979 Intrari 0 9,067,128 3,226,962 12,294,0902.Prod in curs 646,837 Retrageri 0 3,947,334 783,044 4,730,3783.Prod fin si marfuri 1,424,217 marfuri??? Amortizari 100,452 1,801,273 2,167,591 4,069,3164.Avansuri pt cump stocuri 0 SOLD 1,899,748 8,129,521 2,396,327 45,010 12,470,606TOTAL 2,987,033II.Creante Dat peste 1 an1.Creante comerciale 442,188 Sume cred initial din bilant2.Alte creante 12,000TOTAL 454,188III.Inv fin pe termen scurt 0IV.Casa si conturi la banci 1,344,989 e calculat k la dobanda pentru detineri,pag 37ACtIVE CIRCULANTE toTal 4,786,211 sold in cont 1,344,989C.Ch in avans 0D.Datorii pana 1 an diferenta 1,499,5811.Sume instit credit 2,977,000 activ 17,220,5272.Avansuri incasate 200,000 datorii 14,101,2723. Dat comerciale 483,219 cap propriu 3,119,2544.Alte datorii 605,053 pasiv 17,220,526TOTAL 4,265,272 diferenta 0E.Active circulante 520,939 nu e bine!!!!!!F.Total active-datorii curent 12,955,255G.Dat peste 1 an1.Sume instit credit 9,836,000 Active brute fixe Amortizari Net2.Avansuri incasate Initial 9,247,929 6574580 2,673,3493.Dat comerciale Intrari 12,294,0904.Alte datorii Retrageri 4,730,378 4,069,316TOTAL 9,836,000 Final 16,811,641 10,643,896 6,167,745H.Provizione risc chelt 0I.Venituri in avans 0

III.Rez din reevaluare -creditor

in proiectul ala, tipul a pus intr-un element de pasiv diferenta intre activ si pasiv,in "Alte fonduri",si noi am putea pune,da unde…???

poate e bine asa…..punand

datorii comerciale… in astea 3 se sterge intai,da o diferenta (in celula albastra),si diferenta aia se imparte

intre astea 3 ochiometric:)

Indicator Sold t Sold t+1 diferenta indice t t+1 dif indicatorA.Active imobilizate cap si rezI.Imob necorporale 3,475 0 -3,475 0.00% capital 2,878,595 2,878,595 0 100.00%II.Imob corporale 0 0 prime capital 0 0 0 #DIV/0!1.Terenuri si constructii 1,902,084 1,899,748 -2,336 99.88% rezerve legale 244,000 240,659 -3,341 98.63%2.Instalatii tehnice si masini 507,680 8,129,521 7,621,841 1601.31%3.Alte instalatii 236,960 2,396,327 2,159,367 1011.28%4.Avansuri si imob in curs rez exercitiu 1,056,308 4,081,582 3,025,274 386.40%TOTAL 2,646,724 12,425,596 9,778,872 469.47% 3,122,595 3,119,254 -3,341 99.89%III.Imob financiare 8,720 8,720 0 100.00% 3,122,595 3,119,254 -3,341 99.89%Active imob-TOTAL 2,655,444 12,434,316 9,778,872 468.26%B.Active circulante 0 0I.Stocuri 0 01.Mat prime si mat cons 181,160 915,979 734,819 505.62%2.Prod in curs 541,675 646,837 105,162 119.41%3.Prod fin si marfuri 1,136,434 1,424,217 287,783 125.32%4.Avansuri pt cump stocuri 0 0 0TOTAL 1,859,269 2,987,033 1,127,764 160.66%II.Creante 0 01.Creante comerciale 287,101 442,188 155,087 154.02%2.Alte creante 12,050 12,000 -50 99.59%TOTAL 299,151 454,188 155,037 151.83%III.Inv fin pe termen scurt 0 0 0IV.Casa si conturi la banci 652,137 1,344,989 692,852 206.24% diferenta 0ACtIVE CIRCULANTE toTal 2,810,557 4,786,211 1,975,654 170.29% activ 5,466,001 17,220,527C.Ch in avans pasiv 5,466,001 17,220,526D.Datorii pana 1 an 01.Sume instit credit 534,050 2,977,000 2,442,950 557.44% in curs2.Avansuri incasate 170,000 200,000 30,000 117.65% 7.25% 324,7493. Dat comerciale 351,500 483,219 131,719 137.47% 15.00% 671,4664.Alte datorii 1,287,856 605,053 -682,803 46.98% 54.96% 2,460,176TOTAL 2,343,406 4,265,272 1,921,866 182.01% 4,476,581 1.91E.Active circulante 467,151 520,939 53,788 111.51%F.Total active-datorii curent 3,122,595 12,955,255 9,832,660 414.89%G.Dat peste 1 an 0 0 #DIV/0!1.Sume instit credit 0 9,836,000 9,836,000 #DIV/0!2.Avansuri incasate 0 0 0 #DIV/0!3.Dat comerciale 0 0 0 #DIV/0!4.Alte datorii 0 0 0 #DIV/0!TOTAL 0 9,836,000 9,836,000 #DIV/0!

se echilibreaza daca sterg Avansuri si imob

Tabel 7.2 pagina 92 Structura capitalurilorNr crt Indicator t-1 t t+1 t/t-1 t+1/t

1 Cap proprii 1,918,000 3,122,595 3,119,254 162.80% 99.89%2 Cap permanent 1,918,000 3,122,595 12,955,254 162.80% 414.89%3 Struct cap 1.000 1.000 0.241 100.00% 24.08%4 Situatia neta 1,918,000 3,122,595 3,119,255 162.80% 99.89%

0Tabel pagina 93 jos Dinamica fondului de rulment

Indicator t-1 t t+1 t/t-1 t+1/tCap proprii 1,918,000 3,122,595 3,119,254 162.80% 99.89%Dat t lung 0 0 9,836,000 #DIV/0! #DIV/0!Activ imob net 1,910,767 2,655,444 12,434,316 138.97% 468.26%Act circulant 1,799,933 2,810,557 4,786,211 156.15% 170.29%Dat t scurt 1,792,700 2,343,406 4,265,272 130.72% 182.01%Fond rulment 7,233 467,151 520,938 6458.61% 111.51%

7,233 467,151 520,9390 0 0 diferenta tre s fie 0 k sa fie bine

pagina 94 Indicator t-1 t t+1 t/t-1 t+1/tStocuri 1287063 1,859,269 2,987,033 144.46% 160.66%Creante 243500 299,151 454,188 122.85% 151.83%Dat exploat 1,792,700 2,343,406 649,711 130.72% 27.73% datorii de exploatare preluate pt t+1 din pagina 31,pr II, da la celelalte noi am luat total datorii pe termen scurtNFR -262,137 -184,986 2,791,511 70.57% -1509.04% adik nu e bine……da trebe luat asa ca sa ne iasa la fel cum am pornitCresterea NFR 0 77,151 2,976,497 3858.01% mai pe scurt, e gresit din temelii :))

asta tre s iasa egal cu capitalurile proprii, sau nu? Acum iese

calcul verificare

Tabel 7.3 pagina 95, Analiza previzionala a indatorarii intreprinderiiIndicator t-1 t t+1 t/t-1 t+1/t

Dat scurt 1,792,700 2,343,406 4,265,272 130.72% 182.01%Dat lung 0 0 9,836,000 #DIV/0! #DIV/0!Dat totale 1,792,700 2,343,406 14,101,272 130.72% 601.74%Prof net 964,519 1,056,308 4,081,582 109.52% 386.40%Amortizare 728,030 830,024 4,069,316 114.01% 490.26%Partic salar 120,000 150,000 423,158 125.00% 282.11%Dividende 566,702 340,811 0 60.14% 0.00%Tot ACTIV 3,710,700 5,466,001 17,220,527 147.30% 315.05%Dobanzi 572,160 535,060 1,804,041 93.52% 337.17%Credite scadent 1,792,700 2,343,406 4,265,272 130.72% 182.01% credite scadente=alea pe termen scurt+daca s-ar termina unul lung,darR ind glob 0.483 0.429 0.819 88.74% 191.00% noi abia am inceput unul lungCAF reala 1,005,847 1,395,521 7,727,740 138.74% 553.75%R ind termen 0.0000 0.0000 1.2728 #DIV/0! #DIV/0!R indat t lung 0.0000 0.0000 0.5712 #DIV/0! #DIV/0!R acop cred 0.4761 0.5369 1.3430 112.78% 250.12%

Tabe 7.4 pagina 97 Analiza previzionala a indatorarii intreprinderiiIndicator t-1 t t+1 t/t-1 t+1/t

1.Stocuri 1,287,063 1,859,269 2,987,033 144.46% 160.66%2.Creante 243,500 299,151 454,188 122.85% 151.83%3.Disponib 269,370 652,137 1,344,989 242.10% 206.24%4.Dat t scurt 1,792,700 2,343,406 4,265,272 130.72% 182.01%5.Dur rot stoc 15 19 20 128.45% 107.21%6.Clienti 233,080 287,101 442,188 123.18% 154.02%7.CA 31,923,690 35,901,190 53,799,579 112.46% 149.85%8.Dm cred cl 3 3 3 109.53% 102.78%9.Furnizori 190,000 351,500 483,219 185.00% 137.47% nu stiu de unde se ia….nu gasesc,si luat datoriile comerciale….10.Cumparari ma 195,530 193,330 373,719 98.87% 193.31% aici am luat cheltuieli privind marfurile….11.Dm cred furn 350 655 465 187.11% 71.12% cam mare iese,zic eu….

Tabel 7.5 pagina 100 Analiza previzionala a indatorarii intreprinderiiIndicator t-1 t t+1 t/t-1 t+1/t

1.Active fixe brute 9,301,657 9,247,929 16,811,641 99.42% 181.79%2.NFR -262,137 -184,986 2,791,511 70.57% -1509.04%3.Disponibilit 269,370 652,137 1,344,989 242.10% 206.24%4.Prof exploatare 1,792,876 1,728,590 4,711,627 96.41% 272.57%5.Profit brut 1,286,025 1,223,224 4,813,187 95.12% 393.48%6.Profti net 964,519 1,056,308 4,081,582 109.52% 386.40%7.Cap proprii 1,918,000 3,122,595 3,119,254 162.80% 99.89%8.Ch exploat 30,618,074 34,830,836 49,829,009 113.76% 143.06%9.VA 20,218,820 22,562,131 28,164,136 111.59% 124.83%10.Productia exercitiului 32,131,670 36,350,000 50,331,400 113.13% 138.46%11.CA 31,923,690 35,901,190 53,799,579 112.46% 149.85%12.R rent ec 10.36% 10.87% 19.48% 104.94% 179.20%13.R rent fin 50.29% 33.83% 130.85% 67.27% 386.81%14. R rent res consumate 5.86% 4.96% 9.46% 84.75% 190.53%15.R VA 62.92% 62.07% 55.96% 98.64% 90.15%16.R rentab comerciale 4.03% 3.41% 8.95% 84.58% 262.58%

De introdus valorile lui T Indice prett+5 1.05

13 ZILe-0.06542 365

0.7514

De completatt+5

11

Tabel 1.4 Obiective strategice pag 7Niveluri previzionate

t+2 t+3 t+4 t+5

valori ciudate, tab 1.8 pag 13Ip g*ip4 5

1 40.47%1 18.20%1 5.28%

- -1.05 37.85%

- -- -- -- -- 101.80%- -- -- -

pagina 14 sus1377.37

164816001800

Tabel 2.2 pagina 16Productie Indici agregati

t+1 qpl*p0 q0*p0 qPl*Ppl0 0 14,000,000 0

14,734 21,953,660 22,350,000 23,574,40014,865 24,917,456 0 26,757,000totaluri 46,871,116 36,350,000 50,331,400

Laspeyers 128.94%Paasche 107.38%Vol activ 138.46%

1.07

30%112,116485,835

Curs euro 3.65

Tabel 3.5 Incasari totale previzionateIncas intern Incas export Total Diferente

2 3 4 52,760,000 0 2,760,000 0

15,934,400 8,434,712 24,369,112 31,51221,607,200 4,577,429 26,184,629 151,22940,301,602 13,012,144 53,313,745 182,745

Sold Rata Dob ZileIanuarie 12,295,000 204,916.67 146,192.60 31Februarie 12,090,083.33 204,916.67 129,844.18 28Martie 11,885,166.67 204,916.67 141,319.52 31Aprilie 11,680,250.00 204,916.67 134,402.88 30Mai 11,475,333.33 204,916.67 136,446.43 31Iunie 11,270,416.67 204,916.67 129,686.99 30Iulie 11,065,500.00 204,916.67 131,573.34 31August 10,860,583.33 204,916.67 129,136.80 31Septembrie 10,655,666.67 204,916.67 126,700.26 31Octombrie 10,450,750.00 204,916.67 120,255.21 30Noiembrie 10,245,833.33 204,916.67 121,827.17 31Decembrie 10,040,916.67 204,916.67 115,539.32 30Ianuarie 9,836,000.00 204,916.67 116,954.08 31Februarie 9,631,083.33 204,916.67 103,435.20 28Martie 9,426,166.67 204,916.67 112,081.00 31Aprilie 9,221,250.00 204,916.67 106,107.53 30Mai 9,016,333.33 204,916.67 107,207.91 31Iunie 8,811,416.67 204,916.67 101,391.64 30Iulie 8,606,500.00 204,916.67 102,334.82 31

August 8,401,583.33 204,916.67 99,898.28 31Septembrie 8,196,666.67 204,916.67 97,461.74 31Octombrie 7,991,750.00 204,916.67 91,959.86 30Noiembrie 7,786,833.33 204,916.67 92,588.65 31Decembrie 7,581,916.67 204,916.67 87,243.97 30Ianuarie 7,377,000.00 204,916.67 87,715.56 31Februarie 7,172,083.33 204,916.67 77,026.21 28Martie 6,967,166.67 204,916.67 82,842.47 31Aprilie 6,762,250.00 204,916.67 77,812.19 30Mai 6,557,333.33 204,916.67 77,969.39 31Iunie 6,352,416.67 204,916.67 73,096.30 30Iulie 6,147,500.00 204,916.67 73,096.30 31August 5,942,583.33 204,916.67 70,659.76 31Septembrie 5,737,666.67 204,916.67 68,223.21 31Octombrie 5,532,750.00 204,916.67 63,664.52 30Noiembrie 5,327,833.33 204,916.67 63,350.13 31Decembrie 5,122,916.67 204,916.67 58,948.63 30Ianuarie 4,918,000.00 204,916.67 58,477.04 31Februarie 4,713,083.33 204,916.67 50,617.22 28Martie 4,508,166.67 204,916.67 53,603.95 31Aprilie 4,303,250.00 204,916.67 49,516.85 30

Mai 4,098,333.33 204,916.67 48,730.87 31Iunie 3,893,416.67 204,916.67 44,800.96 30Iulie 3,688,500.00 204,916.67 43,857.78 31August 3,483,583.33 204,916.67 41,421.24 31Septembrie 3,278,666.67 204,916.67 38,984.69 31Octombrie 3,073,750.00 204,916.67 35,369.18 30Noiembrie 2,868,833.33 204,916.67 34,111.61 31Decembrie 2,663,916.67 204,916.67 30,653.29 30Ianuarie 2,459,000.00 204,916.67 29,238.52 31Februarie 2,254,083.33 204,916.67 24,208.24 28Martie 2,049,166.67 204,916.67 24,365.43 31Aprilie 1,844,250.00 204,916.67 21,221.51 30Mai 1,639,333.33 204,916.67 19,492.35 31Iunie 1,434,416.67 204,916.67 16,505.62 30Iulie 1,229,500.00 204,916.67 14,619.26 31August 1,024,583.33 204,916.67 12,182.72 31Septembrie 819,666.67 204,916.67 9,746.17 31Octombrie 614,750.00 204,916.67 7,073.84 30Noiembrie 409,833.33 204,916.67 4,873.09 31Decembrie 204,916.67 204,916.67 2,357.95 30

12,295,000.00 4,372,023.40

t t+1prod exerc 36,350,000 50,331,400marja com 655,066 853,172cons terti 14442935 23020436.27mat prime 10,290,864 17,998,427alte materia 8,200 0alte afara 3,925,854 3,985,068ch prest ext 218,017 1,036,941VA 22,562,131 28,164,136

deci am gandit asa : daca pun imobilizari la valorile reevaluate estenormal sa pun si faptul ca le-am reevaluat,adik diferente din reevaluare,si am calculat cat erau

deci Vra total la inceputul perioadei - V initiala care am fost luat-o noi din datele din pr I si pus

totusi imi pare ca au crescut cam mult imobilizarile,cu 14 mil mai exact,deci peste valoarea investitiei…..adik e gresit….asa k am pus totusi cu valorile alea mici,cum am pus la inceput,si s-a anulat dif din reevaluare

9,014,210

in proiectul ala, tipul a pus intr-un element de pasiv diferenta intre activ si pasiv,in "Alte

in astea 3 se sterge intai,da o diferenta (in celula albastra),si diferenta aia se imparte

intre astea 3 ochiometric:)

datorii de exploatare preluate pt t+1 din pagina 31,pr II, da la celelalte noi am luat total datorii pe termen scurt

DIF 1 0.00Necesar direct productivi DIF 2 -14.616

productia norma timp total salar ora fond salarii necesar DIF 3 21.47

118,396 0.8 94,716.80 7.33866 695,094.656 53 53.12215367429,468 0.5 14,734.00 4.67006 68,808.637 8 8.26360067344,464 0.67 29,790.88 7.33866 218,625.223 17 16.708289429,468 2.4 70,723.20 7.33866 519,013.716 40 Salar mediu indirect productivi44,464 3 133,392.00 7.33866 978,918.907 75 74.813236119 653.06

total sectia I 343,356.88 7.22415 2,480,461.138 193

14734 21 309,414.00 8.17000 2,527,912.380 174 173.53561413 8.1700014865 25.2 374,598.00 8.61000 3,225,288.780 210 210.09422322 8.61000

684,012.00 8.41097 5,753,201.160 384Salar mediu direct productivi

1,027,368.88 8.01432 8,233,662.298 577 1,189.15

pag 97 Centralizator necesar personal si fond salariinumar salarii co sporuri fond salarii chelt indirecte

193 2,480,461.138 278,852.138 496,676.390 3,255,989.665 775,528.527pag 96, Fond anual salarii 35 251,580.000 - 45,284.400 296,864.400 296,864.400

1

6 1386 99,792 12 222,264.000 - 40,007.520 262,271.520 262,271.52012 1386 199,584 total I 240 2,954,305.138 278,852.138 581,968.310 3,815,125.585 1,334,664.447

1 1386 16,6321 1386 16,632 384 5,753,201.160 645,962.131 1,151,849.392 7,551,012.683 1,797,811.523

2

3 1562 56,232 71 565,728.000 - 101,831.040 667,559.040 667,559.0405 1562 93,720 20 359,544.000 - 64,717.920 424,261.920 424,261.9202 1562 37,488 total II 475 6,678,473.160 645,962.131 1,318,398.352 8,642,833.643 2,889,632.483

51 1562 955,944

30 668 0 36 331,344.000 - 59,641.920 390,985.920 390,985.9205 668 40,080 8 143,040.000 - 25,747.200 168,787.200 168,787.200

4

2 681 16,344 total repar 44 474,384.000 - 85,389.120 559,773.120 559,773.1202 681 16,3444 681 32,688 37 261,960.000 - 47,152.800 309,112.800 309,112.800

42 681 343,224 117 2,372,328.000 - 427,019.040 2,799,347.040 2,799,347.040

5

1 4158 49,896 total admin 154 2,634,288.000 - 474,171.840 3,108,459.840 3,108,459.8401 4158 49,8961 4686 56,232 TOTAL 913 12,741,450.298 924,814.268 1,206,247.190 16,126,192.189 7,892,529.890

14 4686 787,2483 4700 169,2001 5000 60,000

6

12 - 222,26420 - 359,544

8 - 143,040117 - 2,372,328

7 157 - 3,097,176

pag 98 pag 100 jos chelt uzura materialelor protectie1 293 3,567.44 1,045,261.29 621 228 36.715% 29289 11,183.5872 72 1,959.18 141,061.20 410 455 110.976% 45777 52,833.3573 44 4686 206,184.00 50 36 72.000% 11352 8,500.3784 16 2004 32,064.00 30 37 123.333% 7620 9,773.9205 13 4158 54,054.006 16 2043 32,688.00 94038 82,291.242

pag 101 SDV si alt obiecte pag 101 Necesarul de piese de schimb1 52 175 9,100 1 81 100 8,100.002 81 150 12,150 2 89 125 11,125.003 36 160 5,760 3 1.15 5792 6,660.804 37 120 4,440 4 1.2 8958 10,749.60

31,450 total 36,635.40

pag 102 Necesar energie electrica Cost energie1 2 3 4 5 6 7 8 0.473

R1118,396118,396 3 1.6 568,300.80 268,806.278

R2 29,468 4 0.5 58,936.00 27,876.728R3 44,464 6 2 533,568.00 252,377.664S1 29,468 5,400.00 2,554.200S2 44,464 5,400.00 2,554.200TOTAL I 1,171,604.80 554,169.070

C14,734 10 3 442,020.00 209,075.46014,734 10 5 736,700.00 348,459.100

D

14,865 6 3.2 285,408.00 134,997.98414,865 5 4.3 319,597.50 151,169.61814,865 10 6.5 966,225.00 457,024.42514,865 5,400.00 2,554.200

TOTAL II 2,755,350.50 1,303,280.787Repar 1,453,200.00 687,363.600Ilum 484,450.00 229,144.850

1,033,500.00 488,845.500312,300.00 147,717.900

1,020,550.00 482,720.150

TOTAL 1,656,054.80 783,313.9203,788,850.50 1,792,126.2871,765,500.00 835,081.5001,020,550.00 482,720.1508,230,955.30 3,893,241.857

pret cantitate consum cantitate valoare pagina 103 pretm5 7 118396 4 473,584 3,315,088.00 m2 2.08 206,276 429,054.08

m45.2 29468 6 176,808 919,401.60 m3 3.12 222,320 693,638.405.2 44464 2 88,928 462,425.60 m4 5.2 1,521,401 7,911,285.20

m2 2.08 29468 7 206,276 429,054.08 m5 7 473,584 3,315,088.00m3 3.12 44464 5 222,320 693,638.40 m6 20 267,570 5,351,400.00

total 1 5,819,607.68 17,700,465.68

m45.2 14734 60 884,040 4,597,008.005.2 14865 25 371,625 1,932,450.00

m6 20 14865 18 267,570 5,351,400.0011,880,858.0017,700,465.68

pag 104 Centralizator plan de aprovizionare1 2 3 4 5 6 7 8 9 10

m1 - - -m2 206,276 429,054.08 15 8,595 17,877.25 15600 32,448.00 199,271 414,483.33m3 222,320 693,638.40 15 9,263 28,901.60 9500 29,640.00 222,083 692,900.00m4 1,521,401 7,911,285.20 15 63,392 329,636.88 25500 132,640.00 1,559,293 8,108,282.08m5 473,584 3,315,088.00 15 19,733 138,128.67 - - 493,317 3,453,216.67m6 267,570 5,351,400.00 15 11,149 222,975.00 - - 5,574,375.00

TOTAL 2,691,151 17,700,465.68 15 737,519.40 194,728.00 - 18,243,257.08Mat aux - 147,584.91 15 - 6,149.37 - 4,346.00 - 149,388.28Combust - 91826.37 15 - 3,826.10 - 5,275.00 - 90,377.47Energ el - 3,893,241.857 15 - 162,218.41 - - - 4,055,460.27

Mater - 82,291.242 15 - 3,428.80 - 1,540.00 - 84,180.04SDV - 31,450 15 - 1,310.42 - 9,175.00 - 23,585.42

Piese schimb - 36,635.40 15 - 1,526.48 - 5,320.00 - 32,841.88TOTAL 21,983,495.46 - - 915,978.98 - 220,384.00 - 22,679,090.44

amortizare sI sII p 107 atelier mecano energetic27,312.78 15,069 57263 2.50% 1,431.58

0.00 0 0.000.00 75,000 200000 12.00% 24,000.00

272,681.64 102,000 25,431.580.00 292,340 pag 108 administratie generala0.00 0 1 2,265,548.00 2,265,548.00 2.50% 56,638.70

20,000.00 302,139 32 21,975.80 703,225.60 50.00% 351,612.800.00 351,613 5 2,000.00 10,000.00 20.00% 2,000.00

348,000.00 5,500 2 21,975.80 43,951.60 100.00% 43,951.604,000.00 146,037 3 30,000.00 90,000.00 20.00% 18,000.004,000.00 14,127 3 35,318.25 105,954.75 80.00% 84,763.80

1,105,990.08 1,303,825 4 250,000.00 1,000,000.00 16.00% 160,000.00106,990.80 - - 114,784.31 0.00% 0.00

1,888,975.30 - - 1,117,644.55 12.00% 134,117.35TOTAL 851,084.25

TOTAL AMORTIZARI 4,069,315.68

pag 110 Planul cheltuielilor indirecte pag 111 Cost total pe elemente de cheltuieliI II Reparatii Comp func TOT indir 2 3 4

mat aux 21,017.47 92,199.75 20,513.97 13,853.72 147,584.91 1 9,901,500 17,700,465.68 178.77%uzura prot 11,183.59 52,833.36 8,500.38 9,773.92 82,291.24 2 159,582 147,584.91 92.48%uzura inventar 9,100.00 12,150.00 5,760.00 4,440.00 31,450.00 3 100,494 91,826.37 91.37%combustibil 31,848.75 46,635.97 3,866.07 9,475.58 91,826.37 4 3,825,360 3,893,241.86 101.77%energie elec 783,313.92 1,792,126.29 835,081.50 482,720.15 3,893,241.86 5 42,247 36,635.40 86.72%piese 8,100.00 11,125.00 6,660.80 10,749.60 36,635.40 6 93,497 31,450.00 33.64%salarii ind 1,334,664.45 2,889,632.48 559,773.12 3,108,459.84 7,892,529.89 7 94,038 82,291.24 87.51%asigur 387,052.69 837,993.42 162,334.20 901,453.35 2,288,833.67 8 8,200amortiz 1,888,975.30 1,303,824.56 25,431.58 851,084.25 4,069,315.68 14,216,718 21,983,495.46 -lucrari 37,146.20 37,146.20 9 20,374 37,146.20 182.32%impozite 36,923.25 36,923.25 10 15,928 22,130.36 138.94%protocol 22,130.36 22,130.36 11 168,520 252,780.00 150.00%deplasari 252,780.00 252,780.00 12 35,165 36,923.25 105.00%reparatii 749,222.66 878,698.96 1,627,921.61 13 14,533,370 16,126,192.19 110.96%alte chelt 14,514.50 14,514.50 14 4,796,012 4,676,595.73 97.51%TOTAL 5,224,478.82 7,917,219.79 1,627,921.61 5,755,504.72 20,525,124.94 15 13,195 14,514.50 110.00%

20,525,124.94 16 830,024 4,069,315.68 490.26%34,629,306 47,219,093.37 136.36%

pag 112 -21.47valoare pondere chelt cu rep valoare baza chelt indir cota de ch ind 0.00%

1 6,213,020.75 46.02% 749,222.66 1 9,019,684.04 5,224,478.82 57.92%2 7,286,718.87 53.98% 878,698.96 2 19,302,224.86 7,917,219.79 41.02%

total 13,499,739.62 1,627,921.61 admin gen 41,463,588.65 5,755,504.72 13.88%pag 113, R1 pag 113 S1

consum pret unitar valoare consum pret unitar valoare1 4 7 28

1

7 2.08 14.562 5.8709302326 4 7 283 1.70 6 5.2 31.2

total 35.57 2 25.824 0.5792 20.61 3 7.49

total total 56.18 total 107.07pag 114 S2 chelt com 4 0.5792 62.02

consum pret unitar valoare total mare 169.08

1

4 7 285 3.12 15.62 5.2 10.4

2 32.813 9.51

total 96.32chelt com 4 0.5792 55.79total mare 152.12

C Pag 114,115 D

consum pret unitar valoare consum pret unitar valoare1 60 5.2 312.00

125 5.2 130.00

2 171.65 18 20 360.003 49.78 2 216.88

total 533.43 3 62.8954 0.4102 218.80 total 769.78

5

1 56.18 56.18 4 0.4102 315.742 169.08 338.16

52 56.18 112.36

1 152.12 152.12 2 152.12 304.23cost sectie 1,298.68 cost sectie 1,502.11

8 180.27 8 208.51cost prod 1,478.95 cost productie 1,710.61

9 116.05 9 34.3910 1,595 10 1,745

chelt comune ale sectiei cost de sectie chelt generale soc com cost productiecantitate unitar total unitar total unitar total unitar total

R1 44,464 20.61 916,192.59 56.18 2,497,932.69 0.00 0.00S1 29,468 62.02 1,827,488.48 169.08 4,982,514.89 0.00 0.00S2 44,464 55.79 2,480,797.75 152.12 6,763,715.27 0.00 0.00total I TOTAL I - 5,224,478.82 - 14,244,162.85 - 0.00 - 0.00C 14,734 1,298.68 19,134,804.82 180.27 2,656,076.41 1,478.95 21,790,881.23D 14,865 1,502.11 22,328,802.68 208.51 3,099,430.93 1,710.61 25,428,233.62total II TOTAL II - 0.00 - 41,463,607.50 - 5,755,507.34 - 47,219,114.84TOTAL TOTAL FIRMA - 5,224,478.82 - - - 5,755,507.34 - 47,219,114.84

47,219,114.84 47,219,114.84 21.47

pag 100 materiale auxiliare975,000 343,357 35.22% 57386 21,017.47605,000 684,012 113.06% 78413 92,199.75

35,625,000 49,500,000 138.95% 14196 20,513.9735,625,000 49,500,000 138.95% 9587 13,853.72

147,584.91

1 550.80 688.50 4.002912 581.40 726.75 4.225293 612.00 765.00 4.447674 642.60 803.25 4.670065 673.20 841.50 4.892446 719.10 898.88 5.226027 765.00 956.25 5.559598 826.20 1,032.75 6.004369 887.40 1,109.25 6.44913

10 1,009.80 1,262.25 7.3386611 1,101.60 1,377.00 8.0058112 1,315.80 1,644.75 9.5625013 1,407.60 1,759.50 10.2296514 1,530.00 1,912.50 11.1191915 1,744.20 2,180.25 12.6758716 1,989.00 2,486.25 14.4549417 2,356.20 2,945.25 17.1235518 2,907.00 3,633.75 21.12645

1 8 1.22 6 1.63 7 4.34 13 6.55 12 11.6

612

11352

51052

24

42111

1431

12 15720

8117157

???????

pag 107,amortiz sct I+II826,308.00 600,000.00160,000.00 1,020,000.00

2,784,000.00 877,106.7580,000.00 906,506.25

1,471,122.75 3,516,128.00891,590.00 55,000.00

194,250.376,213,020.75 117,727.50

7,286,718.871092511

7,305,531.75

0.8 7.34 5.87 R10.5 4.67 2.34 R2

0.67 7.34 4.92 R30.8 7.34 5.870.5 4.67 2.342.4 7.34 17.61

S1 25.820.8 7.34 5.87

S20.67 7.34 4.92

3 7.34 22.0232.81

6 6.004 36.02

C

5 8.005 40.0310 9.56 95.60

171.6525.2 8.61 216.88 D

materii prime salarii directe cas somaj repere subansamblecantitate unitar total unitar total unitar total unitar total unitar total

R1 44,464 28.0000 1,244,992.00 5.87093 261,045.04 1.70 75,703.06 - - - -S1 29,468 73.76 2,173,559.68 25.82 760,826.93 7.49 220,639.81 - - - -S2 44,464 54 2,401,056.00 32.81 1,458,807.38 9.51 423,054.14 - - - -total I TOTAL I 5,819,607.68 2,480,679.35 - 719,397.01 - - - -C 14,734 312.00 4,597,008.00 171.65 2,529,076.37 49.78 733,432.15 56.18 827,737.95 490.28 7,223,801.79D 14,865 490.00 7,283,850.00 216.88 3,223,921.20 62.90 934,937.15 112.36 1,670,194.74 304.23 4,522,428.37total II TOTAL II 11880858 5,752,997.57 - 1,668,369.29 2,497,932.69 11,746,230.16TOTAL TOTAL FIRMA 17,700,465.68 8,233,676.91 - 2,387,766.31 2,497,932.69 11,746,230.16

din centralizatorul pag 103= 17,700,465.68 8,233,662.2980.00 -14.616

42,566,071.75