Download - Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy
![Page 1: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/1.jpg)
![Page 2: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/2.jpg)
<Insert Picture Here>
Meeting the Profitability andCosting Analysis ChallengeJohn FitzmauriceCPM Product Strategy
![Page 3: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/3.jpg)
S281901Meeting the Profitability and Costing Analysis Challenge
• We are going to talk about the challenges facing organizations
• - small, large, for profit and not-for-profit
• in understanding their current operations and performance
• explain to you how we position the Oracle CPM Suite and Oracle Profitability Manager to meet these challenges
![Page 4: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/4.jpg)
S281901Meeting the Profitability and Costing Analysis Challenge
• … tying this to the theme of Oracle OpenWorld 2006 …
• Better Information
• Better Results
![Page 5: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/5.jpg)
<Insert Picture Here>
Program Agenda
• Introduce the Oracle CPM Suite • Examine some of the challenges• Meeting the challenge with Profitability Manager• A demonstration of Profitability Manager• Q&A – your chance to describe your challenges
![Page 6: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/6.jpg)
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
![Page 7: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/7.jpg)
<Insert Picture Here>
Our Mission
Making our software a source of continual competitive advantage for our customers
Better Information
Better Results
![Page 8: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/8.jpg)
Unique, customer focused strategy
FUSION
Customers continue to get innovation in existing release and choose when they are ready to move to next generation technology.
EBS 12 EBS 12.2EBS 12.1
Enterprise 9 Enterprise 9.2Enterprise 9.1
Siebel 8 Siebel 8.2Siebel 8.1
EnterpriseOne 9.0 World A9.1 EnterpriseOne 9.1 World A9.2
![Page 9: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/9.jpg)
Rapidly Changing Conditions• How can I accelerate my planning
and decision cycles?
• How do I monitor conditions and take early corrective action?
Accountability, Transparency• How do I comply with corporate
governance requirements?
• How can I ensure accurate, timely reporting?
Ineffective Decision Support• How do I filter extraneous data
and focus on relevant information?
• How can I access and rationalize disparate, fragmented data?
Efficiency & Cost Control• How can I sustain / improve
profitability?
• How do I keep information current?
Business Pressures
Marketing
Purchasing
Service
Sales
Project MgmtHuman
Resources
Manufacturing
Finance
Plan &ModelPlan &Model
ExecuteExecute
Report &Analyze
Report &Analyze
![Page 10: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/10.jpg)
To Meet These Challenges, Businesses Must…
Connect strategies to plansConnect strategies to plans to align the organization for execution
Monitor ExecutionMonitor Execution to drive a culture of accountability
Drive Performance Drive Performance by operationalizing execution
![Page 11: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/11.jpg)
Blueprint for the Insight-Driven Enterprise
CxO Partners SuppliersProcess Workers ManagersCustomers Sales Teams
Information-Driven Oracle Fusion Applications
BI ApplicationsCorporate Performance
Management
Supply Chain Sales ServiceHuman Capital MarketingFinance
Enterprise Information Model
Industry Specific
Oracle Fusion Middleware
Enterprise ApplicationsOracle
Databases Syndicated DataOther Operational & Analytic Sources
OtherDatabases
![Page 12: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/12.jpg)
• Make timely decisions with integrated information systems
• Target information delivery with role-based dashboards
• Protect organizational integrity with secure information delivery
Financials, Supply Chain, Projects,PLM, Sales & Marketing, HR, Service
Transaction Processing
Us
ers Sensor
BasedServices
AnalystsManagersExecutives
OperationalReporting
ProfitabilityAnalysis
PerformanceScorecards
Consolidation & Compliance
Reporting Planning
Greater InsightComprehensive Corporate Performance Management
Forecasting& Modeling
Ad-HocReporting
Goal Setting
Budgeting
![Page 13: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/13.jpg)
<Insert Picture Here>
My Challenges Include …
![Page 14: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/14.jpg)
My Challenges Include …
• need an integrated approach to analytics• need more dimensionality• need costing insights• need to bring discipline to the process• need ever more detailed profitability analysis
![Page 15: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/15.jpg)
Challenge: need an integrated approach to analytics
• Have initiatives going on all over the place …• Planning
• Do it centrally, but it’s spreadsheet based• Consolidation
• Merged two entities together, but cannot get a complete view of operations
• Performance measurement• The major business units allocate costs and
calculate profitability … but there is no comparison to plans/forecasts
![Page 16: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/16.jpg)
Challenge: need more dimensionality
• The Finance Department do not want to perform management accounting in the G/Ledger
…and Line of Business Managers keep saying…
• Need more dimensionality for our analytics• for processing business rules, and• for analysis and reporting
![Page 17: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/17.jpg)
Challenge: need costing insights
• The industry regulator is asking for another review• Communications, Utilities• Health Care, Hospitals, Education• Financial Services• Need to provide justification for rate increases
• Need to compare the costs at our 3 Help Desks• We have a Shared Services model, but no agreement
• Our Customers are telling us that we’ve got to drop our prices as their income is down
![Page 18: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/18.jpg)
Challenge:need to bring discipline to the process
• No formal process management• No formal approval process for changes to the
process• Methodologies get revised, but want to see the prior
versions – rules and hierarchies• Lack the ability to run ‘what if’ analysis
![Page 19: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/19.jpg)
Challenge: need ever more detailed profitability
• Behavior of the market and customers is changing
• We know the numbers at the enterprise level, but …
• Now need to know revenues and expenses• by Customer, and
• by Product, and• by Channel
• for every transaction
![Page 20: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/20.jpg)
<Insert Picture Here>
Oracle Profitability Manager (PFT)
![Page 21: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/21.jpg)
Profitability Manager
• Profitability Manager was launched September 2005
• Merges Oracle Performance Analyzer and Oracle ABM
• Use to model and analyze costs and profitability of products, customers, channels...
• Customers include financial services, telcos, public sector
• Integration to Oracle G/L • Shares data with EPB & FCH, for
planning, profitability analysis on consolidated results
Profitability Manager:Analyze Cost & Calculate Profitability
![Page 22: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/22.jpg)
• Build, Model and Analyze Profitability
• Integrates Multiple Data Sources
• Easy to Use
• Embedded Activity-Based Management
Oracle Profitability ManagerThe Value
![Page 23: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/23.jpg)
Rep
ortin
g La
yer
Rep
ortin
g La
yer
ControlControl
Security
Business
Process
Rule
Sets
Definitions
Oracle Profitability ManagerMethodology
Transactional
Data
Transactional
Data
General
Ledger
General
Ledger
OtherOtherOtherOther
Rules
EnginePrimedPrimed
DataData
PrimedPrimed
DataData
Reconciliation
Cleansing
Mgmt Ledger
Customer Data
Statistics
Validation Control
P&L
Ad Hoc
Audit
Drivers
Activity
Rates
Methods
Role
Based
Users
![Page 24: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/24.jpg)
<Insert Picture Here>
Meeting the Challenge with Profitability Manager
![Page 25: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/25.jpg)
Meeting the challenge: need an integrated approach to analytics
• The Oracle CPM Suite
![Page 26: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/26.jpg)
Oracle CPM Suite: Single, Unified Architecture
• Robust, shared relational dimensional model
• Common engines & utilities
• Seamless integration with Oracle General Ledger, open APIs for any source data
• Discoverer Reporting, open to 3rd party reporting
OracleE-Business Suite
Da
ily B
usi
ne
ss
Inte
llig
en
ce
Ba
lan
ced
Sco
reca
rd
Oracle DB, Oracle BI OLAP
Enterprise Performance Foundation (EPF)
Enterprise Performance Foundation (EPF)
Oracle Business Intelligence
External Systems
Ent
erpr
ise
Pla
nnin
g a
nd B
udge
ting
Pro
fita
bili
ty
Man
ager
Fin
anci
al
Con
solid
atio
n H
ub
FS
I A
nal
ytic
s: F
TP
Inte
rna
l Co
ntr
ols
Ma
na
ge
r
Enterprise Performance Foundation supports all Oracle CPM applications
![Page 27: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/27.jpg)
Meeting the challenge: need more dimensionality
• A rich multi dimensional model• Dimensions and hierarchies centrally
managed and maintained• Ability to extend and customize to meet your
analysis and reporting challenge
![Page 28: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/28.jpg)
Dimension
• Dimension• Define dimensions and hierarchies
![Page 29: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/29.jpg)
Dimensional Model
• Basic Facts• 19 Base Dimensions• 10 User Defined Dimensions• Numerous Application Specific Dimensions
• Dimension Member Support• Unlimited number of members• Grouping of members into Levels• Filtering of member list based on the Ledger
![Page 30: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/30.jpg)
Dimensional Model
• Analytic Dimensions• COMPANY/CCTR/ORG• PRODUCT• CHANNEL• PROJECT• CUSTOMER• TASK• ACTIVITY• COST OBJECT• CAL PERIOD• GEOGRAPHY• + 10 User Defined
• Financial Characteristics
• FINANCIAL ELEM • NATURAL ACCOUNT• LINE ITEM
• Financial Consolidation
• INTERCOMPANY• ENTITY
• Data Management• SOURCE SYSTEM• LEDGER• DATASET CODE• CURRENCY CODE
![Page 31: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/31.jpg)
Dimensional Model
• Attribute Support• Simple vs. Attributed Dimensions• Unlimited number of Attributes• Level-specific Attributes
![Page 32: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/32.jpg)
Dimensional Model
• Hierarchy Support• Unlimited number of hierarchies per dimension• Unlimited number of levels per hierarchy• Creation & Maintenance
• Create, Maintain in Hierarchy User Interfaces• Load with Dimension Hierarchy Loader• Load using OGL Integration• Versioning, Effective Dating Supported to track changes
![Page 33: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/33.jpg)
Meeting the challenge: need costing insights
• An analysis approach that includes activity-based costing as a core part of the solution
![Page 34: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/34.jpg)
<Insert Picture Here>
“In the 1980’s and early 1990’s, back office departments used ABC for cost
analysis and to improve the bottom line, while the front office worried about
revenue and the top line.
Today a more integrative approach is needed – profitability analysis.”
“ABC Provides the Basics of Corporate Performance Management”
Frank Buytendijk, Nigel Rayner, Gartner IncAugust 08, 2005
![Page 35: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/35.jpg)
Oracle Profitability ManagerMethodology
Traditional
Financial Statement
Activities
Resources
Models
Drivers
Methods
Analytics
Percent Distributions
Rate X Volume
Cost Pools
Transactions
Costs/Revenues
Statistics
![Page 36: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/36.jpg)
Meeting the challenge:need to bring discipline to the process
• Embed process management into the application
![Page 37: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/37.jpg)
Oracle Profitability ManagerModels and Rules
• Separation of Data, Model, Rules
• Role Based Security
• Process Admin. Controls
• Rule Sets /Processing Rules
• Restate and Reverse Entries
• Validation and Reconciliation
• Scalability
![Page 38: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/38.jpg)
Meeting the challenge: need ever more detailed profitability
• A sophisticated data model, allowing the right level of detail for each analysis challenge
![Page 39: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/39.jpg)
The right level of detail for each analysis challenge
Management Ledger
•G/L data – single view of truth
•Multi dimensional analysis
•Use aggregated transaction drivers
Customer Profitability
•Aggregate to Customers
•Rollup to Corporates or Households
Account Analysis
•Model revenue and expenses
•Develop a P&L per accountTransaction Detail
•Model transaction volume and cost/revenue – millions of events
•Aggregate to drive business rules
![Page 40: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/40.jpg)
<Insert Picture Here>
A demonstration of Profitability Manager
![Page 41: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/41.jpg)
<Insert Picture Here>
Profitability ManagerDemonstration
• Demo Flow• Present a demo flow, highlighting the functionality
• Navigation• Preview the main screen interfaces of the application
• Create a Business Rule• Create a Mapping Rule, step by step
![Page 42: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/42.jpg)
Profitability Manager
• Demo Script Flow:
• Vision Support Dept. has a support help desk• The support operators answer Customer support calls
covering these issues:• Browser• Modem / Network• Hardware
![Page 43: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/43.jpg)
Profitability Manager
• Demo Script Flow:
Vision Corp wants to calculate the profitability of the Customers that use the Support Dept.
• Profitability Manager is used to calculate customer profitability, including determining the activity rates for the services performed
![Page 44: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/44.jpg)
Profitability Manager
• Demo Script Flow:
• The data model has received data from multiple sources:• G/L data: Balance Sheet and P&L• Customer detail• Support transaction detail
![Page 45: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/45.jpg)
Profitability Manager
• Demo Script Flow:
• Business Rules to cover:• Map indirect costs to operational cost centers• Determine activity rates for the support center• Show the results, highlighting unused capacity• Apply the costs to the customer transactions• Determine customer profitability
![Page 46: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/46.jpg)
Profitability Manager
![Page 47: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/47.jpg)
Profitability Manager
![Page 48: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/48.jpg)
Profitability Manager
![Page 49: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/49.jpg)
Profitability Manager
![Page 50: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/50.jpg)
Profitability Manager
![Page 51: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/51.jpg)
Profitability Manager
![Page 52: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/52.jpg)
Profitability Manager
![Page 53: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/53.jpg)
Profitability Manager
![Page 54: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/54.jpg)
Profitability Manager
![Page 55: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/55.jpg)
Profitability Manager
![Page 56: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/56.jpg)
<Insert Picture Here>
Profitability Manager (PFT)Navigation
![Page 57: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/57.jpg)
Navigation
• Profitability Manager tabs• Business Rules• Process Management• Administration• Documents• Home
![Page 58: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/58.jpg)
Business Rules
• Profitability Manager Business Rule tab• Mapping• Activity• Customer• Dimension• Condition• Data Inspector
![Page 59: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/59.jpg)
Mapping
• Profitability Manager Mapping page• Adjustment• By Dimension• Field• Percent Distribution• Retrieve Statistic• Simple Source On
![Page 60: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/60.jpg)
Activity
• Profitability Manager Activity page• Activity Rate• Cost Object• Cost Rollup• Statistic Rollup
![Page 61: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/61.jpg)
Customer
• Profitability Manager Customer page• Account Consolidation• Profit Aggregation• Value Index Formula• Profit Calculation
![Page 62: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/62.jpg)
AQ&
![Page 63: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/63.jpg)
For More Information
http://search.oracle.com
or
oracle.com
www.oracle.com/applications/cpm
![Page 64: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/64.jpg)
![Page 65: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/65.jpg)
<Insert Picture Here>
Profitability Manager (PFT)Create a Business Rule
![Page 66: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/66.jpg)
Create a Business Rule
• Here’s the business situation:
• Facilities is a department that provides real estate and security services to operational departments
• We are going to map the Facilities expenses out to the operational departments that Facilities serves
• The operational departments are going to receive the expenses based upon the square feet the departments occupy
![Page 67: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/67.jpg)
Mapping Rule Formula Type:Percent Distribution
• Let’s now look at a demonstration of the Percent Distribution mapping rule
• We are going to include a local condition and a global condition with this rule• Filter on the source using a Local Condition• Filter on the percent distribution set using a Global Condition• The global condition will use both individual dimension values
and a dimension hierarchy
![Page 68: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/68.jpg)
Preview: The Source and the Results
![Page 69: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/69.jpg)
Preview: Percent Distribution Set
![Page 70: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/70.jpg)
Preview: Impact on Support Department
![Page 71: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/71.jpg)
Step 1:
Create Mapping Rule
Define the Folder,
Name, and
Description
Create Mapping Rule
![Page 72: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/72.jpg)
Step 2:
Create Mapping Definition
Define the Version and Description.
Select the Formula Type:
Percent Distribution
Create Mapping Definition
![Page 73: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/73.jpg)
Update Source:
Define the Table Name and the
Column Name.
Select Create Local Condition.
Update Source
![Page 74: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/74.jpg)
Define the Dimension Components:
The dimensions are added, and the values are selected for the Source.
Select Dimension Components
![Page 75: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/75.jpg)
Update Source completed:
Here we see that we have defined a Local Condition, and the dimension values that we selected are displayed.
Review Source Selections
![Page 76: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/76.jpg)
Update Percentage Of:
Select the Table Name and Column Name.
Define whether the rule output target will be the Debit or the Credit.
Force to 100:
Default is enabled.
Define the Percent Statistics
![Page 77: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/77.jpg)
Percent Dimension Details:
Select the Usage method:
We are selecting Percent Distribution for the CoyCCtrOrg dimension.
Match Statistics to Source
![Page 78: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/78.jpg)
Percent Dimension Details:
Select the Usage method:
We are also selecting Percent Distribution for the Department dimension.
Define Distribution Output Dimensions
![Page 79: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/79.jpg)
Choose Global Conditions:
We are selecting a Global Condition, created in a prior demonstration.
Global Condition to Identify Statistic Rows
![Page 80: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/80.jpg)
Choose Global Conditions:
Here we can see our Global Condition selection, and the dimensions and their selections are displayed.
Review Percent Distribution Selections
![Page 81: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/81.jpg)
Update Debit:
Select the Table Name and the Column Name for the target.
We already defined the Debit as our target, and we can see that 2 dimensions are defined as being mapped to the percent distribution set values.
Define the Target Output
![Page 82: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/82.jpg)
Update Debit:
We are defining a specific value as the rule output for our Line Item target (debit).
We select Value as the usage.
Map the Output Results
![Page 83: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/83.jpg)
Update Debit:
We are defining a specific value as the rule output for our target (debit).
We select the dimension value from the list.
Select Target Dimension Values
![Page 84: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/84.jpg)
Debit:
Our selections are displayed here.
CoyCCtrOrg and Dept are defined as “Same As Pct”.
Line Item is defined as a specific value.
Review Target Output
![Page 85: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/85.jpg)
Credit:
For this demonstration rule, the Credit is enabled, and the selection for all the dimensions is “Same As Source”.
This will create offset rows, so that our rule nets to $-nil-,
and the result is the expenses are allocated to the targets.
Review Offset
![Page 86: Meeting the Profitability and Costing Analysis Challenge John Fitzmaurice CPM Product Strategy](https://reader036.vdocuments.us/reader036/viewer/2022062500/5697bfac1a28abf838c9b694/html5/thumbnails/86.jpg)
Review: Mapping Rule Output