Solve using excel, pls show steps clearly.

A manufacturing engineer facing the problem of reducing the costs of production in his department, decided to see whether he can reduce the number of work stations involved in the production of a certain product. The final product consists of 6 components each of which is fabricated with- in a single work station and then added to the product as it is passed through these stations. Even though more than one of these components may be fabricated in any one station, there is a limit of 16 min. on how long the product can stay at any given station. In addition, due to the geometry of the parts, some components cannot be added unless others have been previously attached. (See table. This type of restriction is sometimes referred to as a precedence relation.) The objective is to formulate this problem as an integer programming problem, the solution of which will correlate the assembly of the components with the minimum number of work stations. Assembly Component (i) Time Required For Assembly (Min.) (t) Predecessors 1 2 3 4 5 6 ON 9 3 5 7 3 8