Operations ManagementQuestion 9Please show work and explain. Thank you. Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures thewashers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the followingnumbers of washing machines to be produced at each location:New York CityFort Worth50,00070,000San Diego60,00080,000MinneapolisBindley has three plants that can produce the motors. The plants and production capacities areBoulderMaconGaryDue to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they wereproduced 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.)PRODUCED ATBoulderMaconGary100,000100,000150,000From/ToBoulderMaconGaryRequirementsNEW YORK CITY7208SHIPPED TOFORT WORTH111718Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and howmany motors should be shipped from each plant to each destination.a. Develop a transportation grid for this problem.SAN DIEGO81213New York City Fort WorthMINNEAPOLIS131016San DiegoMinneapolis Supply b. Find the optimal solution using Microsoft Excel. (Note: Due to existing transportation contracts, Macon must ship 50,000 motors toFort Worth and 0 motors to San Diego. These requirements are already shown in the Candidate Solution below.)Note: Leave the cells blank, whenever zero (0) is required.Candidate SolutionBoulderMaconGaryTotal suppliedProfitBoulderMaconGaryTotal profitNew York City0New York City Fort WorthFort Worth50,00050,000San DiegoSan Diego0MinneapolisMinneapolis$0Total Shipped0050,00050,000

Assume the following as the decision variables: Production at Rinso ltd. and Bindley is taken in "000 units As per the given information in the question, the following is the transportation grid for the problem listing the Supply and requirements (in'000) along with dollar profit per unit to ship the units from Bindley to Rinso. Objective functionMax Z = 7Bn+11Bf+8Bs+13Bm+20Mn+17Mf+12Ms+10Mm+8Gn+18Gf+13Gs+16GmSubject to constraintMf=50Ms=0Bn+Mn+Gn=50Bf+Mf+Gf=70Bs+Ms+Gs=60Bm+Mm+Gm=80Bn+Bf+Bs+Bm≤100Mn+Mf+Ms+Mm≤100Gn+Gf+Gs+Gm≤150Formulate the Excel as follows: Solver parametersCandidate solution Profit