Spreadsheet: 816216d1675432263-hello-i-need-help-in-a-sales-profitability-excel-sheet-weighted-average-calculation-by-product
Sheet: INVOICES

Invoice # | Date | Client | Description of Goods | Unit | Pack Size | Units | Total Qty | Unit Price | Discount | Total | Total Sales in USD | Day | Initial Cost | Initial Qty/Added Qty | Remaining Qty
[NAME] | 2020-01-25 00:00:00 | H G | [NAME] (25L) | L | 25 | 40 |  | 181.25 |  | 7250 | 7250
[NAME] | 2020-01-25 00:00:00 | H G | [NAME] (25L) | L | 25 | 2 |  | 181.25 |  | 362.5 | 362.5 |  |  | 2
[NAME] | 2020-01-25 00:00:00 | H G | [NAME] (25L) | L | 25 | 14 |  | 181.25 |  | 2537.5 | 2537.5
0020/2020 | 2020-02-19 00:00:00 | K H | [NAME] (25L) | L | 25 | 2 | 50 |  |  | 362.5 | 362.5
0021/2020 | 2020-02-19 00:00:00 | A R | [NAME] (25L) | L | 25 | 1 | 25 | 195 |  | 195 | 195
0023/2020 | 2020-02-19 00:00:00 | M A A | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 225 | 225
0037/2020 | 2020-03-02 00:00:00 | A M el Mama | [NAME] (25L) | L | 25 | 8 | 200 | 250 |  | 2000 | 2000
0042/2020 | 2020-03-02 00:00:00 | C N | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 225 | 225
0045/2020 | 2020-03-05 00:00:00 | H Gho | [NAME] (25L) | L | 25 | 4 | 100 | 200 |  | 800 | 800
0047/2020 | 2020-03-10 00:00:00 | K H | [NAME] (25L) | L | 25 | 1 | 25 | 193.75 |  | 193.75 | 193.75
0057/2020 | 2020-03-18 00:00:00 | Ag M T | [NAME] (25L) | L | 25 | 60 | 1500 | 175 |  | 10500 | 10500
0067/2020 | 2020-03-29 00:00:00 | A Taleb | [NAME] (25L) | L | 25 | 10 | 250 | 225 |  | 2250 | 2250
0068/2020 | 2020-03-29 00:00:00 | M A A | [NAME] (25L) | L | 25 | 2 | 50 | 450 |  | 900 | 900
0070/2020 | 2020-04-04 00:00:00 | A R | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 200 | 200
0072/2020 | 2020-04-07 00:00:00 | Ag M T | [NAME] (25L) | L | 25 | 40 | 1000 | 175 |  | 7000 | 7000
0076/2020 | 2020-04-09 00:00:00 | H Gho | [NAME] (25L) | L | 25 | 4 | 100 |  |  | 775 | 775
0077/2020 | 2020-04-09 00:00:00 | M Kot | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 225 | 225
miss06/2020 | 2020-04-12 00:00:00 | A K D | [NAME] (25L) | L | 25 | 1 |  | 225 |  | 225 | 225
0081/2020 | 2020-04-21 00:00:00 | A Taleb | [NAME] (25L) | L | 25 | 10 | 250 |  |  | 2250 | 2250
0083/2020 | 2020-04-21 00:00:00 | A K D | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 225 | 225
0095/2020 | 2020-04-22 00:00:00 | A [NAME] (South) | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 225 | 225
0102/2020 | 2020-04-28 00:00:00 | H El Ajami | [NAME] (25L) | L | 25 | 22 | 550 | 200 |  | 4400 | 4400
0102/2020 | 2020-04-28 00:00:00 | H El Ajami | [NAME] (25L) | L | 1 | 25 |  |  |  | 200 | 200
0103/2020 | 2020-04-29 00:00:00 | I [NAME] | [NAME] (25L) | L | 25 | 3 |  |  |  | 600 | 600
0106/2020 | 2020-04-29 00:00:00 | R Faraj | [NAME] (25L) | L | 25 | 40 | 1000 |  |  | 7250 | 7250
0111/2020 | 2020-05-04 00:00:00 | M A A | [NAME] (25L) | L | 25 | 2 | 50 |  |  | 450 | 450
0114/2020 | 2020-05-05 00:00:00 | A Taleb | [NAME] (25L) | L | 25 | 10 | 250 | 225 |  | 2250 | 2250 |  | 1
0116/2020 | 2020-05-07 00:00:00 | H Khreiz | [NAME] (25L) | L | 25 | 2 | 50 | 0 |  | 0 | 0
0126/2020 | 2020-05-13 00:00:00 | I [NAME] | [NAME] (25L) | L | 25 | 3 | 75 |  |  | 675 | 675
0128/2020 | 2020-05-14 00:00:00 | A [NAME] (South) | [NAME] (25L) | L | 25 | 1 | 25 |  |  | 212.5 | 212.5
0139/2020 | 2020-05-21 00:00:00 | Mz J | [NAME] (25L) | L | 25 | 1 | 25 | 237.5 |  | 237.5 | 237.5
0140/2020 | 2020-05-21 00:00:00 | O Z | [NAME] (25L) | L | 25 | 5 | 125 |  |  | 1062.5 | 1062.5
0141/2020 | 2020-05-21 00:00:00 | M e B | [NAME] (25L) | L | 25 | 3 | 75 | 225 |  | 675 | 675
0150/2020 | 2020-06-01 00:00:00 | H Gho | [NAME] (25L) | L | 25 | 20 | 500 | 200 |  | 4000 | 4000
0150/2020 | 2020-06-01 00:00:00 | H Gho | Essence | L | 15 | 10 | 150 | 200 |  | 2000 | 2000
0153/2020 | 2020-06-02 00:00:00 | S Z | [NAME] (25L) | L | 25 | 2 | 50 |  |  | 450 | 450
0154/2020 | 2020-06-02 00:00:00 | K Far | [NAME] (25L) | L | 25 | 2 | 50 | 225 |  | 450 | 450
0158/2020 | 2020-06-06 00:00:00 | K H | [NAME] (25L) | L | 25 | 1 | 25 | 200 |  | 200 | 200
0158/2020 | 2020-06-06 00:00:00 | K H | Essence | L | 15 | 1 | 15 | 200 |  | 200 | 200
0161/2020 | 2020-06-05 00:00:00 | Mo Ham | [NAME] (25L) | L | 25 | 3 |  | 225 |  | 675 | 675
0161/2020 | 2020-06-05 00:00:00 | Mo Ham | Essence | L | 15 | 2 | 30 | 225 |  | 450 | 450