0% found this document useful (0 votes)
61 views6 pages

Producator Model Cod Fabrica Culoare Pret Unitati Vandute

The document contains sales data for various car models from different manufacturers including Audi, BMW, Citroen, Fiat, Ford, Nissan, Peugeot, Renault, Rover, Skoda, Volkswagen, and Volvo. It lists the manufacturer, model, factory code, color, price, and number of units sold for each car model. It also includes information on total revenue, average price, number of models, minimum and maximum price, total standard and premium models sold, and revenue by model type.

Uploaded by

Tica Diaconita
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
61 views6 pages

Producator Model Cod Fabrica Culoare Pret Unitati Vandute

The document contains sales data for various car models from different manufacturers including Audi, BMW, Citroen, Fiat, Ford, Nissan, Peugeot, Renault, Rover, Skoda, Volkswagen, and Volvo. It lists the manufacturer, model, factory code, color, price, and number of units sold for each car model. It also includes information on total revenue, average price, number of models, minimum and maximum price, total standard and premium models sold, and revenue by model type.

Uploaded by

Tica Diaconita
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Valoare impozit 18.

00%

Producator Model Cod fabrica Culoare Pret Unitati vandute


Audi A4 A222 JFD Green 6,495.00 20
Audi TT N866 GHR Black 3,295.00 15
BMW M3 L766 PVS Blue 5,899.00 45
BMW 712 T800 CIP Black 6,895.00 20
BMW M3 L766 PVS Blue 5,899.00 14
Citroen XM Estate N298 LUI Black 9,950.00 56
Citroen XM Estate N298 LUI Black 9,950.00 10
Fiat Uno L766 PVS Blue 3,295.00 88
Fiat Uno L766 PVS Blue 3,295.00 12
Ford Escort N342 PRW Black 6,495.00 19
Ford Escort N342 PRW Black 6,495.00 10
Nissan Bluebird F446 JJK Red 1,995.00 90
Peugeot S407 F446 JJK Gray 8,911.00 75
Peugeot 306 N722 JFD Blue 5,000.00 40
Ranault Megane L766 PVS Red 3,195.00 18
Renault Clio J962 NRK Red 3,195.00 15
Renault Megane L766 PVS Red 3,195.00 8
Rover Kensington N866 GHR Red 4,495.00 70
Skoda Felicia P334 JKE Burgundy 4,995.00 18
Volkswagen Golf K452 UKM Red 5,495.00 60
Volkswagen Polo J342 DEL White 3,995.00 20
Volvo 440 M275 CRE White 6,895.00 80
Volvo 440 M275 CRE White 6,895.00 70
Wolswagen Golf F446 JJK White 5,495.00 15

Raport
Incasari totale
Pret mediu
Numar modele
Pret minim
Pret maxim
Numar total de modele standard
Numar total de modele premium
Incasari totale pentru modelele standard
Incasari totale pentru modelele premium
Numar de modele care genereaza incasari de peste 500000
Evidentiati modele care genereaza incasari de peste 500000 (formatare conditionala)
Incasari pe model Impozit datorat Top incasari Categorie Tara

Cod Tara
A222 JFD Austria
F446 JJK Germania
J342 DEL Belgia
J962 NRK Bulgaria
K452 UKM Rusia
L766 PVS Japonia
M275 CRE Chile
N298 LUI Mexic
N342 PRW Africa de sud
N722 JFD India
N866 GHR China
P334 JKE Norvegia
T800 CIP Anglia
Nume Functia Cod angajDepartament Salariu de incadrare
Tartan Alexandru economist 001 Financiar 4,560
Tataru Marian contabil 002 Contabilitate 9,950
Teler Mihaela agent vanzari 003 Mvanzari 8,911
Teler Mihaela asistent 005 Marketing 6,895
Teodorescu Raluca Ioana manager 001 Financiar 6,895
teodoru bogdan asistent 002 Marketing 6,895
Tepelus Georgiana economist 005 Financiar 6,495
Timmer Maria agent vanzari 001 Vanzari 6,495
Toader Marian Razvan operator 002 IT 6,495
toma ana-cristina programator 003 IT 5,899
Tomescu Gabriel agent vanzari 005 Vanzari 5,899
Ionescu Alexandra contabil 001 Contabilitate 5,495
Trif Bianca economist 002 Financiar 5,495
Troasca Andrei agent vanzari 003 Vanzari 5,000
Tudor Stoenescu operator 005 IT 4,995
Tudose Ana-Maria economist 001 Financiar 4,495
tudose jenica agent vanzari 002 Vanzari 3,995
Turcan Lavinia manager 003 Marketing 3,295
Turcanu Iuliana economist 005 ResurseUmane 3,295
Turcitu Cristian agent vanzari 001 Vanzari 3,295
Tutuianu Liviu operator 002 IT 3,195
Udrea Bogdan - Mitrut economist 003 ResurseUmane 3,195
Ungureanu Andreea agent vanzari 004 Vanzari 3,195
Ursu Elena Alexandra economist 001 Financiar 1,995

Raport
Salarii totale
Salariu mediu
Numar angajati
Salariu minim
Salariu maxim
Numar total de angajati cu vechime mai mare de 5 ani
Numar total de angajati cu vechime mai mica de 5 ani
Suma salariilor platite angajatilor cu vechime mai mare de 5 ani
Suma salariilor platite angajatilor cu vechime mai mica de 5 ani
Data angajarii Vechime Spor vechime Salariu brut Impozit Sector sediu
01/11/04
27/08/02
03/04/01
12/07/01
21/05/02
01/05/09
18/09/06
17/06/07
04/03/06
13/06/03
16/04/04
23/03/08
10/08/06
11/11/06
03/06/04
30/03/03
28/05/06
13/03/01
14/02/05
02/05/03
17/05/03
10/05/03
11/05/03
12/05/03

Cod Sediul Ani vechime


001 Sector 1 <=2
002 Sector 2 2<vecime<=4
003 Sector 3 4<vecime<=6
005 Sector 4 6<vecime<=8
>8

Salariu Cota Impozit


<=2000 0.1
2000<s<=4000 0.15
4000<s<=6000 0.2
>6000 0.25
Spor vechime
0
0.05
0.1
0.15
0.2
Cost Firma 1 Firma 2 Firma 3 Firma 4
Produs 1 180 160 125 170
Produs 2 190 175 150 185
Produs 3 1000 890 845 775

Destinatie Mijloc Cost


Produs 1 Firma 2

You might also like