% 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
