PROBLEM 2 (25 points) The GS Electronics Company produces a variety of appliances. One of their most popular appliance is a large side-by-side refrigerator/freezer. Orders have been received from five retailers in 5 different cities to purchase these appliances during the next week. The appliances will be shipped individually from factories located in different cities. The table below shows what the cost will be for shipping each appliance from each of 4 GS factories to each retailor. The table also shows how many appliances have been ordered by each customer and how many will be produced by each factory. The company's distribution manager now wants to determine how many appliances to ship from each factory to each retailor to minimize the total shipping cost. From To Charlotte Retailer Shipping Cost for Each Appliance Atlanta Chicago Dallas Retailer | Retailer Retailer Output (units) San Diego Retailer $100 $120 $140 $70 $85 12 $100 $105 $65 $110 $150 15 Omaha Factory Kansas City Factory Denver Factory Cincinnati Factory Order Size (units) $165 $170 $120 $80 $90 $95 $100 $30 $140 $1708 5 9 / 13 11 7 a. Draw the network diagram for this problem showing all of the data provided in the table above. b. Write out the LP model for this problem. Be sure to define your variables up front. c. Set up the LP model in Excel and solve for the optimal solution (Note: Be sure to explicitly state what the optimal solution and the associated objective function value are in your test document)