1. can you fix the error that pops up in solver for question 1 and question 3. It keeps telling me that "Variable bound conflict in binary or all different constraints" when I try to solve it in solver and it won't solve?? (show how you input the data to make it solve in solver)

CASE STUDY Managing a Merger at Lightning Networks After receiving regulatory approval from the European her initial attention on the distribution networks the two Union, Lightning Networks, a major wireless carrier, companies used to fulfill demand for installation and and SatTV, the largest satellite TV provider in Europe, repair products. The merger offered an opportunity to completed their 50 billion euro merger in 2016. After combine the two distribution networks. initial skepticism when the deal was first announced, analysts had warmed to the idea of synergies in the The Current Distribution Network merger. Lightning expected to benefit from the large customer base of SatTV and the company announced Any new installation or repair by Lightning or SatTV that it expected significant annual cost savings within required a set of products for the technician to complete three years of the merger. Simone Durand, senior VP of the job. Rather than carrying these products with technisupply chain at Lightning, was charged with identifying cians, both companies had decided to centralize product some cost reduction opportunities. She decided to focus inventories in a few locations. Annual product demand 136 Chapter 5 Network Design in the Supply Chain TABLE 5-16 Annual Demand in Europe for Lightning Networks (wireless) and SatTV (satellite) for the two companies across six regions in Europe was much annual demand it can handle. From Table 5-17, as shown in Table 5-16. observe that the Madrid warehouse can serve demand of Lightning had served its product needs from three up to 370,000 units. The variable cost of shipping one unit warehouses located in Madrid, Spain; Rotterdam, Nether- (either wireless or satellite) from each warehouse location lands; and Krakow, Poland. SatTV had served its product to each market is shown in Table 5-18. needs from three warehouses located in Toulouse, France; Munich, Germany; and Budapest, Hungary. Each facility was specialized to handle either wireless or satellite prod- The Network Options ucts because of the historical focus of the company it Simone had a short term and a long term decision to belonged to. The specialization, capacity, and annual make. In the short term, she had to decide whether to fixed cost for each facility were as shown in Table 5-17. make all the warehouses flexible or not. Making all The capacity of each warehouse is given in terms of how warehouses flexible required an investment equivalent TABLE 5-18 Variable Distribution Cost per Unit in Euro to an additional annual cost of 200,000 euro. Flexible Study Questions warehouses, however, could be used to serve demand for