Vizzy T wants to develop a transportation plan (showing how many truck loads should be shipped from each production facility to each regional warehouse) to minimize transportation costs while meeting the demand of each region. a. What are the variables and what is the objective function for this problem? b. What are the constraints for this problem? c. Solve the problem using Excel Solver or LP Solve. What is the optimal transportation plan? d. What is the total cost according to the solution?

5. [15 points] Vizzy T is an auto part manufacturer. They manufacture the products in factories in Atlanta, Tulsa, and Reno. The products are then shipped to five regional warehouses located in Nashville, Chicago, Dallas, Los Angeles, and New Jersey. The transportation cost to each regional warehouse from each production facility is given in the table below. The demand in each region and capacity of the production facilities are also shown in the table