Insert Table Chart Text Shape Media Comment 03. Julian got a job in an agri-food company as a purchasing analyst. In order to conduct a marketing forecast, he was asked to generate monthly price indices using an old four year set of monthly corn prices. When Julian finished he was not sure what he had. So he asked you to help him complete the following task. Month Year 1 Year 2 Year 3 Year 4 Monthly Monthly Average Price Index Jan 5.20 7.02 7.40 4.10 Feb 4.80 8.90 5.30 7.10 Mar 8.60 3.00 7.60 8.40 6.40 4.70 8.10 7.10 April May 7/10 5.46 4.50 6.60 June 9.90 6.02 3.40 5.34 July 740 7:30 5.30 405 7.50 7.60 8.10 August Sept 6.10 5.20 630 6.20 7.40 Oct 7.60 3:10 8.10 5 20 Nov. 30 5:20 9.20 16.00 Dec. 5.40 6.10 720 7010 OVE avera 1) What is the live moothly index and monthly average prices (Fill in the banks of the above table What does the monthly prices tells you (Which month is harvest time and which month is best time to sell to carn highest profits) (3 points) 2) Julian needs to use this to forecast price, such as the average price in year. If the price trendline is +0.55 per year Explain how you would do this point) MacBook Air