Create Assigned Hours as a Reporting Object to Improve Date based Forecasting
Our leadership would like to be able to use Workfront to forecast hours, revenues, costs and profits by month. Reporting on the Assignments object does not give project owners, resource managers or leadership information about daily/weekly/monthly totals of upcoming work for users. Under People, the Teams and Scheduling tools do give daily totals for users, but the views cannot be manipulated like a report. Nor can these views give information about future revenue or cost.
The solution is to create Assigned Hours as a reporting object. Necessary data fields would include user, task/issue/project, date, forecasted resource revenue, and forecasted resource cost. An Assigned Hours report would function just like an hours report, but would be future looking. The Assigned hours data already exists at the user, date level in the Scheduling and Teams tools, so adding the financial information and exposing as a reporting object are the next step to making the data more powerful.
Assigned Hours reporting will enable date based forecasting for both revenues and costs by user, role, team, project, program, portfolio and company. Forecasting using this approach is critical for firms performing time and materials based projects.