Question: 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

Insert Table Chart Text Shape Media Comment 03.
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!