You make donuts where one donut needs 4 ounces of dough and 3 ounces of icing to
ID: 360278 • Letter: Y
Question
You make donuts where one donut needs 4 ounces of dough and 3 ounces of icing to complete
Calculate the Material Requirements Plan below.
The beginning inventory for each item has been given.
Hour
Beg. Inv.
1
2
3
4
5
6
7
8
Quantity
70
110
60
40
Donut
Lead Time = 1 hr
Lot Size of 60
Gross Requirements
Scheduled Receipts
Projected On-Hand
5
Net Requirements
Planned Order Receipts
Planned Order Releases
Dough
Lead Time = 1 hr
Lot Size of 165 ounces
Gross Requirements
Scheduled Receipts
Projected On-Hand
15
Net Requirements
Planned Order Receipts
Planned Order Releases
Icing
Lead Time = 1 hr
Lot-Size of 24 ounces
Gross Requirements
Scheduled Receipts
Projected On-Hand
65
Net Requirements
Planned Order Receipts
Planned Order Releases
Hour
Beg. Inv.
1
2
3
4
5
6
7
8
Quantity
70
110
60
40
Donut
Lead Time = 1 hr
Lot Size of 60
Gross Requirements
Scheduled Receipts
Projected On-Hand
5
Net Requirements
Planned Order Receipts
Planned Order Releases
Dough
Lead Time = 1 hr
Lot Size of 165 ounces
Gross Requirements
Scheduled Receipts
Projected On-Hand
15
Net Requirements
Planned Order Receipts
Planned Order Releases
Icing
Lead Time = 1 hr
Lot-Size of 24 ounces
Gross Requirements
Scheduled Receipts
Projected On-Hand
65
Net Requirements
Planned Order Receipts
Planned Order Releases
Explanation / Answer
The filled up table for MRP requirement of all three items are presented below . Please let me know should you have further query on same :
Item: Donut
Week
Lot size: 60
Lead time: 1 Hour
Beginning Inv
1
2
3
4
5
6
7
8
Gross Requirement
0
0
70
0
110
60
0
40
Scheduled receipt
0
0
0
0
0
0
0
0
Projected on hand
5
5
5
55
55
5
5
5
25
Net requirement
0
0
65
0
55
55
0
35
Planned order receipt
0
0
120
0
60
60
0
60
Planned order release
0
120
0
60
60
0
60
0
Item: Dough ( 1 Donut requires 4 ounces of Dough)
Week
Lot size: 165 ounce
Lead time:1 hour
Beginning Inventory
1
2
3
4
5
6
7
8
Gross Requirement
0
480
0
240
240
0
240
0
Scheduled receipt
0
0
0
0
0
0
0
0
Projected on hand
15
15
30
30
120
45
45
135
135
Net requirement
0
465
0
210
120
0
0
0
Planned order receipt
0
495
0
330
165
0
330
0
Planned order release
495
0
330
165
0
330
0
0
Item: Icing ( 1 Donut requires 3 ounces of Icing)
Week
Lot size: 24 ounce
Lead time: 1 hour
Beginning Inventory
1
2
3
4
5
6
7
8
Gross Requirement
0
360
0
180
180
0
180
Scheduled receipt
0
0
0
0
0
0
0
Projected on hand
65
65
17
17
5
17
17
5
Net requirement
0
295
0
163
175
0
163
Planned order receipt
0
312
0
168
192
0
168
Planned order release
312
168
192
168
Item: Donut
Week
Lot size: 60
Lead time: 1 Hour
Beginning Inv
1
2
3
4
5
6
7
8
Gross Requirement
0
0
70
0
110
60
0
40
Scheduled receipt
0
0
0
0
0
0
0
0
Projected on hand
5
5
5
55
55
5
5
5
25
Net requirement
0
0
65
0
55
55
0
35
Planned order receipt
0
0
120
0
60
60
0
60
Planned order release
0
120
0
60
60
0
60
0
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.