This article is for Timesheets for Data Center. Visit Cloud
Tracking project finances in Tempo Budgets for Server
In this tutorial, you will learn how to track project finances by creating a folio that tracks cost and revenue for a project, associating the right skills and resources with the folio, and planning costs and revenues. You need Budgets by Tempo to complete these tasks.
Step 1: Creating a project
Beverly and her team are developing a small app for another company. Beverly wants to use Budgets by Tempo to plan employee salaries and expenses, approve a baseline, and plan for revenue.
First, she creates a project to hold her Jira issues. She calls this project UMBRELLA.
Step 2: Creating issues and providing original estimates
Beverly has a pretty good idea of how much work will be required for this project. For each development task, she creates an issue in the UMBRELLA project and estimates the number of hours of work required in the Original Estimate field.
Tempo Budgets for Server will automatically total the hours in scope to calculate both costs and revenues, as needed.
Step 3: Creating a folio
Next, Beverly uses Tempo Budgets for Server to create a folio to track her costs and expenses.
She defines the folio's scope using the project she's just created, and decides to track both cost and revenue. She sets the currency as USD, sets the start and end dates for the folio, selects the Umbrella project, and chooses herself as the manager for the folio.
Step 4: Planning salary costs based on scope
Now that Beverly has created a folio, she can use Budgets by Tempo to plan for costs. For the development, she decides to plan the costs using Plan from Estimates, which automatically plans how many human resources are needed based on the time frame and the amount of work in scope.
Beverly estimates that the human resources will cost approximately $35 USD per hour. For the effective date, she selects the Folio's start date.
Beverly clicks Plan, and Budgets estimates that the project will take four full-time developers to complete it in the time allotted.
Step 5: Planning salaries costs based on start and end dates
Beverly still needs a project manager for this project, so she clicks on Plan a human resource. Because she doesn't know exactly how much time will be needed, she sets the salary dates equal to the start and end date of the folio, sets the Cost Rate at $50 USD/hour, sets the Planned Effort to 100%, and allows Budgets by Tempo to calculate the rest.
Given the scope, Tempo Budgets then estimates the planned time at 344 hours total, and the total salary costs at USD $17,200.00.
Step 6: Planning expenses
Now Beverly needs to add some expenses to her folio to account for one-time project costs. Expenses refers to any kind of expense that isn't a salary.
She clicks on Add an expense and adds expenses for software licensing, food, and onsite travel.
Step 7: Approving a cost baseline
With her project costs planned, Beverly submits this baseline for approval. A baseline is a simply a fixed set of costs or revenues that results from planning. All baselines can be consulted from the Planned tab and be compared under the Forecast tab.
Approving a budget sets it as a new baseline.
Step 8: Planning a revenue
Now that her baseline of planned costs has been approved, Beverly can plan for revenues. For this project, she's expecting the revenue to come from a contract as well as from hourly consulting fees for development.
She adds the planned revenue from the contract using Plan a revenue.
Step 9: Planning consulting revenue
Next, Beverly uses Plan a Consulting Revenue to set revenue from four consultants, and selects the dates to match the folio start and end dates.
She sets the Planned Effort at 95% (giving some room for meetings and other administrative time) and sets the Price Rate at $95 USD per hour.
Using these projections, Tempo Budgets for Server calculates the total revenue as USD$ 124,184.00.
Step 10: Approving a revenue baseline
With her project revenues planned, Beverly submits the revenue baseline for approval. She now has an estimate of the planned costs of the project, the planned revenues of the project, and the expected profitability.
Step 11: Adding staff
Beverly got approval to move forward with the project, and now it's time to add actual staff members to the folio. Since Beverly does not have a Tempo Team configured for this project, she'll add configure staff members individually.
Beverly adds Gregory Nolan as a developer, using the default Weekly schedule and Holidays. She sets the From and To dates equal to the folio's start and end dates, and sets his availability to 100%. Budgets by Tempo plans 344 hours of development time for Gregory based upon his schedule and the dates of the folio.
After she has added Gregory to the project, she does the same for three other developers.
Step 12: Setting cost and price rates for the folio
For this project, Beverly wants to follow the established pricing for both costs and consulting revenues.
Therefore, she sets the Cost Rate for each employee as synchronized with the Cost Rates table. If she prefers, Beverly can de-synchronize the folio from the cost rates table using the the Folio Accounting options.
Now that Beverly has set the cost rate synchronized with a global Cost Rate table, she can do the same thing for revenues. She sets the price of consulting to synchronize with a Price Table.
Step 13: Adding revenues to a folio
The project is approved, the contract is signed, and the cheque clears!
Beverly clicks on the planned revenue from the initial contract and selects Copy to actual (V) to copy the planned revenue and post the first income for the project.
Alternatively, she can copy items of planned revenue into actual revenue.
Step 14: Adding a consulting revenue
To add consulting revenues to the folio, Beverly must now select which of the folio staff to add as consultants. The revenue added to the portfolio from consulting will also depend on the start and end dates of the consultancy, the billable ratio, and the individual price rate or price tables.
Step 15: Synchronizing the folio with billed hours
Beverly has assigned some of the folio staff members as contractors, but they won't be working on contracting work all the time, so she would like the team to divide their work between billable and non-billable hours. She sets this option using the Folio Accounting screen.
