Hierarchy Chart for a 1 x 2 matrix direct sell company possible in Excel?

matthewlopez1974

New Member
Joined
Jul 19, 2014
Messages
2
I am brand new to the forum and am no expert at excel. I have a MAC Excel 2011 program to work with. I have created a direct selling model that pays commissions based on percentages of sales. I also have partner companies I am working with plus the product distributor. The partner companies (2) take 15% of revenue each. The direct selling employees/contractors percentages vary depending on their selling volume. It is a complex chart I am seeking to build but I believe excel can do it, am I right? and if so, where can I find how to build it ie; tutorials, videos or chat forums such as this? Thank You.
The matrix is a 1 x 2 system that goes 20 levels deep. There are three matrixes; 1.) 25.00 2.) 50.00 3.) 100.00. I hope that helps and please ask any questions for information I may have left out for a clearer answer. thanks
matt
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

matthewlopez1974

New Member
Joined
Jul 19, 2014
Messages
2
Hi there, maybe posting an actual sample of your data and what you would like to achieve would trigger more replies.
You can post sample as follows:
Recommendation being to use the last one (Border Copy-paste) since you are using Excel 2011.

Excel jeanie
or
MrExcel HTML Maker (HtmlMakeryyyymmdd)
or
Borders-Copy-Paste

ok, so I do not have a sample, per say, but i can tell you that i am creating a hierarchy tree. Starting with myself in the number 1 spot, line 1. I have 2 people under me on line 2, those 2 people each have 2 people on line 3 (7 total people...1 on line 1, 2 on line 2, 4 on line 3 etc etc. Each one of those people will spend x amount of dollars per month on product sales. Each one of those people will earn a set commission percentage on product sales of the people below them (line 2 makes their commission from line 3 and line 3 from line 4). There could be a number of variable such as volume of product sales, attrition and faster growing legs vs slower. The only variable I would like to plug in would be sales volume. I call it the trickle effect; example...spot 30 on line 17 makes 7000 in sales, how does that commission change for the person directly above spot 30/line 17? I need it 20 levels deep on a 1 by 2 ,matrix formula.
I am hoping this makes sense to someone. It makes perfect sense to me, but that doesnt help unless i can build it. thanks
 

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
365
Platform
Windows, Mobile
If you know the percentages take would be applied from on level to another (not mentioned in your sample)
would the two person in level two get a commission from all members from level 3 or only from their respective subordinates in level 3?
Arranging your data in a table might be easier, level could be identified with a value (1,2,3...) and commission computed by summing the values directly one level below and factored by a specific coefficient related to whatever criteria you may have.
Does this make sense to you?
 

Watch MrExcel Video

Forum statistics

Threads
1,096,288
Messages
5,449,489
Members
405,566
Latest member
JeIIyfish

This Week's Hot Topics

Top