ch15 MRP

Chapter 15
Resource Planning
Operations
Operations Management
Management -- 66thth Edition
Edition
Roberta Russell & Bernard W. Taylor, III
Beni Asllani
Copyright 2009 John Wiley & Sons, Inc. University of Tennessee at
Resource
Planning for
Manufacturing
Copyright 2009 John Wiley & Sons, Inc. 15-2

Material Requirements
Planning (MRP)
 Computerized inventory control
and production planning system
 When to use MRP?
 Dependent demand items
 Discrete demand items
 Complex products
 Job shop production
 Assemble-to-order environments

Demand Characteristics
Independent demand Dependent demand
100 x 1 =
100 tabletops
100 tables 100 x 4 = 400 table legs
Continuous demand
Discrete demand
400 –
400 –
No. of tables
300 –
No. of tables
300 –
200 –
200 –
100 –
100 –
1 2 3 4 5
Week M T W Th F M T W Th F

Material Master
production
Requirements schedule
Planning
Product Material Item
structure requirements master
file planning file
Planned
order
releases
Work Purchase Rescheduling

orders orders notices

MRP Inputs and Outputs
 Inputs  Outputs
 Master  Planned order
production releases
schedule  Work orders
 Product structure  Purchase orders
file  Rescheduling
notices
 Item master file

Master Production Schedule
 Drives MRP process with a schedule of

finished products
 Quantities represent production not
demand
 Quantities may consist of a combination
of customer orders and demand
forecasts
 Quantities represent what needs to be
produced, not what can be produced
 Quantities represent end items that may
or may not be finished products

(cont.)
PERIOD
MPS ITEM 1 2 3 4 5
Pencil Case 125 125 125 125 125
Clipboard 85 95 120 100 100
Lapboard 75 120 47 20 17
Lapdesk 0 50 0 50 0

Product Structure
Clipboard
Top clip (1) Bottom clip (1)
Pivot (1) Spring (1)
Rivets (2)
Finished clipboard Pressboard (1)

Product Structure Tree
Clipboard Level 0
Pressboard Clip Ass’y Rivets

(1) (1) (2) Level 1
Top Clip Bottom Clip Pivot Spring

(1) (1) (1) Level 2
(1)

Multilevel Indented BOM
LEVEL ITEM UNIT OF MEASURE QUANTITY

0---- Clipboard ea 1
-1--- Clip Assembly ea 1
--2-- Top Clip ea 1
--2-- Bottom Clip ea 1
--2-- Pivot ea 1
--2-- Spring ea 1
-1--- Rivet ea 2
-1--- Press Board ea 1

Item Master File
DESCRIPTION INVENTORY POLICY
Item Pressboard Lead time 1

Item no. 7341 Annual demand 5000
Item type Purch Holding cost 1
Product/sales class Comp Ordering/setup cost 50
Value class B Safety stock 0
Buyer/planner RSR Reorder point 39
Vendor/drawing 07142 EOQ 316
Phantom code N Minimum order qty 100
Unit price/cost 1.25 Maximum order qty 500
Pegging Y Multiple order qty 1
LLC 1 Policy code 3

Item Master File (cont.)
PHYSICAL INVENTORY USAGE/SALES
On hand 150 YTD usage/sales 1100
Location W142 MTD usage/sales 75
On order 100 YTD receipts 1200
Allocated 75 MTD receipts 0
Cycle 3 Last receipt 8/25
Last count 9/5 Last issue 10/5
Difference -2
CODES
Cost acct. 00754
Routing 00326
Engr 07142

MRP Processes
 Exploding the bill  Netting
of material  process of subtracting
on-hand quantities and
 Netting out scheduled receipts
inventory from gross
requirements to
 Lot sizing produce net
 Time-phasing requirements
requirements  Lot sizing
 determining the
quantities in which
items are usually made
or purchased

MRP Matrix

School Mate offers a number of standard products to encourage writing
outside of the classroom,
including clipboards, lapdesks, lapboards, and pencil boxes. Rising costs
and inventory
levels have prompted the company to install a computerized planning
and control system
called MRP. The MPS and bill of material modules are up and running.
Sample output
follows. Before going live with the MRP module, School Mate has asked
for a manual
demonstration. Since manual calculations can be quite tedious, you have
decided to prepare
MRP matrices for only three items—the clipboard and lapdesk, and a
common component,
pressboard. The master production schedule, abbreviated product
structure diagrams, and
Copyright 2009 John Wiley & Sons,
inventory Inc.
information are given below. 15-16
MRP: Example
1 2 3 4 5
Clipboard 85 95 120 100 100
Lapdesk 0 60 0 60 0
Item Master File

