Freelancer must be very familiar with Binary and Unilevel marketing/mlm compensation plan and Excel.
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
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.
Total # of Entries:
Total Product Cost:
Total # of Pairs:
Total 5th Pairs:
Total Pairing Commission:
Total Referral 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.