Development of material requirements planning system(Case study in Coldair factory)

Abstract

This project aims to develop an inventory management system based on the material requirements planning, the system helps in facilitating the process of inventory management and ensure the availability of materials for production, and make sure inventory is onthe same line with demand.The software system is made by using Microsoft Excel and Microsoft access, Excel is the base of the system, the necessary calculation for the system to function are done by using it, such as the required quantities for the items of the product, and the dates of orders. Access helps us in making necessary output reports in the appropriate image.A field visit to Coldair’s factory inventory sector is made to collect the necessary data for the system to run. Andto assess the status of the plant and finds out its requirements to help us develop the appropriate system for the factory.As a result the Material Requirements Planning system software is designed to fit the plant requirements, the results obtained by the system are the dates of deliveries, the quantities of each item needed for production, the dates of orders and the quantity required for inventory. The system facilitates the process of managing the inventory necessary for production.