Album	Released	Format	Category	Stock on hand	Cost price	Normal Price	Sales price	Rating out of 10
100 80's Hits-Various	2000	CD	Compilation	13	143,61	258,49	155,10	4
100 Oorspronklike Afrikaanse Treffers-Various	2003	DVD	Compilation	75	124,06	223,30	133,98	6
120 Heel Beste Stories-Tolla van der Merwe	2006	Blu-Ray	Afrikaans	35	98,56	177,40	106,44	8
36 Gewildste Stories - Vol.2-Not applicable	2011	CD	Afrikaans	52	28,86	51,94	31,17	10
A Good Year-Various	2012	DVD	Compilation	75	150,41	270,73	162,44	9
ADAM-ADAM	2013	Blu-Ray	Afrikaans	65	138,51	249,31	149,59	7
Afrikaanse Volksliedjies Vol 1-Various	2006	CD	Children	65	30,56	55,00	33,00	1
Awake-Live	2007	DVD	Adult contempory	75	138,51	249,31	149,59	5
Back To Black-Amy Winehouse	2005	Blu-Ray	R&B	46	130,01	234,01	140,41	9
Believers Never Die-Fall Out Boy	1999	CD	Adult contempory	65	130,01	234,01	140,41	9
Ben Bicycle-Adam Tax	1999	DVD	Afrikaans	75	133,41	240,13	144,08	7
Die Bekroonde Kunstenaars-Koos Kombuis	2007	Blu-Ray	Afrikaans	23	150,41	270,73	162,44	1
Dreaming out Loud-OneReplublic	2003	CD	Adult contempory	52	68,81	123,85	74,31	8
Films About Ghosts-The Counting Crows	2002	DVD	Adult contempory	56	89,21	160,57	96,34	4
Forever Young-Alphaville	2000	Blu-Ray	Golden Oldies	48	28,86	51,94	31,17	10
Greatest Hits-Shania Twain	2003	CD	Adult contempory	82	130,01	234,01	140,41	6

3. You are in control of the inventory records of a media company. In column J, you have to write a formula that will indicate Buy when new inventory should be ordered. An empty cell should display when it is not necessary to order inventory. The following requirements describe how inventory reorder levels are determined: a. Afrikaans CD's issued before 2000 must only be reordered if there are less than 20 on hand. b. Afrikaanse CD's with a cost of less than R100 should be ordered when there are less than 25 items on hand. C. DVD's and Blu Rays in Afrikaans are only ordered if there are less than 20 items on hand while all other DVD's and Blu Rays are only ordered when there are less than 10 items on hand. d. Any Compilation, Golden Oldies or Musicals are only ordered when there are less than 20 items on hand and if it was issued after 2005. 3. You are in control of the inventory records of a media company. In column J, you have to write a formula that will indicate Buy when new inventory should be ordered. An empty cell should display when it is not necessary to order inventory. The following requirements describe how inventory reorder levels are determined: a. Afrikaans CD's issued before 2000 must only be reordered if there are less than 20 on hand. b. Afrikaanse CD's with a cost of less than R100 should be ordered when there are less than 25 items on hand. C. DVD's and Blu Rays in Afrikaans are only ordered if there are less than 20 items on hand while all other DVD's and Blu Rays are only ordered when there are less than 10 items on hand. d. Any Compilation, Golden Oldies or Musicals are only ordered when there are less than 20 items on hand and if it was issued after 2005