quickly update your project financial forecast for your oracle ebs projects from an ms-excel...
DESCRIPTION
Project Partners UI-Apps provides a simple MS-Excel Template that provides you your complete project WBS with assigned resources and actuals to date allowing you to update your Estimates to Complete providing you a simple way to complete your project forecasts.TRANSCRIPT
Copyright © Project Partners, LLC
Easy Forecast Creation with UI-Apps
Hidden Gems
Copyright © Project Partners, LLC
Project Forecasts
Oracle Projects provides project managers the ability to create periodic project forecasts
The most accurate forecasts can be created when the project manager sees project budget amounts, actuals to-date, committed amounts, and then can add Estimate-to-Complete amounts for each task/resource
It is also necessary to be able to add new tasks and resources as projects mature
Most importantly, access to up-to-date actuals and commitments is important for accurate forecasts
UI-Apps offers easier approach in one MS-Excel Worksheet
Copyright © Project Partners, LLC
Eight Steps – with UI-Apps
Step 1: See all financial tasks with budgets, actuals, commitments, and prior forecast
Step 2: Add new tasks/resources as needed
Step 3: Choose tasks/resources to forecast against
Step 4: Add/update ETC amounts as needed
Step 5: See amounts roll-up in real time
Step 6: Refresh Actuals
Step 7: See total forecast plan in one sheet
Step 8: Compare total forecast plan totals with Original and Baselined budgets
UI-Apps offers easier approach in one MS-Excel Worksheet
Copyright © Project Partners, LLC
Step 1: See All Financial Forecast TasksOne worksheet display all financial forecast tasks
Financial Forecast Tasks Resource Details Quantities and Amounts
Task/Resource Dates
Copyright © Project Partners, LLC
Step 2: Add Tasks to Forecast as Needed
Task Maintenance: Add new, indent, outdent, manage dates a. Click Add Task to add new tasks b. Click indent or outdent c. Change dates
Copyright © Project Partners, LLC
Step 3: Choose Tasks to Forecast Against
Add resources to tasks for forecasting
a. Click Add Resource b. Choose Resource Format c. Select Resource
Copyright © Project Partners, LLC
Step 4: Add Estimate-to-Complete (ETC) Amounts
ETC amounts are calculated automatically when quantities are input for rate-based resources, and all ETC amounts are spread over remaining periods based on spread method selected.
a. Enter Quantity b. Amounts are automatically calculated from rates in Oracle
c. Select spread method d. Amounts automatically spread
Copyright © Project Partners, LLC
Step 5: Real-Time Roll-up
Amounts roll up to higher tasks and project in real time
As new resources are added, amounts automatically roll up to higher tasks and project levels
New Resource Amounts New Rollup Totals New Resource
Copyright © Project Partners, LLC
Step 6: Refresh ActualsMaintain total forecast, but get real-time actual amounts
Refresh Actuals Button
Downloads current actual amounts
Keeps current forecast the same
Adjusts next open period ETC to reflect any difference between actuals and current period ETC
Replaces current Pd ETC with actuals
Copyright © Project Partners, LLC
Step 7: See Total ForecastOne worksheet display total forecast and component amounts
Financial Forecast Tasks Resource Details Quantities and Amounts
Task/Resource Dates Actuals + Commitments + ETC = Forecast
Copyright © Project Partners, LLC
Step 8: Compare Forecast Plan Totals One worksheet display all financial forecast tasks
Compare Forecast Amounts
Copyright © Project Partners, LLC
Easy Forecast Creation with UI-Apps
Use the flexibility of financial plans in Oracle Projects to effectively forecast your project
Quickly and easily create and update your forecasts with one MS-Excel worksheet using UI-Apps
Stay tuned for more Hidden Gems from Project Partners
Copyright © Project Partners, LLC
A series of videos describing unique features of Project Partners UI-Apps which add significant functionality to Oracle Projects
See them all on the Project Partners YouTube Channel
http://www.youtube.com/user/ProjectPartnersLLC
UI-Apps Hidden Gems
14Copyright © Project Partners, LLC
For more information:
Phone: 650.712.6200email: [email protected]
www.projectp.com