Gross Requirements are mentioned as follows for the periods 1 to 8, all the peri
ID: 373729 • Letter: G
Question
Gross Requirements are mentioned as follows for the periods 1 to 8, all the periods have gross requirements.
The given table has figures for inventory on hand (2000), scheduled receipts for periods 1 & 2, lot size as 1200 and lead time of 1 period, whereas for Y it is mentioned that lead time is zero means orders are released and received in the same period, on hand = safety = allocated=0, and lot size is 1500.
Therefore the revised table is as follows:
Similarly table provide answers to other questions
Period 0 1 2 3 4 5 6 7 8 Gross Requirements--G 700 500 800 700 900 1100 500 600 Scheduled Receipts--S 0 0 0 0 0 0 0 0 Projected on Hand (Beginning)--PB 0 0 800 300 1000 300 900 1300 800 PB = PE of the previous period+S Projected on Hand (Ending)--PE 800 300 1000 300 900 1300 800 200 PE = R-N if R>N or PB-G Net Requirements--N 700 500 600 200 N = G-PB-S or 0 if PB >G Planned order Receipt--R 1500 1500 1500 1500 R = Lot size as per O-order release Planned order Releases--O 1500 1500 1500 1500 O=Lot size in case N > PB otherwise 0Explanation / Answer
12.) Which of the following periods have gross requirements for Y? Check all that apply.
Period 1
Period 2
Period 3
Period 4
Period 5
Period 6
Period 7
Period 8
13.) Which of the following periods have planned order releases of Y? Check all that apply.
Period 1
Period 2
Period 3
Period 4
Period 5
Period 6
Period 7
Period 8
14.) What is the projected on-hand at the beginning of period 1 for Y?
15.) What is the projected on-hand at the end of period 8 for Y?
16.) What is the planned order release for Y for period 1? If there is no planned order release, enter a zero.
17.) What is the planned order release for Y for period 2? If there is no planned order release, enter a zero.
18.) What is the planned order release for Y for period 3? If there is no planned order release, enter a zero.
19.) What is the planned order release for Y for period 4? If there is no planned order release, enter a zero.
20.) What is the planned order release for Y for period 5? If there is no planned order release, enter a zero.
21.) What is the planned order release for Y for period 6? If there is no planned order release, enter a zero.
22.) What is the planned order release for Y for period 7? If there is no planned order release, enter a zero.
23.) What is the planned order release for Y for period 8? If there is no planned order release, enter a zero.
***Please show all steps including formulas on excel spreadsheet. Disregard letter X in table--That should be Y. ****
Use the following inventory information for the MRP problems that follow regarding Y: Lot Size: On Hand: Safety Stock: 0 Allocated: Lead Time: 1,500 0 0 0 0 4 Gross Requirements Scheduled Receipts Projected on Hand (Beginning) 2000 2500 2300 1800 1000 300 600 700200 Projected on Hand (Ending) Net Requirements Planned Order Receipts Planned Order Releases 700 500 800 700 900 1100 500 600 500 500 2300 1800 1000 300 600 600 1200 1200 700 500 1200 800 400 1200 0 1200 1200Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.