One unit of a is made from two units of B and one unit of C. B is made from three units of D and one units of F. C is composed of three units of B and one unit of D and four units of E. D is made of...

One unit of a is made from two units of B and one unit of C. B is made from three units of D and one units of F. C is composed of three units of B and one unit of D and four units of E. D is made of one of E. The lead time of C is two weeks; A, B E and F are two weeks; and D is three weeks. L4L is used for item C, E and F. the lot size of 20, 40 and 160 is used for A, B and D respectively. Item A,B, D and E have inventories (at the beginning of period of time) 5, 10, 100 and 100 respectively. Assume parts are assembled in your company and delivered to your customer, if you are asked to delivery (provide ) 10 units of A to your customer in week3, 20units of B in week7, 40units of F in week 5 and 60units of E, what would be you’re planned order receipt and release look like?( for every and each components) using excel in one sheet