PROBLEM IS ALREADY SOLVED, I need to be instructed on how to get the smae answer using Python!! $[$coding in Google Collab$]$ PLEASE USE gurobipy package FOR OPTIMIZATION!! $($see images, colorful excel sheet is data that is uploaded in optimization, steps are the steps that I need to answer, then the last attachment is the word problem it self$)$ Steps for running optimization in Python using gurobipy

$(100$ Points$)$ Paul & Giovanni $($PG$)$ Foods distributes supplies to restaurants in five major cities:

Houston, Las Vegas, New Orleans, Chicago, and San Francisco. In a study to reconfigure their

supply chain, they have identified four possible locations for distribution centers: Los Angeles,

Denver, Pensacola, and Cincinnati. PG Food wish to open two distribution centers. The costs of

supplying each customer city from each possible distribution center are shown in the table

below. PG Foods wishes to determine the best supply chain configuration to minimize cost.

The spreadsheet model with optimal solution and the mathematical formulation are presented

in the Excel file.

Implement this problem in Python using Google Collab and gurobipy package. Submit yourDCs Chosen

Constraints

Customer Assignment

Objective

Total Cost

Python notebook.