Project Server 2010 Planned Vs. Actual Report RRS feed

  • Question

  • I need to show Planned resource hours vs. Actual resource hours and we are using Project Server 2010. We are baselining, so I understand the "planned" information needs to come from there. But here's the catch: I need to show Planned vs. Actual by MONTH. Once we load our project plans with tasks and resources I need a way to be able to show what has been planned for all of our tasks by month so we can compare that to timesheet actuals that are submitted. So far I've only been able to show Planned Vs. Actual in one lump overall sum.

    Thursday, May 29, 2014 6:03 PM

All replies

  • Hi,

    I'd suggest to use the task usage view. This is a timephased view that displays the list of tasks and assignments on the left part and a timephased grid "excel-like" in the right part. Going to the "view" tab in the ribbon, you can format the grid timescale in month. Doubleclicking on the grid anywhere, you can select which information you want to display for each tasks/assignments. Selecting baseline work, work and actual work, you'll obtain the view you actually need.

    Hope this helps,

    Guillaume Rouyre, MBA, MCP, MCTS |

    Thursday, May 29, 2014 6:29 PM
  • allisonkterry,

    Just to add on to Guillaume's accurate reply, which applies to individual projects,  I am assuming you need this report across multiple projects, since you are using project server.

    I suggest you use the OLAP Cube named Project Timesheet, which gives you "Baseline Work" as planned across projects, and "Actual Work Billable" across timesheets. The advantage of the cube is that you can add the time component, as well.

    Prasanna Adavi,PMP,MCTS,MCITP,MCT

    Thursday, May 29, 2014 7:17 PM