$1.$ Please read the "Managing a Merger at Lightning Networks" Case study on page $135137$ of your course textbook "Supply Chain Management, Strategy, Planning, and Operation" and then answer the following questions. Please feel free to use the Excel spreadsheet available to you as part of this homework assignment $-$ As a guidance, some of the calculations are provided to you in the Excel file. a$.$ What is the annual cost if Lightning uses the current network $($with warehouses specialized as in Table $5-17)$ optimally to meet European demand? $(30$ points$)$ b$.$ Should Simone make all warehouses flexible given the additional cost of $200,000$ euro per year? $(30$ points$)$