Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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 80

Explanation / 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

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote