Date Angajati si ProduseCompania Maximum
Angajati CompanieCod identificare departamentDepartamentProduse
VanduteTableteTelefoaneCalculatoareLaptop-uriiPod-uriNumePrenumeMoldovanAndreiC202IT2010250500120420590AvramGabrielA304Productie2011300401320300350BurteaStefanaD101Directiune2012290680254500100CioplanDianaB102TehnicVebarLiviuA304ProductieBalanDenisaC202ITPopaFlaviusD101DirectiuneAlamoreanLiviaA304ProductieEftimieIoanB102TehnicSacadatLaurentiuE103FinanciarSuciuBiancaF203ContabilitateMercenarAdrianA304ProductieSavuIonutE103FinanciarTatarIoanaC202ITDennumire
Produs:calculatoareAnul
Vanzarii201020122013StefanAlexandraA304Productie120320254MoldovanDariusD101DirectiuneDavidCristianF203ContabilitateBeleanMadalinaA304ProductieFodorAna-MariaE103FinanciarSasIoanB102Tehnic
Cod identificare
departamentDepartamentA304ProductieB102TehnicC202ITD101DirectiuneE103FinanciarF203Contabilitate
Anul
Salarii AngajatiNr.Crt.Nume Si Prenume
AngajatSalariu/OraProgramOre LucrateSalariu Brut/ZiSalariu pe
LunaPersoane cu Salarii >4800 RONOra IntrariOra
Iesiri1AvramGabriel80 RON8:0014:006480 RON9,600
RONAvram2BalanDenisa40 RON9:0015:006240 RON4,800 RON
3BurteaStefana35 RON7:0015:008280 RON5,600 RONBurtea4CioplanDiana12
RON11:0019:00896 RON1,920 RON 5MoldovanAndrei35 RON8:0015:007245
RON4,900 RONMoldovan6PopaFlavius35 RON10:0015:005175 RON3,500 RON
7VebarLiviu80 RON14:0019:005400 RON8,000 RONVebar8AlamoreanLivia30
RON14:0019:005150 RON3,000 RON 9EftimieIoan25 RON7:0015:008200
RON4,000 RON 10SacadatLaurentiu40 RON8:0014:006240 RON4,800 RON
11SuciuBianca40 RON11:0019:008320 RON6,400
RONSuciu12MercenarAdrian30 RON10:0015:005150 RON3,000 RON
13SavuIonut15 RON14:0019:00575 RON1,500 RON 14TatarIoana20
RON8:0014:006120 RON2,400 RON 15StefanAlexandra40 RON9:0015:006240
RON4,800 RON 16MoldovanDarius20 RON7:0015:008160 RON3,200 RON
17DavidCristian29 RON10:0015:005145 RON2,900 RON 18BeleanMadalina52
RON9:0015:006312 RON6,240 RONBelean19FodorAna-Maria40
RON8:0014:006240 RON4,800 RON 20SasIoan40 RON11:0019:008320
RON6,400 RONSas91,760 RONData Infiintarii Firmei2/23/10Data De
Azi5/27/13Total Zile Lucratoare850
Informatii Suplimentare AngajatiSalariul minim1,500
RONNr.Crt.Nume Si Prenume AngajatData NasteriiLunaZiua
SaptamaniiSalariul maxim91,760 RONSalariul mediu8,739
RON1AvramGabriel10/5/5610Friday2BalanDenisa25/2/812Wednesday3BurteaStefana3/8/748Saturday4CioplanDiana20/10/9010Saturday5MoldovanAndrei26/12/6912Friday6PopaFlavius8/9/939Wednesday7VebarLiviu28/3/793Wednesday8AlamoreanLivia10/7/8810Friday9EftimieIoan25/10/8110Sunday10SacadatLaurentiu15/8/848Wednesday11SuciuBianca20/10/9010Saturday12MercenarAdrian26/11/7911Monday13SavuIonut8/5/915Wednesday14TatarIoana4/5/754Saturday15StefanAlexandra25/2/812Wednesday16MoldovanDarius3/8/748Saturday17DavidCristian20/10/9010Saturday18BeleanMadalina26/12/6912Friday19FodorAna-Maria8/9/939Wednesday20SasIoan28/3/793Wednesday
Detali Produse
Produse
Vandute201020112012Calculatoare250300290iPod-uri500401680Laptop-uri120320254Tablete420300500Telefoane590350100Monitoare100200250Tastatura5059405Mouse60100101Casti100400450Imprimanta1039890Total
Produse Vandute Annual220028283120
Media Vanzarilor220283312Maxim Prod. Vandute dintr-o
Categorie590401680Legenda:Produse vandute peste 390 bucatiMinim
Prod. Vandute dintr-o Categorie105990Produse vandute sub 200 de
bucati
Pret ProduseProduse VanduteAnul UMCantitate
VandutaPret/BucValoare TotalaCalculatoare2010BUC2502,500 RON625,000
RONiPod-uriBUC500400 RON200,000 RONLaptop-uriBUC1202,800 RON336,000
RONTableteBUC420800 RON336,000 RONTelefoaneBUC590500 RON295,000
RONMonitoareBUC100350 RON35,000 RONTastaturaBUC5080 RON4,000
RONMouseBUC6060 RON3,600 RONCastiBUC10040 RON4,000
RONImprimantaBUC10450 RON4,500 RON5%Calculatoare2011BUC3002,625
RON787,500 RONiPod-uriBUC401420 RON168,420 RONLaptop-uriBUC3202,940
RON940,800 RONTableteBUC300840 RON252,000 RONTelefoaneBUC350525
RON183,750 RONMonitoareBUC200368 RON73,500 RONTastaturaBUC5984
RON4,956 RONMouseBUC10063 RON6,300 RONCastiBUC40042 RON16,800
RONImprimantaBUC398473 RON188,055 RON10%Calculatoare2012BUC2902,888
RON837,375 RONiPod-uriBUC680462 RON314,160 RONLaptop-uriBUC2543,234
RON821,436 RONTableteBUC500924 RON462,000 RONTelefoaneBUC100578
RON57,750 RONMonitoareBUC250404 RON101,063 RONTastaturaBUC40592
RON37,422 RONMouseBUC10169 RON6,999 RONCastiBUC45046 RON20,790
RONImprimantaBUC90520 RON46,778 RONTotal:7,124,176 RON
Reduceri de Pret
ProdusePret/BucReducerePret cu ReducereRotunjire in josRotunjire
in susCalculatoare2,888 RON10%2,599 lei25952600iPod-uri462 RON5%439
lei435500Laptop-uri3,234 RON7%3,008 lei30053100Tablete924 RON10%832
lei830900Telefoane578 RON20%462 lei460500Monitoare404 RON5%384
RON380400Tastatura92 RON4%89 RON85100Mouse69 RON8%64
RON60100Casti46 RON2%45 RON45100Imprimanta520 RON15%442
RON440500
Profit2012Produse VanduteCantitate VandutePret BucVenituri in
Urma VanzarilorCheltuieli Totale categorie de ProdusImpozitul pe
ProfitProfit BrutProfit Brut (%)Impozit pe Profit (RON)Profit
NetProfit Net (%)Calculatoare2902,888 RON837,375 RON750,000
RON16%87,375 RON10%13,980 RON73,395 RON39%iPod-uri680462 RON314,160
RON305,000 RON16%9,160 RON3%1,466 RON7,694 RON4%Laptop-uri2543,234
RON821,436 RON784,231 RON16%37,205 RON5%5,953 RON31,252
RON17%Tablete500924 RON462,000 RON399,500 RON16%62,500 RON14%10,000
RON52,500 RON28%Telefoane100578 RON57,750 RON50,000 RON16%7,750
RON13%1,240 RON6,510 RON3%Monitoare250404 RON101,063 RON95,000
RON16%6,063 RON6%970 RON5,093 RON3%Tastatura40592 RON37,422
RON30,555 RON16%6,867 RON18%1,099 RON5,768 RON3%Mouse10169 RON6,999
RON5,999 RON16%1,000 RON14%160 RON840 RON0%Casti45046 RON20,790
RON19,852 RON16%938 RON5%150 RON788 RON0%Imprimanta90520 RON46,778
RON41,200 RON16%5,578 RON12%892 RON4,685 RON2%
Total2,705,772 RON2,481,337 RON224,435 RON100%35,910 RON188,526
RON100%
Bonus Angajati
Nr.CrtNume AngajatDepartamentVanzariBonusAngajati D. ITAngajati
D. ProductieAngajati D. DirectiuneAngajati D. TehnicAngajati D.
FinanciarAngajati D. ContabilVanzatori care depasesc Media
Vanzarilor si primesc Bonus1Moldovan AndreiIT100,000
RONBonusTRUEFALSEFALSEFALSEFALSEFALSETRUE2Avram
GabrielProductie80,000
RON0FALSETRUEFALSEFALSEFALSEFALSEFALSE3Burtea
StefanaDirectiune90,000
RONBonusFALSEFALSETRUEFALSEFALSEFALSETRUE4Cioplan DianaTehnic55,896
RON0FALSEFALSEFALSETRUEFALSEFALSEFALSE5Vebar LiviuProductie478,500
RONBonusFALSETRUEFALSEFALSEFALSEFALSETRUE6Balan DenisaIT49,900
RON0TRUEFALSEFALSEFALSEFALSEFALSEFALSE7Popa FlaviusDirectiune50,000
RON0FALSEFALSETRUEFALSEFALSEFALSEFALSE8Alamorean
LiviaProductie44,957 RON0FALSETRUEFALSEFALSEFALSEFALSEFALSE9Eftimie
IoanTehnic37,271 RON0FALSEFALSEFALSETRUEFALSEFALSEFALSE10Sacadat
LaurentiuFinanciar29,585
RON0FALSEFALSEFALSEFALSETRUEFALSEFALSE11Suciu
BiancaContabilitate41,900
RON0FALSEFALSEFALSEFALSEFALSETRUEFALSE12Mercenar
AdrianProductie14,214 RON0FALSETRUEFALSEFALSEFALSEFALSEFALSE13Savu
IonutFinanciar62,052 RON0FALSEFALSEFALSEFALSETRUEFALSEFALSE14Tatar
IoanaIT88,071 RON0TRUEFALSEFALSEFALSEFALSEFALSEFALSE15Stefan
AlexandraProductie88,428
RON0FALSETRUEFALSEFALSEFALSEFALSEFALSE16Moldovan
DariusDirectiune165,285
RONBonusFALSEFALSETRUEFALSEFALSEFALSETRUE17David
CristianContabilitate242,142
RONBonusFALSEFALSEFALSEFALSEFALSETRUETRUE18Belean
MadalinaProductie219,000
RONBonusFALSETRUEFALSEFALSEFALSEFALSETRUE19Fodor
Ana-MariaFinanciar395,857
RONBonusFALSEFALSEFALSEFALSETRUEFALSETRUE20Sas IoanTehnic372,714
RONBonusFALSEFALSEFALSETRUEFALSEFALSETRUETOTAL2,705,772 RON
Vanzari Propuse90,000 RONVanzari minime14,214 RONVanzari
Maxime478,500 RONMedia Vanzarilor135,289 RON
1Total Vanzari Departament IT237,971 RON2Total Vanzari
Departament Productie925,099 RON3Total Vanzari Departament
Contabilitate284,042 RON4Total Vanzari Departament Financiar487,494
RON5Total Vanzari Departament Tehnic465,881 RON6Total Vanzari
Departament Directiune305,285 RONTOTAL2,705,772 RON
Imprumut si Depozite Firma Imprumut200,000 leiRata
Dobanzi5.10%Perioada120Plata2,131 leiRata Anuala a Dobanzi5%Plata
Periodica200 leiDepozit curent2,000 leiDupa retragere20,000 lei
Economii lunare20,000 leiNumarul de plati
139.45Dobanda2.50%Perioda depozit60Suma dupa retragere1,276,811
lei
InfoClientiCodClientNumePrenumeAdresaOrasJudetCodPostalTelefonEmailReducereProdVechimeClient7AvramAdriana
Atanasiu
[email protected]%4/29/102BoianLiviaTesatorilor
[email protected]%4/1/138CroitorVasilica
Calinului
[email protected]%11/16/115DavidAlexandruMorilor
[email protected]%9/20/113DorogaTraianIzvorului
[email protected]%9/20/1215FloreaAndreeaViilor
[email protected]%3/14/126HateganCristinaFantani
[email protected]%4/18/139KovacsHenrietaPetofi
Sandor 25Miercurea
[email protected]%7/24/1211LacatusMargaretaEroilor
[email protected]%12/29/1210MercenarVasileConstitutiei
[email protected]%11/14/1213NistorGeorgianaAbatorului
[email protected]%10/18/1114PrihoiMadalinaVitro
Metan
[email protected]%9/20/1212VasiuAlexandruMegediei
122Sfantu
[email protected]%8/10/111VijoliAdrianMediasului
51Copsa
[email protected]%10/5/104VijoliRaisaCastanilor
[email protected]%5/23/13
Detali Comenzii
NR.CrtNume si PrenumeProdusData achizitionariiTimp Cod
ComandaCantitati cerutePret/bucTVAPret fara TVAPret cu TVA
1CroitorVasilicaCalculator15/3/2010mai veche
de3ani1C5250024%12,500 RON15,500
RON2DavidAlexandruLaptop20/8/2010mai veche de3ani2L2280024%5,600
RON6,944 RON3DorogaTraianCasti10/10/2011mai veche de2ani3C34224%126
RON156
RON4FloreaAndreeaTelefon10/5/2013AndreeaareTelefonde17zile4T4577.524%2,310
RON2,864 RON5HateganCristinaMonitor19/12/2012mai veche
de1ani5M1404.2524%404 RON501
RON6KovacsHenrietaImprimanta20/2/2013HenrietaareImprimantade96zile6I4519.7524%2,079
RON2,578 RON7LacatusMargaretaIpod27/11/2011mai veche
de2ani7I842024%3,360 RON4,166
RON8MercenarVasileMouse12/4/2013VasileareMousede45zile8M169.324%69
RON86 RON9NistorGeorgianaLaptop13/8/2012mai veche
de1ani9L2323424%6,468 RON8,020
RON10PrihoiMadalinaTastatura24/7/2011mai veche de2ani10T58424%420
RON521
RON11VasiuAlexandruCalculator28/1/2013AlexandruareCalculatorde119zile11C2250024%5,000
RON6,200 RON12VijoliAdrianMouse16/9/2012mai veche
de1ani12M369.324%208 RON258
RON13VijoliRaisaIpod27/4/2013RaisaareIpodde30zile13I146224%462
RON573 RON
LegendaIpodTelefonCalculatorMouseLaptop
Analiza StatisticaProduse Vandute2010Analiza
Calculatoare250iPod-uri500Mean220.00Laptop-uri120Standard
Error66.13Tablete420Median110.00Telefoane590Mode100.00Monitoare100Standard
Deviation209.12Tastatura50Sample
Variance43733.33Mouse60Kurtosis-0.86Casti100Skewness0.87Imprimanta10Range580.00Minimum10.00Maximum590.00Sum2200.00Count10.001070140BinFrequency2101012807023501403420210049028015903500420149005902More0
