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