Supplier database and stock/sales comparison

Sheet1

	Supplier Name	Address	Phone	Location	Email	Specialisation
1	ABC Direct Sales & Wholesale	PO Box 500 NSW 1586	(02) 8849 2345	Crows Nest	[email protected]	WORLD
2	Action AV: Everything DVD & CD	Unit 3/90QLD4122	(07) 3349 7111	Wecker Rd Mansfield	[email protected]	REGGAE
3	Blue Moon Worldwide Music	54 JohnstonVIC 3065	(03) 9415 7643	St Fitzroy	www.bluemoonrec.com.au	LATIN
4	Cruise Muse	1129VIC 3074	(03) 9328 9011	Main Rd Thomastown	[email protected]	BLUES
5	Don Quixote CD DVD Supplier	78 Adelaide 4123	(08) 9234 5678	Windmill Terrace	[email protected]	REGGAE
6	Fuse Music Group	23 DavidVIC 3056	(03) 9388 8976	St Brunswick	[email protected]	JAZZ WORLD
7	MAD CDs Pty Ltd	PO Box 190 NSW 2044	(02) 9557 9622	St Peters	[email protected]	INDIE
8	Major Music	PO Box 2729NSW 2229	02) 9525 8022	Reed		INDIE
9	Mediapack	Door 5/168	(03)93292334	Macaulay Rd North	http://www.mediapack.com.au	WORLD
10	NATIONAL MUSIC	PO Box 10 Banyo 4014	(07) 3267 3721	QLD AUSTRALIA	email [email protected]	REGGAE WORLD INDIE
11	One Stop Entertainment		(07) 3279 2754		[email protected]	WORLD
12	P Crews Wholesalers	PO Box 565 NSW 2022	(02)87664422	Kikiecrankie	[email protected]	BLUES

&"Franklin Gothic Book,Regular"&18Cindy's Cd Suppliers Contact Info

ER BSBITU304A &D

mailto:[email protected] http://www.bluemoonrec.com.au/

Sheet2

Month\Music Genre	Reggae	World	Indie	Latin	Blues	Jazz	TOTAL
January	23	16	34	12	29	6	120
February	14	17	36	10	27	5	109
March	10	18	35	8	22	11	104
April	16	19	33	11	27	10	116
May	19	20	32	5	26	13	115
June	24	21	31	0	24	9	109
July	26	22	37	3	25	14	127
August	24	23	35	6	30	16	134
September	18	24	34	4	31	13	124
October	15	25	32	8	28	10	118
November	16	26	36	2	23	15	118
December	21	27	31	0	24	16	119
TOTAL	226	258	406	69	316	138	1413

&"Franklin Gothic Book,Regular"&18Sales at Ciny's Cd for the year 2016

ER BSBITU304A &D

Reggae January February March April May 23 14 10 16 19 World January February March April May 16 17 18 19 20 Indie January February March April May 34 36 35 33 32 Latin January February March April May 12 10 8 11 5 Blues January February March April May 29 27 22 27 26 Jazz January February March April May 6 5 11 10 13 Reggae January February March April May 23 14 10 16 19 World January February March April May 16 17 18 19 20 Indie January February March April May 34 36 35 33 32 Latin January February March April May 12 10 8 11 5 Blues January February March April May 29 27 22 27 26 Jazz January February March April May 6 5 11 10 13

Sheet3

	Purchase Order for Indie Rock CDs brought from MAD CDs Pty Ltd
	Order No	Month	No of copies	AMOUNT	TOTAL
	285013	January	22	12.95	284.9
	285014	February	18	12.95	233.1
	285015	March	16	12.95	207.2
	285016	April	23	12.95	297.85
	285017	May	24	12.95	310.8
	285018	June	23	12.95	297.85
	285019	July	12	12.95	155.4
	285020	August	21	12.95	271.95
	285021	September	15	12.95	194.25
	285022	October	23	12.95	297.85
	285023	November	18	12.95	233.1
	285024	December	19	12.95	246.05
	TOTAL		234	155.4	3030.3
	Purchase Order for Indie Rock CDs brought from Major Music
	Order No	Month	No of copies	AMOUNT	TOTAL
	23415	January	12	12.95	155.4
	23416	February	18	12.95	233.1
	23417	March	19	12.95	246.05
	23418	April	10	12.95	129.5
	23419	May	8	12.95	103.6
	23420	June	8	12.95	103.6
	23421	July	25	12.95	323.75
	23422	August	14	12.95	181.3
	23423	September	19	12.95	246.05
	23424	October	9	12.95	116.55
	23425	November	18	12.95	233.1
	23426	December	12	12.95	155.4
	TOTAL		172	155.4	2227.4
	Purchase Order for Latin jazz CDs brought from Blue Moon Worldwide Music
	Order No	Month	No of copies	AMOUNT	TOTAL
	342541	January	12	12.95	155.4
	342541	February	10	12.95	129.5
	342541	March	8	12.95	103.6
	342541	April	11	12.95	142.45
	342541	May	5	12.95	64.75
		June	0	12.95	0
	342541	July	3	12.95	38.85
	342541	August	6	12.95	77.7
	342541	September	4	12.95	51.8
	342541	October	8	12.95	103.6
	342541	November	2	12.95	25.9
		December	0	12.95	0
	TOTAL		69	155.4	893.55
	Purchase Order for Latin jazz CDs brought from Fuse Music Group
	Order No	Month	No of copies	AMOUNT	TOTAL
	2345	january	6	12.95	77.7
	2346	february	5	12.95	64.75
	2347	march	11	12.95	142.45
	2348	april	10	12.95	129.5
	2349	may	13	12.95	168.35
	2350	june	9	12.95	116.55
	2351	july	14	12.95	181.3
	2352	august	16	12.95	207.2
	2353	september	13	12.95	168.35
	2354	october	10	12.95	129.5
	2355	november	15	12.95	194.25
	2356	december	16	12.95	207.2
	TOTAL		138	155.4	1787.1
	Purchase Order for World live concertDVDs brought from Mediapack
	Order No	Month	No of copies	AMOUNT	TOTAL
	565432	January	12	18.57	222.84
	565432	February	8	18.57	148.56
	565432	March	4	18.57	74.28
	565432	April	12	18.57	222.84
	565432	May	13	18.57	241.41
	565432	June	12	18.57	222.84
	565432	July	13	18.57	241.41
	565432	August	10	18.57	185.7
	565432	September	14	18.57	259.98
	565432	October	13	18.57	241.41
	565432	November	7	18.57	129.99
	565432	December	12	18.57	222.84
	TOTAL		130	222.84	2414.1

&"Franklin Gothic Book,Regular"&18Purchase Orders

ER BSBITU304A &D