The partially completed inventory record for the driveshaft subassembly in the t
ID: 336255 • Letter: T
Question
The partially completed inventory record for the driveshaft subassembly in the table below shows gross? requirements, scheduled? receipts, lead? time, and current? on-hand inventory.
a. Complete the last three rows of the record for an FOQ of
50
units. ?(Enter your responses as integers. A response of? "0" is equivalent to being not? applicable.)
?Item: Driveshaft subassembly
FOQequals=50
Lead? Time: 3 weeks
Week
1
2
3
4
5
6
7
8
Gross
requirements
30
25
20
15
30
30
50
50
Scheduled
receipts
75
Projected? on-hand
inventory
10
Planned
receipts
b. Complete the last three rows of the record by using the L4L? lot-sizing rule.
c. Complete the last three rows of the record by using the POQ? lot-sizing rule, with
Pequals=4.
?Item: Driveshaft subassembly
Lot? Size:FOQequals=50
unitsLead? Time: 3 weeks
Week
1
2
3
4
5
6
7
8
Gross
requirements
30
25
20
15
30
30
50
50
Scheduled
receipts
75
Projected? on-hand
inventory
10
Planned
receipts
b. Complete the last three rows of the record by using the L4L? lot-sizing rule.
c. Complete the last three rows of the record by using the POQ? lot-sizing rule, with
Pequals=4.
Explanation / Answer
Please find below filled up MRP table for both L4L as well as POQ rule.
For L4L:
Projected on hand inventory for period t = Projected on hand inventory for period t-1 + Scheduled receipt for period t – Gross requirement for period t( Provided Projected on hand inventory for period t > = 0)
In case Projected on hand inventory for period t <0as per above calculation , in such case:
Planned order receipt for period t = Gross requirement for period t – Scheduled receipt for period t – Projected on hand inventory for period t-1
Lot sizing rule = L4L
Driveshaft subassembly
1
2
3
4
5
6
7
8
Gross requirement
30
25
20
15
30
30
50
50
Scheduled receipt
75
0
0
0
0
0
0
0
Projected on hand inventory: 10
55
30
10
0
0
0
0
0
Planned order receipt
0
0
0
5
30
30
50
50
For POQ ( period order quantity ) = 4 :
Calculation for Projected on hand inventory for period t = same as above In case Projected on hand inventory for period t <0as per above calculation , in such case:
Planned order receipt for period t = Sum of gross requirements for periods ( t, t+1 , t+2 , t+3 ) – Scheduled receipt for period t – Projected on hand inventory for period t-1
Lot sizing rule =POQ of 4
Driveshaft subassembly
2
3
4
5
6
7
8
Gross requirement
30
25
20
15
30
30
50
50
Scheduled receipt
75
0
0
0
0
0
0
0
Projected on hand inventory: 10
50
30
10
110
80
50
0
0
Planned order receipt
0
0
0
115
0
0
0
50
Driveshaft subassembly
1
2
3
4
5
6
7
8
Gross requirement
30
25
20
15
30
30
50
50
Scheduled receipt
75
0
0
0
0
0
0
0
Projected on hand inventory: 10
55
30
10
0
0
0
0
0
Planned order receipt
0
0
0
5
30
30
50
50
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.