please solve the Case study and prepare a short report (up to two pages including tables and graphs) which describes the obtained results provides answers to the questions and interpretations. Please send the report (possible formats: doc docx) together with the solutions in the Excel file.all requrement are lsited in the attached files belwo.