MRP

Report Module Guide: Material Requirements Planning (MRP Report)

Module Location

PPIC > Reports > MRP

Module Objective

The Material Requirements Planning (MRP) Report module is a crucial planning tool used to calculate future net material requirements. This report compares the total material demand (based on the sales forecast or production plan) with current and incoming stock availability (from outstanding POs) to determine which items need to be purchased and in what quantity.

1. Report Parameters (Filter)

The main page of this module is a form to define the scope and period of the MRP calculation.

Here is an explanation for each parameter:

• Forecast Period: Specify the Start Date and End date range for the forecast or production plan whose requirements will be calculated.

• Category: Filter the calculation for a specific material category or All Categories.

• Include Expired Item: Check this if you want to include items nearing their expiration date in the stock availability calculation.

2. Steps to Generate the Report

• Step 1: Set Report Parameters Define the Forecast Period you wish to plan for.

• Step 2: Generate the Report After the parameters are set, click one of the buttons at the bottom:

  • [Display Report]: To preview the MRP report directly on your screen.

  • [Regenerate]: To run the MRP calculation process again.

  • [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a planning worksheet that details the status of each material.

Key Column Explanation

• Stock: Shows the quantity of stock currently available in the warehouse.

• Outstanding (SPP / PO): Shows the quantity of goods that are currently on order (from both Purchase Requisitions and Purchase Orders) and will be received soon.

• Total Ostd & Stock: The total available quantity of the item (Stock + Outstanding).

• Forecast: The total gross requirement for this material based on the selected production or sales plan for the period.

• +/-: The Most Important Column. This is the net requirement, calculated from Forecast - Total Ostd & Stock. If the value is negative, your stock is sufficient. If the value is positive, that is the amount you must purchase.

• MOI (Month of Inventory): An estimate of how many months the current stock will last.

• Status & LT (Lead Time): Shows the planning status and the purchase lead time for the item.

Tips & Important Notes

• This report is the "brain" of the planning system. Use the results from the +/- column as the primary basis for creating new Purchase Requisitions (PR) or Purchase Orders (PO).

• Running the MRP report routinely (e.g., weekly) is crucial for maintaining a smooth production flow and preventing raw material shortages.

• This is a crucial strategic report for the PPIC and Purchasing teams.