CLIPBOARD LAPDESK PRESSBOARD
On hand 25 20 150
On order 175 (Period 1) 0 0
(sch receipt)
LLC 0 0 1
Lot size L4L Mult 50 Min 100
Lead time 1 1 1
MRP: Example (cont.)
Product Structure Record
Clipboard Level 0
Pressboard Clip Ass’y Rivets

(1) (1) (2) Level 1
Lapdesk Level 0
Pressboard Trim Beanbag Glue

(2) (3’) (1) (4 oz) Level 1

ITEM: CLIPBOARD LLC: 0 PERIOD

LOT SIZE: L4L LT: 1 1 2 3 4 5
Gross Requirements 85 95 120 100 100

Scheduled Receipts 175
Projected on Hand 25
Net Requirements
Planned Order Receipts
Planned Order Releases


LOT SIZE: L4L LT: 1 1 2 3 4 5

Projected on Hand 25 115
Net Requirements 0
(25 + 175) = 200 units available

(200 - 85) = 115 on hand at the end of Period 1


LOT SIZE: L4L LT: 1 1 2 3 4 5

Projected on Hand 25 115 20
Net Requirements 0 0
115 units available

(115 - 85) = 20 on hand at the end of Period 2


LOT SIZE: L4L LT: 1 1 2 3 4 5

Projected on Hand 25 115 20 0
Net Requirements 0 0 100
Planned Order Receipts 100
Planned Order Releases 100
20 units available
(20 - 120) = -100 — 100 additional Clipboards are required
Order must be placed in Period 2 to be received in Period 3


LOT SIZE: L4L LT: 1 1 2 3 4 5

Projected on Hand 25 115 20 0 0 0
Net Requirements 0 0 100 100 100
Planned Order Receipts 100 100 100
Planned Order Releases 100 100 100
Following the same logic Gross Requirements in Periods 4

and 5 develop Net Requirements, Planned Order Receipts, and
ITEM: LAPDESK LLC: 0 PERIOD

LOT SIZE: MULT 50 LT: 1 1 2 3 4 5
Scheduled Receipts
Net Requirements


LOT SIZE: MULT 50 LT: 1 1 2 3 4 5
Scheduled Receipts
Planned Order Receipts 50 50
Planned Order Releases 50 50
Following the same logic, the Lapdesk MRP matrix is

completed as shown

LOT SIZE: L4L LT: 1 1 2 3 4 5
LOT SIZE: MULT 50 LT: 1 1 2 3 4 5
ITEM: PRESSBOARD LLC: 0 PERIOD
LOT SIZE: MIN 100 LT: 1 1 2 3 4 5
Gross Requirements
Scheduled Receipts
Net Requirements

LOT SIZE: L4L LT: 1 1 2 3 4 5
ITEM: LAPDESK LLC: 0 x1 PERIOD x1 x1
LOT SIZE: MULT 50 LT: 1 1 2 3 4 5
ITEM: PRESSBOARD LLC: 0 x2 x2 PERIOD
LOT SIZE: MIN 100 LT: 1 1 2 3 4 5
Scheduled Receipts
Net Requirements

LOT SIZE: L4L LT: 1 1 2 3 4 5
LOT SIZE: MULT 50 LT: 1 1 2 3 4 5
ITEM: PRESSBOARD LLC: 0 PERIOD
LOT SIZE: MIN 100 LT: 1 1 2 3 4 5
Scheduled Receipts
Planned Order Receipts 100 150 100

Planned Order Report

PERIOD
ITEM 1 2 3 4 5
Clipboard 100 100 100
Lapdesk 50 50
Pressboard 100 150 100

Capacity Requirements
Planning (CRP)
 Creates a load profile

 Identifies under-loads and over-
loads
 Inputs
 Planned order releases
 Routing file
 Open orders file

CRP
MRP planned
order
releases
Capacity Open
Routing
requirements orders
file
planning file
Load profile for

each process

Calculating Capacity
 Maximum capability to produce

 Rated Capacity
 Theoretical output that could be attained if a
process were operating at full speed without
interruption, exceptions, or downtime
 Effective Capacity
 Takes into account the efficiency with which a
particular product or customer can be processed
and the utilization of the scheduled hours or work
Effective Daily Capacity = (no. of machines or workers) x

(hours per shift) x (no. of shifts) x (utilization) x ( efficiency)

Calculating Capacity (cont.)
 Utilization
 Percent of available time spent working
 Efficiency
 How well a machine or worker performs
