I attached what I have so far in excel. Please help

Problem 1 Tumley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Tumley has three plants that can produce the motors in New York City, Fort Worth, and San Diego. Turnley's production capacities are as follows: New York City Fort Worth San Diego Rinso manufactures the washers at the following five locations around the country. Plans call for the following numbers of washing machines to be produced at each Rinso location: Boulder Minneapolis Gary Memphis Macon 60,000 40,000 60,000 Produced at New York Fort Worth San Diego 20,000 30,000 30,000 50,000 20,000 Shipments will be made in lots of 1,000 motors from Turnley to Rinso. Due to varying production and distribution costs, Tumley's profits depend on where the motors are produced and where they are shipped. Based on estimates from Turnley's Accounting Department, the following table provides the profit in dollars per unit. Boulder $10 $15 $16 Minneapolis $15 $16 $14 Shipped To Gary $16 $18 $12 Memphis $14 $19 $15 Macon $17 $18 $12 Given profit maximization as a criterion, use the Transportation Method of Linear Programming to determine the optimum ship quantity from each Turnley location to each Rinso location. Include the following items in your response: (a) Submit your Excel file in Canvas so that I can review the Solver parameters used in your solution. (If you use Google Sheets instead, then you must share file permissions and submit the URL link in Canvas so that I can review your Solver parameters.) Demonstrate your understanding of the Excel solution by answering the following questions:

Tumley Corporation has a one-year contract to supply molors for all washing machines produced by Rinso Ltd. Tumley has three plants that can produce the motors in New York City, Fort Worth, and San Diego. Turnley's production capacities are as follows: Rinso manufactures the washers at the following five locations around the country. Plans call for the following numbers of washing machines to be produced at each Rinso location: Shipments will be made in lots of 1,000 motors from Turnley to Rinso. Due to varying production and distribution costs, Tumley's profits depend on where the motors are produced and where they are shipped. Based on estimates from Tumley's Accounting Department, the following table provides the profit in dollars per unit Given profit maximization as a criterion, use the Transportation Method of Linear Programming to determine the optimum ship quantity from each Turnley location to each Rinso location. Include the following items in your response: (a) Submit your Excel file in Canvas so thatI can reviow the Solver parameters used in your solution. (If you use Google Sheets instead, then you must share file permissions and submit the URL Ink in Canvas so that I can review your Solver parameters.) Demonstrate your understanding of the Excel solution by answering the following questions H17