================================================================================================================================================================
  WEIGHTED-AVERAGE STOCK LEDGER
  Didactic Python code · Kardex Tauro · kardex-tauro.muisca.co
================================================================================================================================================================
Movements read: 10

Product: Gray cement 50 kg
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Date        Detail                                               In  Unit cost      In value      Out  Avg. cost Cost of sales  Balance  Avg. cost Balance value
----------------------------------------------------------------------------------------------------------------------------------------------------------------
2026-03-02  Purchase from Northern Cement - Invoice 1041     100.00  18,000.00  1,800,000.00                                     100.00  18,000.00  1,800,000.00
2026-03-05  Sale to La 80 Hardware - Delivery note 233                                          90.00  18,000.00  1,620,000.00    10.00  18,000.00    180,000.00
2026-03-09  Purchase from Northern Cement - Invoice 1078      60.00  20,000.00  1,200,000.00                                      70.00  19,714.29  1,380,000.00
2026-03-12  Sale to El Portal Builder - Delivery note 240                                       20.00  19,714.29    394,285.80    50.00  19,714.28    985,714.20
2026-03-18  Purchase from Andean Distributor - Invoice ...    40.00  21,000.00    840,000.00                                      90.00  20,285.71  1,825,714.20
2026-03-25  Sale to La 80 Hardware - Delivery note 251                                          50.00  20,285.71  1,014,285.50    40.00  20,285.72    811,428.70
----------------------------------------------------------------------------------------------------------------------------------------------------------------
FINAL BALANCE: 40.00 units -> 811,428.70

Product: THHN 12 AWG wire
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Date        Detail                                               In  Unit cost      In value      Out  Avg. cost Cost of sales  Balance  Avg. cost Balance value
----------------------------------------------------------------------------------------------------------------------------------------------------------------
2026-03-03  Purchase from Electro Supply Inc - Invoice ...   200.00   1,200.00    240,000.00                                     200.00   1,200.00    240,000.00
2026-03-07  Sale to United Electricians - Delivery note...                                     120.00   1,200.00    144,000.00    80.00   1,200.00     96,000.00
2026-03-11  Purchase from Electro Supply Inc - Invoice ...   150.00   1,350.00    202,500.00                                     230.00   1,297.83    298,500.00
2026-03-19  Sale to United Electricians - Delivery note...                                      80.00   1,297.83    103,826.40   150.00   1,297.82    194,673.60
----------------------------------------------------------------------------------------------------------------------------------------------------------------
FINAL BALANCE: 150.00 units -> 194,673.60

================================================================================================================================================================
SUMMARY BY PRODUCT
================================================================================================================================================================
  Gray cement 50 kg
    Purchases :    200.00 units     3,840,000.00
    Sales      :    160.00 units     3,028,571.30
    Balance      :     40.00 units       811,428.70
    Check (balance = purchases - sales): TIES
  THHN 12 AWG wire
    Purchases :    350.00 units       442,500.00
    Sales      :    200.00 units       247,826.40
    Balance      :    150.00 units       194,673.60
    Check (balance = purchases - sales): TIES

File written: salida/kardex.csv
