INTRODUCTION Material requirements planning (MRP) is one of the integral production control techniques used in enterprise resource planning (ERP). Calculate the net material requirement based on its dependence on other materials and develop procurement proposals which often come in the form of purchase requisitions and planned orders. MRP creates planned orders for all finished and semi-finished products and aims to ensure that the company has sufficient material availability to meet its needs. In ERP, master data is a key factor in the successful implementation of the production process. Sorts and stores data automatically, based on their functions and distinctive characteristics. Material master data is the most commonly used type of master data in business organizations. It contains all the essential information needed to manage materials, the production of these materials, as well as information on their delivery. Material master data includes some key components that allow it to function efficiently. They include purchasing group, MRP controller, base unit of measure, lot size, procurement type, etc. PRODUCT PROFILE DR Ltd is a manufacturing company involved in producing aluminum alloy components which uses to produce various household equipment, such as windows, doors, cabinets etc. In this manufacturing process, DR Ltd will produce aluminum DOOR-DR for its customers, based on their level of demand. In MRP, the first task is usually to determine which materials need to be planned. To produce the aluminum door, we will use materials such as aluminum alloy, glass, frames, door handles, hinges, screws, etc. Aluminum alloy is our raw material, which is......half of paper. .....using the scheduling times in the material master data. The MRP elements column shows the planned order (PlOrd) and independent requirements (IndReq)) for our finished product. MRP RUN RESULTS FOR SEMI-FINISHED PRODUCT Figure 8. In the screenshot above, DepReq means dependent requirement. This indicates that our glass product is based on the requirement of another material. MRP RUN RESULTS FOR RAW MATERIALS Figure 9. The MRP run for different types of materials, as shown in Figures 6-9, calculates the actual production time (from when the order is placed to its completion) to actual delivery times. By doing this, the company is able to identify whether or not it has sufficient materials and whether it will be able to complete production as planned. The following figure is the spreadsheet of our Muti-level single-item planning approach. Figure 10.