Material Requirements Planning MRP Summary of Scheduling Process

Material Requirements Planning (MRP)

Summary of Scheduling Process FORECAST ROUGH-CUT CAPACITY PLANNING PRODUCTION PLAN MASTER PRODUCTION SCHEDULE (MPS) MATERIAL REQUIREMENTS PLANNING (MRP) CAPACITY REQUIREMENTS PLANNING SHOP FLOOR CONTROLS VENDOR CONTROLS

MRP v Material Requirements Planning (MRP) – Translates MPS into Schedule of Component Requirements, Order Quantities, and Times v Manufacturing Resource Planning (MRP II) – Computes Resource Requirements, i. e. Labor v Enterprise Resource Planning (ERP) – Has Financial, Marketing, Etc. Components

Nature of Demand v. Independent Demand – Demand Outside of Firm, on MPS (Vanilla Ice Cream) v. Dependent Demand – Derived Demand within Firm (Cream, Vanilla Flavoring, Etc. )

MRP Outputs (Objectives) v. Determine Requirements – What to Order – How Much to Order – When to Schedule Delivery v. Keep Priorities Current

MRP Inputs v. Master Production Schedule (MPS) v. Bill of Materials (Parts List) v. Inventory Status – On Hand v. Lead Times

MRP Example 1 The Protecto Corporation sells special survival kits to the visitors of Congress and the state legislatures. In April there are requirements for 1000 kits. Each kit contains: two ear plugs one bottle of extra strength aspirin five paper gas masks one box one label The firm only manufactures the ear plugs and the gas masks. The other parts are purchased. Each ear plug uses two ounces of wax and. 08 hours of labor time. Each gas mask uses a sheet of cardboard, one-half ounce of wax, and. 10 hours of labor.

Bill of Materials: Example 1

Component Parts & Labor Requirements Ear Plugs (2 x 1000) = 2000 Aspirin (1 x 1000) = 1000 Gas Masks (5 x 1000) = 5000 Boxes (1 x 1000) = 1000 Labels (1 x 1000) = 1000 Cardboard (1 x 5000) = 5000 Wax (2 x 2000) + (. 5 x 5000) = 6500 Labor Hours (. 08 x 2000) + (. 1 x 5000) = 660

Cardboard Sheets if 3% Scrapped Adjustment for Scrap: Scheduled Units = MRP / (1 – Scrap %) Scheduled Units = 5000 /. 97 = 5155

Standard and Actual Labor Time Standard Time = MRP / (1 - % Delay) ST = 0. 66 / 0. 8 = 0. 825 Hours Actual Time AT = 0. 825 /. 9 = ST / Labor Efficiency = 0. 920 Hours

MRP Example 2 In order to make one starship, you need 3 warp engines and 4 impulse engines. Each warp engine requires 10 dilithium crystals, 7 units of platinum, and 3 antimatter pods. Each impulse engine requires 2 antimatter pods and 4 units of platinum. The lead times are: Item Starship (SS) Warp Engine (WE) Impulse Engine (IE) Dilithium Crystal (DC) Antimatter Pods (AM) Platinum (PL) Lead Time 2 years 3 years 1 year 2 years The Federation has ordered 3 starships to be delivered in AD 2379.

Bill of Materials: Example 2

MRP Calculations Starship: Lead Time 2 Years Year 2372 2373 2374 2375 2376 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 2377 2378 2379 3 0 0 3 3 3 Warp Engine: Lead Time 3 Years Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 9 9 0 0 9 9

MRP Calculations Starship: Lead Time 2 Years Year 2372 2373 2374 2375 2376 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 2377 2378 2379 3 0 0 3 3 3 Impulse Engine: Lead Time 1 Year Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 12 12 0 0 12 12

MRP Calculations Warp Engine: Lead Time 3 Years Year 2372 2373 2374 2375 2376 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 9 2377 2378 2379 9 0 0 9 9 Dilithium Crystal: Lead Time 2 Years Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts 90 0 0 90 Planned Order Releases 90

MRP Calculations: v. Work from Top to Bottom of Product Structure Tree v. Subtract Out Any Items On Hand v. Combine Common Components – Put on the Same Table. If on the Same Square, Add.

MRP Extensions: v. Multiple Bills of Material v. On Hand Quantities v. On Order Quantities v. Spare Parts

MRP Example 3 A firm makes two products, A and R. A computer file reveals the following information about A and R, and their component parts: Item A B C D E R On Hand 10 0 0 20 Lead Time 3 Weeks 2 Weeks 1 Week 3 Weeks MPS 160 (week 8) 400 (week 5) 145 (week 7) Lot Size 1 400 1 500 1 1 On Order 200 (week 2)

Bill of Materials: Example 3

Bill of Materials: Example 3

MRP Calculations A: Lead Time 3 Weeks, Low-Level Code 0 Week 1 2 3 4 5 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 6 7 8 160 0 10 150 150 D: Lead Time 3 Weeks, Low-Level Code 1 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts 450 200 250 500 Planned Order Releases 500

MRP Calculations R: Lead Time 3 Weeks, Low-Level Code 0 Week 1 2 3 4 5 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 125 6 7 8 145 0 20 125 B: Lead Time 2 Weeks, Low-Level Code 1 Gross Requirements Scheduled Receipts Available Net Requirements Planned Order Receipts Planned Order Releases 800 500 300 0 0 300 500 0 800

Low Level Codes v. Item E is What Low-Level Code? v. Item C is What Low-Level Code? v. Can You Do the MRP Tables for Items C and E?

Material Planners v. People Who Manage MRP System v. Release Manufacturing Orders (MO) or Purchasing Orders (PO) v. Reschedule Due Dates of Open Orders as Needed v. Reconcile Orders and Find Cause v. Solve Shortages by Expediting v. Coordinate with Others

Material Planner Works with: v. Planned Orders v. Released Orders v. Firm Planned Orders v. Exception Messages v. Transaction Messages

Material Planner Uses Feedback for Priorities v. Suppliers Actions Through Purchasing v. Early or Late Completions or Differing Quantities v. Management Actions (Changing MPS)