ad ABCD Albedde Problem 1 % Grude Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Bis ins manufactures the washers at four locations around the country New York City, 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 60,000 Minneapolis 80,000 Bindley 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 Bindiey to Bioso. 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 $7 $11 $8 $13 Macan $20 $17 $12 $10 Gary S8 $18 $13 $16 Given profit maximization as a criterion, use the Transportation Method of Linear Programming to determine the optimum ship quantity from each Bindley 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.) (3095) (b) Demonstrate your understanding of the Excel solution by answering the following questions eBook ad ABCD Albedde Problem 1 % Grude Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Bis ins manufactures the washers at four locations around the country New York City, 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 60,000 Minneapolis 80,000 Bindley 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 Bindiey to Bioso. 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 $7 $11 $8 $13 Macan $20 $17 $12 $10 Gary S8 $18 $13 $16 Given profit maximization as a criterion, use the Transportation Method of Linear Programming to determine the optimum ship quantity from each Bindley 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.) (3095) (b) Demonstrate your understanding of the Excel solution by answering the following questions eBook