[Company Name] Project Parameters Company Confidential
[Date] Gray cells will be calculated for you. You do not need to enter anything in 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% $150 Administrative staff 10% 10% 10% 10% 10% 10% $50 Total 100% 100% 100% 100% 100% 100%
$175
[Company Name] Project Planning Company Confidential
Gray cells will be calculated for you. You do not need to enter anything in them. Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Vineyard & Winery Coho Winery Consolidated Messenger Contoso, Ltd. Contoso Pharmaceuticals 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 HOURS Project type Business continuity planning Business process re-engineering Cost reduction Process improvement Cost reduction Sarbanes-Oxley Strategic planning Sarbanes-Oxley Cost reduction Process improvement Cost reduction Business process re-engineering Cost reduction Sarbanes-Oxley Sarbanes-Oxley Cost reduction Strategic planning Business continuity planning Cost reduction Process improvement Sarbanes-Oxley Cost reduction Estimated start 4-Jan-2005 20-Jan-2005 6-Feb-2005 24-Feb-2005 8-Mar-2005 19-Mar-2005 10-Apr-2005 12-May-2005 18-Apr-2005 30-Jun-2005 23-May-2005 14-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 22-Jun-2005 12-May-2005 30-Aug-2005 21-Jul-2005 12-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 (hours) 200 400 500 150 250 300 500 450 750 180 250 200 250 240 320 550 350 200 220 600 525 180 7,565 Duration (days) 60 31 70 61 10 40 10 40 24 60 58 58 209 44 65 60 42 70 73 68 50 20
[Company Name] Project Tracking Company Confidential
Gray cells will be calculated for you. You do not need to enter anything in them. Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Vineyard & Winery Coho Winery Consolidated Messenger Contoso, Ltd. Contoso Pharmaceuticals 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 HOURS 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 (hours) 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 (days) 65 33 73 67 19 46 15 29 39 60 60 83 208 56 84 73 53 71 76 62 56 16
[Company Name] Planned Project Totals Company Confidential
Gray cells will be calculated for you. You do not need to enter anything in them. Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Vineyard & Winery Coho Winery Consolidated Messenger Contoso, Ltd. Contoso Pharmaceuticals 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 11,250 18,750 4,500 6,250 5,000 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 9,000 22,500 6,750 11,250 13,500 11,250 20,250 33,750 8,100 11,250 4,500 11,250 10,800 14,400 24,750 7,875 9,000 9,900 27,000 23,625 8,100 307,800 1,368 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Business analyst 16,000 8,000 10,000 3,000 5,000 12,000 50,000 18,000 15,000 3,600 5,000 4,000 5,000 9,600 12,800 11,000 35,000 16,000 4,400 12,000 21,000 3,600 280,000 1,400 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Process specialist 3,500 35,000 17,500 10,500 8,750 10,500 — 15,750 26,250 12,600 8,750 17,500 8,750 8,400 11,200 19,250 — 3,500 7,700 42,000 18,375 6,300 292,075 1,669 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Finance specialist 3,000 6,000 22,500 2,250 11,250 9,000 15,000 13,500 33,750 2,700 11,250 3,000 11,250 7,200 9,600 24,750 10,500 3,000 9,900 9,000 15,750 8,100 242,250 1,615 Administrative staff $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000 2,000 2,500 750 1,250 1,500 2,500 2,250 3,750 900 1,250 1,000 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 70,000 87,500 27,000 43,750 54,000 91,250 81,000 131,250 32,400 43,750 35,000 43,750 43,200 57,600 96,250 63,875 37,500 38,500 108,000 94,500 31,500 1,349,075 7,565
[Company Name] Actual Project Totals Company Confidential
Gray cells will be calculated for you. You do not need to enter anything in them. Project name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Vineyard & Winery Coho Winery Consolidated Messenger Contoso, Ltd. Contoso Pharmaceuticals 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 8,775 22,500 6,525 11,475 13,950 11,475 35,550 19,350 10,575 10,575 4,275 10,350 10,125 13,725 25,425 7,875 9,225 10,350 25,200 24,300 8,550 310,050 1,378 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Business analyst 17,600 7,800 10,000 2,900 5,100 12,400 51,000 31,600 8,600 4,700 4,700 3,800 4,600 9,000 12,200 11,300 35,000 16,400 4,600 11,200 21,600 3,800 289,900 1,450 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Process specialist 3,850 34,125 17,500 10,150 8,925 10,850 — 27,650 15,050 16,450 8,225 16,625 8,050 7,875 10,675 19,775 — 3,588 8,050 39,200 18,900 6,650 292,163 1,670 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Finance specialist 3,300 5,850 22,500 2,175 11,475 9,300 15,300 23,700 19,350 3,525 10,575 2,850 10,350 6,750 9,150 25,425 10,500 3,075 10,350 8,400 16,200 8,550 238,650 1,591 Administrative 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 68,250 87,500 26,100 44,625 55,800 93,075 142,200 75,250 42,300 41,125 33,250 40,250 40,500 54,900 98,875 63,875 38,438 40,250 100,800 97,200 33,250 1,359,063 7,610
Hours per Skill Type
Planned Hours Actual Hours
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 Administrative staff
Billing per Skill Type
Planned Billings Actual Billings
$350,000
$300,000
$250,000
Billing
$200,000
$150,000
$100,000
$50,000
$— Account manager Project manager Business analyst Process specialist Finance specialist Administrative staff