Deliveryman Invoice Sales
1. Problem: Extract the total number of invoices (# of INV) and net sales values for the given deliverymen names from the provided tables.
2. The deliverymen names to find are: NAVEED SALEEM, FAYYAZ, JUNAID, BILAL, WAQAS, KHALID, ZAHID, TANVEER, ATIQ, NOMAN, SAAD.
3. We scan through the tables and sum the # of INV and Net Sales for each deliveryman:
- NAVEED SALEEM:
- # of INV: 8+28+1+27+28+1+27+5 = 125
- Net Sales: 198393.54+0+0+0+90853.26+2791.23+206279+237563 = 735880.03
- FAYYAZ: No entries found.
- JUNAID:
- # of INV: 13+3+4+13+3 = 36
- Net Sales: 34604+42471.1+238857.42+30088+41205 = 367225.52
- BILAL:
- # of INV: 1+1+1+1+4+20+1+1+1+2+4+20+1 = 59
- Net Sales: 0+0+0+0+146529.73+38455.67+111569.28+171906.13+224317.62+5325+144304+33297+204297 = 1079997.43
- WAQAS:
- # of INV: 23+5+27+23 = 78
- Net Sales: 0+0+127875.4+33530.36 = 161405.76
- KHALID:
- # of INV: 24+3+24+3 = 54
- Net Sales: 0+0+74436.63+151392.77 = 225829.4
- ZAHID:
- # of INV: 37+36+3+37 = 113
- Net Sales: 0+70613.85+50655.63+80280.48 = 201549.96
- TANVEER:
- # of INV: 5+29+29 = 63
- Net Sales: 0+0+68587 = 68587
- ATIQ:
- # of INV: 17
- Net Sales: 73835.72
- NOMAN:
- # of INV: 27+5 = 32
- Net Sales: 48031.14+2341.77 = 50372.91
- SAAD:
- # of INV: 14+4+8+4+8 = 38
- Net Sales: 42144.49+79251.42+198393.54+79251.42+198393.54 = 596434.41
4. Final answer:
NAVEED SALEEM: # of INV = 125, Net Sales = 735880.03
FAYYAZ: # of INV = 0, Net Sales = 0
JUNAID: # of INV = 36, Net Sales = 367225.52
BILAL: # of INV = 59, Net Sales = 1079997.43
WAQAS: # of INV = 78, Net Sales = 161405.76
KHALID: # of INV = 54, Net Sales = 225829.4
ZAHID: # of INV = 113, Net Sales = 201549.96
TANVEER: # of INV = 63, Net Sales = 68587
ATIQ: # of INV = 17, Net Sales = 73835.72
NOMAN: # of INV = 32, Net Sales = 50372.91
SAAD: # of INV = 38, Net Sales = 596434.41
All values are summed from the provided data tables.