SALESMAN by hedongchenchen

VIEWS: 4 PAGES: 4

									.




                                       Salesman Workbook Data
                                       System Information
Workbook Name:        SALESMAN
Workheet Name:        weeklysales
System Purpose:       To maintain weekly sales data for each representative, and
                      to calculate sales to date, the monthly bonus for each salesperson & month total
                      for each representative.

                                       Formulae Descriptions:
End of Month Sales:   Each cell value in this is calculated by adding the Sales To Date to the Monthly Total
Monthly Bonus:        Each cell value in this is calculated by multiplying Monthly Total by the Bonus Rate
Sales To Date:        Each cell in this range is carried over from the End of Month Sales column for the beginning of each new month
Month No:             This cell value is incremented at the start of each new month

                                       Sales Data:

Bonus Rate:                        5
Month No:                          1
                                                 Weekly Sales
Rep Name              Sales To Date      1      2     3       4 Monthly Total Monthly Bonus End of Month Sales
Andy                  135                 54       5    6      12         77 £       385.00               212
Bindi                 459                 32      43   28      33        136 £       680.00               595
Katie                 357                 23      33 150     166         372 £     1,860.00               729
Misba                 540                 32      77   52      19        180 £       900.00               720
Ali                   489                 44      54    0      59        157 £       785.00               646
Amy                   333                 20      56   39      78        193 £       965.00               526
Pete                  336                 21    100     9      -7        123 £       615.00               459
Rhiannon              453                 33      54 402       68        557 £     2,785.00              1010
Gareth                330                 27      44   33      18        122 £       610.00               452
TOTALS                         3432      286    466 719       446       1917           9585              5349
nning of each new month
      Test Data
756         480   547    49
440         771   459   205
 29          89   542    48
789         184   707   379
288         541   189   105
  2         447   187   531
250         371   250   667
625         619   249   169
748         544   334   564
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

								
To top