Planning and System Economics Analyst at the Coca-Cola Company

Job ID: R-03914

Position Overview:

The role will be responsible for budgetary management of the Franchise DME, administering the MEM tool, while ensuring compliance with Company Standard Practices and Procedures.
Contributes to provide the Franchise teams with accurate analysis, benchmarks and reports on a timely manner to ensure optimal allocation of resources in implementation of the Company's business strategies.

Contributes to develop and provide details for a holistic view of the value creation across the system in order to support Region Finance Managers to identify risks & opportunities across the system within its specific Region.
Supports Finance organization on system thinking related to financial policies, programs, company investments, long-range goals and objectives.
This position provides accurate system economics analysis, insights, benchmarks and reports in a Region System Economics function. Supports Region System Economics Manager and Region Finance Manager in guiding the business by providing deep understanding of the financial condition and economics of the system.

Function Specific Activities:

INCUMBENT NAME:

DATE:

JOB TITLE :

Business Unit Planning & Analysis Analyst

MANAGER TITLE & NAME:

Business Unit Planning & Analysis Manager

DEPARTMENT:  Finance

BASE LOCATION: Lagos, Nigeria

CURRENT GRADE (IF JOB ALREADY EXISTS): 10

A. JOB SUMMARY:  Describe the Purpose of this job in 2-3 Sentences. 

The role will be responsible for budgetary management of the Franchise DME, administering the MEM tool, while ensuring compliance with Company Standard Practices and Procedures.

Contributes to provide the Franchise teams with accurate analysis, benchmarks and reports on a timely manner to ensure optimal allocation of resources in implementation of the Company's business strategies.

Contributes to develop and provide details for a holistic view of the value creation across the system in order to support Region Finance Managers to identify risks & opportunities across the system within its specific Region.

Supports Finance organization on system thinking related to financial policies, programs, company investments, long-range goals and objectives.

This position provides accurate system economics analysis, insights, benchmarks and reports in a Region System Economics function. Supports Region System Economics Manager and Region Finance Manager in guiding the business by providing deep understanding of the financial condition and economics of the system.

B. KEY DUTIES/RESPONSIBILITIES:
Briefly describe the primary duties/responsibilities of this job in 5-8 bullet points.  Please list these duties in order of importance and include the percentage of time spent or required for each activity.

Prioritized Responsibilities

% of Time

1. Coordinate the Central Franchise Marketing DME for RE process:

• Compile expected monthly DME expenses & submit monthly figures to Finance manager and RFMs
• Strategic & Annual Business Planning (BP) - Support CMI manager on the annual DME Business Planning process by:
• Serving as marketing expense controller (MEC)for the BU. manage overspends
• Upload BP DME in Financial system as per submissions and direction by Business Unit leadership within the stipulated BP financials guideline
• Summarize DME by Country, by Brand category.
• Track IMC Charters and Assets - Per Global policy
• Budget Management and Control - Daily. Check that no supplements/returns are made outside BP without FD/MD approval.
• Share RE narratives for DME Vs Actuals
• Blackline approval for JVs relating to DME
• Prespend reclass analysis and JV preparation
• GL analysis for PL and balance sheet lines
• Effecting monthly MPP accruals and reversals on the system
• Analyzing currency exchange fluctuations as they relate to DME spend for FOs with currencies different from USD
• Effect timely DME freeze & shifts on directives from BU leadership and approved RFA's
• Effect timely DFR budget supplements on directives from franchise
• Brand Contribution Report - Monthly update and Communicate key deviation to finance and marketing teams
• Be the Financial consultant relating for Marketing associates on Marketing Expenditure Mgt

40%

2. Process Improvement:

• Supports BU P&A Team to achieve efficient, effective and sustainable finance processes and transactions
• Provides support to Finance Managers on reports/updates needed in Planning system
• Works with process owners to identify and implement continuous improvements in processes, systems and procedures
• Acts as a part of the process and ensures standard processes are followed.

