integrated financial planning - prophixresource.prophix.com/links/recorded-webinar/cews...integrated...
TRANSCRIPT
Jasmin Dorsett, CPA, CMA
Principal Consultant
Judy Correia, MBA
Solution Architect
Integrated Financial Planning
Agenda
• Objectives
• Integrated planning definition
• Overview of various types (with
demos)
• Tips to improve the overall process
• Q&A
Objectives
• Integrate multiple elements of the
planning process in Prophix
• Think outside of the Balance Sheet/P&L
box
• Expand the planning process beyond
the Finance Dept
• Take advantage of functionality
already available to you
Examples of Plan Data Types &
Parameters
• Operating expenses by expense account
and cost center
• Sales by account (sales and COS),
product and/or customer and/or sales
person
• Personnel expenses by payroll expense
account, employee and cost center
• Capital expenses by account (cost and
depreciation), asset and cost center
Models & Model UsageFinancial Model
Report by: Account (B/S, P&L, CF)
Cost Center/Line of BusinessMonthVersion
Time Perspective
Budget expenses by:Expense Account
Cost Center/Line of BusinessMonth
Plan/Forecast Version
Used to consolidate all planning elements/type
by:Account
Cost Center/Line of BusinessMonthVersion
Sales Model
Report by: Account (Rev, COS, stat)
ProductCustomer
WeekVersion
Time Perspective
Budget revenue by:Account (rev type, stats)
ProductCustomer
WeekPlan/Forecast Version
Models & Model Usage
Production Model
Report by: Account (COS, stats)
ProductLine of Business
WeekVersion
Time Perspective
Budget COS by:Account (cost type,
stats)Product
CustomerWeek
Plan/Forecast Version
Personnel Model
Report by: Account (personnel,
stats)Employee
Cost Center/Line of BusinessMonthVersion
Time Perspective
Budget employee expenses by:
Account (payroll, stats)Employee
Cost Center/Line of BusinessMonth
Plan/Forecast Version
Plan Data Flow
Financial ModelSales Model
Production Model Personnel Model
Rev, COS
Sales UnitsCOS Indirect and SG&A Labor
Direct Labor
Budget OwnersBudget Owners
Data Entry
Personnel Planning
Demonstration
Recap
• Multi-model systems:
– Allow for planning based on different
dimensions
– Can be consolidated to produce total
company plans/reports
– Allow for detailed reporting at various
levels
Integrated Financial Planning
Resources • Solutions Page http://www.prophix.com/solutions/integrated-financial-planning/
• Case Study http://resource.prophix.com/en-casestudy/Interstates-Companies-In-Depth-Profile.pdf
• Press Releasehttp://www.prophix.com/news/using-prophix-cpm-to-transform-planning-into-a-decisive-competitive-advantage/
• Bloghttp://www.prophix.com/blog/harness-the-infinite-value-of-your-companys-information/
• Customer videohttp://www.prophix.com/who-uses-prophix/manufacturing/
Prophix Resources
• http://support.prophix.com
• https://feedback.prophix.com
• https://www.prophixacademy.
com
• http://documentation.prophix.c
om/p11help/en/
Questions?