This question(Case study) has two parts to it. The first part requires you to create an excel model the template for which i have attached to as an excel file. The second part requires you to answer a few theoretical questions based on your excel findings and the case. The Questions for both these parts are given in the word file. Finally the case itself is given in the pdf file.