Please solve the questions below using the Excel sheet where you’ll need to use the Solver feature on excel. The Excel sheet already contains some information of the answer so it will be helpful, so it shouldn’t take long. The questions are listed below. The Excel sheet is attached.
give me the excel sheet as the submition also the answers of the questions on a word document
questions
Homework Assignment – Network Design
1.Please read the “Managing a Merger at Lightning Networks” Case study on page 135-137 of your course textbook “Supply Chain Management, Strategy, Planning, and Operation” and then answer the following questions. ( just sove the excel and it hsould be fine while answering the questions below)
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)
