Đã hoàn thành

I need an excel expert with matrices

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?

Notes:

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.

Kĩ năng: Excel, Xử lí dữ liệu, Khai thác dữ liệu, Statistics

Xem nhiều hơn: need excel expert, need excel expert match columns, need excel expert create macro, ca inter excel expert candidates in south delhi, i need a 3d designer in kerala, i need a cad designer in huddersfield, i need a cantonese translator in orlando florida october 23, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need excel expert, i need you to fill in a spreadsheet with data its an easy task to enter the data in excel sheet, i will provide names address phone email etc etc on a pdf file i need the information put in an excel spread sheet under company, how do i find excel expert in sri lanka, i need an expert in facebook, i need an expert to teach me structural design softwares in abuja, i need excel help in agra, need help with excel expert consultant in marathahalli, I need someone expert in asp.net and angular, I need an expert in email marketing - TO INCREASE DELIVERY RATE by Haddaoui, I need an expert in email marketing - TO INCREASE DELIVERY RATE

Về Bên Thuê:
( 1 Nhận xét ) fords, United States

ID dự án: #22834055

Được trao cho:

sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I checked the attached file and read the project description. I can Thêm

$30 USD trong 1 ngày
(134 Đánh Giá)
5.9

29 freelancer đang chào giá trung bình $148 cho công việc này

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$222 USD trong 3 ngày
(745 Nhận xét)
8.5
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Thêm

$220 USD trong 4 ngày
(351 Nhận xét)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD trong 3 ngày
(346 Nhận xét)
7.4
elqueabandona

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

$200 USD trong 3 ngày
(236 Nhận xét)
6.9
TonmoyRoy111

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

$200 USD trong 3 ngày
(355 Nhận xét)
6.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Thêm

$100 USD trong 2 ngày
(133 Nhận xét)
6.1
nvchien94

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

$150 USD trong 2 ngày
(168 Nhận xét)
6.1
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Thêm

$250 USD trong 6 ngày
(13 Nhận xét)
5.6
IgeS

Hi there, I can create you a dynamic matrix that will help you slice and dice your data easily and find certain trends in your skus performance. Furthermore, the dynamic matrix will have conditional formatting thus yo Thêm

$100 USD trong 3 ngày
(12 Nhận xét)
4.5
reubengi

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

$50 USD trong 1 ngày
(6 Nhận xét)
3.6
emilianoreyes70

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

$80 USD trong 7 ngày
(3 Nhận xét)
3.2
nikhil5642

Currently a [login to view URL] 4th-year student at IIT Roorkee. I am an outstanding and highly experienced freelancer offering services in Machine Learning, Deep Leaning mobile app development, OpenCV, Data Science, Natural Langua Thêm

$166 USD trong 3 ngày
(1 Nhận xét)
2.8
dheerajjshetty19

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.

$30 USD trong 1 ngày
(12 Nhận xét)
3.0
MaLiguo

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

$150 USD trong 2 ngày
(1 Nhận xét)
2.1
sharaf044

Hi , I have read carefully your request.I am ready for your excel Job. I am expert and experience in MS Word,PPT, Excel also PDF. I will delivery your job on time and even before since. I will provide this job with 1 Thêm

$140 USD trong 7 ngày
(2 Nhận xét)
1.5
mattjparker1104

Hello, How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in Python, PHP, Java, Web Search/Scraping, VB, Excel, Word, VBA, Data Entry. I can help Thêm

$150 USD trong 2 ngày
(4 Nhận xét)
1.5
Yusrap

Expert in data entry Relevant Skills and Experience Data entry

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
pankaj976

I have 4 years of business analyst experience and doing daily analysis on the same problems. excel, SQL, R this all tools are familiar to me.

$222 USD trong 3 ngày
(0 Nhận xét)
0.0
AryamaR

Hi, I have 8 years of experience working in the IT industry where we often deal with complex problems in Excel. After going through your requirement I could assure you that this problem is easily solvable. I am very n Thêm

$100 USD trong 3 ngày
(0 Nhận xét)
0.0
analystardi

Hi there, thank you for the opportunity. i look that you need freelance data analyst that can help you about statistical analysis. let me introduce my self, i am ardiansyah, i am an expert data analyst, especially in s Thêm

$222 USD trong 3 ngày
(1 Nhận xét)
2.2