Chapter 12 – MRP and ERP
12-21
11. a.
Master
Schedule
Period
Beg.
Inv.
1
2
3
4
5
6
7
Quantity
120
E LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
120
Scheduled receipts
0
I(2) LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
240
Scheduled receipts
40
Projected on hand
Net requirements
200
Planned order receipts
200
Planned order releases
200
N(4) LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
800
Scheduled receipts
Projected on hand
100
100
100
Net requirements
700
Planned order receipts
700
Planned order releases
700
Projected on hand
0
Net requirements
120
Planned order receipts
120
Planned order releases
120
Chapter 12 – MRP and ERP
11. a. (continued)
V LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
200
Scheduled receipts
10
Projected on hand
Net requirements
190
Planned order receipts
Planned order releases
190
b.
Master
Schedule for E
Period
Beg.
Inv.
1
2
3
4
5
6
7
8
Quantity
100
55
Week
E LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
100
55
Scheduled receipts
Projected on hand
Net requirements
100
55
Planned order receipt
100
55
Planned order release
55
Chapter 12 – MRP and ERP
11. b. (continued)
I(2) LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
200
110
Scheduled receipts
40
Projected on hand
40
40
Net requirements
160
110
Planned order receipts
Planned order releases
160
110
N(4) LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
640
440
Scheduled receipts
Projected on hand
Net requirements
540
180
Planned order receipts
800
800
Planned order releases
V LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
160
100
Scheduled receipts
10
Projected on hand
50
50
Net requirements
150
50
Planned order receipts
200
200
Planned order releases
Chapter 12 – MRP and ERP
12-24
11. c. Case 1.
One week elapsed
Master
Schedule for
Week
Beg.
Inv.
1
2
3
4
6
7
Quantity
100
50
Week
E LT = 1 wk.
Beg.
Inv.
1
2
3
4
6
7
Gross requirements
100
50
Scheduled receipts
Week
I(2) LT = 1 wk.
Beg.
Inv.
1
2
3
4
6
7
Gross requirements
240
200
Scheduled receipts
40
0
Projected on hand
0
0
Net requirements
160
200
Planned order receipt
160
200
Planned order release
160
100
200
Week
N(4) LT = 2 wks.
Beg.
Inv.
1
2
3
4
6
7
Gross requirements
640
400
800
Scheduled receipts
0
Projected on hand
100
260
660
660
660
Net requirements
100
540
140
1400
Planned order receipt
800
800
800
Planned order release
800
800
Week
V LT = 2 wks.
Beg.
Inv.
1
2
3
4
6
7
Gross requirements
160
100
200
Scheduled receipts
10
Projected on hand
50
150
150
Projected on hand
0
0
0
Planned order receipt
100
50
100
Planned order release
100
100
Chapter 12 – MRP and ERP
12-25
11. c. Case 2.
Three weeks elapsed
Master Schedule
for
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
Quantity
100
50
100
Week
E LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
8
Gross requirements
100
50
100
Scheduled receipts
Week
I(2) LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
200
100
200
Scheduled receipts
0
Projected on hand
40
0
0
0
0
0
0
Net requirements
160
100
200
Planned order receipt
160
100
200
Planned order release
100
200
Week
N(4) LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
400
800
Scheduled receipts
0
Projected on hand
400
400
400
400
400
400
400
Net requirements
400
400
Planned order receipt
800
800
Planned order release
800
Week
V LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
100
200
Scheduled receipts
0
Projected on hand
110
110
110
110
110
110
110
Net requirements
90
90
Planned order receipt
200
200
Projected on hand
0
0
0
0
0
Planned order receipt
100
100
Planned order release
100
100
Chapter 12 – MRP and ERP
12-26
12. a.
Supports
Cover
Cart
Frame
Controls
Wheels (4)
Cover
Base
Top
Golf
Cart
Top
b.
Motor
Chapter 12 – MRP and ERP
12-27
12. c.
Master
Schedule for
golf carts
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
Quantity
200
Item: Gold Cart LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
200
Item: Top LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
200
Scheduled receipts
Projected on hand
Net requirements
160
Planned order receipts
160
Planned order releases
160
Item: Supports (4) LT = 1
wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
640
Scheduled receipts
Projected on hand 0
200
200
200
200
200
200
Net requirements
440
Planned order receipts
440
Planned order releases
440
Scheduled receipts
Projected on hand
Planned order receipts
200
Planned order releases
200
Chapter 12 – MRP and ERP
12-28
12. c. (continued)
Item: Cover LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
160
Scheduled receipts
Item: Base LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
200
Scheduled receipts
Projected on hand
Net requirements
180
Planned order receipts
Planned order releases
180
Item: Motor LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
180
Scheduled receipts
Projected on hand
300
300
300
300
300
300
120
Net requirements
(120)
Planned order receipts
Planned order releases
Projected on hand
Net requirements
160
Planned order receipts
Planned order releases
160
Chapter 12 – MRP and ERP
12. c. (Continued)
Item: Body LT = 3 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
180
Scheduled receipts
Projected on hand
Net requirements
130
Planned order receipts
Item: Seats LT = 2 wks.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
360
Scheduled receipts
Projected on hand
120
120
120
120
120
120
120
Net requirements
240
Planned order receipts
Planned order releases
240
Item: Frame LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
Gross requirements
130
Scheduled receipts
Projected on hand
Net requirements
Planned order receipts
Planned order releases
Chapter 12 – MRP and ERP
12-30
12. c. (Continued)
Item: Controls LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
130
Scheduled receipts
Item: Wheel Assemblies LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
520
Scheduled receipts
Projected on hand
Net requirements
280
Planned order receipts
280
Planned order releases
13. a.
Master
Schedule for
golf carts
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Quantity
100
100
100
b.
Item: Golf cart LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Gross requirements
100
100
100
Scheduled receipts
Projected on hand
Net requirements
100
100
100
Planned order receipts
100
100
100
Planned order releases
100
100
100
Projected on hand
Net requirements
130
Planned order receipts
Chapter 12 – MRP and ERP
12-31
13. b. (continued)
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Quantity
100
100
100
Item: Tops LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Gross requirements
100
100
100
Scheduled receipts
Item: Base LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Gross requirements
100
100
100
Scheduled receipts
Projected on hand
Net requirements
100
100
Planned order receipts
100
100
Planned order releases
100
100
c. Master schedule for golf carts
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Quantity
100
100
100
Item: Golf Cart LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Gross requirements
100
100
100
Scheduled receipts
Projected on hand
Net requirements
100
100
100
Planned order receipts
100
100
100
100
100
Projected on hand
Net requirements
100
100
Planned order receipts
100
100
Planned order releases
100
100
Chapter 12 – MRP and ERP
12-32
13. c. (continued)
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Quantity
100
100
100
Item: Bases LT = 1 wk.
Beg.
Inv.
1
2
3
4
5
6
7
8
9
Gross requirements
100
100
100
Scheduled receipts
14. a.
b.
Master
Schedule for:
Week
Beg.
Inv.
1
2
3
4
5
6
7
8
Quantity
600
Week
Scissors (LT = 1 week)
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
600
Scheduled receipts
On hand
Planned order receipts
600
Planned order releases
Scissors
Bottom Blade Assembly
Top Blade Assembly
Screw
Projected on hand
100
100
Net requirements
100
Planned order receipts
Planned order releases
Chapter 12 – MRP and ERP
12-33
Week
Bottom Blade Assembly
(LT = 1 week)
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
600
Scheduled receipts
Week
Top Blade Assembly
(LT = 1 week)
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
600
Scheduled receipts
On hand
40
40
40
40
40
40
Net requirements
560
Planned order receipts
560
Planned order releases
Week
Screw (LT = 1 week)
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
600
Scheduled receipts
On hand
Net requirements
600
Planned order receipts
600
Planned order releases
600
Week
Straight Blade
(LT = 1 week)
Beg.
Inv.
1
2
3
4
5
6
7
8
Gross requirements
600
Scheduled receipts
On hand
200
200
200
200
200
Net requirements
400
Planned order releases
400
On hand
Net requirements
600
Planned order receipts
600
Planned order releases