Commission Calculator

Commission is evaluated from Total Sales Amount, Commission Rate and Base Salary - optional. The calculation reports Commission Earned, Total Monthly Earnings and Quota Attainment.

Results

Thanks — we’ve logged this for review.

About the Commission Calculator

Commission is treated here as a quantitative relation between Total Sales Amount, Commission Rate, Base Salary - optional and Sales Quota - optional and Commission Earned, Total Monthly Earnings, Quota Attainment and Effective Commission Rate.

The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.

Formula basis:
Commission = sales x rate. Add base salary for total earnings. Quota attainment = actual / quota x 100%. Effective rate = commission / total sales x 100%.

Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.

Formula & How It Works

The calculation applies the following relations exactly as recorded in the metadata:

Commission = sales x rate. Add base salary for total earnings. Quota attainment = actual / quota x 100%. Effective rate = commission / total sales x 100%.

Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.

Worked Examples

Example 1: Real estate agent: $400,000 home sale at 3%

Inputs

sales_amount: 400000 commission_rate: 3 base_salary: 0 quota:
Commission Earned: $12,000. Total Monthly Earnings: $12,000. Quota Attainment: 100%. Effective Commission Rate: 3%. Annual Earnings Projection: $144,000

With Total Sales Amount = 400,000, Commission Rate = 3 and Base Salary - optional = 0 as the stated inputs, the result is Commission Earned = $12,000, Total Monthly Earnings = $12,000 and Quota Attainment = 100%. Each value corresponds to the declared output fields.

Example 2: Software salesperson: $80,000 month + $3,000 base + quota

Inputs

sales_amount: 80000 commission_rate: 8 base_salary: 3000 quota: 70000
Commission Earned: $6,400. Total Monthly Earnings: $9,400. Quota Attainment: 114.3%. Effective Commission Rate: 8%. Annual Earnings Projection: $112,800

With Total Sales Amount = 80,000, Commission Rate = 8, Base Salary - optional = 3,000 and Sales Quota - optional = 70,000 as the stated inputs, the result is Commission Earned = $6,400, Total Monthly Earnings = $9,400 and Quota Attainment = 114.3%. Each value corresponds to the declared output fields.

Example 3: Car salesperson: $35,000 sale at 1.5% + $2,500 base

Inputs

sales_amount: 35000 commission_rate: 1.5 base_salary: 2500 quota: 30000
Commission Earned: $525. Total Monthly Earnings: $3,025. Quota Attainment: 116.7%. Effective Commission Rate: 1.5%. Annual Earnings Projection: $36,300

With Total Sales Amount = 35,000, Commission Rate = 1.5, Base Salary - optional = 2,500 and Sales Quota - optional = 30,000 as the stated inputs, the result is Commission Earned = $525, Total Monthly Earnings = $3,025 and Quota Attainment = 116.7%. Each value corresponds to the declared output fields.

Example 4: Insurance agent: $12,000 in premiums at 15%

Inputs

sales_amount: 12000 commission_rate: 15 base_salary: 1000 quota: 10000
Commission Earned: $1,800. Total Monthly Earnings: $2,800. Quota Attainment: 120%. Effective Commission Rate: 15%. Annual Earnings Projection: $33,600

With Total Sales Amount = 12,000, Commission Rate = 15, Base Salary - optional = 1,000 and Sales Quota - optional = 10,000 as the stated inputs, the result is Commission Earned = $1,800, Total Monthly Earnings = $2,800 and Quota Attainment = 120%. Each value corresponds to the declared output fields.

Common Use Cases

  • Calculate sales commission from revenue and rate
  • Figure out total pay with base salary plus commission
  • Compare different commission structures