AD Mabote AaBbcc albed Copert Chapter 15 Problem Set: Logistics Problem 1 % Grade Bindley Corporation has a one-year contract to supply motors for all washing machines produod by Rose Lid. Romanufactures the washers at four locations around the country: New York Oy, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location New York City 50,000 Fort Worth 70,000 San Diego 80,000 Minneapolis 80,000 Bindey has three plants that can produce the motors. The plants and production capacities are as follows: Boulder 100,000 Macon 100,000 Gary 150,000 Shipment will be made in lots of 1,000 motors from Bindley to Rinso Due to varying production and transportation costs, Bindley's profits depend on where the motors are produced and where they are shipped. Based on estimates from Bindley's Accounting Department, the following table provides the profit in dollars per unit Shipped To Produced at New York Fort Worth San Diego Minneapolis Boulder 57 $11 S8 $13 Macon $20 $17 S12 $10 Gary $8 $18 $13 $16 Given profit maximization as a criterion, use the Transportation Method of Linear Programming to determine the optimum ship quantity from each Bindlay location to each Rinso location. Include the following items in your response: (a) Submit your Excel file in Canvas, showing your solution using the Excel Solver add in. (As an alternative, you can use the Solver add-on in Google Sheets, but in that case, you must share file permissions and submit the URL link in Canvas.) (b) Demonstrate your understanding of the Excel solution by answering the following questions 130%