Question

Fill in the following question marks (?) to complete thr MRP Chart.

E l T able Chart Text Shape Media Comment Share Sheet3 Sheet4 Sheets W X Y Z AA AB AC AD AE AF AG Dibing Rule Lat for Lot 7 40 16 - t ei A Leadtine 2 weeks PD 1 2 3 4 5 6 163425 0 0 0 0 0 72 259 0 0 0 0 25 25 50 40 LO 25 25 50 40 25 25 50 40 16 12 Gross Requirements Scheduled Reciepts Projected on-hand Net Requirements Planned Order Receipts Planned Order Releases - - 16 16 : Problem listing Rule 10Q 180 EOQ = 180 (show calculations Ledena Level-2 PD 1 2 3 4 5 6 7 8 so50 100 0 2 4 ; 0 0 0 0 : : 130 2011030171541 o 70 2 0 1 800 1800 ?? 1800 1800 Gross Requirements Scheduled Reciepts Projected on-hand Net Requirements Planned Order Receipts Planned Order Releases 1. ee

Answer 1

Item A                 Period	1	2	3	4	5	6	7	8
Gross requirements	47	16	34	25	50	40	16	12
Scheduled receipts	0	0	0	0	0	0	0	0
Projected available balance 72	25	9	0	0	0	0	0	0
Net requirements	0	0	25	25	50	40	16	12
Planned order recepits	0	0	25	25	50	40	16	12
Planned order releases	25	25	50	40	16	12	0	0

Item B                 Period	1	2	3	4	5	6	7	8
Gross requirements	50	50	100	80	32	24	0	0
Scheduled receipts	0	0	0	0	0	0	0	0
Projected available balance 130	80	30	110	30	178	154	0	0
Net requirements	0	0	70	0	2	0	0	0
Planned order recepits	0	0	180	0	180	0	0	0
Planned order releases	0	180	0	180	0	0	0	0

Item C                 Period	1	2	3	4	5	6	7	8
Gross requirements	75	75	150	120	48	36	0	0
Scheduled receipts	0	0	0	0	0	0	0	0
Projected available balance 150	75	0		0	36	0	0	0
Net requirements	0	0	150	0	48	0	0	0
Planned order recepits	0	0	270	0	84	0	0	0
Planned order releases	270	0	84	0	0	0	0	0