I need help with an Excel Spreadsheet (Its attached)
cooer3
prjex-4.xlsx
Sheet1
| Commission Worksheet |
| Commission Rate: | 0.02 |
| Salesperson | Renfrew, Steven | Anderson, Jane | Cole, Michael | James, Ron |
| Week 1 | $ 14,283.00 | $ 11,020.00 | $ 13,477.00 | $ 12,405.00 |
| Week 2 | $ 17,808.00 | $ 12,381.00 | $ 1,100.00 | $ 12,889.00 |
| Week 3 | $ 12,302.00 | $ 14,830.00 | $ 13,747.00 | $ 14,700.00 |
| Week 4 | $ 13,100.00 | $ 19,787.00 | $ 18,483.00 | $ 15,806.00 |
| Total Sales | $ 57,493.00 | $ 58,018.00 | $ 46,807.00 | $ 55,800.00 |
| Sales Commission |
| Base Salary | $ 500.00 | $ 501.00 | $ 502.00 | $ 503.00 |
| Salary Plus Commission | $ 500.00 | $ 501.00 | $ 502.00 | $ 503.00 |