Total Pageviews

Monday, August 12, 2013

Unilever Indonesia Tbk


Sales Forecasting with Moving Average Time series analysis (in Billion IDR)
2008 2009 2010 2011 2012 2013
Q1 3,787.2 4,482.3 4,972.9 5,668.3 6,604.1 5,387.9
Q2 3,832.9 4,473.4 4,949.7 5,795.8 6,755.5 6,582.0
Q3 4,135.3 4,556.9 4,762.4 5,858.0 6,984.5 8,961.5
Q4 3,822.3 4,734.2 5,005.3 6,147.0 6,959.2 8,447.9
Total 27,303.2 29,379.3
Growth  7,6%







Based on the table at above, sales projection of 2013 increase 7,6 %. I used simple combination of moving average and time series, then use its factor to adjust the forecast in four quarters. 

Forecasting with seasonality 



with another method, I conclude that the growth rate will be at 15 % up.  I used seasonality method to estimate the sales of 2013. 

I think the advancement in sales is occurred because of inflation rate factor and increase in sales. It is need deeper in analysis at sales in number.  Is there any increase in number ? which product are dominant in sales contribution ?. commonly consumer goods are inelastic in its demand to price. 


Rise of oil and gas price which is moved by the worse politic condition in Middle East make the global economy slow downs. The energy cost, production cost and transportation cost is more expensive. 

Meanwhile the Fed plans to decrease its money supply as the economic start to recover in USA. The Indonesian rupiah will be weaken to US dollar. In recent times the US government has shut down its activities because they have to negotiate with parliament about Government Debt. Government plan to increase its debt but unfortunately parliament disagree with that plan. 

Meanwhile based on data from trade ministry, Indonesia's export is decrease in 2011 - 2012. It declines 5 % down.


estimation for next year in private consumption will be decline because people will spend more money for transportation cost, energy cost and also the multiplier effect of cost of energy. The price of goods will increase as the increase in production cost.

According to the forecasting above I have made its financial projection





In 2013 -2015, i estimate the company will be able to increase their sales 15 % up in each year. I use seasonality method with 15% growth. 

Big company usually grow stronger with M&A strategy or buy the existing brand in order to advance growth. Unilever has done several corporate action such as buy local brand like sari wangi, buavita etc.

I think the analyst have to find the product which has stronger impact in sales increase then it must be figure out its price sensitivity. Will the change in its price effect demand from customer ?

No comments:

Post a Comment