Directions Forecast & Analysis Assignment

I have attached the assignment details with another two examples, I need the assignmemt to be done just like the example and the excel sheet. I need it to be done before mid night.