Problem $5(20$ points$)$

An electronic manufacturer makes a product designated as A$.$ Each unit of A is assembled from one unit of each of two subassemblies B and C$.$ Subassembly B requires two parts of D and two of component E$.$ Component $E$ in turn is made from one of part $F$ and five fasteners coded $G.$ Subassembly $C$ consists only of two units of part $H$ and four fasteners $G.$ The MPS for product $A$ is as follows

$\backslash$table$[[$Week$,7,8],[$Sales$,20,30]]$

The MRP system's inventory record file indicates the following lead time, on$-$hand inventory, and scheduled receipts

$\backslash$table$[[$Item$,$Lead time $($week$),$On$-$hand,Scheduled receipt$],[$A$,1,5,-],[$B$,2,10,10,4],[$C$,1,30,],[$D$,1,30,],[$E$,1,45,],[$F$,3,20,],[$G$,2,20,30,3],[$H$,1,20,]]$

a$-$ Draw the bill of materials for product A $(4$ points$)$

b$-$ Find the cumulative planning horizon $($show your answer$)(4$ points$)$

c$-$ Produce a list of all planned order releases $(8$ points$)$

$$