CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G ( M RP) AND E RP 231
14.26
periods)
1
2
3
4
5
6
7
8
1
—
—
—
0
640
640
640
640
640
128
Lot for
Lot
1
—
—
—
1
640
640
128
640
640
128
640
640
128
128
1
—
—
—
1
16
16
16
1
—
—
—
1
8
8
100
100
100
100
12
4
100
1
—
—
—
1
640
640
128
640
640
128
640
640
128
640
128
128
Lot for
Lot
1
—
—
—
2
1,280
1,280
256
256
1,280
1,280
256
256
1,280
1,280
256
256
1,280
256
256
Lead
Copyright ©2014 Pearson Education, Inc.
232 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
Planned order release
1,280
256
1
—
—
—
2
Gross requirement
2,560
2,560
512
512
Scheduled receipt
Projected on hand
Net requirement
2,560
2,560
512
512
Planned order release
2,560
512
Lot for
Lot
1
—
—
—
3
Brass
Caps
Gross requirement
2,560
512
Scheduled receipt
Projected on hand
368
856
856
856
Net requirement
2,120
144
Planned order receipt
3,000
Planned order release
Required Date
A
Order Release
10
Planned order release
1,280
256
1
—
—
—
2
Gross requirement
2,560
2,560
512
512
Scheduled receipt
Projected on hand
Net requirement
2,560
2,560
512
512
Planned order release
2,560
512
Lot for
Lot
1
—
—
—
3
Brass
Caps
Gross requirement
2,560
512
Scheduled receipt
Projected on hand
368
856
856
856
Net requirement
2,120
144
Planned order receipt
3,000
Planned order release
Required Date
A
Order Release
10
14.28 (a)
(b)
Lot for
Lot
1
—
—
—
2
Long
Brace
Gross requirement
1,280
1,280
256
256
Scheduled receipt
Projected on hand
Net requirement
1,280
1,280
256
256
Planned order receipt
1,280
1,280
256
256
Required Date
30
D
Order Release
30
Required Date
20
F
Order Release
20
Copyright ©2014 Pearson Education, Inc.
14.30 (a)
P.O. receipt
30
Gross requirement
On hand 10
Net
P.O. receipt
B
1
2
3
4
5
6
7
Gross requirement
On hand 30
Net
P.O. receipt
P.O. receipt
30
Gross requirement
On hand 10
Net
P.O. receipt
B
1
2
3
4
5
6
7
Gross requirement
On hand 30
Net
P.O. receipt
14.30 (c)
Stepper
1
2
3
4
5
6
7
8
Gross requirement
50
On hand 20
20
Net
30
Gross requirement
Scheduled receipt
On hand 2
Net requirement
Planned order receipt
Gross requirement
Scheduled receipt
On hand 4
4
Net requirement
Gross requirement
Scheduled receipt
On hand
Net requirement
Planned order receipt
Gross requirement
Scheduled receipt
On hand 2
Net requirement
Planned order receipt
Gross requirement
Scheduled receipt
On hand 4
4
Net requirement
Gross requirement
Scheduled receipt
On hand
Net requirement
Planned order receipt
234 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
Net
160
40
P.O. receipt
160
40
Now
2
3
6
Gr req
0
0
Beg inv
0
0
–5
Ord rcpt
105
105
105
Gr req
Beg inv
End inv
Ord rcpt
Net
160
40
P.O. receipt
160
40
Now
2
3
6
Gr req
0
0
Beg inv
0
0
–5
Ord rcpt
105
105
105
Gr req
Beg inv
End inv
Ord rcpt
1
2
3
4
5
6
7
8
9
1
2
3
4
5
6
7
8
9
Gr req
35
10
40
Beg inv
0
10
0
End inv
85
0
60
Ord rcpt
120
100
Combined
Net Req.
Hold
1
0 = 0
+ 0.00
1, 2
1, 2, 3
1, 2, 3, 4
1, 2, 3, 4, 5*
Gr req
35
10
40
Beg inv
0
10
0
End inv
85
0
60
Ord rcpt
120
100
Combined
Net Req.
Hold
1
0 = 0
+ 0.00
1, 2
1, 2, 3
1, 2, 3, 4
1, 2, 3, 4, 5*
Theoretical total cost:
. . Order cost holding cost = 2
DS QH
TC Q
= + +
F
1
2
3
4
5
6
7
8
Gross requirement
180
40
On hand 20
20
0
Copyright ©2014 Pearson Education, Inc.
236 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
On hand
5
5
2
Net req.
7
20
10
3
Ord rec.
7
20
10
3
Item F
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
On hand
5
5
Net req.
7
10
5
Ord rec.
7
10
5
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Total req.
5
10
5
On hand
1
1
1
1
Net req.
4
10
5
Ord rec.
4
10
5
Total req.
10
5
On hand
10
Net req.
10
5
Ord rec.
10
5
On hand
5
5
2
Net req.
7
20
10
3
Ord rec.
7
20
10
3
Item F
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
On hand
5
5
Net req.
7
10
5
Ord rec.
7
10
5
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Total req.
5
10
5
On hand
1
1
1
1
Net req.
4
10
5
Ord rec.
4
10
5
Total req.
10
5
On hand
10
Net req.
10
5
Ord rec.
10
5
Item E
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Total req.
3
9
20
10
3
238 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
2. Cost per portion for Cheeto Crusted Mac & Cheese
Mac & Cheese Base
44 0.80
35.20
$ 1,267.20
Milk
4 0.03
0.12
$ 4.32
Elbow Macaroni
20 0.09
10 0.17
32 0.80
Milk
4 0.03
Mac & Cheese Base
44 0.80
35.20
$ 1,267.20
Milk
4 0.03
0.12
$ 4.32
Elbow Macaroni
20 0.09
10 0.17
32 0.80
Milk
4 0.03
Unit
Cost
Cost of Mix for
6 Portions
Cost for Ingredients for
36 Mixes (216 Portions)
Elbow Macaroni
20 0.09
1.80
$ 64.80
Shredded Cheddar Cheese
10 0.16
1.60
$ 57.60
232 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
14.28 (a)
(b)
Lot for
Lot
1
—
—
—
2
Long
Brace
Gross requirement
1,280
1,280
256
256
Scheduled receipt
Projected on hand
Net requirement
1,280
1,280
256
256
Planned order receipt
1,280
1,280
256
256
Required Date
30
D
Order Release
30
Required Date
20
F
Order Release
20
Copyright ©2014 Pearson Education, Inc.
14.30 (a)
14.30 (c)
Stepper
1
2
3
4
5
6
7
8
Gross requirement
50
On hand 20
20
Net
30
234 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
Theoretical total cost:
. . Order cost holding cost = 2
DS QH
TC Q
= + +
F
1
2
3
4
5
6
7
8
Gross requirement
180
40
On hand 20
20
0
Copyright ©2014 Pearson Education, Inc.
236 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
Item E
Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Total req.
3
9
20
10
3
238 CHAPTER 14 MA T E R I A L RE Q U I R E M E N T S PL A N N I N G (M RP) AND E RP
2. Cost per portion for Cheeto Crusted Mac & Cheese
Unit
Cost
Cost of Mix for
6 Portions
Cost for Ingredients for
36 Mixes (216 Portions)
Elbow Macaroni
20 0.09
1.80
$ 64.80
Shredded Cheddar Cheese
10 0.16
1.60
$ 57.60