Forecasting and etc...

Hi,
I was wondering if any of you could help me out on this. I was asked to solve this problems using Excel, and I have spent two days but can't really figure out. Pleae take a look at the attatched file, and any comments will be appreciated. Thank you in advance,