Please provide a clear step by step solution. Thank you in advance!!

The Global Plastic (GP) is a manufacturer of polyethylene plastic products around the U.S.. GP currently operates five manufacturing centers in Philadelphia, PA: Plano, TX: Anaheim, CA; Des Moines, IO; and Atlanta, GA. These plants have different production capacities. GP has four distribution centers with varying demands located in San Antonio, TX; Birmingham, AL; Memphis, TN; Louisville, KY. GP Manufacturing centers are in Five Locations Philadelphia, PA 85.000 Plano, TX 1 10.000 Anaheim, CA 80.000 Des Moines, IO 90.000 Atlanta, GA 75.000 440.000 The GP Warehouses are in four locations San Antonio, TX 100,000 Birmingham,AL 140,000 Memphis, TN 10,000 Louisville, KY 90,000 440,00 Due to varying production and transportation costs, the profit GP earns on every 1.000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000) Philadelphia Plano Anaheim Des Moines Atlanta San Antonio 15 15 Birmingham 18 1I Memphis Louisville 13 Given the profit maximization as a criterion, GP would like to determine what quantities of products should be produced at each of these plants. GP also wants to determine economically transportation plan how many products should be shipped from each plant to each warehouse. Create a solver model and find the optimal solution using Microsoft Excel Note: An excel template is on the Assignment 3 folder. Create a secondary table below indicating only the manufacturing facilities and warehouses. San Antonio, TX Birmingham, Louisville, Manufacturin AL Memphis, TN KY g Supply Philadelphia. PA 85,000 Plano, TX 1 10,000 Anaheim, CA 30.000 Des Moines, 10 90,00 Atlanta, GA 75.000 Demand 100,000 140,000 110,000 90,000 Find the following answers What does the total transportation cost! O 5.560,000 O 5.600,600 5.160,000 4,810,000QUESTION 2 Given the data in Question 1. Based on LP optimal solution, what is the cost to transport items from Des Moines, 10 to Birmingham, AL O 75,000 O 85,000 O 70,000 O 80,000 QUESTION 3 Given the data in Question 1. Based on LP optimal solution, what is the cost to transport items from Atlanta, GA to Louisville, KY. O 80,000 O 70,000 O 75,000 O 85,000