Generate the MRP output for items A$,200,300,$ and $400$ using the following

information in addition to the information in the tab titled $$MRP$.$

$$ Bill of materials:

$$ One item A requires two $200$ and one $400$

$$ One item $400$ requires one $200$ and one $300$

$$ Items $200$ and $300$ are raw material

$$Amount on Order$$ means that an order was placed for a particular item at Week $0$ and

will arrive at the $$Due$$ date. For example, $200$ units of Item $200$ was placed at Week

$0$ and will arrive $3$ weeks later