Please help in answering the questions along with the excels as an where required.

7. Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Lid. Rinso 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 Boulder 100,000 Macon 100,000 Gary 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 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.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS Boulder 7 11 8 13 Macon 20 17 12 10 Gary 8 18 13 16 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem. b. Find the optimal solution using Microsoft Excel.8. Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. To D E F From G Supply $9 $8 $6 $5 A 50 B 40 5 3 10 C 75 Demand 50 25 30 165 60 165 a. Find the solution that minimizes moving costs using Microsoft Excel. b. What would you have to do to the costs to ensure that A always sends a car to D as part of the optimal solution?9. Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by manufacturers of plastic goods around the United States. SP currently operates four manufacturing centers in Philadelphia, PA; Atlanta, GA; St. Louis, MO; and Salt Lake City, UT. The plants have different capacities and production costs as indicated in the table below. MAXIMUM CAPACITY PROD. COSTS PLANT (x 100,000 LB.) (PER 1,000 LB.) Philadelphia 7.5 $325.00 Atlanta 9.0 $275.00 St. Louis 12.0 $305.00 Salt Lake City 10.3 $250.00 SP currently has six contract customers located in New York City; Birmingham, AL; Terre Haute, IN; Dallas, TX; Spokane, WA; and San Diego, CA. Transportation costs between the plants and various customers, as well as contracted demand from each customer, are shown in the table below. TRANSPORT COSTS PER 1,000 LB. FROM/To NYC BIRMINGHAM TERRE HAUTE DALLAS SPOKANE SAN DIEGO Philadelphia $45 $52 $56 $62 $78 $85 Atlanta $55 $42 $58 $59 $80 $82 St. Louis $57 $60 $50 $54 $65 $70 Salt Lake City $72 $71 $67 $57 $52 $60 Total Demand (x 1,000 lb.) 525 415 925 600 325 400 a. Create a solver model and find the optimal solution to help SP develop a distribution plan that will minimize costs to supply the customers' demand. b. Comment briefly on your solution. Beyond the obvious, does your proposed solution have any other implications for SP?ID. A small manufacturing facility is being planned that will feed parts to three heavy manufacturing facilities. The locations of the current plants with their coordinates and volume requirements are given in the following table: CODEDINA'I'ES VOLUME. PLANT LOCATION [.t, y) (PARTS PER YEAR) Peoria 300, 320 4000 Decatur 375, 410 6,000 Joliet 470,180 3,000 Use the centroid method to determine a location for this new facility