For full credit, please submit two files: one managerial report as MS Word or PD

For full credit, please submit two files: one managerial report as MS Word or PDF file AND one MS Excel file to show the operations. If you only submit the managerial report, you will receive zero credit; if you only submit the Excel file, you may earn up to 50% of the grade.
For Q5, you may watch the video
Also, for reference we are using Textbook:
Jeffrey D Camm , James J Cochran , Michael J Fry , Jeffrey W Ohlmann , Essentials of Business Analytics , 4th ed , Cengage Learning , ISBN 9780357131787 (Required)