excel

gloo1989

FinalExam-Excel.xlsm

Home >Business & Finance homework help >Accounting homework help >excel

Q2-A

Information for Year 1
		Sales	COGS
Store Name	Store ID	Sales_Yr1	COGS_Year1
Reforma Angel	REF-001	299202	74800.5
Aguilas	AGU-002	205447	51361.75
Olivar de los Padres	OLI-003	126956	31739
Bosque Horizontes	BOS-004	190037	47509.25
Prado Norte	PRA-005	165388	41347
Pedregal	PED-006	166902	41725.5
Campos Eliseos	CAM-007	191314	47828.5
WTC	WTC-008	312087	78021.75
Torre Mayor	TOR-009	265300	66325
Masaryk	MAS-010	148147	37036.75
Insurgentes Parroquia	INS-011	137729	34432.25
Juan Pablo II	JUA-012	195230	48807.5
Miramontes	MIR-013	162359	40589.75
Zona Azul	ZON-014	148199	37049.75
Santa Teresa	SAN-015	171693	42923.25
Satélite	SAT-016	205046	65614.72
Corporativo Polanco	COR-017	265366	84917.12
Lomas Verdes	LOM-018	162359	51361.75

Q2-B

Information for Year 2
Store Name	Store ID	Sales_Yr2	COGS_Year2
Reforma Angel	REF-001	284587	71146.75
Aguilas	AGU-002	199714	49928.5
Olivar de los Padres	OLI-003	132097	33024.25
Bosque Horizontes	BOS-004	189326	47331.5
Prado Norte	PRA-005	169669	42417.25
Pedregal	PED-006	175060	43765
Campos Eliseos	CAM-007	202371	50592.75
WTC	WTC-008	326494	81623.5
Torre Mayor	TOR-009	266798	66699.5
Masaryk	MAS-010	181451	45362.75
Insurgentes Parroquia	INS-011	139181	34795.25
Juan Pablo II	JUA-012	197529	49382.25
Miramontes	MIR-013	162355	40588.75
Zona Azul	ZON-014	152000	38000
Santa Teresa	SAN-015	184427	46106.75
Satélite	SAT-016	206216	65989.12
Corporativo Polanco	COR-017	270442	86541.44
Lomas Verdes	LOM-018	181451	50592.75

Q2-C

Information for Year 3
Store Name	Store ID	Sales_Yr3	COGS_Year3
Reforma Angel	REF-001	320623	80155.75
Aguilas	AGU-002	191600	47900
Olivar de los Padres	OLI-003	134120	33530
Bosque Horizontes	BOS-004	188446	47111.5
Prado Norte	PRA-005	163438	40859.5
Pedregal	PED-006	179502	44875.5
Campos Eliseos	CAM-007	185803	46450.75
WTC	WTC-008	283125	70781.25
Torre Mayor	TOR-009	272981	68245.25
Masaryk	MAS-010	177619	44404.75
Insurgentes Parroquia	INS-011	144664	36166
Juan Pablo II	JUA-012	193927	48481.75
Miramontes	MIR-013	155424	38856
Zona Azul	ZON-014	149177	37294.25
Santa Teresa	SAN-015	182175	45543.75
Satélite	SAT-016	199099	63711.68
Corporativo Polanco	COR-017	267599	85631.68
Lomas Verdes	LOM-018	272981	44875.5

Q2-D

Information for Year 4
Store Name	Store ID	Sales_Yr4	COGS_Year4
Reforma Angel	REF-001	310343	77585.75
Aguilas	AGU-002	196768	49192
Olivar de los Padres	OLI-003	123319	30829.75
Bosque Horizontes	BOS-004	190001	47500.25
Prado Norte	PRA-005	171596	42899
Pedregal	PED-006	168502	42125.5
Campos Eliseos	CAM-007	178330	44582.5
WTC	WTC-008	317349	79337.25
Torre Mayor	TOR-009	260876	65219
Masaryk	MAS-010	195647	48911.75
Insurgentes Parroquia	INS-011	129479	32369.75
Juan Pablo II	JUA-012	189414	47353.5
Miramontes	MIR-013	147209	36802.25
Zona Azul	ZON-014	151538	37884.5
Santa Teresa	SAN-015	171512	42878
Satélite	SAT-016	193770	62006.4
Corporativo Polanco	COR-017	262321	83942.72
Lomas Verdes	LOM-018	178330	47500.25

