slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
for Budget Planning & Rolling Forecast PowerPoint Presentation
Download Presentation
for Budget Planning & Rolling Forecast

Loading in 2 Seconds...

play fullscreen
1 / 95

for Budget Planning & Rolling Forecast - PowerPoint PPT Presentation


  • 178 Views
  • Uploaded on

FESA P lanning. for Budget Planning & Rolling Forecast. www.fesaconsol.com/fesaplanning.pdf www.fesaconsol.com/fesaplanning.ppt x Last update: 23-Dec-2013. FESA Q uery. FESA Consolidation Series. Analytical Performance Management. FESA A nalyst. FESA P lanning.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'for Budget Planning & Rolling Forecast' - ossie


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

FESAPlanning

for Budget Planning

& Rolling Forecast

www.fesaconsol.com/fesaplanning.pdf

www.fesaconsol.com/fesaplanning.pptx

Last update: 23-Dec-2013

fesa consolidation series

FESA Query

FESA Consolidation Series

Analytical Performance Management

  • FESA Analyst
  • FESA Planning

Level of Automation & Investment

Multinational Financial Management

Group Consolidation & Budgeting

  • FESA Financial
  • FESA Professional Accounting
  • FESA Consol

Regional Financial Management

Budget Planning & Rolling Forecast

Management Reporting

Scope of Solutions & Services Mix

slide3

FlexSystem

Enterprise

Software

Architecture

about planning
About Planning

Your ERP systems responsible for historical data

Management demand for managing future proactively

HR manager analyze HR plans provided by line managers

Sales department updates sales forecast every day

IT department prepares annual IT budget for 201X

Brand manager monitors variance of actual cf budget

Finance Manager responsible for cash flow projection

about challenges of planning
About Challenges of Planning
  • Substantial time are involving data manipulation rather
  • the core work of planning and analysis
  • Nightmare of using linked formulas amongst different spreadsheet files
  • Difficult to ensure the correct version of forecast
  • Very time consuming to consolidate different budget scenarios
  • High frequency of errors and difficult to identify the source of errors
  • Internal auditor identifies current weakness of budgetary control system
  • Extended time for new staff to learn and practice the tedious processes of data manipulation
slide11

FESAPlanning

Solving Issues Arising from

Aggregation & Versioning

slide12

Aggregation Computing Issues

  • Simplex form of aggregation
    • 1 + 1 = 2
  • Most common aggregation functions
    • Sum(), Count (), Max(), Min()
  • Assumptions (Based on standardized data source)
    • Measurement and recognition rules
    • Chart of accounts
    • Reporting currencies
    • Data file formats
    • Presentations of transactions or trial balances
  • Example
    • Each company of a consolidation group furnishes standardized transactions, vouchers or trial balances to their headquarters for aggregation in order to prepare different kinds of summary reports (i.e. aggregation scenarios)
slide13

Aggregation Computing Issues

  • Key problems encountered by headquarters
    • Issues of unexpected speed and accuracy when
      • Many data files
      • Many rows and many columns for each data file
      • Following are examples of column name:
      • Many amendments of data files
      • Identifying missing and duplication of data files
      • Frequent reporting, from monthly to weekly to daily to…
    • Issues of security control
      • Send data through email system to wrong recipients
slide14

Aggregation Computing Issues

  • Aggregation scenarios
    • Scenario 1: Aggregation for strategic management
      • Five-year budget planning with multi-scenario analysis
      • Acquisition and disposal decisions
        • – Capital asset, legal entity, branch, product line
    • Scenario 2: Aggregation for operational management
      • YTD actual profit and loss by business unit by month
      • Monthly forecast by business unit by department
      • Actual cfbudget scenarios cf rolling forecast versions
      • Sale-thru analysis by different dimensions
    • Scenario 3: Aggregation for statutory compliance
      • YTD actual consolidated trial balance by company by the following GAAPs:
        • – PRC GAAP
        • – US GAAP
        • – HK GAAP
        • – Japan GAAP
slide15

Aggregation Computing Issues

  • An example of dynamic on-line aggregation
slide16

Aggregation Computing Issues

  • An example of dynamic on-line aggregation
slide17

Versioning Computing Issues

  • Definition
    • Versioning means version control over data processing and/or reporting based on same sets of assumptions
    • It shall be differentiated from aggregation scenarios
  • Two types of version control
    • Version control for audit trial purpose
    • Version control for reportingpurpose
  • Version control for audit trial purpose
    • Who, when, how about the submission of data files
    • Who, when, why about the subsequent amendments
    • Who, when, what about the authorization of data postings
    • About the status of process: pending, completed, fail
  • Version control for reporting purpose
    • Q1, Q2, Q3, Q4 version of rolling forecast
slide18

Versioning Computing Issues

  • Key problems encountered by headquarters
    • Manually assign version number of file and folder name
      • Problem to support multi-user enquiry
      • Not easy to maintain completeness
      • Issue of security control
    • Implement standalone document management system
      • Can keep every version of data file upload itself rather than post and store relevant raw data within database
      • It cannot support to automate aggregation, so it cannot support the retrieval of particular version of consolidated rolling forecast
slide19

Versioning Computing Issues

  • An example of versioning for audit trial purpose
slide20

Versioning Computing Issues

  • An example of versioning for reporting purpose
slide21

What is FESA Planning ?

  • Sales & Marketing
  • Sales & Marketing
  • Business Dimensions
  • Income / Expense
  • Assets / Liability
  • Off/Post-Balance Sheet
  • BU / Department
  • Project / Product
  • Other Dimensions
  • Version / Scenario
  • Internal / External
  • Currency / Amount
  • Quantity / Statistics
  • HR & Admin
  • HR & Admin
  • Production
  • Production
  • Logistics
  • Logistics
  • Time Dimensions
  • Daily / Weekly
  • Monthly / Quarterly
  • Yearly
  • Month-To-Date
  • Year-To-Date
  • Location Dimensions
  • Branch
  • District
  • City
  • Country
