Assume that Product Z is made of two units of A and three units of B. Ais made o
ID: 361209 • Letter: A
Question
Assume that Product Z is made of two units of A and three units of B. Ais made of four units of C and four of D. Dis made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks: A, B, C, and D take one week each; and E takes three weeks. Fifty six units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.) b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.) | 10 Item z OH - 0 LT-2 SS = 0 Q=L4L Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item A OH = 0 LT=1 SS = 0 Q- L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item B OH - 0 LT-1 SS = 0 Q= L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item C OH = 0 LT=1 SS-0 Q-L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D OH-0 LT-1 SS = 0 Q= L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E OH = 0 LT=3 SS-0 Q- L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releasesExplanation / Answer
The MRP table for all components are presented below. Blank spaces should be considered as “Zero”
Item: Z On hand =0, SS = 0
Week
Lot size: Lot for Lot
Lead time: 2 week
1
2
3
4
5
6
7
8
9
10
Gross Requirement
56
Scheduled receipt
0
Projected available balance
0
Net requirement
56
Planned order receipt
56
Planned order release
56
Item: A, On hand=0, SS = 0
Week
Lot size: Lot for Lot
Lead time: 1 weeks
1
2
3
4
5
6
7
8
9
10
Gross Requirement
112
Scheduled receipt
0
Projected available balance
0
Net requirement
112
Planned order receipt
112
Planned order release
112
Item: B , SS = 0 On hand=0
Week
Lot size: Lot for Lot
Lead time: 1 weeks
1
2
3
4
5
6
7
8
9
10
Gross Requirement
168
Scheduled receipt
0
Projected available balance
0
Net requirement
168
Planned order receipt
168
Planned order release
168
Item: C, SS = 0 , On hand = 0
Week
Lot size: L4L
Lead time: 1 week
1
2
3
4
5
6
7
8
9
10
Gross Requirement
448
Scheduled receipt
0
Projected available balance
0
Net requirement
448
Planned order receipt
448
Planned order release
448
Item: D, OH = , SS = 0
Week
Lot size:
Lot for Lot
Lead time: 1 weeks
1
2
3
4
5
6
7
8
9
10
Gross Requirement
448
Scheduled receipt
0
Projected available balance
0
Net requirement
448
Planned order receipt
448
Planned order release
448
Item: E
Week
Lot size: L4L
Lead time: 3 weeks
1
2
3
4
5
6
7
8
9
10
Gross Requirement
896
Scheduled receipt
0
Projected available balance
0
Net requirement
896
Planned order receipt
Planned order release
896
Item: Z On hand =0, SS = 0
Week
Lot size: Lot for Lot
Lead time: 2 week
1
2
3
4
5
6
7
8
9
10
Gross Requirement
56
Scheduled receipt
0
Projected available balance
0
Net requirement
56
Planned order receipt
56
Planned order release
56
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.