Excel Boromir

ANGAJATII S.C BOROMIR S.R.L

NR.CRT. NUME SI PRENUME FUNCTIE DATA ANGAJARII VECHIME SALARIU

1 Anghel Larisa director general 1/1/2001 22 5000

2 Antonescu Pavel director adjunct 3/12/2001 22 2500

3 Avram Ioana director marketing 2/16/2002 21 2300

4 Badea Marian director vanzari 7/23/2001 22 2300

5 Baiasu Elena vanzator 5/4/2001 22 1500

6 Berceanu Eduard paznic 8/25/2003 20 500

7 Bitu Maria contabil 1/18/2001 22 2200

8 Casapu Elisa vanzator 9/28/2005 18 1500

9 Coman Antonel sef raion 12/11/2008 15 2000

10 Creanga Ion paznic 11/26/2010 13 1300

11 Cristescu Mihaela contabil 9/19/2009 14 2200

12 Dan Ana Maria vanzator 6/12/2007 16 1500

13 Danescu Cristina sef magazin 5/3/2012 11 2100

14 Gateje Ana Maria sef raion 5/10/2013 10 2000

15 Gheorghe Ramona vanzator 2/15/2001 22 1500

16 Grigorescu Alexandra vanzator 9/12/2004 19 1500

17 Lica Constantin paznic 5/14/2006 17 1300

18 Radoi Antonia contabil 9/25/2007 16 2200

19 Radutoiu Andreea vanzator 6/13/2005 18 1500

20 Serban Alexandru paznic 12/19/2012 11 1300

Total

351 38200

CEL MAI MARE SALARIU 837.25CEL MAI MIC SALARIU 126.5SALARIU MEDIU 361.159

Salarii

Salarii


SPOR VECHIME PRIME SALARIU BRUT SOMAJ C.A.S.S C.A.S IMPOZIT

0.00 550 5550 27.75 1387.5 2497.5 800

0.00 500 3000 15 750 1350 400

0.00 450 2750 13.75 687.5 1237.5 368

0.00 450 2750 13.75 687.5 1237.5 368

0.00 250 1750 8.75 437.5 787.5 240

0.00 200 700 3.5 175 315 80

0.00 350 2550 12.75 637.5 1147.5 352

0.00 250 1750 8.75 437.5 787.5 240

0.00 300 2300 11.5 575 1035 320

156.00 200 1656 8.28 414 745.2 208

0.00 350 2550 12.75 637.5 1147.5 352

0.00 250 1750 8.75 437.5 787.5 240

252.00 300 2652 13.26 663 1193.4 336

240.00 300 2540 12.7 635 1143 320

0.00 250 1750 8.75 437.5 787.5 240

0.00 250 1750 8.75 437.5 787.5 240

0.00 200 1500 7.5 375 675 208

0.00 350 2550 12.75 637.5 1147.5 352

0.00 250 1750 8.75 437.5 787.5 240

156.00 200 1656 8.28 414 745.2 208

804.00 6200 45204 226.02 11301 20341.8 6112

Salarii

Salarii


SALARIU NET

837.25

485

443.25

443.25

276.25

126.5

400.25

276.25

358.5

280.52

400.25

276.25

446.34

429.3

276.25

276.25

234.5

400.25

276.25

280.52

7223.18

PRODUSE BOROMIR

NR.CRT. PRODUS CANTITATE TVA PRET TVAPRET FARA TVA

1 Paine alba 150 0.36 1.86 1.50

2 Paine secara 145 0.41 2.11 1.70

3 Paine neagra 150 0.36 1.86 1.50

4 Paine graham 135 0.31 1.61 1.30

5 Cozonac traditional 78 4.29 22.18 17.89

6 Cozonac nuca si stafide 95 4.29 22.18 17.89

7 Piscoturi 100 1.08 5.58 4.50

8 Prestige cu cicolata 50 4.56 23.55 18.99

9 Pasca cu branza si stafide 40 4.56 23.55 18.99

10 Pasca tiramisu 30 1.56 8.06 6.50

11 Pasca lamaie 50 1.56 8.06 6.50

12 Pasca ciocolata 45 1.56 8.06 6.50

13 Croissante crema ciocolata 30 0.36 1.86 1.50

14 Croissante crema lamaie 40 0.36 1.86 1.50

15 Croissante crema vanilie 50 0.36 1.86 1.50

16 Blat tort simplu 10 2.30 11.89 9.59

17 Blat tort cacao 12 2.30 11.89 9.59

18 Tortina crema caise 28 0.35 1.80 1.45

19 Tortina crema lapte 48 0.35 1.80 1.45

