Materials Requirement Plan

Introduction

Helps to generate material consumption, procurement plan and full kit availability.
MRP are created based on the Unti Codes. For every unit a different plan ae created.
It is also based on the production plan created.

Mandatory Fields
Select Unit - Pre selected as Pune (options as per GST Units)
Year - Pre selected as current fiscal year (Select from year combo box)
Report Type - Pre selected as Production plan (Production Plan, Procurement Plan, Full Kit Plan)
Plan Range From - Select from Plan Details list `Validation` - For full kit, plan range from & plan range to must be same
Plan Range To - Select from Plan Details list

Mandatory Fields
Item - Select from Inventory Master .
Stage - Pre selected as FG (FG, RM.)
Quantity `Validation` - Qty : Range 0.001 - 99999.999 .

Features
Create New
Modify
Delete
Import To Excel - To upload budget in csv formate `Validation` - Uploaded file name should be ImportInProcessStock

Reports
1. Production Plan - 1.1. Production Plan : This report will show the quantity of products that are planned to be manufactured within a date range. - 1.2. Final Production Plan : It will display the final plan qty for products along with plan qty, order qty, stock qty of FG - 1.3. Product Wise Consumption : This report will show the product wise consumption of various items along with Uom, qty. - 1.4. Item Wise Consumption : This report shows customized report which is used to keep track of all products, process, items etc. - 1.5. Item Wise Consumption Summary : It will show the summary of items and its consumption. 1.6. IIRS Qty : This report will show the consumption report for Inventory Issues & Receipts (IIRS) quantity with rack info.
2. Procurement Plan - 2.1. Procurement Plan : It will show the purchase information of goods and services and also it lists all requirements expected to be procured over a period of time. 2.2. Procurement Based On Max Order : This report displays the the purchase information of goods and services with max order level details.
3. Full kit Plan - 3.1. Fullkit Plan : This report will show plan qty, full kit qty and system qty for all FG items. - 3.2. Fullkit Working : It will display some quantities like plan, full kit, max prdn qty etc details for various FG and RM items with balance.

First you need to select the unit code with the given dropdown.
Then you need to select the year in which you want to create the MRP. Based on the year you will get to select the production plans.
After you have selected the financial year, you need to select the type of report you want to download. The types you will get to see are the Production plan, Procurement plan and full kit plan.
Once the report type is selected you need to select the production plans given in the drop-down.

Note: The Production plans will be displayed based on the financial year you have selected.

For the full kit plan, the production plans need to be the same.
Once all the above fields are selected you will get 4 checkboxes.
1. Add Pending Order Qty [Upto 2 years] to Plan Qty.
2. Adjust FG Store Stock from Pending Orders.
3. Adjust RM Store Stock in Procurement.
4. Scan BOM of Sub Assemblies to Workout Consumption

Note: By default Adjust RM Store Stock in Procurement will be selected.