compared to a standard output level
 Load
 Standard hours of work assigned to a facility
 Load Percent
 Ratio of load to capacity
load
Load Percent = x 100%
capacity

 Copy Courier (CC) is a fledgling copy center in downtown Richmond run by
two college students.
 Currently, the equipment consists of two high-speed copiers that can be
operated by one
 operator. If the students work alone, it is conceivable that two shifts per
day can be staffed. The
 students each work 8 hours a day, 5 days a week. They do not take breaks
during the day, but
 they do allow themselves 30 minutes for lunch or dinner. In addition, they
service the machines
 for about 30 minutes at the beginning of each shift. The time required to set
up for each order
 varies by the type of paper, use of color, number of copies, and so on.
Estimates of setup time
 are kept with each order. Since the machines are new, their efficiency is
estimated at 90%.

 Due to extensive advertising and new customer incentives, orders
have been pouring in.
 The students need help determining the capacity of their
operation and the current load on
 their facility. Use the following information to calculate the normal
daily capacity of Copy
 Courier and to project next Monday’s load and load percent.


ch15 MRP

Uploaded by

Copyright:

Available Formats

ch15 MRP

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

ch15 MRP

Uploaded by

Copyright:

Available Formats

Chapter 15

Copyright 2009 John Wiley & Sons, Inc. 15-2

Copyright 2009 John Wiley & Sons, Inc. 15-3

100 tables 100 x 4 = 400 table legs

Copyright 2009 John Wiley & Sons, Inc. 15-4

Work Purchase Rescheduling

Copyright 2009 John Wiley & Sons, Inc. 15-5

Copyright 2009 John Wiley & Sons, Inc. 15-6

 Drives MRP process with a schedule of

Copyright 2009 John Wiley & Sons, Inc. 15-7

Copyright 2009 John Wiley & Sons, Inc. 15-8

Top clip (1) Bottom clip (1)

Pivot (1) Spring (1)

Copyright 2009 John Wiley & Sons, Inc. 15-9

Pressboard Clip Ass’y Rivets

Top Clip Bottom Clip Pivot Spring

Copyright 2009 John Wiley & Sons, Inc. 15-10

LEVEL ITEM UNIT OF MEASURE QUANTITY

Copyright 2009 John Wiley & Sons, Inc. 15-11

Item Pressboard Lead time 1

Copyright 2009 John Wiley & Sons, Inc. 15-12

Copyright 2009 John Wiley & Sons, Inc. 15-13

Copyright 2009 John Wiley & Sons, Inc. 15-14

Copyright 2009 John Wiley & Sons, Inc. 15-15

Item Master File

Pressboard Clip Ass’y Rivets

Pressboard Trim Beanbag Glue

Copyright 2009 John Wiley & Sons, Inc. 15-18

ITEM: CLIPBOARD LLC: 0 PERIOD

Gross Requirements 85 95 120 100 100

Copyright 2009 John Wiley & Sons, Inc. 15-20

ITEM: CLIPBOARD LLC: 0 PERIOD

Gross Requirements 85 95 120 100 100

(25 + 175) = 200 units available

Copyright 2009 John Wiley & Sons, Inc. 15-21

ITEM: CLIPBOARD LLC: 0 PERIOD

Gross Requirements 85 95 120 100 100

115 units available

Copyright 2009 John Wiley & Sons, Inc. 15-22

ITEM: CLIPBOARD LLC: 0 PERIOD

Gross Requirements 85 95 120 100 100

Copyright 2009 John Wiley & Sons, Inc. 15-23

ITEM: CLIPBOARD LLC: 0 PERIOD

Gross Requirements 85 95 120 100 100

Following the same logic Gross Requirements in Periods 4

ITEM: LAPDESK LLC: 0 PERIOD

Copyright 2009 John Wiley & Sons, Inc. 15-25

ITEM: LAPDESK LLC: 0 PERIOD

Following the same logic, the Lapdesk MRP matrix is

Copyright 2009 John Wiley & Sons, Inc. 15-26

Copyright 2009 John Wiley & Sons, Inc. 15-27

Copyright 2009 John Wiley & Sons, Inc. 15-28

Copyright 2009 John Wiley & Sons, Inc. 15-29

Planned Order Report

Copyright 2009 John Wiley & Sons, Inc. 15-30

 Creates a load profile

Copyright 2009 John Wiley & Sons, Inc. 15-31

Load profile for

Copyright 2009 John Wiley & Sons, Inc. 15-32

 Maximum capability to produce