1286 31.28 161.62 130.34TOTAL

VALOARE TVA VALOARE FARA TVA

279.00 225.00

305.66 246.50

279.00 225.00

217.62 175.50

1730.32 1395.42

2107.44 1699.55

558.00 450.00

1177.38 949.50

941.90 759.60

241.80 195.00

403.00 325.00

362.70 292.50

55.80 45.00

74.40 60.00

93.00 75.00

118.92 95.90

142.70 115.08

50.34 40.60

86.30 69.60

9225.29 7439.75

Nr.crt. Produse Pret fara TVA TVA Pret TVA

1 Paine alba 1.50 0.36 1.86

2 Paine secara 1.70 0.41 2.11

3 Paine neagra 1.50 0.36 1.86

4 Paine graham 1.30 0.31 1.61

5 Cozonac traditional 17.89 4.29 22.18

6 Cozonac nuca si stafide 17.89 4.29 22.18

7 Piscoturi 4.50 1.08 5.58

8 Prestige cu ciocolata 18.99 4.56 23.55

9 Pasca cu branza si stafide 18.99 4.56 23.55

10 Pasca tiramisu 6.50 1.56 8.06

11 Pasca lamaie 6.50 1.56 8.06

12 Pasca ciocolata 6.50 1.56 8.06

13 Croissante crema ciocolata 1.50 0.36 1.86

14 Croissante crema lamaie 1.50 0.36 1.86

15 Croissante crema vanilie 1.50 0.36 1.86

16 Blat tort simplu 9.59 2.30 11.89

17 Blat tort cacao 9.59 2.30 11.89

18 Tortina crema caise 1.45 0.35 1.80

19 Tortina crema lapte 1.45 0.35 1.80

TOTAL 130.34 31.28 161.62

Produse Preturi rotunjite COD PRODUS PRET

Paine alba 1.00 Pain 1.00

Paine secara 2.00 Pain 2.00

Paine neagra 1.00 Pain 1.00

Paine graham 1.00 Pain 1.00

Cozonac traditional 22.00 Cozo 22.00

Cozonac nuca si stafide 22.00 Cozo 22.00

Piscoturi 5.00 Pisc 5.00

Prestige cu ciocolata 23.00 Pres 23.00

Pasca cu branza si stafide 23.00 Pasc 23.00

Pasca tiramisu 8.00 isu 8.00

Pasca lamaie 8.00 aie 8.00

Pasca ciocolata 8.00 ata 8.00

Croissante crema ciocolata 1.00 ata 1.00

Croissante crema lamaie 1.00 aie 1.00

Croissante crema vanilie 1.00 lie 1.00

Blat tort simplu 11.00 plu 11.00

Blat tort cacao 11.00 cao 11.00

Tortina crema caise 1.00 ise 1.00

Tortina crema lapte 1.00 pte 1.00

PRODUSE

Media aritmetica a pretului cu TVA 8.51

Media aritmetica a pretului fara TVA 6.86

Media aritmetica a valorii cu TVA 485.54

Media aritmetica a valorii fara TVA 391.57

Det val medie 6.86

Radical din suma 6.534503

PRETURI

Media aritmetica a pretului cu TVA 8.51Media aritmetica a pretului fara TVA 6.86Media aritmetica a preturilor rotunjite 8.33Numarare 19Det val medie 8.51Radical din suma 4.868237

CEL MAI MARE TVA 0.31CEL MAI MIC TVA 4.56CEA MAI MARE VALOARE 2107.44CEA MAI MICA VOLOARE 50.34CEL MAI MIC PRET 1.61CEL MAI MARE PRET 23.55

CEL MAI MIC TVA 0.31CEL MAI MARE TVA 4.56CEL MAI MIC PRET 1.61CEL MAI MARE PRET 23.55CEL MAI MIC PRET ROTUNJIT 1.00CEL MAI MARE PRET ROTUNJIT 23.00

NR.CRT NUME SI PRENUME FUNCTIE SALARIU PRIME IMPOZIT

1 Anghel Larisa director general 5000 550 800

2 Antonescu Pavel director adjunct 2500 500 400

3 Avram Ioana director marketing 2300 450 368

4 Badea Marian director vanzari 2300 450 368

5 Baiasu Elena vanzator 1500 250 240

6 Berceanu Eduard paznic 500 200 80

7 Bitu Maria contabil 2200 350 352

8 Casapu Elisa vanzator 1500 250 240

9 Coman Antonel sef raion 2000 300 320

10 Creanga Ion paznic 1300 200 208

11 Cristescu Mihaela contabil 2200 350 352

12 Dan Ana Maria vanzator 1500 250 240

