Q:
From the past actual revenue/sales, he intends to estimate the 3 quarters and 5-quarters moving averages.

a) Visualise a relevant time series graph to help to understand better.
b) Explain and see the results.
 

Transcribed Image Text:

A petrol station operator wanted to expand his business. But first, he needs to understand current situation and at least to forecast future revenue/sales from his five petrol stations (RON95) in Malaysia. He has collected the previous 4 years' actual revenue/sales, data shown below. Time Period 1 23 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Year 1 2 3 4 Quarter 1 2 3 4 1 2 3 4 123 4 1 234 4 Sales/Revenue RON95 ('000) 39 37 61 58 18 56 82 27 41 69 49 66 54 42 90 66 A petrol station operator wanted to expand his business. But first, he needs to understand current situation and at least to forecast future revenue/sales from his five petrol stations (RON95) in Malaysia. He has collected the previous 4 years' actual revenue/sales, data shown below. Time Period 1 23 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Year 1 2 3 4 Quarter 1 2 3 4 1 2 3 4 123 4 1 234 4 Sales/Revenue RON95 ('000) 39 37 61 58 18 56 82 27 41 69 49 66 54 42 90 66