Q2

Question 2
Store Name	Total Sales	Total COGS
Reforma Angel
Aguilas
Olivar de los Padres
Bosque Horizontes
Prado Norte
Pedregal
Campos Eliseos
WTC
Torre Mayor
Masaryk
Insurgentes Parroquia
Juan Pablo II
Miramontes
Zona Azul
Santa Teresa
Satélite
Corporativo Polanco
Lomas Verdes

&D &T &Z&F &F

Q3

Question 3

Q5

Question 5

Q6

Question 6

IF Statement

Q9

	Question 9	Pivot Tables
Month	Customer Name	Department	Planner Code	Units Sold
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS		16,848
Jun-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	10,440
Jun-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	8,706
Dec-11	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	7,920
Dec-11	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	7,344
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS		4,320
Mar-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	3,000
Mar-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	3,000
Apr-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	2,400
Apr-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	2,400
May-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	2,400
Dec-11	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	2,328
Dec-11	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	2,040
Apr-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	2,016
May-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	1,800
Jun-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	1,800
Jun-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	1,800
Apr-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	1,500
May-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	1,356
Dec-11	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	1,224
Jul-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	1,200
Jul-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	1,200
Dec-11	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	1,116
May-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	1,092
Sep-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	1,080
Jul-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	900
Aug-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	840
Aug-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	840
Aug-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	840
Sep-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	840
Jan-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	804
Sep-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	714
Jan-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	600
Sep-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	600
Feb-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	576
May-12	LASINO SA	060 ROASTED COFFEE	BONEIL	576
Jan-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	552
Aug-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	516
Aug-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	480
Aug-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	480
Sep-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	480
Jan-12	LASINO SA	060 ROASTED COFFEE	BONEIL	468
Jun-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	EMALKOWS	456
Jun-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	456
Jul-12	DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	060 ROASTED COFFEE	BONEIL	456
Jan-12	LASINO SA	060 ROASTED COFFEE	EMALKOWS	432
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	396
Jul-12	LASINO SA	060 ROASTED COFFEE	EMALKOWS	360
Aug-12	LASINO SA	060 ROASTED COFFEE	EMALKOWS	360
Sep-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	360
Oct-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	360
Oct-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	324
Mar-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	312
Mar-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	312
Jul-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	312
Jul-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	312
Feb-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	300
Feb-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	300
May-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	300
Oct-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	300
Dec-11	COFFEE CAY	060 ROASTED COFFEE	BONEIL	288
May-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	288
May-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	288
May-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	288
Oct-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	288
Oct-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	288
Oct-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	288
Oct-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	288
Oct-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	270
Dec-11	COFFEE CAY	060 ROASTED COFFEE	EMALKOWS	252
Jun-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	252
Jan-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	240
Jan-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	240
Jan-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	240
Mar-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	240
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	240
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	240
Aug-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	240
Aug-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	240
Oct-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	240
Mar-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	228
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	228
Jun-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	192
Mar-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	180
Apr-12	PANACAFE DE GUATEMALA, S.A.	060 ROASTED COFFEE	EMALKOWS	180
Apr-12	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	EMALKOWS	180
Apr-12	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	BONEIL	180
Apr-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	180
Jan-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	BONEIL	168
Oct-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	168
Feb-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	156
Feb-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	156
Feb-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	156
Mar-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	156
May-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	156
Jun-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	156
Jan-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	EMALKOWS	144
Feb-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	144
Feb-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	EMALKOWS	144
Mar-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	144
Mar-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	144
Mar-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	144
Mar-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	144
Mar-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	144
Mar-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	144
Apr-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	144
Apr-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	144
Apr-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	BONEIL	144
Apr-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	144
Apr-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	144
Jul-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	144
Oct-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	144
Jul-12	LASINO SA	060 ROASTED COFFEE	BONEIL	132
Jul-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	132
Dec-11	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	BONEIL	120
Dec-11	PANACAFE DE GUATEMALA, S.A.	060 ROASTED COFFEE	BONEIL	120
Mar-12	COFFEE CAY	060 ROASTED COFFEE	EMALKOWS	120
Mar-12	COFFEE CAY	060 ROASTED COFFEE	BONEIL	120
Mar-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	120
May-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	120
May-12	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	EMALKOWS	120
May-12	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	BONEIL	120
Jul-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	060 ROASTED COFFEE	BONEIL	120
Jul-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	120
Jul-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	120
Dec-11	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	EMALKOWS	108
Dec-11	PANACAFE DE GUATEMALA, S.A.	060 ROASTED COFFEE	EMALKOWS	108
Jun-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	108
Aug-12	LASINO SA	060 ROASTED COFFEE	BONEIL	108
Sep-12	STARBUCKS BRASIL COMERCIO de CAFES LTDA	010 BEVERAGE COMPONENTS	BGUBBELS	102
Mar-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	96
Apr-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	96
May-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	96
Jun-12	LASINO SA	060 ROASTED COFFEE	BONEIL	96
Jul-12	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	EMALKOWS	96
Jul-12	PANACAFE DE ELSALVADOR, S.A. DE C.V.	060 ROASTED COFFEE	BONEIL	96
Apr-12	PANACAFE DE COSTA RICA, S.A.	060 ROASTED COFFEE	EMALKOWS	84
Apr-12	PANACAFE DE COSTA RICA, S.A.	060 ROASTED COFFEE	BONEIL	84
May-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	72
Jun-12	PANACAFE DE GUATEMALA, S.A.	060 ROASTED COFFEE	EMALKOWS	72
Aug-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	72
Aug-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	BONEIL	72
Sep-12	LASINO SA	060 ROASTED COFFEE	BONEIL	72
Sep-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	72
Sep-12	PANACAFE DE COSTA RICA, S.A.	060 ROASTED COFFEE	EMALKOWS	72
Sep-12	STARBUCKS COFFEE CHILE S.A	060 ROASTED COFFEE	EMALKOWS	60
Apr-12	COFFEE CAY	060 ROASTED COFFEE	EMALKOWS	48
Apr-12	COFFEE CAY	060 ROASTED COFFEE	BONEIL	48
May-12	LASINO SA	060 ROASTED COFFEE	BONEIL	48
Sep-12	PANACAFE DE COSTA RICA, S.A.	060 ROASTED COFFEE	BONEIL	48
Jul-12	LASINO SA	060 ROASTED COFFEE	EMALKOWS	36
Aug-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	EMALKOWS	36
Aug-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	BONEIL	36
Oct-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	EMALKOWS	36
Oct-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	BONEIL	36
Jul-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	EMALKOWS	24
Jul-12	CARIBBEAN OVERSEAS LTD	060 ROASTED COFFEE	BONEIL	24
Aug-12	COFFEE CAY	060 ROASTED COFFEE	EMALKOWS	24
Aug-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	24
Aug-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	24
Aug-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	24
Sep-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	24
Sep-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	24
Sep-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	24
Oct-12	STARBUCKS COFFEE PUERTO RICO LLC	060 ROASTED COFFEE	EMALKOWS	24
Jul-12	LASINO SA	060 ROASTED COFFEE	BONEIL	12
Aug-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	12
Aug-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	12
Aug-12	COFFEE CAY	022 READY TO DRINK & EAT	KIANDERS	12