13 Danescu Cristina sef magazin 2100 300 336

14 Gateje Ana Maria sef raion 2000 300 320

15 Gheorghe Ramona vanzator 1500 250 240

16 Grigorescu Alexandra vanzator 1500 250 240

17 Lica Constantin paznic 1300 200 208

18 Radoi Antonia contabil 2200 350 352

19 Radutoiu Andreea vanzator 1500 250 240

20 Serban Alexandru paznic 1300 200 208

ANGAJATUL NR. 4 SI FUNCTIA director vanzariANGAJATULUI NR 8 SI SALARIUL 1500ANGAJATUL NR 17 SI PRIMA 200ANGAJATUL NR 14 SI NUMELE Gateje Ana MariaANGAJATUL NR 19 SI IMPOZITUL 240

directo

r gen

eral

directo

r adjunct

directo

r mark

eting

directo

r van

zari

vanzat

or

paznic

contab

il

vanzat

or

sef ra

ion

paznic

contab

il

vanzat

or

sef m

agazi

n

sef ra

ion

vanzat

or

vanzat

or

paznic

contab

il

vanzat

or

paznic

0

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

Column F

Paine albaPaine secaraPaine neagraPaine grahamCozonac traditionalCozonac nuca si stafidePiscoturiPrestige cu cicolataPasca cu branza si stafidePasca tiramisuPasca lamaiePasca ciocolataCroissante crema ciocolataCroissante crema lamaieCroissante crema vanilieBlat tort simpluBlat tort cacaoTortina crema caiseTortina crema lapte

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

0500

100015002000250030003500400045005000 5000

25002300 2300

1500

500

2200

15002000

1300

2200

1500

21002000

1500 15001300

2200

15001300

837.25485 443.25 443.25

276.25126.5 400.25

276.25 358.5 280.52 400.25276.25 446.34 429.3

276.25 276.25 234.5 400.25276.25 280.52

SALARII

SALARIU ANGAJARESALARIU NET

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

0500

100015002000250030003500400045005000 5000

25002300 2300

1500

500

2200

15002000

1300

2200

1500

21002000

1500 15001300

2200

15001300

837.25485 443.25 443.25

276.25126.5 400.25

276.25 358.5 280.52 400.25276.25 446.34 429.3

276.25 276.25 234.5 400.25276.25 280.52

SALARII


directo

r gen

eral

directo

r adjunct

directo

r mark

eting

directo

r van

zari

vanzat

or

paznic

contab

il

vanzat

or

sef ra

ion

paznic

contab

il

vanzat

or

sef m

agazi

n

sef ra

ion

vanzat

or

vanzat

or

paznic

contab

il

vanzat

or

paznic

0

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

Column F


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

0500

100015002000250030003500400045005000 5000

25002300 2300

1500

500

2200

15002000

1300

2200

1500

21002000

1500 15001300

2200

15001300

837.25485 443.25 443.25

276.25126.5 400.25

276.25 358.5 280.52 400.25276.25 446.34 429.3

276.25 276.25 234.5 400.25276.25 280.52

SALARII


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

0500

100015002000250030003500400045005000 5000

25002300 2300

1500

500

2200

15002000

1300

2200

1500

21002000

1500 15001300

2200

15001300

837.25485 443.25 443.25

276.25126.5 400.25

276.25 358.5 280.52 400.25276.25 446.34 429.3

276.25 276.25 234.5 400.25276.25 280.52

SALARII


directo

r gen

eral

directo

r adjunct

directo

r mark

eting

directo

r van

zari

vanzat

or

paznic

contab

il

vanzat

or

sef ra

ion

paznic

contab

il

vanzat

or

sef m

agazi

n

sef ra

ion

vanzat

or

vanzat

or

paznic

contab

il

vanzat

or

paznic

0

500

1000

1500

2000

2500

3000

3500

4000

4500

5000

Column F


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

0500

100015002000250030003500400045005000 5000

25002300 2300

1500

500

2200

15002000

1300

2200

1500

21002000

1500 15001300

2200

15001300

837.25485 443.25 443.25

276.25126.5 400.25

276.25 358.5 280.52 400.25276.25 446.34 429.3

276.25 276.25 234.5 400.25276.25 280.52

SALARII


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

0500

100015002000250030003500400045005000 5000

25002300 2300

1500

500

2200

15002000

1300

2200

1500

21002000

1500 15001300

2200

15001300

837.25485 443.25 443.25

276.25126.5 400.25

276.25 358.5 280.52 400.25276.25 446.34 429.3

276.25 276.25 234.5 400.25276.25 280.52

SALARII


Excel Boromir

Documents

Transcript of Excel Boromir