Ensure that all topline forecasting processes are supported to work properly, accurately and efficiently in order to achieve total company topline algorithm targets. Providing accurate and timely analysis to feed all forecasting, monitoring, performance tracking, risk & opportunities identification and all other topline- related forecasting and planning processes on a regular and systematic basis.
Provide advanced analysis in order to support and facilitate net revenue forecasting and tracking on three main subjects:
Company volume, Gross, D&A and Net Revenue (NR) for rolling forecast and annual budget (AOP)
Financial models to enable the management of the process
The actuals versus budgets or year a go (YAGO) for volume, pricing, D&A and NR
Role requires significant analytical work to achieve organized, systematic, accurate, timely and advanced analysis to feed all topline-related processes. The person prepares all iS&OP (short term quarterly commercial plan (QCP) and long term Management Business Review (MBR)) financials, MBR presentations topline slides, Pre-close actual analysis and annual forecast financial data and analysis to be reviewed with Revenue Governance Manager
Beverage actual database update for all channels & subchannels (Volume, NR, COGS, Freight)
Beverage planning consolidation (both short-term and long-term)
Beverage category short-term revisions
Commercial plan (list price, sales door value (SDV), price reduction (TPR) update and maintenance for all channels
Database maintenance and integration for AOP, Forecast (FC) and actual (ACT)
Cause of Change (CoC) analysis tool development & maintenance for Bev category
Data Miner tool development & maintenance for Beverage category
Beverage Category KPI Tracking (Gross revenue, D&A, Net revenue
Actual, AOP and forecast process support for Beverages category.
Build and analyze direct costs (Raw materials and pack for Beverages category working with Bern finance, supply chain team and financial planning team for the monthly rolling forecasts (RF) and Annual Operating Plan (AOP), Manage & prepare cogs analysis to deliver the targeted unit cost, tracking and reflecting all upsides/downsides and taking corrective action if necessary, Identify potential issues in cogs budget before they arise and lead the input to identify and implement solutions and ensure accuracy of the forecasts, Prepare and submit all sector reporting requirements i.e. monthly PBR, SCF requests COGS COC, Attend forums to discuss production plans and strategies and its effect on company P&L, Monitor the productivity projects (GP), ensure the financial impacts are reflected in the P&L algorithm and make sure the savings are properly calculated, Provide support to Turkey GP and Local Procurement Leaders to prepare monthly Productivity Council.