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 $10$ units.

$50$ units of $P$ should be available at the start of week $5$ and $50$ units of $P$ should be available at the start of week $8.$

Beginning inventories are: $10$ Ps$,25$ As$,$ and $50$ Fs$.$

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