Membership Commission Calculator

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)””

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)

Total Sales Commission $s (D) = New Memberships Sales Commission $s + Sales commission ($s) for membership renewals = (x13 + y13) = (((m – (m * x9)) * x11)* x12) + (((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) =

((m -(m * y9))*y11)

Total Sales Generated $s (C) = New membership sales ($s) + Membership renewals Sales ($s) = (x14 + y14) = ((m -(m * x9))*x11) + (((m -(m * y9))*y11)

% of target achieved (new memberships) = (New Memberships Sold / New memberships Target Count) * 100 = (x11/x10) *100

% of target achieved (memberships renewals) = (Number of renewed memberships / Memberships renewal Target) * 100 = (y11/y10) * 100