1. The problem is to find the net sales and number of invoices (# of INV) for each specified deliveryman: NAVEED SALEEM, FAYYAZ, JUNAID, BILAL, WAQAS, KHALID, ZAHID, TANVEER, ATIQ, NOMAN, and SAAD. 2. From the data, we extract the relevant rows for each deliveryman and sum their net sales and # of INV. 3. Calculations: - NAVEED SALEEM: Rows 58, 59, 60, 61 # of INV = 28 + 1 + 27 + 5 = 61 Net Sales = 86114 + 2791 + 206279 + 237563 = 533747 - FAYYAZ: No data provided for FAYYAZ in the table, so # of INV = 0, Net Sales = 0 - JUNAID: Rows 5, 6, 10, 50, 51 # of INV = 13 + 3 + 4 + 13 + 3 = 36 Net Sales = 34604 + 42471.1 + 238857.42 + 30088 + 41205 = 386225.52 - BILAL: Rows 19, 20, 21, 22, 23, 39, 40, 49, 62, 63, 64 # of INV = 1 + 1 + 1 + 4 + 20 + 1 + 1 + 2 + 4 + 20 + 1 = 56 Net Sales = 0 + 0 + 0 + 0 + 0 + 171906 + 96509 + 5325 + 144304 + 33297 + 204297 = 655638 - WAQAS: Rows 3, 4, 7, 33, 34 # of INV = 23 + 5 + 27 + 23 + 5 = 83 Net Sales = 0 + 0 + 127875.4 + 32972 + 54025 = 214872.4 - KHALID: Rows 1, 2, 52, 53 # of INV = 24 + 3 + 24 + 3 = 54 Net Sales = 0 + 0 + 74437 + 151393 = 225830 - ZAHID: Rows 11, 12, 13, 57 # of INV = 37 + 36 + 3 + 37 = 113 Net Sales = 0 + 70613.85 + 50655.63 + 75068 = 196337.48 - TANVEER: Row 54 # of INV = 29 Net Sales = 68587 - ATIQ: Row 14 # of INV = 17 Net Sales = 73835.72 - NOMAN: Rows 8, 9 # of INV = 27 + 5 = 32 Net Sales = 48031.14 + 2341.77 = 50372.91 - SAAD: Rows 24, 25, 56 # of INV = 14 + 4 + 8 = 26 Net Sales = 42144.49 + 79251 + 198394 = 319789.49 Final answers: - NAVEED SALEEM: # of INV = 61, Net Sales = 533747 - FAYYAZ: # of INV = 0, Net Sales = 0 - JUNAID: # of INV = 36, Net Sales = 386225.52 - BILAL: # of INV = 56, Net Sales = 655638 - WAQAS: # of INV = 83, Net Sales = 214872.4 - KHALID: # of INV = 54, Net Sales = 225830 - ZAHID: # of INV = 113, Net Sales = 196337.48 - TANVEER: # of INV = 29, Net Sales = 68587 - ATIQ: # of INV = 17, Net Sales = 73835.72 - NOMAN: # of INV = 32, Net Sales = 50372.91 - SAAD: # of INV = 26, Net Sales = 319789.49