qq

Milestone 3 (Due Week beginning 29th September 2014) Task 6

· a)  Using freehand graphical method, predict the sales/revenue/profit for the next two years. (Do it manually on a graph paper) (2 Marks)

· b)  Using semi-average method, predict the sales/revenue/profit for the next two years. (Do it manually on a graph paper) ( 5 Marks)

· c)  Using the Least squares method, predict the sales revenue for the next two years. You need to do this by framing the least squares equation manually by coding the

years. (6 Marks)

d) Using the excel method of prediction using the “FORECAST’ function, predict the sales/revenue for the next two years. (3 Marks)

Task 7

Prepare a comparitive table for the predictions using all the different methods. ( 2 Marks)

Task 8

Provide an analysis of the above table. In your opinion, which of the above methods are more suitable for making the predictions. And also how reliable are your predictions for Sales/Revenue/Profits. Provide reasons to support your answer. ( 6 Marks)