Capacity Planning System Optimization/Automation

Project goal: To automate the sponsor’s capacity-planning system by implementing an accessible and user-friendly web-based form.The sponsor runs an error-prone manual capacity-planning system using Microsoft Excel. The designed system includes back end and laser-marking capacity planning. An analysis of the sponsor’s current method was done in MatLab, and a simulation of the capacity planning was produced. The simulation was used to learn how to convert, process and interface the required information into a website. The designed web form consists of hypertext markup language graphic interfaces, C# back end computation, and an Oracle database that manages the data storage and interfaces with the web form using Structured Query Language. The web form allows multiple departments, such as human resources and sales, to enter data directly into the system within a certain time frame before a supervisor is notified via automated message. The system also checks if the input values fall within acceptable bounds.