10%

3. Contributes in providing a complete view of the value creation across the system 

• Understands, applies and articulates accounting and tax implications of all value sharing models
• Determines value creation between all parties from suppliers to consumers by preparing the system value chain
• Provides accurate system economics analysis and reports and supports Region System Economics Managers
• Supports Region System Economics Manager to analyze and assess gaps and to identify revenue growth opportunities and commercial opportunities
• Understands and provides the system revenue strategic framework from Long-Term (Long Range Plan) to yearly projections
• Supports in defining system investment and program risks and provides recommendations like:
  • Bottler support investments, rebates
  • Cold Drink Equipment and Bottler Capital Investments, etc.
• Performs financial analysis and performance tracking for investment decisions
• New launches (extension, delist)
• Cold Drink Equipment investments
• Different OBPPC structures
• Pre, post promotion analysis
• CAPPRS performance tracking
• Validate proof of purchase of CAPPRS

40%

4. Customizes Financial Guidelines and ensures guidelines are applied within Region:

• System Health Corridor guidelines
• Concentrate Pricing models
• New product development guidelines
• Incidence guidelines
• CAPPRS tracking guidelines

10%

C. FINANCIAL/ JOB SCOPE: Identify quantitative factors for this job, such as volume, annual budget, customer contacts (e.g., # of bottlers, customers, etc.), and other major indicators of the scope and complexity of this job.

Volume (unit case/gallons)

#

Retail Customer Locations

#

Foodservice Customer Locations

#

Brands/Products

#

Product Launches Annually

#

Countries

#31

Currencies

#5

Bottlers & types

#

Suppliers

#

# Vendors & Dollars Managed

#

$

Management Role:

     P&L, Profit Before Tax

$

     Operating Budget

$

     Opex dollars influenced

$

     Other

Countries, BU(s), and/or Group Responsibility

31

D. COMMUNICATION COMPLEXITIES:  Indicate the level, purpose and complexity of the communications inside and outside TCCC. (Examples:  Across business unit, groups or global communications; Dissemination of information internally, externally or mixed; Negotiations with one party internally or multiple parties externally, etc.) Include any Company spokesperson responsibilities.

Internal

• BU Planning & Analysis Manager (problem solving, brain storming, receives guidance, supervision, coaching)
• Region Finance Manager (service requests, issue management)
• Group planning team (Feedback on expectations/Client Management)
• Financial Services Representative (Following up Feedback on queries)
• Group and Business Unit Strategic Planning, Technical, and PAC Managers/Analysts (partner, support, data validation)

E. ANALYSIS: Describe the types of problems this job must solve to perform successfully.  Is the process well defined, or must this job develop new approaches to solve these problems?

This position consists of routine tasks or processes in accordance with predetermined, clearly defined steps. It also requires sophisticated and contemporary information management and superior analytic skills and expertise. The individual must also possess exceptional collaboration and organization skills/capabilities; with the ability to multi-task, set priorities and meet deadlines.

F. JUDGMENT AND DECISION MAKING: Describe the nature and impact of decisions required in this job.  Distinguish between recommendations made to someone else and decisions where this job has final authority.  Indicate involvement (if any) with ABP and OBP development and execution.

The rules set in agreed deliverables will be used to regulate transactions between BU and the Region.

Contributes on creating the structure for business cases, assigns resources in the system and establishes processes and routines.

G. INNOVATION: Indicate this job's responsibility for new processes, systems, or products.

• Supports continuous improvement by applying standardized processes and templates.

H. SUPERVISORY RESPONSIBILITIES: List the number, if any,  and type (full-time, part-time, contract) of direct reports; indicate the extent of this job's involvement in supervision including hiring, conducting performance reviews, and terminations as well as team leadership, coordination of work assignments and other indirect supervision.  Please attach a copy of the current or proposed organization chart, unless the org chart on the system is representative.

No direct reports

I. QUALIFICATIONS / COMPENTENCIES / SKILLS:

List the functional competencies and skills needed to successfully perform this job. Please do not describe the skills and qualifications of the incumbent, but rather the minimum skills and qualifications required to perform the job.

Is this position a:

Leader of Self

X

Leader of Others

Leader of Leaders

Foundational competencies

• Analytical skills
• Influencing and negotiation skills
• Financial knowledge
• Optimizing strategic relationships and networks
• Attention to detail
• Communicating effectively
• Thinking systemically
• Understanding the system
• Acting as a team member
• Planning and organizing
• Demonstrating self-confidence

Technical skills

• Financial analysis
• Planning and forecasting skills
• Performance management
• GAAP, cost accounting / analysis
• Excellent computer skills (i.e. Excel)

J. RELATED EXPERIENCE REQUIREMENTS/ QUALIFICATIONS: List the number of years and type of previous work experience required.  Please do not describe the experience of the incumbent, but rather the minimum experience required to perform the job.

• Minimum 3 to 4 years of experience
• Accounting experience is a strong plus

K. EDUCATIONAL REQUIREMENTS: Indicate the minimum education level required to perform the job. 

Education Required

Level of Certificate

• No Degree
• High School
• Intermediate Certificate / Associate Degree
• University/Bachelor's degree

Minimum

• University/Advanced degree
• Postgraduate/Master's degree

Preferred

16  Doctorate/JD/Ph.D./MD

L. PREFERRED QUALIFICATIONS: Please list any additional preferred qualifications.  (example:  CPA/MBA preferred)

CPA/ACCA/CIMA

M. CULTURAL DIVERSITY: Please describe any language, ethnic or culture differences this job faces.  List any language requirements.

This position requires working in diverse environments and with multicultural teams.

N. WORKING CONDITIONS: Describe the risk of exposure to hazards in performing this job, and the types of hazards faced.

N/A

O. TRAVEL REQUIREMENTS:  Indicate the annual percent of time that this job requires overnight travel or day trips.  Please include the nature and geographic scope of travel requirements

Minimal travel is required through BU locations.

P. ADDITIONAL INFORMATION: Please provide any additional information that is not included in any of the above sections that would aid in ensuring that this job description represents an accurate and complete picture of the job.  If the job existed previously, please describe what has changed.  Also, please include any jobs that you believe are comparable to this job.

The key success-criteria is:

• Provides accurate analysis and reports
• Meets deadlines
• Because of the necessary interaction with other departments, good interpersonal relationships are essential.

Job Requirements:

Years of Experience:

Leadership Behaviors:

• DRIVE INNOVATION: Generate new or unique solutions and embrace new ideas that help sustain our business(encompassing everything from continuous improvement to new product and package innovation). 

• COLLABORATE WITH SYSTEM, CUSTOMERS, AND OTHER STAKEHOLDERS: Develop and leverage relationships with stakeholders to approximately stretch and impact the System (Company and Bottler).

• ACT LIKE AN OWNER: Deliver results, creating value for our Brands, our System, our customers, and key stakeholders. 

• INSPIRE OTHERS: Inspire people to deliver our mission and 2020 Vision, demonstrate passion for the business and give people a reason to believe anything is possible. 

• DEVELOP SELF AND OTHERS: Develop self and support others' development to achieve full potential. 

Growth Behaviors:

• GROWTH MINDSET: Demonstrates curiosity. Welcomes failure as a learning opportunity.
• SMART RISK: Makes bold decisions/recommendations.
• EXTERNALLY FOCUSED: Understands the upstream and downstream implications of his/her work. Tracks and shares external trends, best practices or ideas.
• PERFORMANCE DRIVEN AND ACCOUNTABLE: Has high performance standards. Outperforms her/his peers.
• FAST/AGILE: Removes barriers to move faster. Experiments and adapts. Thrives under pressure and fast pace.
• EMPOWERED: Brings solutions instead of problems. Challenges the status quo. Has the courage to take an unpopular stance.