Absolutely NO PLAGIARISM. Must be original.Answering all questions with a great amount of effort; with purpose to apply knowledge in solving real business cases. On an excel file solve the following

Absolutely NO PLAGIARISM. Must be original.

Answering all questions with a great amount of effort; with purpose to apply knowledge in solving real business cases. 

On an excel file solve the following case study:

Case 4.1:- See attachments

Instructions:

1- Create an excel file 

2- Explain in detail all your steps.

3- Use excel functions in doing the calculations.

4- Support your rationale with external readings.

5- The case study is made of 6 parts with equal weights.