New eStores rental Commission ($s) (x6) = (Store Rental Price per Day * Number of New eStores Rental * Number of Store Rental Days) * Commission Rate for new eStores rental )
New eStores rental Commission ($s) (x6)= ((s -(s * x4))*x1*x2*x3)
eStores renewal Commission ($s) (y6) = (Store Rental Price per Day * Number of eStore renewals * Number of eStore Renewal Days * %commission for renewing stores)
(eStores Value by Type -( eStores Value by Type * % Discount for renewal of existing eStores))*Number of renewed eStores * Number of eStore Renewal Days )
(Number of renewed eStores / eStores renewal Target) * 100
Description
Store Type rent/day (s): The sales agent chooses the store type, such as Ad Rectangle, AD Box, Mega Store, Large Store, Standard Store, Market Store, or Agent/Booth Store. Based on the chosen store type, the corresponding rental price per day is identified. For example, if the $10/day.
Number of New eStores Rental (x1): The sales agent enters the number of new stores rented through the agent (purchased using the agent’s booth ID)
Number of eStore Rental Days (x2): The sales agent sets the number of days the store has been rented. This is selected from the slider.
Commission% for new eStores rental (x3%): Enter the percentage commission. The commission rate on new eStores rentals is stated as a percentage. For example, the commission for new estores rental is 10%, then x3% = 10.
% Discount offered for new eStores rental (x4%): Enter a % discount. The discount rate for new memberships is set as a percentage, select then x7 = 5%
New eStores rental Target Count (x5): The sales agent specifies the Sales Target eStores Rental Count. Choose from the slider.
Number of eStore renewals (y1): The sales agent sets the number of stores that have been renewed through the agent (using the agent’s booth ID)
Number of eStore Renewal Days (y2): The sales agent determines the number of days the store has been renewed. Choose the days from the slider.
% commission for renewing stores (y3%): Enter the percentage commission. The commission rate on eStores renewal is set as a percentage. For example, the renewal commission is 5%, then y3% = 5.
% Discount offered for eStores renewal (y4%): Enter a % discount. The discount offered for renewal of existing eStores is set as a percentage, select from the slider. For example, the discount offered to sellers on eStores renewal is 2%, then y7 = 2%
eStores renewal Target (y5): The sales agent enters the target eStores renewal number. Choose from the slider.
Membership Commission Calculator
Membership Type
Membership Value/Year (m)
% Discount offered for new memberships (x9)
New memberships Target Count (x10)
New Memberships Sold (x11)
New Memberships Sales Commission % (x12)
% Discount for renewal of existing memberships (y9)
Memberships renewal Target (y10)
Number of renewed memberships (y11)
Sales commission % for renewed memberships (y12)
Membership Calculated Result
Membership Type
New Memberships Sales Commission $s (x13)
Sales commission ($s) for membership renewal (y13)
% Discount for renewal of existing memberships (y9)
Memberships renewal Target (y10)
Number of renewed memberships (y11)
Sales commission % for renewed memberships (y12)””
New Memberships Sales Commission $s (x13) = (((Membership Value by Type – (Membership Value by Type * % Discount offered for new memberships)) * New Memberships Sold)* New Memberships Sales Commission%) = (((m – (m * x9)) * x11)* x12)
Sales commission ($s) for membership renewal (y13) = (((Membership Value by Type – (Membership Value by Type * % Discount for renewal of existing memberships)) * Number of renewed memberships)* Sales commission % for renewed memberships) = (((m – (m * y9)) * y11)* y12)
New membership sales ($s) (x14) = ((Membership Value by Type -(Membership Value by Type * % Discount offered for new memberships))*New Memberships Sold) = ((m -(m * x9))*x11)
Membership renewals Sales ($s) (y14) = ((Membership Value by Type -( Membership Value by Type * % Discount for renewal of existing memberships))*Number of renewed memberships) =
Membership Value by Type (m): The sales agent chooses the Membership Type from the available options, such as Basic (Free), Silver ($100), Gold ($1500), Premium ($6000)
New Memberships Sold (x4): The sales agent specifies the number of new memberships sold. This can be a numeric, preferably option to select from a slider.
New memberships Target Count (x5): The sales agent sets the number of new membership sales targets. Choose from the slider.
New Memberships Sales Commission% (x6%): Enter the commission rate. The commission rate for new memberships is set as a percentage, select from the slider. For example, if it is a new membership, then 20%, then x6 = 20.
% Discount offered for new memberships (x7%): Enter a % discount. The discount rate for new memberships is set as a percentage, select from the slider. For example, the discount offered to suppliers on new membership is 5%, then x7 = 5%
Number of renewed memberships (y4): The sales agent enters the number of memberships renewed, select from the slider.
Memberships renewal Target (y5): The sales agent enters the target membership renewal number. Choose from the slider.
Sales commission % for renewed memberships (y6%): Enter the commission%. The commission rate for renewed memberships is set as a percentage, select from the slider. For example, if it is existing membership renewal, then 15%, then y6 = 15.
% Discount for renewal of existing memberships (y7%): Enter a % discount. The discount offered for renewal of existing memberships is set as a percentage, select from the slider. For example, the discount offered to sellers on membership renewal is 2%, then y7 = 2%
ENG
