A python package to find optimal number of orders


Keywords
pyomo, operations
License
BSD-3-Clause
Install
pip install fono==0.2.9

Documentation

fono - Find Optimal Number of Orders

Pyomo python program to find number of optimal order from websites including shipping costs (MILP)

Install

pip install fono
pip install fono --upgrade

Dependencies

  • Install glpk

    brew install glpk # osx
    

Run

  • Run the following to find the optimal order using input from individual files

    fono --quantity fono/data/quantity.csv --price fono/data/price.csv --shipping fono/data/shipping.csv
    

OR

  • Run the following to find the optimal order using input in a folder

    fono --folder fono/data
    

Use help

fono --help

Three files are required to find the optimal order

  • prices.csv
  • quantity.csv
  • shipping.csv

Prices contains the price of an item when purchased from a website.

Quantity contains the number of items required.

Shipping contains the shipping cost from the individual websites.

Troubleshooting

  • Names of items in quantity.csv has to match prices.csv
  • Names of websites in shipping.csv has to match prices.csv
  • Remove all empty lines

Contribution

Feel free to submit a pull request. Thanks to Matt for the inspiration.