Spreadsheet: 846568d1697722395-automatic-date-formula-dagang-tas-eiger-tahap-3
Sheet: Purchase

Purchase History & Expenses
Purchase Date | Source | Qty | Items | Color | Buying Total Price | Price/Unit | Price List | Selling Price Target | Estimated Profit | % Estimated Profit | Balance | Balance Total |  | Items | Price List |  | Colors | Source |  | Items | Color | Sum of Qty | Sum of Buying Total Price | Sum of Balance | Sum of Balance Total
2023-07-02 00:00:00 | Shopee | 2 | Eiger Starter Daypack 16L | Blue |  |  |  |  |  |  |  |  |  | Eiger Starter Daypack 16L | 359000 |  | Blue | Shopee |  | Bubble wrap [NAME] | - | 1 | 59375 | 0 | 0
2023-07-02 00:00:00 | Shopee | 2 | Eiger Starter Daypack 16L | Olive |  |  |  |  |  |  |  |  |  | Eiger Meridian 30L Laptop Backpack | 689000 |  | Black | Tokopedia |  | Bubble wrap dan lakban Total |  | 1 | 59375 | 0 | 0
2023-07-03 00:00:00 | Shopee | 1 | [NAME] Backpack 20L | Black | 297100 |  |  |  |  |  |  |  |  | [NAME] [NAME] | 319000 |  | Burgundy | Lazada |  | [NAME] Pack 20L Backpack | Black | 1 | 291816.6666666667 | 1 | 291816.6666666667
2023-07-04 00:00:00 | Tokopedia | 1 | [NAME] Backpack 20L | Black | 291850 |  |  |  |  |  |  |  |  | [NAME] 15 Laptop Backpack | 369000 |  | Olive |  |  |  | Green | 2 | 577793 | 0 | 0
2023-07-07 00:00:00 | Lazada | 8 | Eiger Meridian 30L Laptop Backpack | Black | 3469382.045509301 |  |  |  |  |  |  |  |  | [NAME] 10 1.0 Backpack | 129000 |  | Navy |  |  |  | Navy | 2 | 542372.0030408683 | 1 | 271186.0015204342
2023-07-07 00:00:00 | Lazada | 1 | Eiger Starter Daypack 16L | Olive | 227439.5677059111 |  |  |  |  |  |  |  |  | Eiger Versapack Waist Pack | 279000 |  | [NAME] |  |  | [NAME] Pack 20L Backpack Total |  | 5 | 1411981.669707535 | 2 | 563002.6681871009
2023-07-07 00:00:00 | Lazada | 2 | [NAME] 15 Laptop Backpack | Navy | 467378.1165016859 |  |  |  |  |  |  |  |  | [NAME] 20L Woman Backpack | 529000 |  | Khaki |  |  | [NAME] 15 Laptop Backpack | Navy | 2 | 467378.1165016859 | 0 | 0
2023-07-07 00:00:00 | Lazada | 2 | [NAME] Backpack 20L | Navy | 567369.9652205957 |  |  |  |  |  |  |  |  | [NAME] 20L Laptop Backpack | 629000 |  |  |  |  | [NAME] 15 Laptop Backpack Total |  | 2 | 467378.1165016859 | 0 | 0
2023-07-07 00:00:00 | Lazada | 6 | [NAME] Backpack 20L | Black | 1702109.895661787 |  |  |  |  |  |  |  |  | Eiger Passage 2.0 15L Laptop Daypack | 449000 |  |  |  |  | [NAME] 25L | Black | 13 | 5104371 | 12 | 4703563.9
2023-07-07 00:00:00 | Lazada | 2 | [NAME] Backpack 20L | Khaki | 596907.0310592738 |  |  |  |  |  |  |  |  | Eiger Forlough 20 Laptop Backpack | 519000 |  |  |  |  |  | Khaki | 6 | 2435680 | 5 | 2005387.5
2023-07-07 00:00:00 | Lazada | 2 | [NAME] Pack 20L Backpack | Navy | 542372.0030408683 |  |  |  |  |  |  |  |  | Eiger Reveal 18 Laptop Backpack | 439000 |  |  |  |  |  | Navy | 3 | 1058720 | 3 | 1058720
2023-07-07 00:00:00 | Lazada | 2 | [NAME] | Navy | 492376.0786814133 |  |  |  |  |  |  |  |  | [NAME] 25L | 579000 |  |  |  |  | [NAME] 25L Total |  | 22 | 8598771 | 20 | 7767671.4
2023-07-07 00:00:00 | Lazada | 6 | [NAME] 3.0 Laptop 18L Backpack | Black | 1927091.555279335 |  |  |  |  |  |  |  |  | [NAME] | 239000 |  |  |  |  | [NAME] 3.0 Laptop 18L Backpack | Black | 6 | 1927091.555279335 | 5 | 1605909.629399446
2023-07-07 00:00:00 | Lazada | 4 | [NAME] 2.0 Laptop Backpack 20L | Black | 1259729.741339829 |  |  |  |  |  |  |  |  | [NAME] Backpack 20L | 449000 |  |  |  |  |  | Olive | 3 | 1077000 | 3 | 1077000
2023-07-07 00:00:00 | Shopee | 2 | [NAME] Pack 20L Backpack | Green |  |  |  |  |  |  |  |  |  | [NAME] 2.0 Laptop Backpack 20L | 499000 |  |  |  |  | [NAME] 3.0 Laptop 18L Backpack Total |  | 9 | 3004091.555279335 | 8 | 2682909.629399446
2023-07-07 00:00:00 | Shopee | 1 | [NAME] Termina 2.0 Backpack | Navy |  |  |  |  |  |  |  |  |  | [NAME] | 389000 |  |  |  |  | [NAME] Termina 2.0 Backpack | Black | 4 | 1224650 | 2 | 623550
2023-07-08 00:00:00 | Shopee | 1 | [NAME] | Olive | 276550 |  |  |  |  |  |  |  |  | [NAME] 3.0 Laptop 18L Backpack | 509000 |  |  |  |  |  | Navy | 1 | 330143 | 1 | 330143
2023-07-12 00:00:00 | Lazada | 3 | [NAME] 3.0 Laptop 18L Backpack | Olive | 1077000 |  |  |  |  |  |  |  |  | [NAME] Pack 20L Backpack | 429000 |  |  |  |  | [NAME] Termina 2.0 Backpack Total |  | 5 | 1554793 | 3 | 953693
2023-07-19 00:00:00 | Shopee | 1 | Bubble wrap [NAME] | - | 59375 |  |  |  |  |  |  |  |  | [NAME] Termina 2.0 Backpack | 489000 |  |  |  |  | Eiger Forlough 20 Laptop Backpack | Black | 9 | 3120330.333333333 | 8 | 2774156.761904762
2023-07-29 00:00:00 | Shopee | 3 | [NAME] Termina 2.0 Backpack | Black |  |  |  |  |  |  |  |  |  | Eiger Starter Daypack 21L | 439000 |  |  |  |  |  | Maroon | 1 | 348557.6666666667 | 1 | 348557.6666666667
2023-07-29 00:00:00 | Shopee | 1 | Plastik packing | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Forlough 20 Laptop Backpack Total |  | 10 | 3468888 | 9 | 3122714.428571429
2023-08-01 00:00:00 | Lazada | 3 | [NAME] Backpack 20L | Black | 933584 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Meridian 30L Laptop Backpack | Black | 8 | 3469382.045509301 | 0 | 0
2023-08-08 00:00:00 | Lazada | 2 | [NAME] 20L Woman Backpack | Burgundy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | 1370298.092320783 | 0 | 0
2023-08-08 00:00:00 | Lazada | 1 | [NAME] 20L Woman Backpack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Meridian 30L Laptop Backpack Total |  | 11 | 4839680.137830084 | 0 | 0
2023-08-08 00:00:00 | Shopee | 2 | Eiger Meridian 30L Laptop Backpack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 2.0 Laptop Backpack 20L | Black | 4 | 1259729.741339829 | 1 | 314932.4353349573
2023-08-08 00:00:00 | Shopee | 1 | [NAME] 20L Woman Backpack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 2.0 Laptop Backpack 20L Total |  | 4 | 1259729.741339829 | 1 | 314932.4353349573
2023-08-08 00:00:00 | Shopee | 1 | [NAME] 20L Woman Backpack | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Starter Daypack 16L | Blue | 2 | 437798 | 0 | 0
2023-08-08 00:00:00 | Shopee | 1 | [NAME] Backpack 20L | Navy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Olive | 3 | 665237.5677059111 | 0 | 0
2023-08-08 00:00:00 | Shopee | 2 | [NAME] Backpack 20L | Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Starter Daypack 16L Total |  | 5 | 1103035.567705911 | 0 | 0
2023-08-09 00:00:00 | Lazada | 2 | Eiger Starter Daypack 21L | Olive | 570497.9076792173 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Starter Daypack 21L | Blue | 1 | 278152 | 1 | 278152
2023-08-09 00:00:00 | Lazada | 1 | Eiger Meridian 30L Laptop Backpack | [NAME] | 451298.0923207828 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Olive | 2 | 570497.9076792173 | 2 | 570497.9076792173
2023-09-03 00:00:00 | Lazada | 1 | [NAME] | Olive | 235000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eiger Starter Daypack 21L Total |  | 3 | 848649.9076792173 | 3 | 848649.9076792173
2023-09-09 00:00:00 | Shopee | 10 | [NAME] 25L | Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Backpack 20L | Black | 13 | 3806077.228995121 | 2 | 581433.3333333334
2023-09-09 00:00:00 | Lazada | 7 | Eiger Forlough 20 Laptop Backpack | Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Khaki | 2 | 596907.0310592738 | 1 | 298453.5155296369
2023-09-09 00:00:00 | Shopee | 1 | [NAME] Pack 20L Backpack | Black | 291816.6666666667 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Navy | 3 | 858086.6318872625 | 0 | 0
2023-09-09 00:00:00 | Lazada | 2 | [NAME] | Olive | 537090 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Backpack 20L Total |  | 18 | 5261070.891941657 | 3 | 879886.8488629702
2023-09-09 00:00:00 | Shopee | 1 | [NAME] 20L Laptop Backpack | Navy | 179100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Navy | 2 | 492376.0786814133 | 1 | 246188.0393407067
2023-09-10 00:00:00 | Lazada | 2 | Eiger Forlough 20 Laptop Backpack | Black |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Olive | 4 | 1048640 | 1 | 268545
2023-09-10 00:00:00 | Lazada | 1 | Eiger Forlough 20 Laptop Backpack | Maroon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Backpack Total |  | 6 | 1541016.078681413 | 2 | 514733.0393407067
2023-09-11 00:00:00 | Lazada | 1 | [NAME] Termina 2.0 Backpack | Black | 323000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 20L Woman Backpack | [NAME] | 2 | 749187.8333333333 | 0 | 0
2023-09-14 00:00:00 | Tokopedia | 2 | [NAME] 20L Woman Backpack | Burgundy | 792384 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | 382559.5 | 1 | 382559.5
2023-09-15 00:00:00 | Shopee | 3 | [NAME] 25L | Black | 1096300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Burgundy | 4 | 1525640.666666667 | 2 | 792384
2023-09-21 00:00:00 | Shopee | 3 | [NAME] 25L | Navy | 1058720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 20L Woman Backpack Total |  | 7 | 2657388 | 3 | 1174943.5
2023-09-25 00:00:00 | Shopee | 2 | [NAME] 25L | Khaki | 860585 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 20L Laptop Backpack | Navy | 1 | 179100 | 0 | 0
2023-09-26 00:00:00 | Shopee | 2 | [NAME] 25L | Khaki | 846095 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 20L Laptop Backpack Total |  | 1 | 179100 | 0 | 0
2023-09-27 00:00:00 | Shopee | 2 | [NAME] 25L | Khaki | 729000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastik packing | - | 1 | 38720 | 0 | 0
2023-10-03 00:00:00 | Lazada | 1 | Eiger Starter Daypack 21L | Blue | 278152 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastik packing Total |  | 1 | 38720 | 0 | 0
2023-10-09 00:00:00 | Shopee | 4 | [NAME] 15 Laptop Backpack | Black | 914270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 110 | 36293668.66666666 | 54 | 18823136.85737583
2023-10-10 00:00:00 | Lazada | 2 | [NAME] 20L Woman Backpack | Burgundy | 707590
2023-10-10 00:00:00 | Lazada | 2 | Eiger Starter Daypack 16L | Blue | 476457
2023-10-10 00:00:00 | Lazada | 1 | [NAME] Pack 20L Backpack | Green | 301228
2023-10-14 00:00:00 | Lazada | 1 | [NAME] Pack 20L Backpack | Green | 276604.6719817768
2023-10-14 00:00:00 | Lazada | 1 | Eiger Starter Daypack 16L | Blue | 231471.0425208808
2023-10-14 00:00:00 | Lazada | 1 | [NAME] 20L Woman Backpack | Burgundy | 341081.2854973425