ISM 6137 SUMMER 2021 ASSIGNMENT 3 NAME: (Please Print) (Please Print) Problem I (15 points): Legend 2 points, Network flow model with arrows 3 points, Objective function 2 points, Constraints with labels 6 points, Response Memo 2 points. Develop a network model (including any dummy values texquired). Formulate and solve the model using solver in Excel. Explain your output and give your recommendations in a Memo. Place your solutions in eLearning in a SINGLE file for all problems no later than 2330 Sunday 1 Aug 2021.. MEMO TO: ISM 6137 Management Analysis FROM: ITC Logistics Manager RE: ITC Chemicals shipping schedule Background ITC Chemicals, Inc. can manufacture a chemical solvent that is used in many industrial products. The solvent is the same regardless of the plant that produces it. The following departments have provided information. Marketing The demand for this product from each of the customers 1, 2, and 3 is 60,50, and 40 tons respectively, Production Three factories can supply any of three customers with a particular product. Maximum production at factories located in Navarre, Mary Ester and Fort Walton Beach are 40, 70, and 65 tons respectively. Production costs are $12.00/ton at the Navarre plant. $11.00/ton at the Mary Ester plant, and $13.00/ton at the Fort Walton Beach plant. Transportation The shipping costs (S/ton) are: Factories Navarre Mary Ester Fort Walton Beach 4.5 2.2 1.7 Customers 2 3.1 3.5 1.6 3 4.2 2.4 2.4 Management Determine the quantity of product to be supplied from each factory to each customer so as to minimize total costs