Go Blue Shipping is an over$-$the$-$road shipping company that operates mostly in Ohio. Go Blue needs to determine its optimal weekly shipping policy for $10$ customer locations that need shipments from at least one of four possible distribution centers $($located in Akron, Cincinnati, Columbus, and Cleveland$).$ Each customer location can be supplied by any combination of the four distribution centers, however, the Cincinnati distribution center MUST ship at least $100$ loads to EACH customer location per week. It is also possible to ship partial truckloads, so decision variables can be continuous. Each distribution center has a maximum number of loads that it can ship each week, and each customer location has a different number of required loads over the week. There are also different costs for shipping loads between each distribution center and each customer location. These parameters are contained in the Excel file linked here: GoBlueTemplate.xlsxDownload GoBlueTemplate.xlsxUse the Excel file linked above to build an optimization model to determine the optimal shipping strategy to minimize shipping costs. The decision variable cells representing the number of loads shipped between each distribution center and each customer location are highlighted in yellow. You will need to provide formulas for the cells shaded in gray in the Excel file which includes a formula for the total shipping cost in cell B$33$ as well as intermediate calculations in row $29$ and column F$.$ You will also need to provide all the necessary information into the Solver dialog box to solve the model. What is the minimum Total Shipping Cost that can be achieved by Go Blue Shipping that satisfies all stated constraints? $($Enter your answer as a whole number rounded to the nearest dollar. Do not enter dollar signs or commas in your answer.$)$