Case study 5 pages + calculations

Carefully read the case and i need two things

 

Excel

Word doc

 

Excel sheet should have very very detailed calculations i want to show maximum calculation possible

 

 

Word Doc should talk about the calculations and the findings based on the calculation and the case study