The partially completed inventory record for the driveshaft subassembly in the t
ID: 424168 • 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 60 units. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Driveshaft subassembly Lot Size: FOQ 60 units Lead Time: 3 weeks Week 3 4 5 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts 40 30 10 25 35 35 80Explanation / Answer
Please find below the filled up table as required :
Item : Driveshaft assembly
FOQ = 60 units
Lead time = 3 weeks
1
2
3
4
5
6
7
8
Gross requirement
40
30
10
25
35
35
45
45
Scheduled receipts
80
0
0
0
0
0
0
0
Projected on hand inventory : 15
55
25
15
50
15
40
55
10
Planned receipts
0
0
0
60
0
60
60
0
Following may be noted :
Projected on hand inventory for week 1 = Projected on hand inventory for week 0 + Scheduled receipt for week 1 – Gross requirement for week 1 = 15 + 80 – 40 = 55
Projected on hand inventory for week t ( t > 1 ) = Projected on hand inventory for week t-1 – Gross requirement for week t ( provided Projected on hand inventory for week t-1 > Gross requirement for week t )
Projected on hand inventory for week t ( t > 1 ) = Projected on hand inventory for week t-1 + Planned receipt for week t ( which will always be 60 since FOQ = 60 ) – Gross requirement for week t ( provided Projected on hand inventory for week t-1 < Gross requirement for week t )
Item : Driveshaft assembly
FOQ = 60 units
Lead time = 3 weeks
1
2
3
4
5
6
7
8
Gross requirement
40
30
10
25
35
35
45
45
Scheduled receipts
80
0
0
0
0
0
0
0
Projected on hand inventory : 15
55
25
15
50
15
40
55
10
Planned receipts
0
0
0
60
0
60
60
0
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.