Material Requirements Planning and Enterprise Resource Planning Dr

Material Requirements Planning and Enterprise Resource Planning Dr. Ron Lembke

Historical Perspective ERP- Enterprise Resource Planning MRP II – Manufacturing Resource Planning mrp – material requirements planning

MRP Crusade (1975) l Material Requirements Planning l Make sure you have enough parts when you need them Take future demands, factor in lead times (time phase), compare to on hand, order l Determine order size and timing l Control and plan purchasing vs. OSWO inventory management l

Closed-Loop MRP l Capacity Consideration: Part routings l Calculate loads on each work station l See if scheduled load exceeds capacity l Lead-time long enough to allow some shuffling to make plan feasible l

MRP II -- Manufacturing Resource Planning l “A method for the effective planning of all resources of a manufacturing company” (APICS def. ) l l l Financial accounting incorporated Sales Operations Planning Simulate capacity requirements of different possible Master Production Schedules 1989, $1. 2 B MRPII sales in U. S. , one third of total software sales

Success? MRP Crusade Begins http: //www. census. gov/econ/currentdata/dbsearch

ERP differences l Material planning l Capacity planning l Product design l Information warehousing All functions in the entire company operate off of one common set of data l Instantaneous updating, visibility l

ERP Sales l Y 2 K: Worldwide sales of top 10 vendors 1995 $2. 8 B l 1996 $4. 2 B l 1997 $5. 8 B l l Fortune $3. 2 B SAP survey: 44% reported spending at least 4 times as much on implementation as on software

ERP Challenges l Modules assume “best practices: ” Change software to reflect company ($) l Change company to follow software (? ) l l Accuracy of data Drives entire system l Ownership of / responsibility for l l Ability to follow structure

The Heart of the Matter - mrp l System for organizing WIP releases l l l Work in Process – work that has been started, but not yet finished Consider Lead Time (LT)for each item Look at BOM to see what parts needed l l Bill of Materials – what goes into what Release so they will arrive just as needed

Bike Production Frame OCLV Carbon Drivetrain Wheels Seat, Bars 1 Mar 7 14 21 28 4 Apr Assemble Parts Due Arrive 11 18

MRP Table 6 units short

MRP Table Order 50 units week earlier

Ending Inventory Ending inventory

Terminology l Projected Available balance l l Not on-hand (that may be greater) Tells how many will be available Available to Promise – the units aren’t spoken for yet, we can assign them to a customer Planned order releases ≠ scheduled receipts l l l Only when material has been committed to their production Move to scheduled receipts as late as possible Preserves flexibility

1605 Snow Shovel Front View 1605 Snow Shovel Back View

1605 Snow Shovel 082 Nail (4) 314 scoop assembly 118 Shaft (wood) 14127 Rivet (4) 048 Scoop-shaft connector 13122 Top Handle Assy

314 scoop assembly 019 Blade (steel) 2142 Scoop (aluminum) 14127 Rivet (6)

13122 Top Handle Assembly 11495 Welded Top handle bracket Assembly 082 Nail (2) 1118 Top handle Coupling (steel) 129 Top Handle Bracket (steel) 457 Top handle (wood)

Linking the Records l Process of translating net requirements for one product into Gross Requirements for its component parts Take into account existing inventories l Consider also scheduled receipts l AKA Bill of Materials Explosion l

Put in the Scoop Pieces 18 Shaft 2142 Scoop (wood) (aluminum) 1605 Snow Shovel 314 scoop assembly 019 Blade (steel) 14127 Rivet (6) 14127 Rivet (4) 048 Scoop-shaft connector 13122 Top Handle Assy 082 Nail (4)

Entire BOM 314 scoop assembly 1605 Snow Shovel 14127 Rivet (4) 048 Scoop-shaft connector 13122 Top Handle Assy 082 Nail (4) 18 Shaft (wood) 019 Blade (steel) 14127 Rivet (6) 11495 Welded 457 handle 2142 Scoop (aluminum) 1118 Coupling 129 Top Bracket 082 Nail (2)

Product Structure Diagram 14127 Rivet (4) 314 scoop assembly 118 Shaft 019 Blade 1605 Snow Shovel 14127 Rivet (6) 048 connector 13122 Top Handle Assy 11495 Welded 457 handle 2142 Scoop 1118 Coupling 082 Nail (4) 129 Top Bracket 082 Nail (2)

Product Structure Diagram 1605 Snow Shovel LEVEL 0 LEVEL 1 048 connector 314 scoop assembly 118 Shaft 13122 Top Handle Assy LEVEL 2 019 Blade 14127 Rivet (6) 14127 Rivet (4) 11495 Welded 457 handle 082 Nail (4) (2) 2142 Scoop 1118 Coupling 129 Top Bracket LEVEL 3

BOM Explosion Example l Need to make 100 shovels l We are responsible for handle assemblies.

Net Requirements Part Description Top handle assy Top handle Nail (2 required) Bracket Assy Top bracket Top coupling Sch Inv 25 22 4 27 15 39 Doesn’t tell us when to order what. Gross Rec Req -100 25 75 50 150 -75 -48 15 48 Net Req 75 28 96 48 33 --

13122 Top Handle Assy Order policy: Lot-for-lot Lt = 2

13122 Top Handle Assy Order policy: Lot-for-lot Lt = 2

13122 Top Handle Assembly 11495 Welded Top handle bracket Assembly 457 Top handle (wood) 1118 Top handle Coupling (steel) 129 Top Handle Bracket (steel) 082 Nail (2)

457 Wooden Dowel One handle for Each assembly

457 Wooden Dowel Order policy: Q = 50

457 Wooden Dowel Order policy: Q = 50

082 Nail (2 required) Two nails for Each assembly x 2!!!

082 Nail (2 required) Four nails for Each shovel final assembly x 4!!! +120 +300 +200 +80 +240 +100 +160 +80

082 Nail (2 required)

11495 Bracket Assembly One bracket for Each assembly

11495 Bracket Assembly Periodic Ordering Quantity: 2 periods

11495 Bracket Assembly Periodic Ordering Quantity: 2 periods

129 Top Bracket

129 Top handle bracket Order policy: Lot-for-lot

1118 Top handle coupling

1118 Top handle coupling LT = 1 Order policy: Lot-for-lot, Safety Stock = 20

1118 Top handle coupling LT = 1 Order policy: Lot-for-lot, Safety Stock = 20

Other considerations l Safety stock if uncertainty in demand or supply quantity l l Safety LT if uncertainty in arrival time l l Don’t let available go down to 0 Place order earlier than necessary Order quantities l l l EOQ – Economic Order Quantity, Fixed Size If that’s not enough, order what you need, OR order two or more of the Fixed Size Lot-For-Lot, Periodic Order quantity, others

Summary l Demand for final products Compute needs for it and l Dependent Demand for components l l Look at all parts of the Bill of Materials l Complete the Table for each Bottom row (Pl Order Releases) becomes top row (Gross Requirements) of input components (also called children) l Multiplied by # needed for each parent l

Other considerations l Safety stock if uncertainty in demand or supply quantity l l Safety LT if uncertainty in arrival time l l Don’t let available go down to 0 Place order earlier than necessary Order quantities l l l EOQ – Economic Order Quantity, Fixed Size If that’s not enough, order what you need, OR order two or more of the Fixed Size Lot-For-Lot, Periodic Order quantity, others

Summary l Demand for final products Compute needs for it and l Dependent Demand for components l l Look at all parts of the Bill of Materials l Complete the Table for each Bottom row (Pl Order Releases) becomes top row (Gross Requirements) of input components (also called children) l Multiplied by # needed for each parent l