===================================================================================================================
  REORDER POINT AND EOQ
  Didactic Python code · Kardex Tauro · kardex-tauro.muisca.co
===================================================================================================================
Products read: 4
Note: the business year has 360 days and 1.65 belongs to a 95% service level.
The EOQ is the size that balances the ordering cost against the holding cost.

REPLENISHMENT PARAMETERS PER PRODUCT
-------------------------------------------------------------------------------------------------------------------
Product                        EOQ units      Orders/year    Annual cost Daily demand   Safety stock    Reorder pt.
-------------------------------------------------------------------------------------------------------------------
Gray cement 50 kg              573.00               15.71   2,517,144.50        25.00          45.00         545.00
THHN 12 AWG wire 100 m         425.00               14.12   1,272,794.12        16.67          32.00         282.00
Self-tapping screw 1 in        837.00                5.02     200,798.42        11.67           8.00          67.00
Anticorrosive paint 1 gal      156.00                9.62     673,498.46         4.17          73.00         198.00
-------------------------------------------------------------------------------------------------------------------

ORDER SIZE SENSITIVITY: Gray cement 50 kg
--------------------------------------------------------------------------
Factor   Quantity        Ordering cost       Holding cost       Total cost
--------------------------------------------------------------------------
0.5x     287.00           2,508,710.80         631,400.00     3,140,110.80
0.75x    430.00           1,674,418.60         946,000.00     2,620,418.60
1x       573.00           1,256,544.50       1,260,600.00     2,517,144.50
1.25x    717.00           1,004,184.10       1,577,400.00     2,581,584.10
1.5x     860.00             837,209.30       1,892,000.00     2,729,209.30
2x       1,146.00           628,272.25       2,521,200.00     3,149,472.25
--------------------------------------------------------------------------
Lowest total cost: 1x (2,517,144.50)

===================================================================================================================
SUMMARY AND CHECK
===================================================================================================================
  Gray cement 50 kg
    Order            : 573.00 units
    Every            : 22.92 days between orders
    Reorder point    : 545.00 units
    Total annual cost: 2,517,144.50
  THHN 12 AWG wire 100 m
    Order            : 425.00 units
    Every            : 25.50 days between orders
    Reorder point    : 282.00 units
    Total annual cost: 1,272,794.12
  Self-tapping screw 1 in
    Order            : 837.00 units
    Every            : 71.74 days between orders
    Reorder point    : 67.00 units
    Total annual cost: 200,798.42
  Anticorrosive paint 1 gal
    Order            : 156.00 units
    Every            : 37.44 days between orders
    Reorder point    : 198.00 units
    Total annual cost: 673,498.46

  Check (the lowest cost falls at the EOQ, factor 1): TIES

File written: salida/reorden_eoq.csv
File written: salida/sensibilidad.csv
