Material resource planning of Karen’s Bakeshop

Abstract

The proposed Material Resource Planning of Karen’s Bakeshop focused on the following objective: development of inventory module that manages inventory of raw ingredients and finish product, development of purchasing module that generates purchase order for ingredients below stock level based on inventory, and suggests a supplier with the lowest cost, development of production module that determines the schedule of production and includes forecasting feature to determine quantity of bread to be produced everyday based from 5-day average forecast, development of point of sale module that manages the sales, development of vendor manage inventory that monitors real-time information of all branches’ inventory, and development of report module that handles all reports of all branches.

The methodology used to develop the system was the iterative model which has nine stages: Initial Planning, Planning, Requirements, Analysis & Design, Coding, Test, Implementation, Deployment, and Evaluation.

In this study, the result showed that the proposed Karen’s Bakeshop MRP would help the management in their work. The spoilage of raw ingredients was minimized and the owner could easily view the others branches inventories via Virtual Private Network (VPN).

Based on the conclusion above, the group recommends the installation of the proposed system for Karen’s Bakeshop. Further enhancements could be done in the system function to provide more convenience to the user.