aa 5 - stan nicoleta denis.xls
Post on 26-Feb-2018
222 Views
Preview:
TRANSCRIPT
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 1/42
cod Data de distribuţie Titlu carte
100 Tue Jun 2002 383,785 Baze de Date
100 Mon Apr 2001 383,753 Birotica 2000
100 Mon Oct 2001 383,760 Birotica 2000
100 Fri Jan 2002 383,768 Birotica 2000
100 Sat Mar 2002 383,77 Birotica 2000
100 Fri Oct 2000 383,76 !i"ua# Ba"ic $or App#ication
200 Sat Mar 2002 383,77 Baze de Date
200 Tue Jun 2002 383,786 Baze de Date
200 T%u &o' 2000 383,76 Baze#e (n$or)aticii
200 Fri &o' 2001 383,761 Baze#e (n$or)aticii
200 T%u Ma* 2001 383,75 Birotica 2000
200 Fri Jan 2002 383,768 !i"ua# Fo+ ro
300 Tue Jan 2002 383,76- Baze de Date
300 Mon Mar 2002 383,775 Baze de Date
300 Mon &o' 2001 383,762 Birotica 2000
300 T%u Ma* 2001 383,75 O$$ice 2000 . /
300 Mon &o' 2000 383,77 !i"ua# Ba"ic $or App#ication
400 Fri &o' 2000 383,78 Baze de Date
400 T%u Ma* 2001 383,755 Birotica 2000
400 ed Mar 2002 383,776 (n$or)atica uti#izatoru#ui
400 Tue Jan 2002 383,76- O$$ice 2000 . /
400 Mon &o' 2001 383,763 rora)area ca#cu#atoare#or
500 Fri &o' 2001 383,76 Baze de Date
500 ed Mar 2002 383,776 Baze de Date
500 Tue Jan 2002 383,76- Birotic i Mu#ti)edia
500 ed Jan 2001 383,7- O$$ice 2000 . /
500 Mon Ma* 2001 383,756 rora)area ca#cu#atoare#or
600 Mon Ma* 2001 383,756 Birotica 2000
600 ed Mar 2002 383,776 Birotica 2000
600 Tue Jan 2002 383,770 (n$or)atica uti#izatoru#ui
600 Sat Fe4 2001 383,750 O$$ice 2000 . /
600 Fri &o' 2001 383,76 !i"ua# Fo+ ro
700 Tue Fe4 2001 383,751 Baze de date
700 ed Jan 2002 383,771 Baze de Date
700 ed Mar 2002 383,777 Baze de Date
700 Mon Jun 2001 383,757 !i"ua# Ba"ic $or App#ication
700 Fri &o' 2001 383,765 !i"ua# Ba"ic $or App#ication
800 Tue Fe4 2001 383,752 Baze#e (n$or)aticii
800 T%u Dec 2001 383,766 Birotica 2000
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 2/42
800 T%u Fe4 2002 383,772 Birotica 2000
800 Fri Apr 2002 383,778 Birotica 2000
800 ed Ju# 2001 383,758 !i"ua# Ba"ic $or App#ication
900 Mon Jan 2002 383,767 Baze de Date
900 ed Mar 2002 383,773 Baze de Date900 Fri Apr 2002 383,778 (n$or)atica uti#izatoru#ui
900 Tue Fe4 2001 383,752 O$$ice 2000 . /
900 Fri Oct 2001 383,75- rora)area ca#cu#atoare#or
1000 T%u Apr 2002 383,77- Baze de Date
1000 Fri Oct 2001 383,75- Baze#e (n$or)aticii
1100 ed Ma* 2002 383,780 Baze de Date
1200 ed Ma* 2002 383,780 Baze#e (n$or)aticii
1300 ed Ma* 2002 383,780 Birotica 2000
1400 Fri Ma* 2002 383,781 Baze de Date1500 Sat Ma* 2002 383,782 Baze#e (n$or)aticii
1600 Tue Jun 2002 383,783 Baze#e (n$or)aticii
1700 Tue Jun 2002 383,78 Baze de Date
1800 Tue Jun 2002 383,78 (n$or)atica uti#izatoru#ui
Cerinte:
1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 3/42
Nume Client Oras distributie Agent vanzare
AB& Ser'o) Bucureti A#4u M 180 275,000
!o+ 2000 Bucureti Moi"e"cu A 1,00 265,000
i4ri" Stoc #oie"ti Moi"e"cu A 125 265,000
i4rria entra# Si4iu A#4u M 20 265,000
i4raria 9: #oie"ti A#4u M 50 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 0 180,000
i4raria 9: #oie"ti A#4u M 60 275,000
i4rria entra# Si4iu Moi"e"cu A 320 275,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 80 20,000
i4rria entra# Si4iu #ea 600 20,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 16 265,000
i4rria entra# Si4iu A#4u M 30 180,000
u)ina i4ri" Buzu #ea 0 275,000
AB& Ser'o) Bucureti ;adu#e"cu S -0 275,000
;o#ri" Bucureti Moi"e"cu A 100 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 600 230,000
i4rria entra# Si4iu ;adu#e"cu S 800 180,000
!o+ 2000 Bucureti ope"cu M 00 275,000
i4ri" Stoc #oie"ti (one"cu 650 265,000
!o+ 2000 Bucureti ;adu#e"cu S -00 25,000
u)ina i4ri" Buzu #ea 00 230,000
;o#ri" Bucureti Moi"e"cu A 250 325,000
AB& Ser'o) Bucureti (one"cu -0 275,000
u)ina i4ri" Buzu !a"i#e"cu D 350 275,000
u)ina i4ri" Buzu #ea 200 265,000
i4ri" Stoc #oie"ti (one"cu -00 230,000
;o#ri" Bucureti ope"cu M 1,050 325,000
;o#ri" Bucureti ope"cu M 800 265,000
u)ina i4ri" Buzu !a"i#e"cu D 250 265,000
AB& Ser'o) Bucureti Moi"e"cu A 280 25,000
i4rria entra# Si4iu #ea 850 230,000
AB& Ser'o) Bucureti (one"cu 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D -00 275,000
i4ri" Stoc #oie"ti #ea 300 275,000
o)pania de #i4rrii Bucureti inti#ie 360 275,000
i4rria entra# Si4iu #ea 1,300 180,000
i4ri" Stoc #oie"ti #ea 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D 1,000 20,000
o)pania de #i4rrii Bucureti inti#ie 360 265,000
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 4/42
o)pania de #i4rrii Bucureti inti#ie 1,200 265,000
AB& Ser'o) Bucureti ;adu#e"cu S 750 265,000
o)pania de #i4rrii Bucureti A#4u M 1,000 180,000
o)pania de #i4rrii Bucureti (one"cu 2,000 275,000
!o+ 2000 Bucureti ;adu#e"cu S 1,50 275,000AB& Ser'o) Bucureti ;adu#e"cu S 5 25,000
AB& Ser'o) Bucureti !a"i#e"cu D 30 230,000
!o+ 2000 Bucureti (one"cu 750 325,000
i4raria #aedo Buzu Moi"e"cu A 75 275,000
!o+ 2000 Bucureti (one"cu 60 20,000
u)ina i4ri" Buzu Moi"e"cu A 20 275,000
u)ina i4ri" Buzu Moi"e"cu A 10 20,000
u)ina i4ri" Buzu Moi"e"cu A 0 265,000
!o+ 2000 Bucureti inti#ie 500 275,000i4raria #aedo Buzu A#4u M 20 20,000
o)pania de #i4rrii Bucureti (one"cu 800 20,000
i4raria 9: #oie"ti (one"cu 365 275,000
i4raria 9: on"tanta (one"cu 125 25,000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 5/42
Valoare vânzari
-500000
371,000,000
33125000
5300000
13250000
7,200,000
16500000
88000000
1-,200,000
1000000
,20,000
500000
11000000
2750000
26500000
138,000,000
1,000,000
110,000,000
172,250,000
220500000
-2000000
81250000
2750000
-6250000
53000000
207,000,000
31,250,000
212,000,000
66250000
68600000
1-5,500,000
18000000
27,500,000
82500000
--000000
23,000,000
18000000
20,000,000
-500000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 6/42
318000000
1-8750000
180,000,000
550000000
3-875000011025000
6,-00,000
23,750,000
20625000
100000
5500000
200000
10600000
13750000057600000
1-2000000
100375000
30625000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 7/42
cod Data de distribuţie Titlu carte
100 Tue Jun 2002 383,785 Baze de Date
100 Mon Apr 2001 383,753 Birotica 2000
100 Mon Oct 2001 383,760 Birotica 2000
100 Fri Jan 2002 383,768 Birotica 2000
100 Sat Mar 2002 383,77 Birotica 2000
100 Fri Oct 2000 383,76 !i"ua# Ba"ic $or App#ication
100 Total
200 Sat Mar 2002 383,77 Baze de Date
200 Tue Jun 2002 383,786 Baze de Date
200 T%u &o' 2000 383,76 Baze#e (n$or)aticii
200 Fri &o' 2001 383,761 Baze#e (n$or)aticii
200 T%u Ma* 2001 383,75 Birotica 2000
200 Fri Jan 2002 383,768 !i"ua# Fo+ ro
200 Total
300 Tue Jan 2002 383,76- Baze de Date
300 Mon Mar 2002 383,775 Baze de Date
300 Mon &o' 2001 383,762 Birotica 2000
300 T%u Ma* 2001 383,75 O$$ice 2000 . /
300 Mon &o' 2000 383,77 !i"ua# Ba"ic $or App#ication
300 Total
400 Fri &o' 2000 383,78 Baze de Date
400 T%u Ma* 2001 383,755 Birotica 2000
400 ed Mar 2002 383,776 (n$or)atica uti#izatoru#ui
400 Tue Jan 2002 383,76- O$$ice 2000 . /
400 Mon &o' 2001 383,763 rora)area ca#cu#atoare#or
400 Total
500 Fri &o' 2001 383,76 Baze de Date
500 ed Mar 2002 383,776 Baze de Date
500 Tue Jan 2002 383,76- Birotic i Mu#ti)edia
500 ed Jan 2001 383,7- O$$ice 2000 . /
500 Mon Ma* 2001 383,756 rora)area ca#cu#atoare#or
500 Total
600 Mon Ma* 2001 383,756 Birotica 2000
600 ed Mar 2002 383,776 Birotica 2000
600 Tue Jan 2002 383,770 (n$or)atica uti#izatoru#ui
600 Sat Fe4 2001 383,750 O$$ice 2000 . /
600 Fri &o' 2001 383,76 !i"ua# Fo+ ro
600 Total
700 Tue Fe4 2001 383,751 Baze de date
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 8/42
700 ed Jan 2002 383,771 Baze de Date
700 ed Mar 2002 383,777 Baze de Date
700 Mon Jun 2001 383,757 !i"ua# Ba"ic $or App#ication
700 Fri &o' 2001 383,765 !i"ua# Ba"ic $or App#ication
700 Total
800 Tue Fe4 2001 383,752 Baze#e (n$or)aticii
800 T%u Dec 2001 383,766 Birotica 2000
800 T%u Fe4 2002 383,772 Birotica 2000
800 Fri Apr 2002 383,778 Birotica 2000
800 ed Ju# 2001 383,758 !i"ua# Ba"ic $or App#ication
800 Total
900 Mon Jan 2002 383,767 Baze de Date
900 ed Mar 2002 383,773 Baze de Date
900 Fri Apr 2002 383,778 (n$or)atica uti#izatoru#ui900 Tue Fe4 2001 383,752 O$$ice 2000 . /
900 Fri Oct 2001 383,75- rora)area ca#cu#atoare#or
900 Total
1000 T%u Apr 2002 383,77- Baze de Date
1000 Fri Oct 2001 383,75- Baze#e (n$or)aticii
1000 Total
1100 ed Ma* 2002 383,780 Baze de Date
1100 Total
1200 ed Ma* 2002 383,780 Baze#e (n$or)aticii1200 Total
1300 ed Ma* 2002 383,780 Birotica 2000
1300 Total
1400 Fri Ma* 2002 383,781 Baze de Date
1400 Total
1500 Sat Ma* 2002 383,782 Baze#e (n$or)aticii
1500 Total
1600 Tue Jun 2002 383,783 Baze#e (n$or)aticii
1600 Total
1700 Tue Jun 2002 383,78 Baze de Date
1700 Total
1800 Tue Jun 2002 383,78 (n$or)atica uti#izatoru#ui
1800 Total
Grand Total
Cerinte:
1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 9/42
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 10/42
Nume Client Oras distributie Agent vanzare
AB& Ser'o) Bucureti A#4u M 180 275,000
!o+ 2000 Bucureti Moi"e"cu A 1,00 265,000
i4ri" Stoc #oie"ti Moi"e"cu A 125 265,000
i4rria entra# Si4iu A#4u M 20 265,000
i4raria 9: #oie"ti A#4u M 50 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 0 180,000
i4raria 9: #oie"ti A#4u M 60 275,000
i4rria entra# Si4iu Moi"e"cu A 320 275,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 80 20,000
i4rria entra# Si4iu #ea 600 20,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 16 265,000
i4rria entra# Si4iu A#4u M 30 180,000
u)ina i4ri" Buzu #ea 0 275,000
AB& Ser'o) Bucureti ;adu#e"cu S -0 275,000
;o#ri" Bucureti Moi"e"cu A 100 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 600 230,000
i4rria entra# Si4iu ;adu#e"cu S 800 180,000
!o+ 2000 Bucureti ope"cu M 00 275,000
i4ri" Stoc #oie"ti (one"cu 650 265,000
!o+ 2000 Bucureti ;adu#e"cu S -00 25,000
u)ina i4ri" Buzu #ea 00 230,000
;o#ri" Bucureti Moi"e"cu A 250 325,000
AB& Ser'o) Bucureti (one"cu -0 275,000
u)ina i4ri" Buzu !a"i#e"cu D 350 275,000
u)ina i4ri" Buzu #ea 200 265,000
i4ri" Stoc #oie"ti (one"cu -00 230,000
;o#ri" Bucureti ope"cu M 1,050 325,000
;o#ri" Bucureti ope"cu M 800 265,000
u)ina i4ri" Buzu !a"i#e"cu D 250 265,000
AB& Ser'o) Bucureti Moi"e"cu A 280 25,000
i4rria entra# Si4iu #ea 850 230,000
AB& Ser'o) Bucureti (one"cu 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D -00 275,000
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 11/42
i4ri" Stoc #oie"ti #ea 300 275,000
o)pania de #i4rrii Bucureti inti#ie 360 275,000
i4rria entra# Si4iu #ea 1,300 180,000
i4ri" Stoc #oie"ti #ea 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D 1,000 20,000
o)pania de #i4rrii Bucureti inti#ie 360 265,000
o)pania de #i4rrii Bucureti inti#ie 1,200 265,000
AB& Ser'o) Bucureti ;adu#e"cu S 750 265,000
o)pania de #i4rrii Bucureti A#4u M 1,000 180,000
o)pania de #i4rrii Bucureti (one"cu 2,000 275,000
!o+ 2000 Bucureti ;adu#e"cu S 1,50 275,000
AB& Ser'o) Bucureti ;adu#e"cu S 5 25,000AB& Ser'o) Bucureti !a"i#e"cu D 30 230,000
!o+ 2000 Bucureti (one"cu 750 325,000
i4raria #aedo Buzu Moi"e"cu A 75 275,000
!o+ 2000 Bucureti (one"cu 60 20,000
u)ina i4ri" Buzu Moi"e"cu A 20 275,000
u)ina i4ri" Buzu Moi"e"cu A 10 20,000
u)ina i4ri" Buzu Moi"e"cu A 0 265,000
!o+ 2000 Bucureti inti#ie 500 275,000
i4raria #aedo Buzu A#4u M 20 20,000
o)pania de #i4rrii Bucureti (one"cu 800 20,000
i4raria 9: #oie"ti (one"cu 365 275,000
i4raria 9: on"tanta (one"cu 125 25,000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 12/42
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 13/42
Valoare vânzari
-500000
371,000,000
33125000
5300000
13250000
7,200,000
7-,375,000
16500000
88000000
1-,200,000
1000000
,20,000
500000
27730000
11000000
2750000
26500000
138,000,000
1,000,000
3,250,000
110,000,000
172,250,000
220500000
-2000000
81250000
676000000
2750000
-6250000
53000000
207,000,000
31,250,000
722,250,000
212,000,000
66250000
68600000
1-5,500,000
18000000
560350000
27,500,000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 14/42
82500000
--000000
23,000,000
18000000
68100000020,000,000
-500000
318000000
1-8750000
180,000,000
1,032,150,000
550000000
3-8750000
110250006,-00,000
23,750,000
1,210,25,000
20625000
100000
35025000
5500000
5500000
200000200000
10600000
10600000
137500000
137500000
57600000
57600000
1-2000000
1-2000000100375000
100375000
30625000
30625000
655765000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 15/42
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 16/42
cod Data de distribuţie Titlu carte
Baze de Date Total
Bazele nformaticii Total
Birotica !""" Total
Birotică #i $ultimedia Total
nformatica utilizatorului Total
Office !""" % &P Total
Programarea calculatoarelor To
Visual Basic for A''lication Tot
Visual (o) Pro Total
*rand Total
Cerinte:1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 17/42
Nume Client Oras distributie Agent vanzare
tal
al
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 18/42
Valoare vânzari
2062500000
66-600000
1526665000
53000000
330750000
63-,00,000
666,250,000
583,200,000
2300000
655765000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 19/42
cod Data de distribuţie Titlu carte
Baze de Date $a)
Bazele nformaticii $a)
Birotica !""" $a)
Birotică #i $ultimedia $a)
nformatica utilizatorului $a)
Office !""" % &P $a)
Programarea calculatoarelor $
Visual Basic for A''lication $a
Visual (o) Pro $a)
*rand $a)
Cerinte:1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 20/42
Nume Client Oras distributie Agent vanzare
2,000
1,000
1,00
200
-00
-00
a) 1,050
) 1,300
100
2,000
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 21/42
Valoare vânzari
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 22/42
cod Data de distribuţie Titlu carte
Baze de Date $in
Bazele nformaticii $in
Birotica !""" $in
Birotică #i $ultimedia $in
nformatica utilizatorului $in
Office !""" % &P $in
Programarea calculatoarelor $
Visual Basic for A''lication $i
Visual (o) Pro $in
*rand $in
Cerinte:1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 23/42
Nume Client Oras distributie Agent vanzare
20
10
16
200
5
30
in 250
0
30
10
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 24/42
Valoare vânzari
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 25/42
cod Data de distribuţie Titlu carte
Cerinte:
1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 26/42
Nume Client Oras distributie Agent vanzare
Bucure#ti Average
Buzău Average
Constanta Average
Ploiesti Average
+ibiu Average
*rand Average
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 27/42
Valoare vânzari
1---080651613
1522500
30625000
80375000
116,600,000
11,--5,877
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 28/42
cod Data de distribuţie Titlu carte
100 Tue Jun 2002 383,785 Baze de Date
100 Mon Apr 2001 383,753 Birotica 2000
100 Fri Oct 2000 383,76 !i"ua# Ba"ic $or App#ication
200 T%u &o' 2000 383,76 Baze#e (n$or)aticii
200 T%u Ma* 2001 383,75 Birotica 2000
300 Mon Mar 2002 383,775 Baze de Date
300 Mon &o' 2001 383,762 Birotica 2000
300 T%u Ma* 2001 383,75 O$$ice 2000 . /
400 Fri &o' 2000 383,78 Baze de Date
400 ed Mar 2002 383,776 (n$or)atica uti#izatoru#ui
400 Mon &o' 2001 383,763 rora)area ca#cu#atoare#or
500 Fri &o' 2001 383,76 Baze de Date
500 Mon Ma* 2001 383,756 rora)area ca#cu#atoare#or 600 Mon Ma* 2001 383,756 Birotica 2000
600 Tue Jan 2002 383,770 (n$or)atica uti#izatoru#ui
600 Fri &o' 2001 383,76 !i"ua# Fo+ ro
700 Tue Fe4 2001 383,751 Baze de date
700 ed Mar 2002 383,777 Baze de Date
800 Tue Fe4 2001 383,752 Baze#e (n$or)aticii
800 T%u Dec 2001 383,766 Birotica 2000
800 T%u Fe4 2002 383,772 Birotica 2000
800 Fri Apr 2002 383,778 Birotica 2000800 ed Ju# 2001 383,758 !i"ua# Ba"ic $or App#ication
900 Mon Jan 2002 383,767 Baze de Date
900 ed Mar 2002 383,773 Baze de Date
900 Fri Apr 2002 383,778 (n$or)atica uti#izatoru#ui
900 Tue Fe4 2001 383,752 O$$ice 2000 . /
900 Fri Oct 2001 383,75- rora)area ca#cu#atoare#or
1000 Fri Oct 2001 383,75- Baze#e (n$or)aticii
1400 Fri Ma* 2002 383,781 Baze de Date
1600 Tue Jun 2002 383,783 Baze#e (n$or)aticii
300 Tue Jan 2002 383,76- Baze de Date
400 Tue Jan 2002 383,76- O$$ice 2000 . /
500 ed Mar 2002 383,776 Baze de Date
500 Tue Jan 2002 383,76- Birotic i Mu#ti)edia
600 ed Mar 2002 383,776 Birotica 2000
1000 T%u Apr 2002 383,77- Baze de Date
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 29/42
1100 ed Ma* 2002 383,780 Baze de Date
1200 ed Ma* 2002 383,780 Baze#e (n$or)aticii
1300 ed Ma* 2002 383,780 Birotica 2000
1500 Sat Ma* 2002 383,782 Baze#e (n$or)aticii
1800 Tue Jun 2002 383,78 (n$or)atica uti#izatoru#ui
100 Mon Oct 2001 383,760 Birotica 2000
100 Sat Mar 2002 383,77 Birotica 2000
200 Sat Mar 2002 383,77 Baze de Date
400 T%u Ma* 2001 383,755 Birotica 2000
500 ed Jan 2001 383,7- O$$ice 2000 . /
700 ed Jan 2002 383,771 Baze de Date
700 Fri &o' 2001 383,765 !i"ua# Ba"ic $or App#ication
1700 Tue Jun 2002 383,78 Baze de Date
100 Fri Jan 2002 383,768 Birotica 2000
200 Tue Jun 2002 383,786 Baze de Date
200 Fri &o' 2001 383,761 Baze#e (n$or)aticii
200 Fri Jan 2002 383,768 !i"ua# Fo+ ro
300 Mon &o' 2000 383,77 !i"ua# Ba"ic $or App#ication
600 Sat Fe4 2001 383,750 O$$ice 2000 . /
700 Mon Jun 2001 383,757 !i"ua# Ba"ic $or App#ication
Cerinte:
1. Volumul total al vanzarilor pe coduri de carte
2. Volumul total al vanzarilor pe titluri de carte
3. Maimum cantitatilor vandute pe titluri de carte
4. Minimum cantitatilor vandute pe titluri de carte
5. Media vanzarilor pe ora! de di!tri"utie
6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 30/42
Nume Client Oras distributie Agent vanzare
AB& Ser'o) Bucureti A#4u M 180 275,000
!o+ 2000 Bucureti Moi"e"cu A 1,00 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 0 180,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 80 20,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 16 265,000
AB& Ser'o) Bucureti ;adu#e"cu S -0 275,000
;o#ri" Bucureti Moi"e"cu A 100 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 600 230,000
!o+ 2000 Bucureti ope"cu M 00 275,000
!o+ 2000 Bucureti ;adu#e"cu S -00 25,000
;o#ri" Bucureti Moi"e"cu A 250 325,000
AB& Ser'o) Bucureti (one"cu -0 275,000
;o#ri" Bucureti ope"cu M 1,050 325,000;o#ri" Bucureti ope"cu M 800 265,000
AB& Ser'o) Bucureti Moi"e"cu A 280 25,000
AB& Ser'o) Bucureti (one"cu 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D -00 275,000
o)pania de #i4rrii Bucureti inti#ie 360 275,000
AB& Ser'o) Bucureti !a"i#e"cu D 1,000 20,000
o)pania de #i4rrii Bucureti inti#ie 360 265,000
o)pania de #i4rrii Bucureti inti#ie 1,200 265,000
AB& Ser'o) Bucureti ;adu#e"cu S 750 265,000o)pania de #i4rrii Bucureti A#4u M 1,000 180,000
o)pania de #i4rrii Bucureti (one"cu 2,000 275,000
!o+ 2000 Bucureti ;adu#e"cu S 1,50 275,000
AB& Ser'o) Bucureti ;adu#e"cu S 5 25,000
AB& Ser'o) Bucureti !a"i#e"cu D 30 230,000
!o+ 2000 Bucureti (one"cu 750 325,000
!o+ 2000 Bucureti (one"cu 60 20,000
!o+ 2000 Bucureti inti#ie 500 275,000
o)pania de #i4rrii Bucureti (one"cu 800 20,000
Bucure#ti Total 17,581
u)ina i4ri" Buzu #ea 0 275,000
u)ina i4ri" Buzu #ea 00 230,000
u)ina i4ri" Buzu !a"i#e"cu D 350 275,000
u)ina i4ri" Buzu #ea 200 265,000
u)ina i4ri" Buzu !a"i#e"cu D 250 265,000
i4raria #aedo Buzu Moi"e"cu A 75 275,000
Cantitatevanduta
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 31/42
u)ina i4ri" Buzu Moi"e"cu A 20 275,000
u)ina i4ri" Buzu Moi"e"cu A 10 20,000
u)ina i4ri" Buzu Moi"e"cu A 0 265,000
i4raria #aedo Buzu A#4u M 20 20,000
Buzău Total 1,625
i4raria 9: on"tanta (one"cu 125 25,000
Constanta Total 125
i4ri" Stoc #oie"ti Moi"e"cu A 125 265,000
i4raria 9: #oie"ti A#4u M 50 265,000
i4raria 9: #oie"ti A#4u M 60 275,000
i4ri" Stoc #oie"ti (one"cu 650 265,000
i4ri" Stoc #oie"ti (one"cu -00 230,000
i4ri" Stoc #oie"ti #ea 300 275,000
i4ri" Stoc #oie"ti #ea 100 180,000
i4raria 9: #oie"ti (one"cu 365 275,000
Ploiesti Total 2,550
i4rria entra# Si4iu A#4u M 20 265,000
i4rria entra# Si4iu Moi"e"cu A 320 275,000
i4rria entra# Si4iu #ea 600 20,000
i4rria entra# Si4iu A#4u M 30 180,000
i4rria entra# Si4iu ;adu#e"cu S 800 180,000
i4rria entra# Si4iu #ea 850 230,000
i4rria entra# Si4iu #ea 1,300 180,000
+ibiu Total 3,-20
*rand Total 25,801
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 32/42
Valoare vânzari
-500000
371,000,000
7,200,000
1-,200,000
,20,000
2750000
26500000
138,000,000
110,000,000
220500000
81250000
2750000
31,250,000212,000,000
68600000
18000000
27,500,000
--000000
20,000,000
-500000
318000000
1-8750000180,000,000
550000000
3-8750000
11025000
6,-00,000
23,750,000
100000
137500000
1-2000000
11000000
-2000000
-6250000
53000000
66250000
20625000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 33/42
5500000
200000
10600000
57600000
30625000
33125000
13250000
16500000
172,250,000
207,000,000
82500000
18000000
100375000
5300000
88000000
1000000
500000
1,000,000
1-5,500,000
23,000,000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 34/42
cod Data de distribuţie Titlu carte
100 Tue Jun 2002 383,785 Baze de Date
100 Mon Apr 2001 383,753 Birotica 2000
100 Mon Oct 2001 383,760 Birotica 2000
100 Fri Jan 2002 383,768 Birotica 2000
100 Sat Mar 2002 383,77 Birotica 2000
100 Fri Oct 2000 383,76 !i"ua# Ba"ic $or App#ication
200 Sat Mar 2002 383,77 Baze de Date
200 Tue Jun 2002 383,786 Baze de Date
200 T%u &o' 2000 383,76 Baze#e (n$or)aticii
200 Fri &o' 2001 383,761 Baze#e (n$or)aticii
200 T%u Ma* 2001 383,75 Birotica 2000
200 Fri Jan 2002 383,768 !i"ua# Fo+ ro
300 Tue Jan 2002 383,76- Baze de Date
300 Mon Mar 2002 383,775 Baze de Date
300 Mon &o' 2001 383,762 Birotica 2000
300 T%u Ma* 2001 383,75 O$$ice 2000 . /
300 Mon &o' 2000 383,77 !i"ua# Ba"ic $or App#ication
400 Fri &o' 2000 383,78 Baze de Date
400 T%u Ma* 2001 383,755 Birotica 2000
400 ed Mar 2002 383,776 (n$or)atica uti#izatoru#ui
400 Tue Jan 2002 383,76- O$$ice 2000 . /
400 Mon &o' 2001 383,763 rora)area ca#cu#atoare#or
500 Fri &o' 2001 383,76 Baze de Date500 ed Mar 2002 383,776 Baze de Date
500 Tue Jan 2002 383,76- Birotic i Mu#ti)edia
500 ed Jan 2001 383,7- O$$ice 2000 . /
500 Mon Ma* 2001 383,756 rora)area ca#cu#atoare#or
600 Mon Ma* 2001 383,756 Birotica 2000
600 ed Mar 2002 383,776 Birotica 2000
600 Tue Jan 2002 383,770 (n$or)atica uti#izatoru#ui
600 Sat Fe4 2001 383,750 O$$ice 2000 . /
600 Fri &o' 2001 383,76 !i"ua# Fo+ ro
700 Tue Fe4 2001 383,751 Baze de date
700 ed Jan 2002 383,771 Baze de Date
700 ed Mar 2002 383,777 Baze de Date
700 Mon Jun 2001 383,757 !i"ua# Ba"ic $or App#ication
700 Fri &o' 2001 383,765 !i"ua# Ba"ic $or App#ication
800 Tue Fe4 2001 383,752 Baze#e (n$or)aticii
800 T%u Dec 2001 383,766 Birotica 2000
Numărfactură
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 35/42
800 T%u Fe4 2002 383,772 Birotica 2000
800 Fri Apr 2002 383,778 Birotica 2000
800 ed Ju# 2001 383,758 !i"ua# Ba"ic $or App#ication
900 Mon Jan 2002 383,767 Baze de Date
900 ed Mar 2002 383,773 Baze de Date
900 Fri Apr 2002 383,778 (n$or)atica uti#izatoru#ui
900 Tue Fe4 2001 383,752 O$$ice 2000 . /
900 Fri Oct 2001 383,75- rora)area ca#cu#atoare#or
1000 T%u Apr 2002 383,77- Baze de Date
1000 Fri Oct 2001 383,75- Baze#e (n$or)aticii
1100 ed Ma* 2002 383,780 Baze de Date
1200 ed Ma* 2002 383,780 Baze#e (n$or)aticii
1300 ed Ma* 2002 383,780 Birotica 2000
1400 Fri Ma* 2002 383,781 Baze de Date
1500 Sat Ma* 2002 383,782 Baze#e (n$or)aticii
1600 Tue Jun 2002 383,783 Baze#e (n$or)aticii
1700 Tue Jun 2002 383,78 Baze de Date
1800 Tue Jun 2002 383,78 (n$or)atica uti#izatoru#ui
Cerinte:
1. Volumul total al vanzarilor pe coduri de carte 3. Maimum cantitatilor vandu
cod $um o% Valoare v&nzari 'itlu carte
100 479375000 (aze de )ate
200 277340000 (azele *n%ormaticii
300 344250000 (irotica 2000
400 676000000 (irotic+ ,i Multimedia500 722250000 *n%ormatica utilizatorului
600 560350000 -%%ice 2000 /
700 681000000 roramarea calculatoarelor
800 1032150000 Vi!ual (a!ic %or pplication
900 1210425000 Vi!ual o ro
1000 35025000 rand 'otal
1100 5500000
1200 2400000
1300 10600000
1400 137500000 4. Minimum cantitatilor vandut
1500 57600000
1600 192000000 'itlu carte1700 100375000 (aze de )ate
1800 30625000 (azele *n%ormaticii
rand 'otal 6554765000 (irotica 2000
(irotic+ ,i Multimedia
2. Volumul total al vanzarilor pe titluri de carte *n%ormatica utilizatorului
-%%ice 2000 /
'itlu carte $um o% Valoare v&nzari roramarea calculatoarelor
(aze de )ate 2062500000 Vi!ual (a!ic %or pplication
(azele *n%ormaticii 669600000 Vi!ual o ro
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 36/42
(irotica 2000 1526665000 rand 'otal
(irotic+ ,i Multimedia 53000000
*n%ormatica utilizatorului 330750000
-%%ice 2000 / 639400000
roramarea calculatoarelor 666250000
Vi!ual (a!ic %or pplication 583200000
Vi!ual o ro 23400000
rand 'otal 6554765000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 37/42
Nume Client Oras distributie Agent vanzare Cantitate vanduta
AB& Ser'o) Bucureti A#4u M 180 275,000
!o+ 2000 Bucureti Moi"e"cu A 1,00 265,000
i4ri" Stoc #oie"ti Moi"e"cu A 125 265,000
i4rria entra# Si4iu A#4u M 20 265,000
i4raria 9: #oie"ti A#4u M 50 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 0 180,000
i4raria 9: #oie"ti A#4u M 60 275,000
i4rria entra# Si4iu Moi"e"cu A 320 275,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 80 20,000
i4rria entra# Si4iu #ea 600 20,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 16 265,000
i4rria entra# Si4iu A#4u M 30 180,000
u)ina i4ri" Buzu #ea 0 275,000
AB& Ser'o) Bucureti ;adu#e"cu S -0 275,000
;o#ri" Bucureti Moi"e"cu A 100 265,000
o)pania de #i4rrii Bucureti ;adu#e"cu S 600 230,000
i4rria entra# Si4iu ;adu#e"cu S 800 180,000
!o+ 2000 Bucureti ope"cu M 00 275,000
i4ri" Stoc #oie"ti (one"cu 650 265,000
!o+ 2000 Bucureti ;adu#e"cu S -00 25,000
u)ina i4ri" Buzu #ea 00 230,000
;o#ri" Bucureti Moi"e"cu A 250 325,000
AB& Ser'o) Bucureti (one"cu -0 275,000u)ina i4ri" Buzu !a"i#e"cu D 350 275,000
u)ina i4ri" Buzu #ea 200 265,000
i4ri" Stoc #oie"ti (one"cu -00 230,000
;o#ri" Bucureti ope"cu M 1,050 325,000
;o#ri" Bucureti ope"cu M 800 265,000
u)ina i4ri" Buzu !a"i#e"cu D 250 265,000
AB& Ser'o) Bucureti Moi"e"cu A 280 25,000
i4rria entra# Si4iu #ea 850 230,000
AB& Ser'o) Bucureti (one"cu 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D -00 275,000
i4ri" Stoc #oie"ti #ea 300 275,000
o)pania de #i4rrii Bucureti inti#ie 360 275,000
i4rria entra# Si4iu #ea 1,300 180,000
i4ri" Stoc #oie"ti #ea 100 180,000
AB& Ser'o) Bucureti !a"i#e"cu D 1,000 20,000
o)pania de #i4rrii Bucureti inti#ie 360 265,000
Pretcarte
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 38/42
o)pania de #i4rrii Bucureti inti#ie 1,200 265,000
AB& Ser'o) Bucureti ;adu#e"cu S 750 265,000
o)pania de #i4rrii Bucureti A#4u M 1,000 180,000
o)pania de #i4rrii Bucureti (one"cu 2,000 275,000
!o+ 2000 Bucureti ;adu#e"cu S 1,50 275,000
AB& Ser'o) Bucureti ;adu#e"cu S 5 25,000
AB& Ser'o) Bucureti !a"i#e"cu D 30 230,000
!o+ 2000 Bucureti (one"cu 750 325,000
i4raria #aedo Buzu Moi"e"cu A 75 275,000
!o+ 2000 Bucureti (one"cu 60 20,000
u)ina i4ri" Buzu Moi"e"cu A 20 275,000
u)ina i4ri" Buzu Moi"e"cu A 10 20,000
u)ina i4ri" Buzu Moi"e"cu A 0 265,000
!o+ 2000 Bucureti inti#ie 500 275,000
i4raria #aedo Buzu A#4u M 20 20,000
o)pania de #i4rrii Bucureti (one"cu 800 20,000
i4raria 9: #oie"ti (one"cu 365 275,000
i4raria 9: on"tanta (one"cu 125 25,000
e pe titluri de carte 5. Media vanzarilor pe ora! de di!tri"utie
Ma o% Cantitate vanduta -ra! di!tri"utie verae o% Valoare v&nzari
2000 (ucure,ti 149990806.451613
1000 (uz+u 41522500
1400 Con!tanta 30625000
200 loie!ti 80375000900 $i"iu 116600000
900 rand 'otal 114995877.192982
1050
1300
100
2000 6. #umarul de aparitii al vanzarilor pe ora! de di!tri"utie
-ra! di!tri"utie $um o% Cantitate vanduta
(ucure,ti 17581
pe titluri de carte (uz+u 1625
Con!tanta 125
Min o% Cantitate vanduta loie!ti 255020 $i"iu 3920
10 rand 'otal 25801
16
200
45
30
250
40
30
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 39/42
10
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 40/42
Valoare vânzari
-500000
371,000,000
33125000
5300000
13250000
7,200,000
16500000
88000000
1-,200,000
1000000
,20,000
500000
11000000
2750000
26500000
138,000,000
1,000,000
110,000,000
172,250,000
220500000
-2000000
81250000
2750000-6250000
53000000
207,000,000
31,250,000
212,000,000
66250000
68600000
1-5,500,000
18000000
27,500,000
82500000
--000000
23,000,000
18000000
20,000,000
-500000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 41/42
318000000
1-8750000
180,000,000
550000000
3-8750000
11025000
6,-00,000
23,750,000
20625000
100000
5500000
200000
10600000
137500000
57600000
1-2000000
100375000
30625000
7/25/2019 AA 5 - Stan Nicoleta Denis.xls
http://slidepdf.com/reader/full/aa-5-stan-nicoleta-denisxls 42/42
top related