Overview
There are two ways to look at the data summarized in the left-hand column of the Shaper - by Financials or by Hours. Let's talk about them!
Financials Tab
The Financials Tab has a helpful breakdown of the rate, hours and revenue for each Person on the project. The revenue for each Person is calculated by multiplying the role rate and the total projected hours.
Note: On a fixed bid project, the rate identified in the Rate column is the effective rate.
A fixed bid project will have the lock icon next to the Revenue title.
The drop-down box in the top right of this section allows you to decide the Visible Fields you want to see and the Data type they you want.
We'll talk about Data types in a separate section below, but the Visible Fields are:
- Rate - These are the Hourly Bill Rates associated with each Role assignment.*
- Hours - This is the total Hours for the Role assignment within the Data type you've selected.
- Revenue - This is the Revenue generated by the Roles on the Project. It can be calculated as Hours x Rate = Revenue.
*Parallax Tip - Retainer Projects don't have just one Rate per Person
Unlike T&M Projects where Rates are set by the Rate Card, and Fixed Bid Projects where the same Rate is applied across the whole Offering, Retainer Projects have a different Rate every Period (Week/Monthly) which is separately as:
- Weekly Retainer: Weekly Total Revenue (C&R page) / Weekly Total Hours = Weekly Rate
- Monthly Retainer: Monthly Total Revenue (C&R page) / Monthly Total Hours = Monthly Rate
Since the Shaper can't show multiple Rates at once, and you can have as many different Rates as Weeks/Months, the Rate Column for only Retainers is instead calculated for each individual as Revenue / Hours = Rate.
Project totals for each column are displayed at the bottom of this section, as well:
Hours Tab
When we navigate over to the Hours Tab, we see the three right-most columns change in this section. We can now see Visible Fields:
The Visible Fields** you'll see are:
- Unplanned Hours - This is the variance in Hours between what you Sold and where you are currently projected to end the Project (based on your current progress). Check the next section below for a more comprehensive look at Unplanned.
- Actual/Planned/Projected/Remaining Hours - This column will be set directly by the Data type.
- Sold Hours - This column will show the number of Hours that were planned at the time of sale.
Data Types
We decided to address Data types separately, because the Data types are the same in both the Financials and Hours Tabs - though they behave slightly differently. The Data types are:
- Actual - This the Total recorded in your Timesheet so far.
- Planned - This is the Total Allocations throughout the Offering (both past and future).
- Projected - This is the sum of Actuals and Remaining. It tells you where you'll end if all future Plans are fully completed.
- Remaining - This is the Total Allocations that are just in the future.**
The Data type you select will affect the two tabs similarly, but slightly differently:
- Financials Tab - The Data type will change the Hours and Revenue columns, but Rates will be the same.
- Hours Tab - The Data type will change only the center Column (Actual/Planned/Projected/Remaining).***
**Parallax Tip - When does the Future Start/End?
You set the cut-off between Past and Future within Settings > Customization. It can either be the end of Next Week (recommended) or the end of Last Week. Check out this article for more info.
***Parallax Tip - Comparing Columns
It's important to remember that in the Hours Tab, the columns are not intended to add up. They represent separate data, so depending on your selected Data type, you may not always be able to use one to calculate one of the others.