HW-4 Attached Files: 9 HW4 - Transportation problem.pdf A (64.133 KB) There are two parts of the assignment: Part A: Refer to the problem statement and data in the attached file and build a spreadsheet model and solve to calculate optimal transportation cost. (12 points) Part B: For the same problem, assume the factories have a fixed operating cost of: Des Moines - $5,000, Evansville - $7500, and Fort Lauderdale - $8500. What is the total cost now? (3 points) Submit your spreadsheet via Blackboard. 1 Transportation Problem Refer to the transportation problems presented as Figure 1. There are three manufacturing locations and there warehouses. The warehouses serve their local markets while the factories can ship their products to any of the warehouses. The per unit transportation cost between different locations is summarized in Table 1. You are required to determine how much quantity should be shipped from each of the factories to each location. Table 1: Transportation Cost $/ Ton