Q10

Question 7
Macros		Name:
Customer Name	Month	Department	Demand Class	Planner Code	Units Sold
COFFEE CAY	Aug-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	12
COFFEE CAY	Aug-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	12
COFFEE CAY	Aug-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	12
LASINO SA	Jul-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	12
COFFEE CAY	Aug-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	24
COFFEE CAY	Aug-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	24
COFFEE CAY	Aug-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	24
COFFEE CAY	Sep-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	24
COFFEE CAY	Sep-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	24
COFFEE CAY	Sep-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	24
CARIBBEAN OVERSEAS LTD	Jul-12	060 ROASTED COFFEE	Licensed Aruba	EMALKOWS	24
COFFEE CAY	Aug-12	060 ROASTED COFFEE	Licensed Bahamas	EMALKOWS	24
STARBUCKS COFFEE PUERTO RICO LLC	Oct-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	24
CARIBBEAN OVERSEAS LTD	Jul-12	060 ROASTED COFFEE	Licensed Aruba	BONEIL	24
LASINO SA	Jul-12	060 ROASTED COFFEE	Licensed Peru	EMALKOWS	36
CARIBBEAN OVERSEAS LTD	Aug-12	060 ROASTED COFFEE	Licensed Aruba	EMALKOWS	36
CARIBBEAN OVERSEAS LTD	Oct-12	060 ROASTED COFFEE	Licensed Aruba	EMALKOWS	36
CARIBBEAN OVERSEAS LTD	Aug-12	060 ROASTED COFFEE	Licensed Aruba	BONEIL	36
CARIBBEAN OVERSEAS LTD	Oct-12	060 ROASTED COFFEE	Licensed Aruba	BONEIL	36
COFFEE CAY	Apr-12	060 ROASTED COFFEE	Licensed Bahamas	EMALKOWS	48
COFFEE CAY	Apr-12	060 ROASTED COFFEE	Licensed Bahamas	BONEIL	48
LASINO SA	May-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	48
PANACAFE DE COSTA RICA, S.A.	Sep-12	060 ROASTED COFFEE	Joint Venture Costa Rica	BONEIL	48
STARBUCKS COFFEE CHILE S.A	Sep-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	60
PANACAFE DE GUATEMALA, S.A.	Jun-12	060 ROASTED COFFEE	Joint Venture Guatemala	EMALKOWS	72
STARBUCKS COFFEE CHILE S.A	Aug-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	72
STARBUCKS COFFEE CHILE S.A	Sep-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	72
PANACAFE DE COSTA RICA, S.A.	Sep-12	060 ROASTED COFFEE	Joint Venture Costa Rica	EMALKOWS	72
STARBUCKS COFFEE CHILE S.A	May-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	72
STARBUCKS COFFEE CHILE S.A	Aug-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	72
LASINO SA	Sep-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	72
PANACAFE DE COSTA RICA, S.A.	Apr-12	060 ROASTED COFFEE	Joint Venture Costa Rica	EMALKOWS	84
PANACAFE DE COSTA RICA, S.A.	Apr-12	060 ROASTED COFFEE	Joint Venture Costa Rica	BONEIL	84
PANACAFE DE ELSALVADOR, S.A. DE C.V.	Jul-12	060 ROASTED COFFEE	Joint Venture El Salvador	EMALKOWS	96
STARBUCKS COFFEE CHILE S.A	Mar-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	96
STARBUCKS COFFEE CHILE S.A	Apr-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	96
STARBUCKS COFFEE CHILE S.A	May-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	96
LASINO SA	Jun-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	96
PANACAFE DE ELSALVADOR, S.A. DE C.V.	Jul-12	060 ROASTED COFFEE	Joint Venture El Salvador	BONEIL	96
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Sep-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	102
PANACAFE DE ELSALVADOR, S.A. DE C.V.	Dec-11	060 ROASTED COFFEE	Joint Venture El Salvador	EMALKOWS	108
PANACAFE DE GUATEMALA, S.A.	Dec-11	060 ROASTED COFFEE	Joint Venture Guatemala	EMALKOWS	108
STARBUCKS COFFEE CHILE S.A	Jun-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	108
LASINO SA	Aug-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	108
COFFEE CAY	Mar-12	060 ROASTED COFFEE	Licensed Bahamas	EMALKOWS	120
STARBUCKS COFFEE CHILE S.A	May-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	120
PANACAFE DE ELSALVADOR, S.A. DE C.V.	May-12	060 ROASTED COFFEE	Joint Venture El Salvador	EMALKOWS	120
PANACAFE DE ELSALVADOR, S.A. DE C.V.	Dec-11	060 ROASTED COFFEE	Joint Venture El Salvador	BONEIL	120
PANACAFE DE GUATEMALA, S.A.	Dec-11	060 ROASTED COFFEE	Joint Venture Guatemala	BONEIL	120
COFFEE CAY	Mar-12	060 ROASTED COFFEE	Licensed Bahamas	BONEIL	120
STARBUCKS COFFEE CHILE S.A	Mar-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	120
PANACAFE DE ELSALVADOR, S.A. DE C.V.	May-12	060 ROASTED COFFEE	Joint Venture El Salvador	BONEIL	120
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jul-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	120
STARBUCKS COFFEE CHILE S.A	Jul-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	120
STARBUCKS COFFEE CHILE S.A	Jul-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	120
STARBUCKS COFFEE CHILE S.A	Jul-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	132
LASINO SA	Jul-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	132
CARIBBEAN OVERSEAS LTD	Jan-12	060 ROASTED COFFEE	Licensed Aruba	EMALKOWS	144
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Feb-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	144
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Feb-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	144
STARBUCKS COFFEE PUERTO RICO LLC	Mar-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	144
STARBUCKS COFFEE PUERTO RICO LLC	Mar-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	144
STARBUCKS COFFEE PUERTO RICO LLC	Mar-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	144
STARBUCKS COFFEE CHILE S.A	Apr-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	144
STARBUCKS COFFEE PUERTO RICO LLC	Apr-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	144
STARBUCKS COFFEE CHILE S.A	Apr-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	144
STARBUCKS COFFEE CHILE S.A	Jul-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	144
STARBUCKS COFFEE PUERTO RICO LLC	Mar-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	144
STARBUCKS COFFEE PUERTO RICO LLC	Mar-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	144
STARBUCKS COFFEE PUERTO RICO LLC	Mar-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	144
STARBUCKS COFFEE PUERTO RICO LLC	Apr-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	144
STARBUCKS COFFEE CHILE S.A	Apr-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	144
STARBUCKS COFFEE CHILE S.A	Oct-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	144
STARBUCKS COFFEE CHILE S.A	Feb-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	156
STARBUCKS COFFEE CHILE S.A	Mar-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	156
STARBUCKS COFFEE CHILE S.A	May-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	156
STARBUCKS COFFEE CHILE S.A	Jun-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	156
STARBUCKS COFFEE CHILE S.A	Feb-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	156
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Feb-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	156
STARBUCKS COFFEE CHILE S.A	Oct-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	168
CARIBBEAN OVERSEAS LTD	Jan-12	060 ROASTED COFFEE	Licensed Aruba	BONEIL	168
STARBUCKS COFFEE CHILE S.A	Mar-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	180
PANACAFE DE GUATEMALA, S.A.	Apr-12	060 ROASTED COFFEE	Joint Venture Guatemala	EMALKOWS	180
PANACAFE DE ELSALVADOR, S.A. DE C.V.	Apr-12	060 ROASTED COFFEE	Joint Venture El Salvador	EMALKOWS	180
PANACAFE DE ELSALVADOR, S.A. DE C.V.	Apr-12	060 ROASTED COFFEE	Joint Venture El Salvador	BONEIL	180
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	180
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jun-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	192
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Mar-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	228
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	228
STARBUCKS COFFEE PUERTO RICO LLC	Jan-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	240
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jan-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	240
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Mar-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	240
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	240
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	240
STARBUCKS COFFEE PUERTO RICO LLC	Aug-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	240
STARBUCKS COFFEE CHILE S.A	Oct-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	240
STARBUCKS COFFEE PUERTO RICO LLC	Jan-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	240
STARBUCKS COFFEE PUERTO RICO LLC	Aug-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	240
COFFEE CAY	Dec-11	060 ROASTED COFFEE	Licensed Bahamas	EMALKOWS	252
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jun-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	252
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Oct-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	270
COFFEE CAY	Oct-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	288
COFFEE CAY	Oct-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	288
COFFEE CAY	Oct-12	022 READY TO DRINK & EAT	Foodservice Bahamas	KIANDERS	288
STARBUCKS BRASIL COMERCIO de CAFES LTDA	May-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	288
COFFEE CAY	Dec-11	060 ROASTED COFFEE	Licensed Bahamas	BONEIL	288
STARBUCKS BRASIL COMERCIO de CAFES LTDA	May-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	288
STARBUCKS BRASIL COMERCIO de CAFES LTDA	May-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	288
STARBUCKS COFFEE CHILE S.A	Oct-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	288
STARBUCKS COFFEE CHILE S.A	Feb-12	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	300
STARBUCKS BRASIL COMERCIO de CAFES LTDA	May-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	300
STARBUCKS COFFEE CHILE S.A	Feb-12	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	300
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Oct-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	300
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Mar-12	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	312
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Mar-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	312
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jul-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	312
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jul-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	312
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Oct-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	324
LASINO SA	Jul-12	060 ROASTED COFFEE	Licensed Peru	EMALKOWS	360
LASINO SA	Aug-12	060 ROASTED COFFEE	Licensed Peru	EMALKOWS	360
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Sep-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	360
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Oct-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	360
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	396
LASINO SA	Jan-12	060 ROASTED COFFEE	Licensed Peru	EMALKOWS	432
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Jun-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	456
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Jun-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	456
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Jul-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	456
LASINO SA	Jan-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	468
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Aug-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	480
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Aug-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	480
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Sep-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	480
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Aug-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	516
STARBUCKS COFFEE PUERTO RICO LLC	Jan-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	EMALKOWS	552
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Feb-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	576
LASINO SA	May-12	060 ROASTED COFFEE	Licensed Peru	BONEIL	576
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Sep-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	600
STARBUCKS COFFEE PUERTO RICO LLC	Jan-12	060 ROASTED COFFEE	Company Operated Stores Puerto Rico	BONEIL	600
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Sep-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	714
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jan-12	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	804
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Aug-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	840
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Aug-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	840
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Aug-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	840
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Sep-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	840
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Jul-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	900
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Sep-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	1,080
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	May-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	1,092
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Dec-11	060 ROASTED COFFEE	Joint Venture Brazil	BONEIL	1,116
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jul-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	1,200
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jul-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	1,200
STARBUCKS COFFEE CHILE S.A	Dec-11	060 ROASTED COFFEE	Joint Venture Chile	EMALKOWS	1,224
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	May-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	1,356
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Apr-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	1,500
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Jun-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	1,800
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	May-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	1,800
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Jun-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	1,800
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Apr-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	2,016
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Dec-11	060 ROASTED COFFEE	Joint Venture Brazil	EMALKOWS	2,040
STARBUCKS COFFEE CHILE S.A	Dec-11	060 ROASTED COFFEE	Joint Venture Chile	BONEIL	2,328
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Apr-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	2,400
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Apr-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	2,400
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	May-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	2,400
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Mar-12	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	3,000
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Mar-12	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	3,000
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil		4,320
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Dec-11	060 ROASTED COFFEE	Joint Venture Mexico	EMALKOWS	7,344
DISTRIBUIDORA E IMPORTADORA ALSEA SA DE CV.	Dec-11	060 ROASTED COFFEE	Joint Venture Mexico	BONEIL	7,920
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jun-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	8,706
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Jun-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil	BGUBBELS	10,440
STARBUCKS BRASIL COMERCIO de CAFES LTDA	Apr-12	010 BEVERAGE COMPONENTS	Joint Venture Brazil		16,848