Inspiration

What it does

Application to calculate the cheapest combination of available inventory items that can be used to fill a specific order. It utilizes a MySQL database (inventory) provided by HYL, to extract data pertaining to the availability of reusable parts to create user-requested objects. The application updates the database when certain products are purchased to recycle its parts.

How we built it

(1) Accepts Input from the User through a user-friendly GUI. The code enables the user to return the item name in case the item name does not exist in the database. (2) Calculates all the possible combinations for choosing the lowest possible price option for manufacturing the requested object.

(3) Regardless of whether the object requested by the user can be created or not an output text file is created which displays the status of the request.

(4) The project includes a Test File that validates the functionality of each method in the FinalProject.java file.

Challenges we ran into

Accomplishments that we're proud of

What we learned

Developing the algorithm to calculate the lowest price to build an item of furniture using available inventory.

What's next for University of Calgary Supply Chain Management (HYL 2021)

Built With

Share this project:

Updates