Category management excercise			30 minutes		Retail Management 2024
					
Name:					
Name:					
Name:					
					
Product Name	Brand	Shelf Space (units)	Monthly Sales (units)	Buying Price (USD)	Selling Price (USD)
Cookies A	Brand X	25	150	2.23	4.20
Cookies B	Brand Y	20	170	2.39	3.89
Cookies C	Brand X	28	160	2.33	4.22
Cookies D	Brand Y	22	180	2.08	4.82
Granola Bar A	Brand Z	30	300	1.04	2.17
Granola Bar B	Brand Z	25	320	1.33	2.31
Granola Bar C	Brand Z	32	310	1.15	1.97
Granola Bar D	Brand Z	26	330	1.38	2.42
Chips A	Brand X	20	200	1.82	3.73
Chips B	Brand Y	15	180	2.07	3.41
Chips C	Brand X	22	210	2.10	3.36
Chips D	Brand Y	18	190	2.25	4.09
Juice A	Brand X	30	300	1.72	3.43
Juice B	Brand N	25	250	1.88	4.15
Juice C	Brand X	35	310	2.04	3.21
Juice D	Brand N	28	260	1.81	3.87
Soda A	Brand M	50	500	0.72	1.45
Soda B	Brand N	40	480	0.96	1.46
Soda C	Brand M	55	520	0.85	1.44
Soda D	Brand N	45	490	0.84	1.58
Water A	Brand O	60	600	0.64	1.10
Water B	Brand O	50	550	0.76	1.37
Water C	Brand O	65	620	0.66	1.09
Water D	Brand O	55	560	0.73	1.42
					
"1. From the list of products, create categories:"					
					
					
					
2. Which product has the highest profit margin in each category?					
					
					
					
3. Which product generates the most sales per unit of shelf space?					
					
					
					
4. Which brand has the highest total monthly sales across all its products?					
					
					
					
5. How does the average selling price vary between the products of Brand X and Brand Y?