In the attached Excel spreadsheet, you will find two data tabs: ALL_range tab has a list of all “mother” SKUs in the portfolio with the indication of the lowest available price and the category of the SKU (ring, earring, necklace and bracelet); on the SALES tab you find all sales information per SKUs per a certain time period.
Using 2 data tables provided in this spreadsheet, please build the matrix which shows what is the count of SKUs in each price segment per category and how much revenue and orders each combo (price x category) drive.
The matrix needs to allow me to answer these questions:
1) What are the key price x category segments in the portfolio? Why?
2) Please make a recommendation on where (price x category) we can discontinue some SKUs and where we need to launch more products? Why?
4 Price segments are: <$100, $101 - $250, $251 - $500, $501+
Categories are: Ring, Earring, Necklace, Bracelet
The data sets which are needed for this analysis are mother SKU count, Revenue ($) and number of units sold (#).
There is much more information in those tabs then you need for your analysis. Only use what you need for the matrix.
Please use revenue and unit sales on the net basis.
29 freelancer đang chào giá trung bình $148 cho công việc này
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 250 projects successfully completed here. Contact me to discuss the details. Best regards
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hello there, I am an Excel expert and I can create this matrix for your explanation. I think so. Please contact me. I will need some clear information before start. Thank you. Chien
Hi, I can do this for you. 3 SKUs are missing in your all range (AU183,191 & 192)I can send you a picture of the initial matrix if you will contact through chat. Regards. Reuben
Hello, Ive check the file, i did a draft version to discust the finals utilities that you will need. Fell free to ask for it to evaluate it. Regards, Juan
Hello!! Am very interested in ur project and I'm an expert in Word/Excel/Excel Marcos/VBA/Visual basic/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
Hello, Dear how are you? I have read your project description and am very interested in your project. I have experienced in Data mining for 6 years. I will work very hard and best for you. Best Regards