Solve by hand not using excel:

The problem is complete. Just need to setup the linear model and define the constraints

Tiger makes automated vehicles and has seen its demand grow significantly. The company anticipates demand for cars in 2016 will occur in each of the four regions as given in the Table below. Managers are designing the distribution network and have selected Troy, Chicago, and LA as potential regional distribution sites. The annual cost to operate a distribution site in Troy is $200, 000, in Chicago is $600, 000, and in LA is $800, 000. The per car transportation cost of shipping between the sites and the demand regions are given in the table. Assume that capacity is not an issue at the distribution sites (i.e., all potential sites can be built to handle all customer demand). Formulate a mixed integer linear programming model to determine where Tiger should build its distribution sites to minimize total costs. Define and classify all notation used as sets, parameters, and variables. For each objective function and constraint, provide a brief description of its meaning in words. Annual Demand Demand Regions in # of cars Troy Transport Costs (per car) Northeast South $100 $300 Chicago $200 $300 LA $700 $600 Middle $400 $100 $400 West $500 $250 $300 Northeast 8,000 South 2,000 Middle 3,000 10,000 West