Closed

URGENT! NEED MLM BINARY AND UNILEVEL PLAN ON EXCEL

Freelancer must be very familiar with Binary and Unilevel marketing/mlm compensation plan and Excel.

PROJECT PLAN:

I need you to build excel spreadsheets which represent the MLM Binary compensation plans. Please design these spreadsheets so that when you change the Registration amount, or change the number of distributors, or change the cost of the product, or change any of the critical criteria, the outcome automatically calculates in the spreadsheet.

MLM BINARY AND UNILEVEL

A. BINARY

Objective: We Need to know the Earning Potential of the company at different level of entries.

Details: Registration Amount : _____________ (Php 2,000)

Direct Referral Commission: __________ (Php 150)

Pairing Commission: _________________(Php 350)

Maximum Paid Pairs per day: ____________ (12 pairs) (capping is set on a daily basis)

With 5th Pair: _________________________(with 5th pair)

Product Cost per entry: ________________(Php 405)

Note: Figures in the Cost and Commissions Must not be fixed so we can use it in different clients who needs simulation… We Need to know the Earning Potential of the company at different level of entries. Say at 1,000 entries, how much will the company earn? At 5,000. 10,000. 50,000. 100,000. 200,000. In other words we need to know the exact calculations so we can set our expectations on these level and never experienced overpayment or worst, bankrupt.

Output:

Total # of Entries:

Total Sales:

Total Product Cost:

Total # of Pairs:

Total 5th Pairs:

Total Pairing Commission:

Total Referral Commission:

Total Payout/Commission:

Total Percentage Left to the company before Operating Expenses:

etc... (others related to binary simulation)

Note: The Binary goes infinitely deep but caps/limits the payout at 12 per day and everything else is flushed out beyond the limit. No carry Over for the next day if flush out happens.(This is for the 1st spreadsheet. On the 2nd sheet, use 10 pairs per day, on the 3rd show 16 pairs per day. Again Please design this for auto computation when you will input a new Maximum pairs per day.)

Pls see attached .doc file for the full presentation.

Skills: Accounting, Business Analysis, Excel

See more: mlm excel spreadsheet, mlm excel sheet, unilevel mlm plan, unilevel compensation plan excel, binary compensation plan excel, mlm binary unilevel, binary plan excel, mlm plan sheet, binary mlm plan, mlm binary plan excel file, mlm plan excel, mlm compensation plan excel, mlm binary excel sheet, binary marketing plan mlm simulation, mlm commission spreadsheet, binary plan compensation excel, mlm binary maximum pair, mlm binary simulation, unilevel marketing plan binary marketing plan, binary plan excel spreadsheet, mlm binary spreadsheet, mlm unilevel, simulation mlm excel, binary plan excel sheet, binary excel

About the Employer:
( 0 reviews ) Cagayan de Oro, Philippines

Project ID: #1279211

3 freelancers are bidding on average $117 for this job

gshiels

Please see PM

$200 USD in 3 days
(12 Reviews)
5.0
rishi012

i work at a high level quality

$120 USD in 5 days
(0 Reviews)
0.0
RohitMannewar

hi, i am ready to do this job. please send me the details.

$30 USD in 2 days
(0 Reviews)
0.0