Track: Undergraduate Student Paper Competition

Abstract

Working in tandem with a leading snack manufacturing company, this project addresses the manufacturer's request of developing an MRP system that is flexible and can be easily integrated into the systems used in the company. A solution to develop an MRP system using excel was agreed upon as the software is familiar to both the administration and the plant managers and is a part of the established workflow. The basics of an MRP system are the three inputs those being: Bill of Materials, Demand Forecast, and Inventory status Files. Producing the Desired outputs of a production plan and a raw material Ordering Schedule. Using excel as a repository for demand and inventory data and taking into factor the material ratios, calculations are done using excel and produce both a dynamic purchase report and production schedule. Additional supporting data are also present in the form of pivot tables that show how much raw material can be rationed and distributed among products that have common components to further reduce the chances of stockouts.