slide22

What is FESA Planning ?

  • Budget
  • Budget
  • Business Dimensions
  • Income / Expense
  • Assets / Liability
  • Off/Post-Balance Sheet
  • BU / Department
  • Project / Product
  • Other Dimensions
  • Version / Scenario
  • Internal / External
  • Currency / Amount
  • Quantity / Statistics
  • Actual
  • Actual
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Time Dimensions
  • Daily / Weekly
  • Monthly / Quarterly
  • Yearly
  • Month-To-Date
  • Year-To-Date
  • Location Dimensions
  • Branch
  • District
  • City
  • Country
slide23

What is FESA Planning ?

  • Budget
  • Budget
  • Business Dimensions
  • Income / Expense
  • Assets / Liability
  • Off/Post-Balance Sheet
  • BU / Department
  • Project / Product
  • Other Dimensions
  • Version / Scenario
  • Internal / External
  • Currency / Amount
  • Quantity / Statistics
  • Actual
  • Actual
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Time Dimensions
  • Daily / Weekly
  • Monthly / Quarterly
  • Yearly
  • Month-To-Date
  • Year-To-Date
  • Location Dimensions
  • Branch
  • District
  • City
  • Country
slide24

What is FESA Planning ?

  • Budget
  • Budget
  • Budget
  • Actual
  • Actual
  • Actual
  • Projection
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Forecast
  • Production
slide25

What is FESA Planning ?

  • C&B Code
  • Basic Salary
  • OT
  • Commission
  • Double Pay
  • Performance Bonus
  • Share Options
  • Housing Allowance
  • Medical Insurance
  • Life Insurance
  • Holiday Pay
  • MPF
  • Sick Leave
  • Exam Leave
  • And More
slide26

What is FESA Planning ?

  • Budget
  • Budget
  • Budget
  • Actual
  • Actual
  • Actual
  • Projection
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Forecast
slide27

What is FESA Planning ?

  • Budget
  • Budget
  • Budget
  • Actual
  • Actual
  • Actual
  • Projection
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Forecast
slide28

What is FESA Planning ?

  • Budget
  • Budget
  • Budget
  • Actual
  • Actual
  • Actual
  • Projection
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Forecast
slide29

What is FESA Planning ?

  • Budget
  • Budget
  • Business Dimensions
  • Income / Expense
  • Assets / Liability
  • Off/Post-Balance Sheet
  • BU / Department
  • Project / Product
  • Other Dimensions
  • Version / Scenario
  • Internal / External
  • Currency / Amount
  • Quantity / Statistics
  • Actual
  • Actual
  • Projection
  • Projection
  • Forecast
  • Forecast
  • Time Dimensions
  • Daily / Weekly
  • Monthly / Quarterly
  • Yearly
  • Month-To-Date
  • Year-To-Date
  • Location Dimensions
  • Branch
  • District
  • City
  • Country
start and growth fesa planning with an entry point package
Start and Growth FESA Planningwith an Entry Point Package
  • Save Time
  • Shortest time for implementation
  • Save Efforts
  • Avoid disruption of day-to-day operations
  • Save Money
  • Commit minimum capital investment
  • Mitigate Risk
  • Walk away from associated risks of ultimate complexity
slide33

Support Highly Flexible

Formatting of Spreadsheet Data

We classify formatting of spreadsheet data into two main classes:

  • “Pivot Table Like” or “Column” Form:
  • itcan support Incremental Based Budgeting
  • “Transaction Like” or “Row” Form:
  • it can support Zero Based Budgeting
slide34

Support Data Rewritable Methodology

User can assign Segmental Rewrite Code to their date entry form so as to rewrite posted data associated with specific dimensions such as company, departmentand version:

For example:

  • HR01 represents data entry form responsible by HR department to maintain version 01 of data set
  • SALE01 represents data entry form responsible by Sales department to maintain version 01 of data set
slide43

Support You to Configure

Authorization & User Access Right

slide44

Workflow Scenario 1

User A

User D

2. Posting

1. Data File Upload

Status

Void

Pending

Completed

Restored

2/3

slide45

Workflow Scenario 2

User B

User C

User A

User D

4. Posting

3. Save as Batch

2. Validation Only

1. Data File Upload

Status

Void

Pending

Validated

Completed

Validated

Void

Void

Restored

2/3

slide46

Provide Comprehensive Audit Trial

Provide comprehensive enquiry function for administrator or auditor to monitor and audit data processing activities

conclusion
Conclusion
  • Fast and flexible for the implementation of budget and rolling forecast scenarios.
  • Very user friendly to allow financial users to configure and monitor variances with differing combinations of budgets, current / prior year actuals and multiple versions of rolling forecasts.
  • Outstanding performance of R2R processing so as to enable you to minimize your lead times for budget planning, rolling forecasts, monitoring, and decision making.
  • Improved internal controls throughout the whole process of budget planning and rolling forecasts so that decision making is based on reliable information.
fesa consolidation series1

FESA Query

FESA Consolidation Series

Analytical Performance Management

  • FESA Analyst
  • FESA Planning

Level of Automation & Investment

Multinational Financial Management

Group Consolidation & Budgeting

  • FESA Financial
  • FESA Professional Accounting
  • FESA Consol

Regional Financial Management

Budget Planning & Rolling Forecast

Management Reporting

Scope of Solutions & Services Mix

slide95

FESAConsolidation

Solving Issues Arising from AVESTA Computing

www.fesaconsol.com/fesaconsol.pdf

www.fesaconsol.com/fesaconsol.pptx