only answer part a and b. no excel solver solution needed

Noble Annazon sells books online. Management is trying to determine the best sites for the company's warehouses. The five potential sites under consideration are listed in the first column of the following table. Most of the sales come from customers in the United States. The average weekly demand from each region of the country, the average shipping cost from each Warehouse site to each region of the country the fixed cost per weck of each warehouse if it is operated, and the maximum capacity of each warehouse fifit is operated) are shown in the following table. Formulate and solve a mixed BIP model in a spreadsheet to determine which warehouse sites Noble Amazon should operate and how books should be distributed from each warehouse to each region of the country to mihimize total cost

Read the problem description and answer the following questions

1. Define the decision variables of this problem (jay verbally describing them). (6 points)
2. Formulate algebraically the objective function and constraints of this mixed BIP problem. (17 points)

Noble Amazon sells books online. Management is trying to determine the best sites for the company's warehouses. The five potential sites under consideration are listed in the first column of the following table. Most of the sales come from customers in the United States. The average weekly demand from each region of the country, the average shipping cost from each warehouse site to each region of the country, the fixed cost per week of each warehouse if it is operated, and the maximum capacity of each warehouse (if it is operated) are shown in the following table. Formulate and solve a mixed BIP model in a spreadsheet to determine which warehouse sites Noble Amazon should operate and how books should be distributed from each warehouse to each region of the country to minimize total cost. Read the problem description and answer the following questions. a. Define the decision variables of this problem. (i.e, verbally describing them). ( 6 points) b. Formulate algebraically the objective function and constraints of this mixed BIP problem. (17 points) Noble Amazon sells books online. Management is trying to determine the best sites for the company's warehouses. The five potential sites under consideration are listed in the first column of the following table. Most of the sales come from customers in the United States. The average weekly demand from each region of the country, the average shipping cost from each warehouse site to each region of the country, the fixed cost per week of each warehouse if it is operated, and the maximum capacity of each warehouse (if it is operated) are shown in the following table. Formulate and solve a mixed BIP model in a spreadsheet to determine which warehouse sites Noble Amazon should operate and how books should be distributed from each warehouse to each region of the country to minimize total cost. Read the problem description and answer the following questions. a. Define the decision variables of this problem. (i.e. verbally describing them). ( 6 points) b. Formulate algebraically the objective function and constraints of this mixed BIP problem. (17 points)