Please solve the following & show work:

Question 1:

Please solve for the following across all 6 months:

Solve for gross requirements

Scheduled receipts

Projected on hand

Net requirements

Planned order receipts

Planed order releases

Question 2:

Please solve for the following across all 5 months:

Solve for gross requirements

Scheduled receipts

Projected on hand

Net requirements

Planned order receipts

Planed order releases

Question 3:

Please make sure to answer all parts and show work. Thanks!

Item A has a gross requirement of 2,100 in week 6 . Currently, there are 600 Item A's on hand with a scheduled receipt of 150 item in week 3 . The lead time for item A is 2 weeks with an order quantity of 700 . Complete the MRP record for Item A. Complete the MRP record for Item A (enter your responses as whole numbers). omplete the MRP record for the end item, Item A, that has a gross requirement of 450 in week 3 and 1,600 in week 5 . The lead time for this item is 2 weeks. Currently, iere are 150 items on hand with a scheduled receipt of 150 items in week 2 . The item has a 2 week lead time, and its order quantity is lot for lot. omplete the MRP record for Item A (enter your responses as whole numbers). Use the following MRP record to answer the question. Which one of the statements concerning item LMN is TRUE? A. The planned receipt quantity in week 6 is 30 units. B. The projected on-hand inventory in week 8 is 70 units. C. The scheduled receipt of 80 units in week 3 should be exp D. The planned order release quantity in week 3 is 80 units