Master Data Information

1780 Words4 Pages

INTRODUCTION
Materials Requirement Planning (MRP) is one of the integral production control techniques used in Enterprise resource planning(ERP). It calculates the net requirements for materials based on its dependence on other materials and develop procurement proposals which are often in the form of purchase requisitions and planned orders. The MRP creates planned orders for all finished and semi-finished products and aims to make sure that the company has sufficient availability of material to meet its requirements. In ERP, the Master Data is a key factor in the successful implementation of the production process. It sorts and stores data automatically, based on their functions and distinctive characteristics. The Material Master Data is the most commonly used type of Master data in business organizations. It contains all the essential information required to manage materials, the production of these materials, as well as their delivery information.
The material master data includes some key components which enables it to operate efficiently. They include, the Purchasing group, MRP controller, Base unit of measure, Lot size, procurement type, etc
PRODUCT PROFILE
DR Ltd is a manufacturing company involved in the production of aluminum alloy components which it uses to produce various household equipment, such as windows, doors, cabinets etc. In this production process, DR Ltd will be producing Aluminum DOOR-DR for its customers, based on their demand level.
In the MRP, the first task is usually determining what materials have to be planned. To produce the aluminum door, we will be making use of materials such as aluminum alloy, glass, frames, door handles, hinges, screws etc. The aluminum alloy is our raw material, which wi...

... middle of paper ...

...by using the scheduling times in the material master. The MRP elements column shows the planned order(PlOrd) and the Independent requirements(IndReq)) for our finished product.

MRP RUN RESULTS FOR SEMI-FINISHED PRODUCT
Figure 8.

In the screenshot above, DepReq means Dependent requirement. Which 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 the different types of materials as shown in figures 6-9 calculate the actual production time(from when order is placed to its completion) to the actual delivery time. In so doing, the company is able to identify whether or not it has sufficient materials and if it will be able to complete production as expected.

The figure below is the spreadsheet of our Muti-level single-item planning approach.

Figure 10.

Open Document