Completed

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.

Skills: Excel, Data Processing, Data Mining, Statistics

See more: 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

About the Employer:
( 1 review ) fords, United States

Project ID: #22834055

Awarded to:

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 More

$30 USD in 1 day
(134 Reviews)
5.9

28 freelancers are bidding on average $148 for this job

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 More

$222 USD in 3 days
(745 Reviews)
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 More

$220 USD in 4 days
(351 Reviews)
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 in 3 days
(347 Reviews)
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 in 3 days
(236 Reviews)
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 in 3 days
(355 Reviews)
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] More

$100 USD in 2 days
(135 Reviews)
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 in 2 days
(169 Reviews)
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 More

$250 USD in 6 days
(13 Reviews)
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 More

$100 USD in 3 days
(13 Reviews)
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 in 1 day
(6 Reviews)
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 in 7 days
(4 Reviews)
3.4
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 in 1 day
(12 Reviews)
3.0
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 More

$166 USD in 3 days
(1 Review)
2.8
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 in 2 days
(1 Review)
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 More

$140 USD in 7 days
(2 Reviews)
1.5
mdsamunfrelanch8

I can help you step by step on your business. Please discuss your topics with me. Add me your chats to discuss different issues between the two.

$250 USD in 30 days
(0 Reviews)
0.0
mansimalik3600

I am interseted do your work. I can give your work in half time that given by you. I want an aporchunity to do your work .It is an proud moment to do your work. I have an experince of 5 years in automobile company in i More

$140 USD in 7 days
(0 Reviews)
0.0
ArnabAuditore

I am a Statistician with proper degree and bachelors from an eminent Institute. I am a data analyst also.

$155 USD in 3 days
(0 Reviews)
0.0
nikhil28aryaa

I am expert in excel

$111 USD in 3 days
(0 Reviews)
0.0
cnu142

Dear Employer, I have gone through your excel file. I am good at analysis. I am mechanical engineer. let us discuss in chat and i will prepare required matrix.

$150 USD in 3 days
(0 Reviews)
0.0