Petrea Nicoleta- Simona, MRU 1, Gr.2.xlsx
22
Tabel evaluare angajati Functia sofer microbuz Nr.crt. Nume si prenume Functie Ianuarie 1 CRETU V BOGDAN sofer microbuz 9.00 2 GRAPA G CRISTIAN sofer microbuz 8.00 3 IVAN F CRISTIAN CONSTANTIN sofer microbuz 5.00 4 LICHIARDOPOL L GEORGIANA taxator 7.00 5 MITITELU P NARCIS sofer microbuz 10.00 6 VACULISTEANU L ANDREEA taxator 7.00 7 VOINEA M LIVIU ANDREI sofer microbuz 7.5 8 DOGARU P PETRU GEORGE sofer microbuz 6.5 9 COATU H HORATIU LIVIU sofer microbuz 7.00 10 POPESCU D ELENA DANIELA taxator 5.00 11 BIRLADEANU N CIPRIAN sofer microbuz 10.00 12 BANDOL M MIHAI OVIDIU taxator 10.00 13 GROSU D FLORIN sofer microbuz 9.5 14 RADU CRISTINEL sofer microbuz 6.00 15 HINCU FLORIN sofer microbuz 10.00 16 RADEANU ANCA contabil 9.00 17 VATAFU DAN sofer microbuz 8.89 18 HORCIU I. IOAN ANDREI sofer microbuz 10.00 19 CĂLĂTORU G. ALEXANDRU-GABRIEL dispecer 9.00 20 FRÎNCU G GEORGE taxator 9.90 21 GALICEANU Ş.R. ANDREEA RALUCA taxator 7.00 Media lunara 8.21 nume GROSU D FLORIN teste nota 9.5 6 Ianuarie 8.21
-
Upload
petrea-nicoleta-simona -
Category
Documents
-
view
224 -
download
0
Transcript of Petrea Nicoleta- Simona, MRU 1, Gr.2.xlsx
Tabel evaluare angajati Functiasofer microbuz
Nr.crt. Nume si prenume Functie Ianuarie Februarie1 CRETU V BOGDAN sofer microbuz 9.00 8.002 GRAPA G CRISTIAN sofer microbuz 8.00 7.003 IVAN F CRISTIAN CONSTANTIN sofer microbuz 5.00 7.54 LICHIARDOPOL L GEORGIANA taxator 7.00 8.005 MITITELU P NARCIS sofer microbuz 10.00 8.56 VACULISTEANU L ANDREEA taxator 7.00 8.007 VOINEA M LIVIU ANDREI sofer microbuz 7.5 8.008 DOGARU P PETRU GEORGE sofer microbuz 6.5 9.009 COATU H HORATIU LIVIU sofer microbuz 7.00 9.00
10 POPESCU D ELENA DANIELA taxator 5.00 7.0011 BIRLADEANU N CIPRIAN sofer microbuz 10.00 9.512 BANDOL M MIHAI OVIDIU taxator 10.00 8.513 GROSU D FLORIN sofer microbuz 9.5 10.0014 RADU CRISTINEL sofer microbuz 6.00 8.0015 HINCU FLORIN sofer microbuz 10.00 9.6016 RADEANU ANCA contabil 9.00 9.0017 VATAFU DAN sofer microbuz 8.89 7.0018 HORCIU I. IOAN ANDREI sofer microbuz 10.00 9.00
19 dispecer 9.00 8.2520 FRÎNCU G GEORGE taxator 9.90 9.00
21 taxator 7.00 5.00Media lunara 8.21 8.17
nume GROSU D FLORIN teste
nota 9.5 6
Ianuarie Februarie8.21 8.17
CĂLĂTORU G. ALEXANDRU-GABRIEL
GALICEANU Ş.R. ANDREEA RALUCA
Martie Aprilie Mai Iunie Media Punctajul cel mai mic Punctajul cel mai mare7.00 8.00 9.00 8.00 8.17 7.00 9.006.00 8.00 9.00 6.00 7.33 6.00 9.00
8.5 6.00 8.00 8.00 6.75 5.00 8.009.00 7.00 8.00 9.00 8.00 7.00 9.009.00 7.00 8.00 9.00 8.60 7.00 10.00
9.5 7.00 8.00 6.00 7.20 6.00 8.008.5 9.00 8.5 7.00 8.00 7.00 9.008.4 9.1 8.00 9.00 8.67 8.00 9.00
6.00 8.00 7.00 7.00 7.33 6.00 9.009.00 8.00 8.00 9.00 7.67 5.00 9.009.00 8.5 8.00 8.00 8.75 8.00 10.009.00 8.00 9.00 9.00 9.00 8.00 10.009.00 8.00 9.00 8.00 8.80 8.00 10.007.00 7.59 6.81 7.00 7.07 6.00 8.009.40 9.00 8.00 8.00 9.00 8.00 10.009.00 9.00 9.00 9.00 9.00 9.00 9.007.00 6.25 9.80 9.00 7.99 6.25 9.805.00 8.00 6.00 5.00 7.17 5.00 10.00
8.00 7.00 9.00 8.00 8.21 7.00 9.009.00 9.00 9.00 9.00 9.15 9.00 9.90
6.00 8.00 6.00 7.00 6.50 5.00 8.007.85 7.78 8.13 7.86
Martie Aprilie Mai Iunie7.85 7.78 8.13 7.86
Prima/ NormalPrimaNormalNormalNormalPrimaNormalNormalPrimaNormalNormalPrimaPrimaPrimaNormalPrimaPrimaNormalNormal
PrimaPrima
Normal
Tabel candidatii pe posturile disponibile
Nr.crt. Nume si Prenume Nr.dosar Sex Data nasterii Post dorit
1 BACIU M ANDREEA 1030 F 10/30/1980 taxator
2 ENACHE I ANCA RAMONA 1031 F 6/10/1988 taxator
3 HONDREA C CONSTANTIN 1032 M 8/7/1971 sofer microbuz
4 ROSU D GHEORGHE EMILIAN 1033 M 1/26/1979 sofer microbuz
5 SIMIONICA V. COSMIN RADU 1034 M 4/14/1988 sofer microbuz
6 STRATULAT A ANDREI STELIAN 1035 M 10/15/1967 sofer microbuz
7 ZANCU C ADINA ANA 1036 F 7/30/1982 taxator
8 BISOC L SIMONA 1037 F 7/23/1992 taxator
9 ESANU M DRAGOS IONUT 1038 M 7/31/1969 sofer microbuz
10 DOROFTEI N NECULAI DAN 1039 M 11/2/1976 sofer microbuz
11 CORNEA F ELENA DIANA 1040 F 9/16/1983 taxator
12 TURCU DANIEL 1041 M 9/23/1978 sofer microbuz
13 LACATUSU ION 1042 M 1/26/1982 sofer microbuz
14 BÎRSAN G ŞTEFAN-CRISTIAN 1043 M 4/9/1976 sofer microbuz
15 CAZAN R. ALEXANDRU 1044 M 3/14/1976 sofer microbuz
16 1045 M 11/1/1979 taxator
17 FILIP V. ALEXANDRA MARIA 1046 F 12/4/1989 taxator
sex sexF M
6 11
DOCHIŢA V.C. VLADIMIR TEODOR
Nota interviu Nota proba practica Media finala Rezultat
6.4 7.00 7.00 RESPINS9.00 8.00 8.50 ADMIS
10.00 8.00 9.00 ADMIS10.00 9.00 9.50 ADMIS
9.60 8.00 8.80 ADMIS8.00 7.00 7.50 ADMIS9.00 9.00 9.00 ADMIS7.00 8.00 7.50 ADMIS9.00 8.5 9.00 ADMIS
9.7 9.00 9.00 ADMIS8.00 7.00 7.50 ADMIS
9.5 9.00 9.00 ADMIS7.00 6.00 6.50 RESPINS8.00 6.00 7.00 RESPINS
9.4 8.00 8.00 ADMIS
6.00 7.00 6.50 RESPINS
7.7 7.00 7.00 RESPINS
Imprumut bancar
Rata anuala a dobanzii 10%Numarul de ani 5Valoarea imprumutului 300000.00 lei
Suma lunara platita de firma-6,321.43 lei
simulare dupa o variabila -6,321.43 lei7%8%9%
10%11%12%
Economii angajat IVAN F CRISTIAN CONSTANTIN
Depunere anuala -4000.00 leiRata anuala a dobanzii 11%Valoare viitoare 40000.00 lei
6.59862399 7.183488
Nr.crt. Nume si prenume Functie Ianuarie Februarie Martie1 CRETU V BOGDAN sofer microbuz 9.00 8.00 7.002 GRAPA G CRISTIAN sofer microbuz 8.00 7.00 6.003 IVAN F CRISTIAN CONSTANTsofer microbuz 5.00 7.5 8.55 MITITELU P NARCIS sofer microbuz 10.00 8.5 9.007 VOINEA M LIVIU ANDREI sofer microbuz 7.5 8.00 8.58 DOGARU P PETRU GEORGEsofer microbuz 6.5 9.00 8.49 COATU H HORATIU LIVIU sofer microbuz 7.00 9.00 6.00
11 BIRLADEANU N CIPRIAN sofer microbuz 10.00 9.5 9.0013 GROSU D FLORIN sofer microbuz 9.5 10.00 9.0014 RADU CRISTINEL sofer microbuz 6.00 8.00 7.0015 HINCU FLORIN sofer microbuz 10.00 9.60 9.4017 VATAFU DAN sofer microbuz 8.89 7.00 7.0018 HORCIU I. IOAN ANDREI sofer microbuz 10.00 9.00 5.00
Media maxima soferi
9
Media minima soferi6.75
Nr.crt. Nume si prenume Functie Ianuarie Februarie Martie4 LICHIARDOPOL L GEORGIANtaxator 7.00 8.00 9.006 VACULISTEANU L ANDREEAtaxator 7.00 8.00 9.5
10 POPESCU D ELENA DANIELAtaxator 5.00 7.00 9.0012 BANDOL M MIHAI OVIDIU taxator 10.00 8.5 9.0020 FRÎNCU G GEORGE taxator 9.90 9.00 9.00
21 taxator 7.00 5.00 6.00
Media max taxatori9.15
Media min taxatori6.5
GALICEANU Ş.R. ANDREEA RALUCA
Aprilie Mai Iunie Media8.00 9.00 8.00 8.178.00 9.00 6.00 7.336.00 8.00 8.00 6.757.00 8.00 9.00 8.609.00 8.5 7.00 8.00
9.1 8.00 9.00 8.678.00 7.00 7.00 7.33
8.5 8.00 8.00 8.758.00 9.00 8.00 8.807.59 6.81 7.00 7.079.00 8.00 8.00 9.006.25 9.80 9.00 7.998.00 6.00 5.00 7.17
Aprilie Mai Iunie Media7.00 8.00 9.00 8.007.00 8.00 6.00 7.208.00 8.00 9.00 7.678.00 9.00 9.00 9.009.00 9.00 9.00 9.15
8.00 6.00 7.00 6.50
Calculul amortizarii
Valoare totala bus 200000 195000Perioada 10Val.reziduala 5000
SLN SYD 195,000.00 lei1 20000 19,500.00 lei 1 35,454.55 lei2 20000 19,500.00 lei 2 31,909.09 lei3 20000 19,500.00 lei 3 28,363.64 lei4 20000 19,500.00 lei 4 24,818.18 lei5 20000 19,500.00 lei 5 21,272.73 lei6 20000 19,500.00 lei 6 17,727.27 lei7 20000 19,500.00 lei 7 14,181.82 lei8 20000 19,500.00 lei 8 10,636.36 lei9 20000 19,500.00 lei 9 7,090.91 lei
10 20000 19,500.00 lei 10 3,545.45 lei
Ponderea candidatilor pe sexe
Variatia mediilor lunare ale angajatilor
Variatie medie generala- soferi
6
11
7.50
7.60
7.70
7.80
7.90
8.00
8.10
8.20
8.308.21
8.17
7.85
7.78
8.13
7.86
IanuarieFebruarieMartieAprilieMai Iunie
1 2 3 4 5 6 7 8 9 10 11 12 130.001.002.003.004.005.006.007.008.009.00
10.00
1 2 3 4 5 60.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
10.00
Variatie medie generala- taxatori
1 2 3 4 5 60.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
10.00
Average of Media finala RezultatNume si Prenume ADMIS RESPINS Total ResultBACIU M ANDREEA 7.00 7.00BISOC L SIMONA 7.50 7.50BÎRSAN G ŞTEFAN-CRISTIAN 7.00 7.00CAZAN R. ALEXANDRU 8.00 8.00CORNEA F ELENA DIANA 7.50 7.50DOCHIŢA V.C. VLADIMIR TEODOR 6.50 6.50DOROFTEI N NECULAI DAN 9.00 9.00ENACHE I ANCA RAMONA 8.50 8.50ESANU M DRAGOS IONUT 9.00 9.00FILIP V. ALEXANDRA MARIA 7.00 7.00HONDREA C CONSTANTIN 9.00 9.00LACATUSU ION 6.50 6.50ROSU D GHEORGHE EMILIAN 9.50 9.50SIMIONICA V. COSMIN RADU 8.80 8.80STRATULAT A ANDREI STELIAN 7.50 7.50TURCU DANIEL 9.00 9.00ZANCU C ADINA ANA 9.00 9.00Total Result 8.53 6.80 8.02
Minimizarea costului de transport
Ruta Iasi-Galati Iasi-BacauMaxitaxi/zi 3 maxitaxi/zi 3 maxitaxi/ziDistanta 219.00 KM 128.00 KMCheltuieli constante 4730.40 lei/saptamana 2304.00 lei/saptamanaLocuri disponibile 600 locuri/sapt. 500 locuri/sapt.Locuri ocupate efectiv 600 locuri/sapt. 500 locuri/sapt.Incasari efective 394200.00 lei/sapt 192000.00 lei/saptIncasari maxime 394200.00 lei/sapt 192000.00 lei/sapt
locuri/maxi lei/litru25 locuri/maxitaxi 6.00 lei/l
Ruta Nr. Maxitaxi/ziIasi-Galati 4 maxitaxi/ziIasi-Bacau 4 maxitaxi/ziIasi- Botosani 6 maxitaxi/ziIasi-Roman 3 maxitaxi/ziIasi- Piatra- Neamt 5 maxitaxi/ziBacau- Onesti 7 maxitaxi/ziBotosani- Suceava 10 maxitaxi/ziBuzau- Ramnicu- Sarat 10 maxitaxi/ziBuzau- Braila 8 maxitaxi/ziConstanta- Mangalia 8 maxitaxi/zi
Iasi- Botosani Iasi-Roman Iasi- Piatra- Neamt5 maxitaxi/zi 1 maxitaxi/zi 3 maxitaxi/zi
123.00 KM 86.00 KM 130.00 KM3542.40 lei/saptamana 774.00 lei/saptamana 2340.00 lei/saptamana
800 locuri/sapt. 250 locuri/sapt. 500 locuri/sapt.800 locuri/sapt. 250 locuri/sapt. 500 locuri/sapt.
295200.00 lei/sapt 64500.00 lei/sapt 195000.00 lei/sapt295200.00 lei/sapt 64500.00 lei/sapt 195000.00 lei/sapt
l/100km Pret bilet15.00 litri/100km 3.00 lei/km
Locuri disponibile Locuri ocupate efectiv700 locuri/sapt. 600 locuri/sapt.700 locuri/sapt. 500 locuri/sapt.
1050 locuri/sapt. 800 locuri/sapt.525 locuri/sapt. 250 locuri/sapt.875 locuri/sapt. 500 locuri/sapt.
1225 locuri/sapt. 1000 locuri/sapt.1750 locuri/sapt. 1600 locuri/sapt.1750 locuri/sapt. 1650 locuri/sapt.1400 locuri/sapt. 1200 locuri/sapt.1400 locuri/sapt. 1300 locuri/sapt.
Bacau- Onesti Botosani- Suceava Buzau- Ramnicu- Sarat6 maxitaxi/zi 9 maxitaxi/zi 9 maxitaxi/zi
51.00 KM 44.00 KM 33.00 KM1836.00 lei/saptamana 2534.40 lei/saptamana 1960.20 lei/saptamana
1000 locuri/sapt. 1600 locuri/sapt. 1650 locuri/sapt.1000 locuri/sapt. 1600 locuri/sapt. 1650 locuri/sapt.
153000.00 lei/sapt 211200.00 lei/sapt 163350.00 lei/sapt153000.00 lei/sapt 211200.00 lei/sapt 163350.00 lei/sapt
Buzau- Braila Constanta- Mangalia7 maxitaxi/zi 7 maxitaxi/zi
105.00 KM 45.00 KM4536.00 lei/saptamana 2106.00 lei/saptamana
1200 locuri/sapt. 1300 locuri/sapt.1200 locuri/sapt. 1300 locuri/sapt.
378000.00 lei/sapt 175500.00 lei/sapt 2221950.00 lei/sapt378000.00 lei/sapt 175500.00 lei/sapt 2221950.00 lei/sapt
0.00 lei/sapt
