- To gather and consolidate forecast and actual sales volume data from multiple sources, upload the data into the company’s database systems, and prepare regular high quality analytical reports that are required by the Business Unit Leadership Team (BULT) and other stakeholders, to facilitate timely and effective decision-making that is essential for meeting the Business Unit’s sales volume targets
- To engage with country teams to gain a clear understanding of the complexities and internal/external factors driving volume performance (including business initiatives that are underway to enhance volume growth) and to share the relevant insights with multiple stakeholders through (a) a weekly narrative that is required by the Business Unit President, (b) presentations during Business Unit Rolling Estimate meetings, and (c) informal discussions with the Strategy & Business Planning Director, the Finance Director, Franchise General Managers and other managers on an on-going basis throughout the year.
- To be the BU’s central point of contact for volume analysis and reporting; as well as Subject Matter Expert on all systems and databases relating to volume data gathering, analysis and reporting
KEY DUTIES/RESPONSIBILITIES :
- Sales Volume Forecasting:
- Provide relevant volume analysis/charts required for business planning and forecasting purposes
- Support the Strategy and Business Planning Manager and the Strategy and Business Planning Director in ensuring full alignment in (a) volume estimates submitted by country teams, (b) volume estimates used in developing the financial rolling estimates for franchise territories in the BU, and (c) the volume rolling estimates approved by the Business unit President for submission to Group and/or Corporate Headquarters
- Daily volume tracking and analysis:
- Update the Compass/Dashboard system with Bottler unit case sales data
- Carry out the necessary reconciliations and quality checks on an on-going basis to ensure that the data in the system is accurate
- Weekly volume analysis and reporting to the Business Unit Leadership team and Group:
- Prepare the Weekly Sales Volume Report 3 times a week as per stipulated templates and timelines
- Prepare weekly and monthly narratives outlining key drivers of volume trends
- Monthly volume analysis and reporting to the Business Unit Leadership team and Group:
- Prepare and publish volume data in BOFC on or before 12:00 noon on Wednesday of Week 1 every month
- Engage with country teams to gain a clear understanding of the complexities and internal/external factors that are driving volume performance (including business initiatives that are underway to enhance volume growth)
- Make presentations to multiple stakeholders during Business Unit Rolling Estimate meetings to share the relevant insights on volume performance
- Prepare other monthly volume reports that are required for monthly rolling estimates and for presentation to the Business Unit Leadership Team (BULT) during monthly BULT meetings
- Quarterly volume analysis and reporting to Corporate and the CAPPRs programs:
- Prepare quarterly volume reports that are required for purposes of reporting on the performance of on-going CAPPRs programs, in accordance in the guidelines in the Company’s Standard Practices and Procedures Manual
- Volume tracking and reporting for Customer/Bottler incentive programs:
- Support the Business Unit President’s Executive Assistant in tracking sales volumes for all incentive programs, including the Annual Bottler Incentives and the Olympic Incentive Program
- Other:
- Conducting training periodically on the use of the company’s tracking and reporting systems (including the COMPASS system)
- Engaging with BU and Corporate IT regarding rollout of upgraded volume tracking and reporting systems
- Keep in safe custody (clearly marked “Classified – Confidential” on all pages) all records used in (a) updating the BU’s volume databases, and (b) preparing volume reports submitted to Group and Corporate Headquarters — including the monthly sign-off sheets duly signed by Franchise Business Analysts, to ensure a complete audit trail in accordance with the Company’s internal control guidelines
- Attend to other ad hoc requests for volume information from the Corporate, Group and BU leadership.
ORGANIZATION IMPACT/ INFLUENCE:
Interaction with:
External
Bottlers: Gathering actual sales volume data
Internal
Business Analysts: Gathering actual/forecast sales volume data/ Follow-up on explanation of volume trends
Seeking deep insights on factors driving volume performance
Franchise General Managers: Sharing weekly and monthly sales volume reports/analysis
Presentation of monthly volume performance
Financial Planning and Analysis Manager: Sharing weekly and monthly sales volume reports/analysis
Finance Director: Sharing sales volume reports/analysis
Strategy Analyst: Sharing weekly and monthly sales volume reports/analysis
Strategy & Business Planning Manager: Line manager
Strategy & Business Planning Direct: Function head
BUP Executive Assistant: Sharing sales volume reports/analysis
Communicating insights on factors driving actual volume performance
Communicating on-going and planned volume driving business initiatives
Business Unit President: Sharing sales volume reports/analysis
Communicating insights on factors driving actual volume performance
Communicating on-going and planned volume driving business initiatives
RELATED JOB REQUIREMENTS/ QUALIFICATIONS:
Technical Skills:
- Forecasting
- Analytical skills
- Computer skills (advanced MS Excel and PowerPoint)
- Basic knowledge of SPSS
- Use of COMPASS volume system
- Statistical reporting (numerical and written)
Generic Competencies:
- Imports and Exports Good Ideas
- Delivers Results
- Balances Immediate & Long-Term Priorities
- Lives the Values
Required Experience
- Analytical thinking and effective communication and influencing skills
- Knowledge of statistics, data collection, analysis, and data presentation
- Attention to detail
- Excellent oral and written communication skills
- Effective interpersonal and presentation skills
- Strong business thinker with experience in analyzing data
- Advanced analysis skills
- Exposure to MS Excel
- Preparation of presentations using PowerPoint
- Use of COMPASS and Dashboard systems
- Basic understanding of KO business
EDUCATIONAL REQUIREMENTS :
Undergraduate degree
CULTURAL DIVERSITY:
Responsibility and Interaction with:
Multiple ethnic and cultural exposure – internally and externally. Fluency in English essential. Working knowledge of French would be an added advantage
ANALYSIS:
- Handling data extracted from different software systems and developing new approaches of feeding the data into the company’s volume databases with minimal effort and without any errors
- Dealing with unexpected delays in data submission from different countries and figuring work around solutions for purposes of volume reporting within the strict BU, Group and Corporate reporting deadlines
- Working with multiple stakeholders to ensure that volume forecasts at country level are fully aligned with consolidated forecasts at BU and Group level
- Investigating vigorously the underlying reasons for significant variances between actual and forecast volume data; and sharing the relevant feedback with all the relevant stakeholders in the Business Unit timely
- Testing and working with different statistical volume forecasting models and making recommendations on suitable changes to existing models
- Collaborating with IT to resolve any problems with volume database systems
JUDGEMENT AND DECISION MAKING
Making recommendations regarding daily, weekly, monthly and annual sales volume estimates for purposes of periodic volume reporting to management, as well as for the monthly rolling estimate and annual business planning purposes.
WORKING CONDITIONS :
There is no risk of exposure to any hazard.
TRAVEL REQUIREMENTS :
Potential 5% travel within the BU for training purposes
At The Coca-Cola Company you can cultivate your career in a challenging and dynamic environment. We are the largest manufacturer and distributor of nonalcoholic drinks in the world-selling more than 1 billion drinks a day. Unlock your full potential with a future-focused company that is known and respected throughout the world.
The post The Coca-Cola Company Job Vacancy in Kenya : Volume Analyst appeared first on Jobs in Kenya.
