Before you Begin
This 30-minute tutorial shows you how to plan for project expenses using driver-based assumptions and direct input expenses. The sections build on each other and should be completed sequentially.
Background
With Projects, you can bridge the gap between project planning systems and the financial planning process. You can assess the impact organizational projects and initiatives have on overall corporate resources and ensure they align with short and long term financial targets.
Projects supports these types of projects:
- Indirect, or internal projects—Projects that are run internally by your company, such as IT, RD, and marketing projects.
- Contract projects—Projects that generate revenue; used by companies such as those that make money from contract projects.
- Capital projects—Projects that manage capital investments; used by companies that invest in capital assets. For example, a company building a new facility can manage costs, labor, equipment, and so on to manage capitalization of assets.
Projects provides these components that you can enable incrementally to best meet your project planning needs:
- Project Summary
- Expense
- Revenue
- Analysis
You can plan for projects using these methods:
- Driver-based—Enter global rate assumptions and other assumptions (for example revenue drivers or expense drivers) to take advantage of built-in accounts and calculations to drive the planning process.
- Direct Entry—Directly enter data, for example if your planning and forecasting does not have historic trends or specific business drivers. When you use this planning method, no built-in logic is used.
In this tutorial, you plan for project expenses by entering driver-based assumptions and direct input expenses.
Note:
The Planning application used in this tutorial includes an indirect project: Digital Web Mobile. You will be planning for expenses for this project. To learn more how the project was added, see the Adding Indirect Projects tutorial.What Do You Need?
An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.
- Have Service Administrator access to an EPM Enterprise Cloud Service instance. The instance should not have a business process created.
- Upload and import this snapshot into your instance.
- Download this file (DirectEntry.xlsx) to a local folder.
Note:
If you run into migration errors importing the snapshot, re-run the migration excluding the HSS-Shared Services component, as well as the Security and User Preferences artifacts in the Core component. For more information on uploading and importing snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.Reviewing User Variables
User Variables were added when the business process was created. User variables act as filters in forms, enabling planners to focus only on certain members. In this section, you review the values set for user variables.
- Click (Navigator), then under Tools, click User Preferences.
- On the left, click User Variables.
- Review the selected members for each dimension:
- Return to the home page. On the upper right, click (Home).
Navigating to Project Expenses
In this section, you navigate to the Expenses card to start planning for project expenses using the out-of-the-box dashboards and forms.
- On the home page, click Projects, and then Expense.
The Expense card initially opens the Expense Overview dashboard.
- Review the data point-of-view (POV) and click the Project dropdown list to display its options.
The POV members are taken from user variable values. The Project dropdown lists individual projects, as well project types.
Note:
The Planning application used in this tutorial includes an indirect project: Digital Web Mobile. You will be planning for expenses for this project. To learn more how the project was added, see the Adding Indirect Projects tutorial. - Click and review the following vertical tabs:
- Expense Overview—displays a high-level dashboard-type view of project expenses.
- Driver Based—enables you to perform driver-based planning by setting up expense assumptions.
- Direct Input—enables you enter expenses directly in a spreadsheet-like grid format and plan project benefits.
- Review Project Expense—enables you to review overall expenses for a project.
- Assumptions—enables you to review global rate assumptions that drive project financials.
Entering Driver-Based Expense Assumptions
In this section, you enter and calculate driver-based expenses for the Digital Mobile Web indirect project.
- From the vertical tabs on the left, click (Driver Based).
- In Expense Assumptions, verify that the Project is set to Digital Mobile Web.
- In the grid, enter or select the following labor assignments:
- Click Save.
- At the information message, click OK.
The background color of the "dirty" (yellow) cells turn white after data is saved.
- In the grid's empty corner cell above Line 1, right-click and select Calculate Expenses.
The calculation process takes a moment to complete.
- At the information message, click OK.
The form is updated with calculated data.
Entering Direct Input Expenses
- From the vertical tabs on the left, click (Direct Input).
- In Expense Direct Entry, verify that the Project is set to Digital Mobile Web.
- Expand FY22 - Year Total and enter or select the following Expense Type Assumptions and Monthly values:
Note:
The Quarterly and Year Total values should automatically calculate when you enter the monthly values.Tip:
You can copy and paste or refer to values from the DirectEntry.xlsx file into the grid. - For FY23, FY24, and F25 Year Total, enter the following values:
- Click Save.
- At the information message, click OK.
Data is saved to Planning.
- In the grid's empty corner cell above Line 1, right-click and select Calculate Expenses.
The calculation process takes a moment to complete.
- At the information message, click OK.
Reviewing Project Costs
In this section, you review the overall project costs on the Project Expenses form and Overview dashboard.
- From the vertical tabs on the left, click (Direct Input).
Review Project Expenses opens with the Review and Adjust Expenses horizontal tab displayed.
- Click the Project Expense horizontal tab.
- Review the project costs for the Digital Web Mobile project.
- From the vertical tabs on the left, click (Overview).
- From the Project page dropdown list, verify that Digital Mobile Web is selected.
- Review expenses on the Expense Overview dashboard.
Learn More
Planning for Project Expenses
F46545-02
April 2022
Copyright © 2022, Oracle and/or its affiliates.
This 30-minute tutorial shows you how to plan for project expenses using driver-based assumptions and direct input expenses.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.