VBA ERP Module

ESI4356 Project. An Excel VBA module created for a steel manufacturing company to automate ordering decisions.

This project was a group project for the course ESI4356: Decision Support Systems. The members of this project were Andres Espinosa, Rohan Nadgir, Kaylie Coatney, and Rodolfo Remien. We were tasked with creating a decision support system for a steel manufacturing company to automate ordering decisions. The problem statement was as follows: SteelTime would like a program to evaluate the cost to manufacture a job and provide outputs that help the company decide what products they should outsource for a job if any.

Our solution was a comprehensive VBA module where the manufacturer could keep a input and keep a record of their clients, their orders, and their jobs to fulfill. The manufacturer could use this VBA module as an end-to-end solution for their business, starting at inputting client information and ending at developing a cost report and recommended solution for job fulfillment.

Clicking on the below images will link to or download the respective project files.
This is the accompanying presentation for the project. Click the image to view the presentation.
This is the final Excel file for the project. CAUTION: Clicking on this file will download the excel file with the VBA module.
This is the user guide for the project. Click the image to view the user guide.