This article is for Timesheets for Data Center. Visit Cloud
Project Portfolio Management in Tempo Budgets
In this tutorial, you will create an account and link it to a management project. You will create a folio that tracks costs and revenue, associate the required skills and resources with the folio, and plan the costs and revenue. Finally, you will generate and view folio reports. You need Budgets by Tempo and Timesheets by Tempo to complete these tasks.
Prerequisites:
A Jira project management project is needed for this tutorial. The project should be for a service delivery with 1-2 consultants.
The project must have at least 2 project tasks with original and remaining estimates.
Make sure the Account field is available on the Issue page.
Make sure the Billable options are enabled on the Tempo Global Configuration page (Configuring Global Accounting options).
Make sure you know which issues are OPEX and which are CAPEX related. For example, Task - 1: Development = CAPEX, Task - 2: Training = OPEX.
Step 1: Creating an account
With your Jira project ready, the next step is to link the project to accounts. Create one account for billable time and name it so that you can easily recognize it as a CAPEX account. Assign Taylor as the Account Lead and select Development as the Category. Similarly, create an account for non-billable time, including OPEX in the account name. Again, Taylor is the Lead and the Category is Training.
When you have created the accounts, you need to link them to your Jira project.
If there are no issues in your project, create at least one CAPEX = Development issue and one OPEX = Training issue. To help plan out the projected costs for the project, assign an original estimate in hours to each issue. Also, make sure that the issues are associated with the correct account.
If your project already has issues, you can edit them to ensure that they are associated to the appropriate account and have time estimates.
Step 2: Creating a folio
Now that you have set up your project and your accounts, you are ready to start using Budgets! When working with Budgets, the first step is to create a folio. A folio is aBudgets project that lets you define a financial plan, a scope, and a time frame for your Jira project. Folios can be associated with any number of Jira projects.
Create a new folio and use your Jira project to define the scope, and select to track Cost & Revenue. Give the folio a name (e.g. 'project_name folio'), select USD as the currency, and pick a start and end date for the folio.
Step 3: Planning the salary expense for your folio
Having created your folio, you can start creating a cost plan for your project. In this step you will plan the salary expense for your folio using Plan from Estimates. Using this option, Tempo Budgets calculates the number of staff members required to complete your project. The plan is based on the estimated effort of issues within the folio's scope and time frame. Expenses are planned and tracked on the folio Costs tab. Name the human resource, such as Developer (this can be changed later), estimate the cost rate, and make sure to select the folio start date as the effective date.
The generated plan shows you how many staff positions (in this instance, developers) are needed to complete the project/folio.
Step 4: Planning expenses for your folio
Along with the salary forecast, you need to plan for other expenses such as travel costs, software licenses, training, etc.
Plan some expenses that are related to your project and classify them by category and type.
The planned expenses are displayed on the Costs tab under Planned.
Step 5: Approving and baselining your folio
After you have planned the costs for your folio, you can set a baseline. A baseline is simply a point of comparison. Planned costs can be approved and baselined to help you track their evolution. You can create multiple baselines so you can compare various planning scenarios. You can access all baselines from the Planned view.
In this step you will approve your budget and set it as a baseline for future reference.
Step 6: Planning a consulting revenue
With your planned costs approved, you can plan the revenues you expect the folio will generate. In this step you will plan consulting revenue from four full-time consultants. Assign them the Member role, the planned effort should be 100%, with a price rate of $95.00/hr. Select From and To dates to match the folio start and end dates.
Step 7: Adding staff to your folio
When you are ready to proceed with your folio, you can add the people who are working on the project to your folio. Be sure to check that the people are available by going to the Resource Planning overview in Tempo Planner. Filter by role and find out who is available (4 full-time + 1 day). Now go back to your folio to add your staff. Use folio's start and end dates and set the availability to 100%. Because you are using global user rates, the Cost Rate is fixed.
At this time, there are no actual costs recorded in the folio since no hours have been logged.
Step 8: Synchronizing your folio with Price tables and Tempo Accounts
In this step you will make all consulting revenues in your folio use hourly rates from a globally defined price table. You will also synchronize your folio with Accounts so that all worked time on issues are associated with a Tempo account.
Step 9: Logging non-billable hours for the staff
Worked hours are hours that were spent working on the folio's scope by folio members. The worked hours will be included in costs and revenues. Navigate to Tempo Timesheets and log non-billable hours for your staff on project issues that are linked to your OPEX account. Make sure that the Billable field has 0h. Repeat for each member of your folio.
When you go back to your folio, you will see the logged hours in the Actual Costs.
The Actual Revenue, on the other hand, is still 0.
Step 10: Logging billable hours for the staff
Similarly, log billable hours for the staff and see how your folio changes. Log billable hours for your staff on your project issues that are linked to your CAPEX account. Go to Revenue, select the worklogs to add as consulting revenue, then select a role for each staff member. Also select the Billable Ratio as 100%. You will notice how the Total Revenue changes.
Step 11: Synchronizing your folio with billable hours
In this step you will synchronize your folio with Jira worklogs so that the consulting revenue hours will be driven by billed hours logged in Tempo Timesheets. To do so, select Synchronise with the Tempo billed hours in the Accounting tab of the folio's configuration page.
Then navigate back to your folio and open the Revenue tab. You will see that the total hours are reduced.
Step 12: Generating and viewing reports
The folio's Report tab offers several reports where you can visualize, analyze, extract, and export data in many ways. Go to the Report tab and play around with the following reports:
Forecast Report
Issue Costs Report
Expenses / Revenue Report
Steering Committee Report
