Please help me with this problem, what equations do I use, and do I need to use a tree?
NOTE: none of the incorrect answers are '0' nor are they the 2x of the previous number. Thank you!
- Product A is an end item and is made from three units of B and four of C
- B is made of three units of D and one of E.
- C is made of two units of F and two of E.
- A has a lead time of one week.
- B, C, and E have lead times of two weeks
- D and F have lead times of three weeks.
If 125 units of A are required in Week 10, develop the MRP planning schedule, specifying when items are to be ordered and received. There are currently no units of inventory on hand.
Gross requirements 0 o o 0 0 9 o o 0 o o 0 1 000 9 0 o o o 0 o \"em: D Scheduled receipts 0 o 0 o o a 0 o 0 o o 9 o O 0 o o o 0 o (#130 Projected available balance 0 o 0 o 0 o 0 o 0 Q o 9 0 e 0 o o o 0 Q 53'; 0 Net requirements 0 o o o 0 9 o o 0 o 0 o 1 000 o 0 o o o 0 o 03 L4' Planned order receipts 0 Q o o 0 0 o o 0 o o o 1 000 o 0 o o o 0 a Planned order releases 0 9 0 O 0 0 1 000 0 1 000 9 1 000 a 0 0 0 o o O 0 0 Gross requirements 0 o o o 0 9 o o 0 o 0 0 2 000 0 2 000 o o o 0 0 Item: E Scheduled receipts 0 o o o 0 o o o 0 o o 0 0 o 0 o o o 0 o (#120 Projected available balance 0 o 0 o 0 o 0 o 0 o 0 0 0 o 0 o o o 0 o 55': 0 Net requirements 0 o 0 o 0 9 0 o 0 o o 9 2 000 o 0 o o o 0 o 03 ML Planned order receipts 0 o 0 Q 0 9 0 o 0 Q a 0 2 000 0 0 o o o 0 Q Planned order releases 0 o 0 a 0 a 0 o 0 Q 0 a 0 o 0 o 0 o D 0 Gross requirements 0 o 0 o 0 9 0 o 0 o o 0 3 000 o 0 o o o 0 0 Item: F Scheduled receipts 0 o 0 o 0 o 0 o 0 Q o 9 0 e 0 o o o 0 Q (#139 Projected available balance 0 o o o 0 9 o o 0 o o 0 0 o 0 o o o 0 0 ss': 0 Net requirements 0 9 0 O 0 0 0 O 0 o 0 Q 3000 9 0 o o O 0 o 0: L4'- Planned order receipts 0 o 0 o 0 o 0 o 0 o o 0 3000 o 0 o o o 0 0 Planned order releases 0 o 0 o 0 o 3 000 a 3 000 o O o 0 o 0 o 0 o 0 o Product A is an end item and is made from three units of B and four of C. B is made ofthree units ofD and one of E. C is made oftwo units of F and two of E. A has a lead time ofone week. B, C, and E have lead times oftwo weeks, and D and F have lead times ofthree weeks. b. lf125 units ofA are required in Week 10, develop the MRP planning schedule, specifying when items are to be ordered and received. There are currently no units ofinventory on hand. (Leave the cells blank, whenever zero (0) is required.) 0 Answer is complete but not entirely correct. Period: 4 5 ti 7 9 1o Gross requirements 0 o o o o o o o o o o 0 0 o o 0 o o 125 0 Item: A Scheduled receipts o o o o o o o 0 o o o o 0 o o o o o o a 22:10 Projected available balance 0 o o o 0 o o o 0 o 0 Q 0 o 0 Q o o o o 55': 0 Net requirements 00 00 0 0 00 09 09 00 00 1250 03 L4' Planned order receipts o 0 o 0 o 0 o 9 o o o o 0 o o o o o 125 9 Planned order releases 0 o o o o o o o o o o o 0 o o o 125 o o 0 Gross requirements 0 e 0 a 0 a 0 o D a 0 e 0 a 0 e 0 9 0 0 Item. B Scheduled receipts o 9 0 o 0 0 o a o o 0 Q 0 Q 0 Q o o o a 2:120 Projected available balance 0 o o o o o o o o o o o 0 o o o o o o o as: 0 Net requirements 00 00 0 9 00 no 09 0 a 09 09 00 Q: L4L Planned order receipts 0 9 o o 0 9 o o o 0 0 9 0 o 0 Q o 9 o a Planned order releases 0 a 0 o 0 a 0 a D o 0 e 0 e 0 a 0 o 0 0 Gross requirements 0 e o 0 0 9 o o o 0 0 9 0 a 0 9 500 0 o 0 "am. c Scheduled receipts 0 9 0 o o o o o o 0 0 9 0 9 0 9 o 0 o o 0H_10 Projected available balance 0 o 0 o o o o o o o 0 o 0 o 0 o o o 0 9 $320 Net requirements 0 o o o o o o o o 0 0 o o e 500 o o a 03 L4' Planned order receipts 0 o o o 0 o o o 0 o 0 0 0 a 0 9 500 o o 0 Planned order releases 0 o 0 o o o o o o 0 0 Q 500 0 0 Q o 0 o o