S.
NO Employee name Hourly rate Working Hour Gross pay Gross Pay
1 ffgf 1000 12 12000 720
2 dss 400 13 5200 312
3 fdssg 500 24 12000 720
4 sds 600 6 3600 216
5 sdsgg 300 7 2100 126
6 ffd 700 8 5600 336
7 ddh 500 9 4500 270
8 dfdh 900 3 2700 162
9 fdfdh 800 5 4000 240
10 fdhdh 800 6 4800 288
Net pay
11280
4888
11280
3384
1974
5264
4230
2538
3760
4512
s.no how many calls how many hours call per hour bonus rate bonus
1 243 1 243 2% 4.86
2 234 1 234 2% 4.68
3 654 1 654 2% 13.08
4 234 1 234 2% 4.68
5 765 1 765 2% 15.3
6 897 1 897 2% 17.94
7 345 1 345 2% 6.9
8 765 1 765 2% 15.3
9 123 1 123 2% 2.46
10 342 1 342 2% 6.84
TOTAL 4602 10 4602 0.2 92.04
AVERGE 460.2 1 460.2 0.02 9.204
MAXIMUM 897 1 897 0.02 17.94
MINIMUM 123 1 123 0.02 2.46
COUNT 10 10 10 10 10
s.no sales rates commission salary total salary
1 300 2% 6 1000 1006
2 400 2% 8 2000 2008
3 500 2% 10 3000 3010
4 600 2% 12 4000 4012
5 700 2% 14 5000 5014
6 800 2% 16 6000 6016
7 900 2% 18 7000 7018
8 1000 2% 20 8000 8020
9 1100 2% 22 9000 9022
10 1200 2% 24 10000 10024
s.no city fuel purchase material purchase madical purchase annual purchase
1 sgsg $ 900.00 $ 300.00 $ 200.00 $ 1,400.00
2 fsdfsf $ 1,000.00 $ 400.00 $ 300.00 $ 1,700.00
3 fdfsf $ 1,100.00 $ 500.00 $ 400.00 $ 2,000.00
4 fsdsfd $ 1,200.00 $ 600.00 $ 500.00 $ 2,300.00
5 ddfs $ 1,300.00 $ 700.00 $ 600.00 $ 2,600.00
6 fsd $ 1,400.00 $ 800.00 $ 700.00 $ 2,900.00
7 ddfs $ 1,500.00 $ 900.00 $ 800.00 $ 3,200.00
8 sdsd $ 1,600.00 $ 1,000.00 $ 900.00 $ 3,500.00
9 sdsd $ 1,700.00 $ 1,100.00 $ 1,000.00 $ 3,800.00
10 ddfs $ 1,800.00 $ 1,200.00 $ 1,100.00 $ 4,100.00
s.no gender total no of customers
1 male 808
2 female 700
total no of customers
male female
total no of customers
male female
rtdd
s.no employee name gender age occupation phno martial status
1 hhj hjkh f d gg r
2 ffg gj d d gg r
3 ghg f d d e r
4 ghgh f d d f h
5 hgcgch d d d e j
6 hgcgh d d d e j
7 hgchcg s d dd ee kl
8 hgc s d d e l
9 ghg s d d d i
10 hgc s d d r t
Page 8
rtdd
city working h slary
t tr ast
d dy tsr
ts ytd stg
s tyd fzs
ss ytd zgd
teru tsr gfz
ur r gfz
i dsd gzd
riy dsd zfd
ur s z
Page 9
s.nooyee name gender ageoccupation phno tial status city working h slary
1 hhj hjkh f d gg r t tr ast
2 ffg gj d d gg r d dy tsr
3 ghg f d d e r ts ytd stg
4 ghgh f d d f h s tyd fzs
5 hgcgch d d d e j ss ytd zgd
6 hgcgh d d d e j teru tsr gfz
7 hgchcg s d dd ee kl ur r gfz
8 hgc s d d e l i dsd gzd
9 ghg s d d d i riy dsd zfd
10 hgc s d d r t ur s z
