Develop a material requirements plan for end item P and its components, given the following tree. Assume that all lead times are one week, and that lot-for-lot ordering is used except for item F, which is ordered in multiples of 100 units.

One hundred units of P should be available at the start of week 4 and at the start of week 8. Beginning inventories are:

50 Ps, 80 As, and 100 Fs.

Scheduled receipts are: 500 Fs at the start of week 1.

PLEASE USE A EXCEL FILE TO ANSWER THE QUESTION AND PRIVIDE IT CAN ALSO USE SCREENSHOTS

Instructions Please upload your Excel file into this Dropbox. Develop a material requirements plan for end item P and its components, given the following tree. Assume that all lead times are one week, and that lot-for-lot ordering is used except for item F, which is ordered in multiples of 100 units. One hundred units of P should be available at the start of week 4 and at the start of week 8 . Beginning inventories are: 50Ps,80As, and 100Fs. Scheduled receipts are: 500Fs at the start of week 1