Subjects data analysis

Deliveryman Invoice Sales

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

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.