I am looking to do the following questions utilizing Solver and Excel:

Simone is evaluating the option of combining all 6 warehouses into a unified distribution network. Since each company's warehouses are specialized for their own product category (wireless and satellite), warehouses in the new network will need an upgrade to make them flexible in servicing the demand for both product categories. Note that making all warehouses flexible will incur a one time cost of 200,000 euro?

TABLE 5-16 Annual Demand in Europe for Lightning Networks (wireless) and SatTV (satellite) Wireless Demand Satellite Demand Wireless Demand Satellite Demand Zone Zone 120,000 Middle South Northwest Southwest Middle North 200,000 100,000 Northeast 100,000 100,000 120,000 150,000 90,000 120,000 110,000 100,000 220,000 Southeast TABLE 5-17 Warehouse Specialization, Capacities, and Fixed Costs Location Fixed Cost (euro/year) Madrid Specialization Wireless Wireless Rotterdam Wireless Krakow Toulouse Capacity 370,000 420,000 310,000 280,000 290,000 250,000 600,000 650,000 520,000 475,000 488,000 Satellite Satellite Munich Budapest Satellite 425,000 TABLE 5-18 Variable Distribution Cost per Unit in Euro Middle North Middle South Northwest Southwest Northeast Southeast Madrid 2.50 1.50 3.00 2.75 4.00 4.50 Rotterdam 1.75 3.00 1.50 3.00 2.50 3.50 3.25 4.00 2.50 3.00 2.00 2.50 2.00 2.00 2.75 2.50 3.75 4.00 Krakow Toulouse Munich Budapest 2.25 2.25 2.50 2.75 3.00 3.75 3.00 2.00 3.50 2.50 2.50 2.50 TABLE 5-16 Annual Demand in Europe for Lightning Networks (wireless) and SatTV (satellite) Wireless Demand Satellite Demand Wireless Demand Satellite Demand Zone Zone 120,000 Middle South Northwest Southwest Middle North 200,000 100,000 Northeast 100,000 100,000 120,000 150,000 90,000 120,000 110,000 100,000 220,000 Southeast TABLE 5-17 Warehouse Specialization, Capacities, and Fixed Costs Location Fixed Cost (euro/year) Madrid Specialization Wireless Wireless Rotterdam Wireless Krakow Toulouse Capacity 370,000 420,000 310,000 280,000 290,000 250,000 600,000 650,000 520,000 475,000 488,000 Satellite Satellite Munich Budapest Satellite 425,000 TABLE 5-18 Variable Distribution Cost per Unit in Euro Middle North Middle South Northwest Southwest Northeast Southeast Madrid 2.50 1.50 3.00 2.75 4.00 4.50 Rotterdam 1.75 3.00 1.50 3.00 2.50 3.50 3.25 4.00 2.50 3.00 2.00 2.50 2.00 2.00 2.75 2.50 3.75 4.00 Krakow Toulouse Munich Budapest 2.25 2.25 2.50 2.75 3.00 3.75 3.00 2.00 3.50 2.50 2.50 2.50