5 page paper
California State University, East Bay College of Business and Economics MGMT 365 Enterprise Resource Planning and Control
Material Requirements Planning
Dr. Z. Radovilsky
Lecture Materials
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
1
1
Developed by Dr. Zinovy Radovilsky, Professor of Management and Finance
California State University, Hayward
All rights reserved
Lecture Overview
Why Material Requirements Planning (MRP)?
Definition and Objectives of MRP
MRP Inputs and Outputs
Developing MRP:
Net Requirement
Calculating Net Requirements, Planned Orders and Planned Order Releases
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
2
2
Why Use MRP?
“Material Requirements Planning (MRP) has become a centerpiece for all manufacturing and service systems. Without MRP, we would be totally out of control. It's not a theory - it's the real world”
Al Sondern, Corporate Vice President, Halmark Card, Inc.
“MRP is perhaps the most significant contribution to production and distribution systems… ”
William R. Wassweiler, an industry specialist
Service and manufacturing companies with sales of grater than $10 million are likely to utilize computerized MRP systems
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
3
3
Why Use MRP? (Continued)
Corning, Inc.
Before MRP, only 50 percent of its orders were being delivered on time
After MRP implementation, the company:
reduced inventory by approximately 10%
climbed inventory accuracy from 69 to 86 percent,
improved delivery schedules from 50 to 90 percent
SC Corporation, the world's largest producer of evaporative coolers
After two years of MRP implementation, inventory decreased so dramatically that plant could build the new line, doubled its production, and increased profit fivefold
MRP was applied to plan the NASA's space shuttle missions
To handle the extensive resource demand of each launch, it had design a Flight Operations Planning Schedule (FOPS) which was exactly the same as MRP
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
MRP: Definition and Main Objectives
MRP is a computer based system that determines what final products the firm will make for future periods, and then it specifies production of needed inputs to make those products
The system identifies
Schedules of specific parts and materials and their amounts required to produce end items
Dates when orders for the materials should be released and received
MRP slogan
Getting the right materials in the right place at the right time
“Getting the right quantities at the wrong time does not accomplish anything”
Main objectives of MRP
Improve customer satisfaction
Reduce inventory investment
Improve plant operations efficiency
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
MRP in Enterprise Resource Management
Master Demand Schedule (MDS)
Master Production Schedule (MPS)
Material Requirements Planning (MRP)
Capacity Requirements Planning (CRP)
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
MRP Inputs and Outputs
Inventory Information
Cost information
Material Requirements Planning (MRP)
Capacity Requirements Planning (CRP)
Purchasing and Supply Management
Work-in-Process Short-Term Schedules
Bill of Materials
Master Schedule
Supply Chain Bill Assignment Set
Accounting Material Costs
Changes and Exception Data
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
MRP Major Inputs
Master Schedule
MDS/MPS schedule including quantity and dates of end items production (gross or net requirements)
Incorporates sales orders including their quantity and dates
Bills of Materials
Product structure including single-level and other model BOM
Supply Chain Bill/Assignment Set
Supply chain relationships including all suppliers, customers, and quantities transferred
Inventory Information
Item attributes including lead times, safety stocks, amount on hand, make/buy items, MRP planned, order quantities, scheduled receipts, order entry, etc.
Cost Information
Provide cost of resources (labor, materials, and capacity) used in MRP as well as the end product prices in order to identify the total cost and gross profit for each MRP schedule
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Bell Computer: MDS Plan
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Product Structure Tree (Bill of Materials)
Bell 4000 Laptop Series
01-bell-4000
CD/DVD/RW Drive
01-cd
I/Lithium Battery
01-battery
4000 System Assembly
01-assembly-4000
19’’ LED Panel
01-led
Keyboard
01-kboard
CPU Core i7 Processor
01-cpu
Memory
2GB
01-memory
Power Supply
01-psupply
500 GB Hard Drive
01-hdrive
Assembly Case
01-case
Office Suite
01-office
1
2
1
1
1
1
1
1
3
2
1
1
Windows System
01-windows
Anti-virus Software
01-antivirus
Touchpad Mouse
01-mouse
1
1
Bell 8000 Laptop Series
01-bell-8000
CD/DVD/RW Drive
01-cd
I/Lithium Battery
01-battery
8000 System Assembly
01-assembly -4000
19’’ LED Panel
01-led
Keyboard
01-kboard
CPU Core i7 Duo Mobile
01-cpu
Memory
2GB
01-memory
Power Supply
01-psupply
500 GB Hard Drive
01-hdrive
Assembly Case
01-case
Office Suite
01-office
1
2
1
1
1
1
1
1
5
4
1
1
Windows System
01-windows
Anti-virus Software
01-antivirus
Touchpad Mouse
01-mouse
1
1
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Bell Computer: Supply Chain Bill
| Item Name | Item Description | Item Type | Supplier |
| 01-bell-computer | Bell Computers | Planning item | |
| 01-bell-4000 | Bell 4000 Laptop Series | Finished Good | Boston Manufacturing – M2 |
| 01-bell-8000 | Bell 8000 Laptop Series | Finished Good | Boston Manufacturing – M2 |
| 01-cd | CD/DVD/RW Drive | Purchased Item | Seattle Manufacturing – M1 |
| 01-battery | Ion Lithium Battery | Purchased Item | Seattle Manufacturing – M1 |
| 01-assembly-4000 | 4000 System Assembly | Intermediate Assembly | Boston Manufacturing – M2 |
| 01-assembly-8000 | 8000 System Assembly | Intermediate Assembly | Boston Manufacturing – M2 |
| 01-cpu | CPU Core i7 Processor | Purchased Item | Chicago Subassembly Plant – S1 |
| 01-memory | 2 GB Shared Dual Channel Memory | Purchased Item | Chicago Subassembly Plant – S1 |
| 01-hdrive | 500 GB Hard Drive 5400 RPM | Purchased Item | Dallas Manufacturing – M3 |
| 01-kboard | Keyboard | Purchased Item | Dallas Manufacturing – M3 |
| 01-mouse | Touchpad Mouse | Purchased Item | Dallas Manufacturing – M3 |
| 01-psupply | Power Supply | Purchased Item | Dallas Manufacturing – M3 |
| 01-case | Assembly case | Purchased Item | Dallas Manufacturing – M3 |
| 01-led | 19” LED Panel | Purchased Item | Seattle Manufacturing – M1 |
| 01-windows | Windows Operating System | Purchased Item | Chicago Subassembly Plant – S1 |
| 01-office | Office Suite Software | Purchased Item | Chicago Subassembly Plant – S1 |
| 01-antivirus | Anti-virus Software | Purchased Item | Chicago Subassembly Plant – S1 |
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Bell Computer: Inventory Records
| Item Name | Item Description | Lead Time, days | Safety Stock, units | On-hand Inv., units | Inventory Policy |
| 01-bell-4000 | Bell 4000 Laptop Series | 5 | 50 | 145 | Lot-for-lot |
| 01-bell-8000 | Bell 8000 Laptop Series | 5 | 50 | 120 | Lot-for-lot |
| 01-cd | CD/DVD/RW Drive | 5 | 100 | 135 | Lot-for-lot |
| 01-battery | Ion Lithium Battery | 5 | 100 | 120 | Lot-for-lot |
| 01-assembly-4000 | 4000 System Assembly | 5 | 50 | 84 | Lot-for-lot |
| 01-assembly-8000 | 8000 System Assembly | 5 | 50 | 65 | Lot-for-lot |
| 01-cpu | CPU Core i7 Processor | 10 | 120 | 170 | Lot-for-lot |
| 01-memory | 1 GB Shared Dual Channel Memory | 10 | 120 | 200 | Lot-for-lot |
| 01-hdrive | 500 GB Hard Drive 5400 RPM | 5 | 100 | 130 | Lot-for-lot |
| 01-kboard | Keyboard | 5 | 100 | 112 | Lot-for-lot |
| 01-mouse | Touchpad Mouse | 5 | 120 | 140 | Lot-for-lot |
| 01-psupply | Power Supply | 5 | 120 | 150 | Lot-for-lot |
| 01-case | Assembly case | 5 | 120 | 180 | Lot-for-lot |
| 01-lcd | 19” LED Panel | 5 | 100 | 110 | Lot-for-lot |
| 01-windows | Windows Operating System | 10 | 100 | 120 | Lot-for-lot |
| 01-office | Office Suite Software | 10 | 100 | 125 | Lot-for-lot |
| 01-antivirus | Anti-virus Software | 10 | 100 | 115 | Lot-for-lot |
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
MRP Processing
The MRP program operates in the following way:
Determines the number of end products and planned parts
Analyzes input files and determines the gross requirements of each item and its lead time
Calculates the net requirements for each item using the gross requirements, amount on hand, safety stock:
Net Gross Safety On
Requirement = Requirement + Stock -- Hand
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Example of MRP
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
MRP Processing (Continued)
After MRP calculates the net requirements, it develops planned order (planned order receipts) and planned order releases
Planned orders (planned-order receipts)
is the quantity of each material to be received in each time period of the planning horizon
Planned order releases
is the quantity of each item to be ordered in each time period of the planning horizon. This schedule is determined by offsetting the planned order receipts schedule to allow for lead times
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Example of MRP
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Enterprise Resources Management Applications
Create Inventory Items
(Part Numbers)
Create Bill of Materials (BOM)
Develop Supply Chain Bill (SCB)
Input Forecast and Customer Orders
Develop Master Demand Schedule
(MDS)
Develop Capacity Requirements Plan
(CRP)
Develop Material Requirements Plan
(MRP)
Short-Term Scheduling
MGMT 365 Enterprise Resource Planning
Dr. Z. Radovilsky
‹#›
MGMT 6130 Enterprise Planning
Dr. Z. Radovilsky
‹#›
Month
Demand forecast
WeekWeek 5Week 6Week 7Week 8Week 9
MDS for 01-bell-4000430.0376.0410.0376.0376.0
MDS for 01-bell-800094.0105.094.0100.094.0
July
2350
JuneJuly
Week 1Week 2Week 3Week 4Week 5
01-bell-4000 (finished good, L=1 week)
Gross Requirements430
Safety Stock5050
Amount on Hand145145
Net Requirements335
Planned Orders335
Planned Order Releases 335
01-bell-8000 (finished good, L=1 week)
Gross Requirements94
Safety Stock50 50
Amount on Hand120120
Net Requirements24
Planned Orders24
Planned Order Releases24
01-assembly-4000 (subassembly, L=1 week)
Gross Requirements335
Safety Stock5050
Amount on Hand8484
Net Requirements301
Planned Orders301
Planned Order Releases301
01-assembly-8000 (subassembly, L=1week)
Gross Requirements24
Safety Stock5050
Amount on Hand6565
Net Requirements9
Planned Orders9
Planned Order Releases9
JuneJuly
Week 1Week 2Week 3Week 4Week 5
01-assembly-4000 (subassembly, L=1 week)
Gross Requirements335
Safety Stock5050
Amount on Hand8484
Net Requirements301
Planned Orders301
Planned Order Releases301
01-assembly-8000 (subassembly, L=1week)
Gross Requirements24
Safety Stock5050
Amount on Hand6565
Net Requirements9
Planned Orders9
Planned Order Releases9
01-cpu (Supplier S1, L=2weeks)
Gross Requirements310
Safety Stock120120
Amount on Hand170170
Net Requirements260
Planned Orders260
Planned Order Releases260
01-memory (Supplier S1, L=2weeks)
Gross Requirements948
Safety Stock120120
Amount on Hand200200
Net Requirements868
Planned Orders 868
Planned Order Releases868