a. Given the following information on part Y, Part Y Gross Requirements Schedule
ID: 386741 • Letter: A
Question
a. Given the following information on part Y, Part Y Gross Requirements Scheduled Receipts Projected Balance Planned Order Releases Week 1 80 0 Week 2 50 0 Week 3 90 0 Week 4 0 0 Week 5 90 250 Lot Size (Q) = 20, Lead Time = 2 weeks, and Safety Stock = 10 The projected on-hand balance for Week 5 is b. Given the following information on part Q, Week 2 1,500 0 Week 3 Part Q Gross Requirements Scheduled Receipts Projected Balance Planned Order Releases Week 4 500 0 Week 1 Week 5 800 1,900 990 3,000 Lot Size (Q) = 200, Lead Time = 1 weeks, and Safety Stock 100 The planned order release for Week 2 isExplanation / Answer
Answer to question # a :
Refer below table :
Part X , Lead time = 2 weeks, Lot size = 20, Safety stock = 10
Week 1
Week 2
Week 3
Week 4
Week 5
Gross requirement
80
50
90
0
90
Scheduled receipts
0
0
0
0
0
Projected balance:250
160
110
20
20
10
Net requirement
0
0
0
0
70
Planned order receipt
0
0
0
0
80
Planned order release
0
0
80
0
0
Following may be noted :
a)Projected available balance for week 1
= Projected available balance for week 0 ( i.e. 250 ) – Gross requirement for week 1 – Safety stock of 10
= 250 – 80 – 10
= 160
b)For subsequent weeks ( week 2 to 4 )
Projected available balance for week t = Gross requirement for week t – Projected available balance for week t-1
c)Since requirement for week 5 = 90 and Projected available balance for week 4= 20 , net requirement for week 5 should be 70
However since lot size can be in multiples of 20 ,Planned order receipt for week 5 = 80 ( which is multiple of 20 )
D)Since Lead time = 2 weeks, There will be 2 weeks lag between “Planned order receipt and “Planned order release”
Therefore, Planned order release corresponding to Planned order receipt of 80 for week 5 would be a quantity of “80” during Week 3
Therefore ,
Planned order release for week 3 = 80
Projected available balance for week 5 = Planned order receipt for week 5 – Net requirement for week 5 = 80 – 70 = 10
Projected available balance for week 5 = 10
Answer to question # b:
Refer below table :
Part X , Lead time = 1 week , Lot size = 200, Safety stock = 100
Week 1
Week 2
Week 3
Week 4
Week 5
Gross requirement
800
1500
1900
500
990
Scheduled receipts
0
0
0
0
0
Projected balance:3000
2100
600
100
0
10
Net requirement
0
0
1300
400
990
Planned order receipt
0
0
1400
400
1000
Planned order release
0
1400
400
1000
0
Following may be noted :
a)Projected available balance for week 1
= Projected available balance for week 0 ( i.e. 3000 ) – Gross requirement for week 1 – Safety stock of 100
= 3000 – 800 - 100
= 2100
b)For subsequent weeks ( week 2 to 4 )
Projected available balance for week t = Gross requirement for week t – Projected available balance for week t-1
c)Since requirement for week 5 = 990 and Projected available balance for week 4= 0 , net requirement for week 5 should be = 990
However since lot size can be in multiples of 200 ,Planned order receipt for week 5 =1000 ( which is multiple of 200 )
D)Since Lead time = 1 week, There will be 1 week lag between “Planned order receipt and “Planned order release”
Therefore, Planned order release corresponding to Planned order receipt of 1400 for week 3 would be a quantity of “1400 “ during week 2
Therefore ,
Planned order release for week 2 = 1400
Projected available balance for week 5 = Planned order receipt for week 5 – Net requirement for week 5 = 1000 – 990
Planned order release for week 2 = 1400
Part X , Lead time = 2 weeks, Lot size = 20, Safety stock = 10
Week 1
Week 2
Week 3
Week 4
Week 5
Gross requirement
80
50
90
0
90
Scheduled receipts
0
0
0
0
0
Projected balance:250
160
110
20
20
10
Net requirement
0
0
0
0
70
Planned order receipt
0
0
0
0
80
Planned order release
0
0
80
0
0
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.