Worksheet on calculating total earnings with salary and commission.
A worksheet titled "Salary Plus Commission" from the Consumer Mathematics series, featuring a math problem about calculating total earnings based on sales and commission rates. The worksheet includes a step-by-step example and a table with sales, rate of commission, salary earned, commission, and total earnings.
PNG
298×386
5.5 KB
Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #610840
⭐
Show Answer Key & Explanations
Step-by-step solution for: Salary Plus Commission Chapter 1 Lesson 12 Answer Key - Fill ...
▼
Show Answer Key & Explanations
Step-by-step solution for: Salary Plus Commission Chapter 1 Lesson 12 Answer Key - Fill ...
It looks like you've uploaded a worksheet titled "Salary Plus Commission" from a math workbook. The task is to calculate the total earnings for each of the 20 employees listed, based on their base salary, commission rate, and sales amount.
The formula used is:
> Total Earnings = Base Salary + (Commission Rate × Sales)
Let’s go step by step and solve this for each row.
---
We'll use:
- Base Salary (given)
- Commission Rate (as a decimal)
- Sales (given)
- Commission Earned = Sales × Commission Rate
- Total Earnings = Base Salary + Commission Earned
---
#### 1.
- Salary: $253,900
- Rate: 2% = 0.02
- Sales: $2,786
- Commission = 0.02 × 2,786 = $55.72
- Total Earnings = 253,900 + 55.72 = $253,955.72
#### 2.
- Salary: $371,800
- Rate: 3% = 0.03
- Sales: $5,660
- Commission = 0.03 × 5,660 = $169.80
- Total = 371,800 + 169.80 = $371,969.80
#### 3.
- Salary: $45,000
- Rate: 2.6% = 0.026
- Sales: $3,296
- Commission = 0.026 × 3,296 = $85.696 ≈ $85.70
- Total = 45,000 + 85.70 = $45,085.70
#### 4.
- Salary: $400,000
- Rate: 1.5% = 0.015
- Sales: $5,125
- Commission = 0.015 × 5,125 = $76.875 ≈ $76.88
- Total = 400,000 + 76.88 = $400,076.88
#### 5.
- Salary: $361,129
- Rate: 2.8% = 0.028
- Sales: $2,250
- Commission = 0.028 × 2,250 = $63.00
- Total = 361,129 + 63 = $361,192.00
#### 6.
- Salary: $864,722
- Rate: 3.2% = 0.032
- Sales: $2,976
- Commission = 0.032 × 2,976 = $95.232 ≈ $95.23
- Total = 864,722 + 95.23 = $864,817.23
#### 7.
- Salary: $863,748
- Rate: 1.6% = 0.016
- Sales: $3,130
- Commission = 0.016 × 3,130 = $50.08
- Total = 863,748 + 50.08 = $863,798.08
#### 8.
- Salary: $878,176
- Rate: 1.4% = 0.014
- Sales: $3,098
- Commission = 0.014 × 3,098 = $43.372 ≈ $43.37
- Total = 878,176 + 43.37 = $878,219.37
#### 9.
- Salary: $895,276
- Rate: 3.2% = 0.032
- Sales: $2,088
- Commission = 0.032 × 2,088 = $66.816 ≈ $66.82
- Total = 895,276 + 66.82 = $895,342.82
#### 10.
- Salary: $871,881
- Rate: 2.4% = 0.024
- Sales: $3,125
- Commission = 0.024 × 3,125 = $75.00
- Total = 871,881 + 75 = $871,956.00
#### 11.
- Salary: $871,896
- Rate: 1.6% = 0.016
- Sales: $3,560
- Commission = 0.016 × 3,560 = $56.96
- Total = 871,896 + 56.96 = $871,952.96
#### 12.
- Salary: $51,943
- Rate: 2.8% = 0.028
- Sales: $3,660
- Commission = 0.028 × 3,660 = $102.48
- Total = 51,943 + 102.48 = $52,045.48
#### 13.
- Salary: $522,300
- Rate: 3.8% = 0.038
- Sales: $3,876
- Commission = 0.038 × 3,876 = $147.288 ≈ $147.29
- Total = 522,300 + 147.29 = $522,447.29
#### 14.
- Salary: $523,784
- Rate: 4.8% = 0.048
- Sales: $2,800
- Commission = 0.048 × 2,800 = $134.40
- Total = 523,784 + 134.40 = $523,918.40
#### 15.
- Salary: $61,071,389
- Rate: 4.8% = 0.048
- Sales: $4,876
- Commission = 0.048 × 4,876 = $233.928 ≈ $233.93
- Total = 61,071,389 + 233.93 = $61,071,622.93
#### 16.
- Salary: $278,864
- Rate: 2.7% = 0.027
- Sales: $3,298
- Commission = 0.027 × 3,298 = $89.046 ≈ $89.05
- Total = 278,864 + 89.05 = $278,953.05
#### 17.
- Salary: $888,771
- Rate: 1.6% = 0.016
- Sales: $3,076
- Commission = 0.016 × 3,076 = $49.216 ≈ $49.22
- Total = 888,771 + 49.22 = $888,820.22
#### 18.
- Salary: $576,364
- Rate: 3.1% = 0.031
- Sales: $3,100
- Commission = 0.031 × 3,100 = $96.10
- Total = 576,364 + 96.10 = $576,460.10
#### 19.
- Salary: $518,367
- Rate: 1.4% = 0.014
- Sales: $3,494
- Commission = 0.014 × 3,494 = $48.916 ≈ $48.92
- Total = 518,367 + 48.92 = $518,415.92
#### 20.
- Salary: $896,272
- Rate: 2.6% = 0.026
- Sales: $3,676
- Commission = 0.026 × 3,676 = $95.576 ≈ $95.58
- Total = 896,272 + 95.58 = $896,367.58
---
| # | Commission Earned | Total Earnings |
|---|-------------------|----------------|
| 1 | $55.72 | $253,955.72 |
| 2 | $169.80 | $371,969.80 |
| 3 | $85.70 | $45,085.70 |
| 4 | $76.88 | $400,076.88 |
| 5 | $63.00 | $361,192.00 |
| 6 | $95.23 | $864,817.23 |
| 7 | $50.08 | $863,798.08 |
| 8 | $43.37 | $878,219.37 |
| 9 | $66.82 | $895,342.82 |
|10 | $75.00 | $871,956.00 |
|11 | $56.96 | $871,952.96 |
|12 | $102.48 | $52,045.48 |
|13 | $147.29 | $522,447.29 |
|14 | $134.40 | $523,918.40 |
|15 | $233.93 | $61,071,622.93 |
|16 | $89.05 | $278,953.05 |
|17 | $49.22 | $888,820.22 |
|18 | $96.10 | $576,460.10 |
|19 | $48.92 | $518,415.92 |
|20 | $95.58 | $896,367.58 |
---
This problem teaches how salary plus commission works in real-world jobs. Employees earn a fixed base salary and an additional amount based on sales performance (commission). The total income depends on both factors.
You multiply the sales amount by the commission rate (as a decimal) to get the commission earned, then add it to the base salary.
💡 Tip: Always convert percentages to decimals (e.g., 2.6% → 0.026) before multiplying.
Let me know if you'd like this in a printable table or need help with formatting!
The formula used is:
> Total Earnings = Base Salary + (Commission Rate × Sales)
Let’s go step by step and solve this for each row.
---
Step-by-Step Solution:
We'll use:
- Base Salary (given)
- Commission Rate (as a decimal)
- Sales (given)
- Commission Earned = Sales × Commission Rate
- Total Earnings = Base Salary + Commission Earned
---
#### 1.
- Salary: $253,900
- Rate: 2% = 0.02
- Sales: $2,786
- Commission = 0.02 × 2,786 = $55.72
- Total Earnings = 253,900 + 55.72 = $253,955.72
#### 2.
- Salary: $371,800
- Rate: 3% = 0.03
- Sales: $5,660
- Commission = 0.03 × 5,660 = $169.80
- Total = 371,800 + 169.80 = $371,969.80
#### 3.
- Salary: $45,000
- Rate: 2.6% = 0.026
- Sales: $3,296
- Commission = 0.026 × 3,296 = $85.696 ≈ $85.70
- Total = 45,000 + 85.70 = $45,085.70
#### 4.
- Salary: $400,000
- Rate: 1.5% = 0.015
- Sales: $5,125
- Commission = 0.015 × 5,125 = $76.875 ≈ $76.88
- Total = 400,000 + 76.88 = $400,076.88
#### 5.
- Salary: $361,129
- Rate: 2.8% = 0.028
- Sales: $2,250
- Commission = 0.028 × 2,250 = $63.00
- Total = 361,129 + 63 = $361,192.00
#### 6.
- Salary: $864,722
- Rate: 3.2% = 0.032
- Sales: $2,976
- Commission = 0.032 × 2,976 = $95.232 ≈ $95.23
- Total = 864,722 + 95.23 = $864,817.23
#### 7.
- Salary: $863,748
- Rate: 1.6% = 0.016
- Sales: $3,130
- Commission = 0.016 × 3,130 = $50.08
- Total = 863,748 + 50.08 = $863,798.08
#### 8.
- Salary: $878,176
- Rate: 1.4% = 0.014
- Sales: $3,098
- Commission = 0.014 × 3,098 = $43.372 ≈ $43.37
- Total = 878,176 + 43.37 = $878,219.37
#### 9.
- Salary: $895,276
- Rate: 3.2% = 0.032
- Sales: $2,088
- Commission = 0.032 × 2,088 = $66.816 ≈ $66.82
- Total = 895,276 + 66.82 = $895,342.82
#### 10.
- Salary: $871,881
- Rate: 2.4% = 0.024
- Sales: $3,125
- Commission = 0.024 × 3,125 = $75.00
- Total = 871,881 + 75 = $871,956.00
#### 11.
- Salary: $871,896
- Rate: 1.6% = 0.016
- Sales: $3,560
- Commission = 0.016 × 3,560 = $56.96
- Total = 871,896 + 56.96 = $871,952.96
#### 12.
- Salary: $51,943
- Rate: 2.8% = 0.028
- Sales: $3,660
- Commission = 0.028 × 3,660 = $102.48
- Total = 51,943 + 102.48 = $52,045.48
#### 13.
- Salary: $522,300
- Rate: 3.8% = 0.038
- Sales: $3,876
- Commission = 0.038 × 3,876 = $147.288 ≈ $147.29
- Total = 522,300 + 147.29 = $522,447.29
#### 14.
- Salary: $523,784
- Rate: 4.8% = 0.048
- Sales: $2,800
- Commission = 0.048 × 2,800 = $134.40
- Total = 523,784 + 134.40 = $523,918.40
#### 15.
- Salary: $61,071,389
- Rate: 4.8% = 0.048
- Sales: $4,876
- Commission = 0.048 × 4,876 = $233.928 ≈ $233.93
- Total = 61,071,389 + 233.93 = $61,071,622.93
#### 16.
- Salary: $278,864
- Rate: 2.7% = 0.027
- Sales: $3,298
- Commission = 0.027 × 3,298 = $89.046 ≈ $89.05
- Total = 278,864 + 89.05 = $278,953.05
#### 17.
- Salary: $888,771
- Rate: 1.6% = 0.016
- Sales: $3,076
- Commission = 0.016 × 3,076 = $49.216 ≈ $49.22
- Total = 888,771 + 49.22 = $888,820.22
#### 18.
- Salary: $576,364
- Rate: 3.1% = 0.031
- Sales: $3,100
- Commission = 0.031 × 3,100 = $96.10
- Total = 576,364 + 96.10 = $576,460.10
#### 19.
- Salary: $518,367
- Rate: 1.4% = 0.014
- Sales: $3,494
- Commission = 0.014 × 3,494 = $48.916 ≈ $48.92
- Total = 518,367 + 48.92 = $518,415.92
#### 20.
- Salary: $896,272
- Rate: 2.6% = 0.026
- Sales: $3,676
- Commission = 0.026 × 3,676 = $95.576 ≈ $95.58
- Total = 896,272 + 95.58 = $896,367.58
---
Final Answers (Rounded to Nearest Cent):
| # | Commission Earned | Total Earnings |
|---|-------------------|----------------|
| 1 | $55.72 | $253,955.72 |
| 2 | $169.80 | $371,969.80 |
| 3 | $85.70 | $45,085.70 |
| 4 | $76.88 | $400,076.88 |
| 5 | $63.00 | $361,192.00 |
| 6 | $95.23 | $864,817.23 |
| 7 | $50.08 | $863,798.08 |
| 8 | $43.37 | $878,219.37 |
| 9 | $66.82 | $895,342.82 |
|10 | $75.00 | $871,956.00 |
|11 | $56.96 | $871,952.96 |
|12 | $102.48 | $52,045.48 |
|13 | $147.29 | $522,447.29 |
|14 | $134.40 | $523,918.40 |
|15 | $233.93 | $61,071,622.93 |
|16 | $89.05 | $278,953.05 |
|17 | $49.22 | $888,820.22 |
|18 | $96.10 | $576,460.10 |
|19 | $48.92 | $518,415.92 |
|20 | $95.58 | $896,367.58 |
---
Explanation:
This problem teaches how salary plus commission works in real-world jobs. Employees earn a fixed base salary and an additional amount based on sales performance (commission). The total income depends on both factors.
You multiply the sales amount by the commission rate (as a decimal) to get the commission earned, then add it to the base salary.
💡 Tip: Always convert percentages to decimals (e.g., 2.6% → 0.026) before multiplying.
Let me know if you'd like this in a printable table or need help with formatting!
Parent Tip: Review the logic above to help your child master the concept of calculating commission worksheet.