Henry Lee is the Vice President of Purchasing for the consumer electronics division of the Major Electric Corporation (MEC). The company recently...

a.Create a network flow model for this problem. (Consider inserting intermediate nodes in your network to assist in meeting the minimum monthly purchase restrictions for each supplier and the minimum monthly shipping requirements for each port.)

b. Implement a spreadsheet model for this problem and produce a solution in solver and please make sure your work is shown in solver.

c. What is the optimal solution?