[Company Name] Project Performance Tracking and Reporting Company Confidential
[Date]
Shaded cells are calculated for you. You do not need to enter anything into them. Project type Business continuity planning Business process re-engineering Cost reduction Process improvement Sarbanes-Oxley Strategic planning Blended rates $ Account manager 10% 10% 10% 10% 10% 10% 250 $ Project manager 20% 10% 20% 20% 20% 10% 225 $ Business analyst 40% 10% 10% 10% 20% 50% 200 $ Process specialist 10% 50% 20% 40% 20% Finance specialist 10% 10% 30% 10% 20% 20% 175 $ 150 $ Administration staff 10% 10% 10% 10% 10% 10% 50 Total 100% 100% 100% 100% 100% 100%
[Company Name] Project Performance Tracking and Reporting Company Confidential
Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Winery Coho Vineyard & Winery Contoso, Ltd. Contoso Pharmaceuticals Consolidated Messenger Fabrikam, Inc. Fourth Coffee Graphic Design Institute Humongous Insurance Litware, Inc. Lucerne Publishing Margie's Travel Northwind Traders Proseware, Inc. School of Fine Art TOTAL Project type Business continuity planning Business continuity planning Business process re-engineering Business process re-engineering Cost reduction Cost reduction Cost reduction Cost reduction Cost reduction Cost reduction Cost reduction Cost reduction Process improvement Process improvement Process improvement Sarbanes-Oxley Sarbanes-Oxley Sarbanes-Oxley Sarbanes-Oxley Sarbanes-Oxley Strategic planning Strategic planning Estimated start 4-Jan-2005 20-Jan-2005 6-Feb-2005 24-Feb-2005 8-Mar-2005 19-Mar-2005 10-Apr-2005 18-Apr-2005 12-May-2005 23-May-2005 14-Jun-2005 30-Jun-2005 16-Jan-2005 17-Jul-2005 25-Jul-2005 1-Aug-2005 20-Aug-2005 2-Sep-2005 12-Sep-2005 12-Oct-2005 24-Oct-2005 4-Nov-2005 Estimated finish 4-Mar-2005 21-Feb-2005 16-Apr-2005 25-Apr-2005 18-Mar-2005 29-Apr-2005 20-Apr-2005 12-May-2005 22-Jun-2005 21-Jul-2005 12-Aug-2005 30-Aug-2005 15-Aug-2005 1-Sep-2005 30-Sep-2005 1-Oct-2005 2-Oct-2005 12-Nov-2005 25-Nov-2005 20-Dec-2005 14-Dec-2005 24-Nov-2005 Estimated work 200 400 500 150 250 300 500 750 450 250 200 180 250 240 320 550 350 200 220 600 525 180 7,565 Duration 60 31 70 61 10 40 10 24 40 58 58 60 209 44 65 60 42 70 73 68 50 20
[Company Name] Project Performance Tracking and Reporting Company Confidential
Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Winery Coho Vineyard & Winery Contoso, Ltd. Contoso Pharmaceuticals Consolidated Messenger Fabrikam, Inc. Fourth Coffee Graphic Design Institute Humongous Insurance Litware, Inc. Lucerne Publishing Margie's Travel Northwind Traders Proseware, Inc. School of Fine Art TOTAL Actual start 4-Jan-2005 25-Jan-2005 10-Feb-2005 22-Feb-2005 9-Mar-2005 19-Mar-2005 12-Apr-2005 17-Apr-2005 15-May-2005 24-May-2005 16-Jun-2005 2-Jul-2005 18-Jan-2005 19-Jul-2005 26-Jul-2005 1-Aug-2005 28-Aug-2005 4-Sep-2005 13-Sep-2005 22-Oct-2005 14-Oct-2005 4-Nov-2005 Actual finish 9-Mar-2005 28-Feb-2005 23-Apr-2005 29-Apr-2005 28-Mar-2005 5-May-2005 27-Apr-2005 16-May-2005 24-Jun-2005 24-Jul-2005 16-Aug-2005 25-Sep-2005 16-Aug-2005 15-Sep-2005 20-Oct-2005 14-Oct-2005 21-Oct-2005 15-Nov-2005 29-Nov-2005 24-Dec-2005 10-Dec-2005 20-Nov-2005 Actual work 220 390 500 145 255 310 510 790 430 235 235 190 230 225 305 565 350 205 230 560 540 190 7,610 Actual duration 65 33 73 67 19 46 15 29 39 60 60 83 208 56 84 73 53 71 76 62 56 16
[Company Name] Project Performance Tracking and Reporting Company Confidential
Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Winery Coho Vineyard & Winery Contoso, Ltd. Contoso Pharmaceuticals Consolidated Messenger Fabrikam, Inc. Fourth Coffee Graphic Design Institute Humongous Insurance Litware, Inc. Lucerne Publishing Margie's Travel Northwind Traders Proseware, Inc. School of Fine Art TOTAL Cost TOTAL Hours $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Account manager 5,000 10,000 12,500 3,750 6,250 7,500 12,500 18,750 11,250 6,250 5,000 4,500 6,250 6,000 8,000 13,750 8,750 5,000 5,500 15,000 13,125 4,500 189,125 757 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Project manager 9,000 18,000 11,250 3,375 11,250 13,500 22,500 33,750 20,250 11,250 9,000 8,100 11,250 10,800 14,400 24,750 15,750 9,000 9,900 27,000 11,813 4,050 309,938 1,378 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Business analyst 16,000 32,000 10,000 3,000 5,000 6,000 10,000 15,000 9,000 5,000 4,000 3,600 5,000 4,800 6,400 22,000 14,000 8,000 8,800 24,000 52,500 18,000 282,100 1,411 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Process specialist 3,500 7,000 43,750 13,125 8,750 10,500 17,500 26,250 15,750 8,750 7,000 6,300 17,500 16,800 22,400 19,250 12,250 7,000 7,700 21,000 292,075 1,669 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Finance specialist 3,000 6,000 7,500 2,250 11,250 13,500 22,500 33,750 20,250 11,250 9,000 8,100 3,750 3,600 4,800 16,500 10,500 6,000 6,600 18,000 15,750 5,400 239,250 1,595 Administration staff $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000 2,000 2,500 750 1,250 1,500 2,500 3,750 2,250 1,250 1,000 900 1,250 1,200 1,600 2,750 1,750 1,000 1,100 3,000 2,625 900 37,825 757 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total 37,500 75,000 87,500 26,250 43,750 52,500 87,500 131,250 78,750 43,750 35,000 31,500 45,000 43,200 57,600 99,000 63,000 36,000 39,600 108,000 95,813 32,850 1,350,313 7,565
[Company Name] Project Performance Tracking and Reporting Company Confidential
Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Winery Coho Vineyard & Winery Contoso, Ltd. Contoso Pharmaceuticals Consolidated Messenger Fabrikam, Inc. Fourth Coffee Graphic Design Institute Humongous Insurance Litware, Inc. Lucerne Publishing Margie's Travel Northwind Traders Proseware, Inc. School of Fine Art TOTAL Cost TOTAL Hours $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Account manager 5,500 9,750 12,500 3,625 6,375 7,750 12,750 19,750 10,750 5,875 5,875 4,750 5,750 5,625 7,625 14,125 8,750 5,125 5,750 14,000 13,500 4,750 190,250 761 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Project manager 9,900 17,550 11,250 3,263 11,475 13,950 22,950 35,550 19,350 10,575 10,575 8,550 10,350 10,125 13,725 25,425 15,750 9,225 10,350 25,200 12,150 4,275 311,513 1,385 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Business analyst 17,600 31,200 10,000 2,900 5,100 6,200 10,200 15,800 8,600 4,700 4,700 3,800 4,600 4,500 6,100 22,600 14,000 8,200 9,200 22,400 54,000 19,000 285,400 1,427 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Process specialist 3,850 6,825 43,750 12,688 8,925 10,850 17,850 27,650 15,050 8,225 8,225 6,650 16,100 15,750 21,350 19,775 12,250 7,175 8,050 19,600 290,588 1,661 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Finance specialist 3,300 5,850 7,500 2,175 11,475 13,950 22,950 35,550 19,350 10,575 10,575 8,550 3,450 3,375 4,575 16,950 10,500 6,150 6,900 16,800 16,200 5,700 242,400 1,616 Administration staff $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,100 1,950 2,500 725 1,275 1,550 2,550 3,950 2,150 1,175 1,175 950 1,150 1,125 1,525 2,825 1,750 1,025 1,150 2,800 2,700 950 38,050 761 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total 41,250 73,125 87,500 25,375 44,625 54,250 89,250 138,250 75,250 41,125 41,125 33,250 41,400 40,500 54,900 101,700 63,000 36,900 41,400 100,800 98,550 34,675 1,358,200 7,610
Hours per Skill Type
1,800
1,600
1,400 1,200
Hours
1,000 800 600 400 200 Account manager Project manager Business analyst Process specialist Finance specialist Administration staff
Planned Hours
Actual Hours
Billings per Skill Type
$350,000
$300,000
$250,000
Billings
$200,000
$150,000
$100,000
$50,000
$Account manager Project manager Business analyst Process specialist
Actual Billings
Finance specialist
Administration staff
Planned Billings