ore: 0 of 6 pts roblem 16.16 he partially completed inventory record for the dri
ID: 423608 • Letter: O
Question
ore: 0 of 6 pts roblem 16.16 he partially completed inventory record for the driveshaft subassembly in the table below shows gross requirements, scheduled receipts, lead Sme, and current on-hand inventory ?Complete the last three rows ofthe record for an FOQ of 50 units. (Enter yourosponses as mogen Aresponse of O'segment to begndapa? 20f 340 complete) ? HW Score: 09%, 0 of 24p Question Help Lot Size: FOO 50 units Lead Time: 3 weeks Item: Driveshaft subassembly Week Gross 30 30 20 25 30 30 40 40 Scheduled rece pts Projected on-hand inventory Planned receipts 75Explanation / Answer
Formulas:
Net requirement = GR of week – projected on-hand of previous week – Scheduled Receipts of week
Projected on-hand (POH) = Projected on-hand of previous week + SR of week – GR of week + Planned order receipt (PORc) of week
Planned order receipt = if the project-on-hand is negative, place an order of 50 units.
In week 4, the POH = 10 + 0 – 25 = -15, thus there is requirement of 15 units in week 4, so place the order of 50 units. But since the order size is more than requirement, the inventory =-on-hand will be 50 + 10 – 25 = 35
-1
1
2
3
4
5
6
7
Gross Req.
30
30
20
25
30
30
40
Scheduled receipts
75
0
0
0
0
0
0
Projected-on-hand inventory
(BI= 15
15
75+15-30
= 60
60-30
= 30
30-10
= 10
50+10-25
= 35
35-5
= 5
50+5-30
= 25
50+25-40
= 35
Net Requirement
0
0
0
25-10
= 15
0
30-5
= 25
40-25
= 15
Planned order Receipts
0
0
0
50
0
50
50
-1
1
2
3
4
5
6
7
Gross Req.
30
30
20
25
30
30
40
Scheduled receipts
75
0
0
0
0
0
0
Projected-on-hand inventory
(BI= 15
15
75+15-30
= 60
60-30
= 30
30-10
= 10
50+10-25
= 35
35-5
= 5
50+5-30
= 25
50+25-40
= 35
Net Requirement
0
0
0
25-10
= 15
0
30-5
= 25
40-25
= 15
Planned order Receipts
0
0
0
50
0
50
50
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.