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?