Salesman

Salesman Workbook Data System Information Workbook Name: Worksheet Name: System Purpose:

SALESMAN weeklysales To maintain wekly sales data for each representative, and to calculate sales to date, the monthly bonus for each salesperson & monthy total for each representative

End of the Month Sales: Monthly Bonus: Sales To Date: Month No:

Each cell value in this calculated by addin gthe Sales to Date to the Monthly Total Each cell value in this calculated by multiplying Monthly Total by the Bonus Each cell value in this range is carried over from the End of Month Selas column This cell value is incremented at the start of each new month Sales Data:

Bonus Rate Month No: Rep Name Andy Bindi Katie Misba Ali Amy Pete Rhiannon Gareth Total

Sales To Date 135 459 357 540 489 333 336 453 330 3432

Weekly Sales 2 3 54 5 6 32 43 28 23 33 150 32 77 1660 44 54 0 20 56 39 21 100 9 33 54 402 27 44 33 286 466 2327

1

4 Monthly TotalMonthly Bonus 12 77 385 33 136 680 166 372 1860 19 1788 900 59 157 785 78 193 965 -7 123 615 68 557 2785 18 122 610 446 3525 9585

n & monthy total

he Monthly Total

h Selas column

End of Month Sales 212 595 729 720 646 526 459 1010 452 5349

Rep Name Highest Sales Lowest Sales Difference Andy 58 16 42 Bindi 64 44 20 Katie 84 77 7 Misba 45 32 13 Ali 48 42 6 Amy 78 75 3 Pete 30 23 7 Rhiannon 80 66 14 Gareth 82 65 17