Pepsi Cola Egypt Senior Planning Analyst - Commercial - PepsiCo Inc. | Egypt Jobs



Budgeting & Forecasting:
- Prepare with the budget owners the detailed Annual Operating Plan(AOP) and the quarterly forecasts (P&L, B/S and Cash Flow).- Review and challenge the budget assumptions- Reconcile the agreed numbers with the submitted ones and ensure it is in line with the Hyperion submission- Assess key risks and opportunities that may arise during the forecasted period.- Enhance the planning files to ensure easy flow for information and easy reporting and reconciliation.- Give early alerts for possible risks for budget/FCST deviations.
Business cases:- Develop flexible financial models for business case financial evaluation.- Review & challenge the commercial assumptions to develop accurate Return On Investment(ROI) analysis.- Identify risks in the proposed business case through sensitivity check measures to be provided with the financials.- Check if the business case is within the forecast.- Perform post mortem evaluation on quarterly basis for new or revamped products and on monthly basis for promotions and offers.
Reporting & analysis:- Understand, identify, and communicate key performance drivers and reason for variances vs. forecast and business cases by preparing a monthly pack to explain the performance and the variance of each product/category and communicate to the stakeholders.- Develop weekly outlook for volumes and revenues and explain the volume and mix impact on the latest forecast and measure the accuracy of the outlook weekly.- Highlight variances for the actual results and give alerts on budget deviation to the commercial managers (Sales and Marketing).- Report on SKU profitability and Channel Profitability to give direction to the decision makers on which SKU/Channel to invest behind.- Support the monthly and year-end closing process and prepare clear and detailed explanation to be provided in a monthly forum.- Enhance COPA reports.
Internal Controls:- Ensure internal controls exist whenever applied- SAP / HFM knowledge is a must- Preferably CMA holder- Results oriented, takes initiatives to get things done- Excellent communication skills.- Team player, adapts well in a diverse environment- Good knowledge of local statutory laws/regulations, financial policies and procedures- Proficient in computer usage. Microsoft Office, Excel, Power Point- Fluency in English


PepsiCo

Job Details

Date Posted: 2013-01-15
Job Location: Egypt
Job Role: Other
Company Industry: Accounting/Auditing

Preferred Candidate

Career Level: Student/Internship

Apply Now - Jobs in Egypt - Search All Jobs

Add a comment!


0 comments:

Post a Comment

Copyright © Egypt Jobs