Material Requirement Planning

{{company_name}}

{{company_address}}

PHONE: {{phone}}

EMAIL: {{email}}

WEBSITE: {{website}}

MATERIAL REQUIREMENT PLANNING (MRP) DOCUMENT

**Date:** {{date}}

**Prepared By:** {{preparer_name}}

**Department:** {{department}}

**MRP Run Date:** {{mrp_run_date}}

**Planning Period:** {{planning_period_start}} to {{planning_period_end}}

1. Product Information

**Product Name:** {{product_name}}

**Product Code:** {{product_code}}

**Bill of Materials (BOM) Version:** {{bom_version}}

**Master Production Schedule (MPS) Reference:** {{mps_reference}}

2. Production Schedule and Forecast

**Planned Production Quantity (Units):** {{planned_production_quantity}}

**Production Start Date:** {{production_start_date}}

**Production End Date:** {{production_end_date}}

**Sales Forecast (Units) for Period:** {{sales_forecast}}

3. Material Requirements Breakdown

The following table details the raw materials and components required for the planned production.

**Product:** {{product_name}}

| Item Code | Item Description | Quantity per Unit | Total Required Quantity | Unit of Measure | On-Hand Inventory | Net Requirement | Lead Time (Days) | Order Quantity | Proposed Order Date | Proposed Delivery Date | Supplier |

|---|---|---|---|---|---|---|---|---|---|---|---|

| {{item_code_1}} | {{item_description_1}} | {{qty_per_unit_1}} | {{total_required_qty_1}} | {{uom_1}} | {{on_hand_inventory_1}} | {{net_requirement_1}} | {{lead_time_1}} | {{order_qty_1}} | {{proposed_order_date_1}} | {{proposed_delivery_date_1}} | {{supplier_1}} |

| {{item_code_N}} | {{item_description_N}} | {{qty_per_unit_N}} | {{total_required_qty_N}} | {{uom_N}} | {{on_hand_inventory_N}} | {{net_requirement_N}} | {{lead_time_N}} | {{order_qty_N}} | {{proposed_order_date_N}} | {{proposed_delivery_date_N}} | {{supplier_N}} |

4. Inventory Status

**Current Inventory Levels (as of {{inventory_date}}):**

* **Raw Materials:** {{raw_materials_inventory}} ({{raw_materials_uom}})

* **Work-in-Progress (WIP):** {{wip_inventory}} ({{wip_uom}})

* **Finished Goods:** {{finished_goods_inventory}} ({{finished_goods_uom}})

**Safety Stock Levels:**

* **Raw Material A:** {{safety_stock_A}}

* **Component B:** {{safety_stock_B}}

**Reorder Points:**

* **Raw Material A:** {{reorder_point_A}}

* **Component B:** {{reorder_point_B}}

5. Capacity Planning Considerations

**Available Production Capacity:** {{available_capacity}} (hours/units)

**Required Production Capacity:** {{required_capacity}} (hours/units)

**Capacity Variance:** {{capacity_variance}}

**Notes on Capacity Adjustments:** {{capacity_adjustment_notes}}

6. Proposed Actions and Recommendations

Based on the above analysis, the following actions are recommended to ensure material availability and production efficiency:

* **Purchase Order Generation:** {{po_generation_details}}

* **Production Order Adjustments:** {{production_order_adjustments}}

* **Supplier Expediting/Communication:** {{supplier_communication}}

* **Inventory Adjustments:** {{inventory_adjustments}}

* **Other Recommendations:** {{other_recommendations}}

7. Approvals and Authorization

This Material Requirement Plan has been reviewed and approved by the undersigned.

**Prepared By:**

Name: {{preparer_sign_name}}

Signature: __________________________

Date: {{preparer_sign_date}}

**Approved By (Production Manager):**

Name: {{production_manager_name}}

Signature: __________________________

Date: {{production_manager_date}}

**Approved By (Procurement Manager):**

Name: {{procurement_manager_name}}

Signature: __________________________

Date: {{procurement_manager_date}}