ABC Company Project Parameters Company Confidential
1/3/2005
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,000
Project Manager 20% 10% 20% 20% 20% 10% $225,000
Business Analyst 40% 10% 10% 10% 20% 50% $200,000
Process Specialist 10% 50% 20% 40% 20%
Finance Specialist 10% 10% 30% 10% 20% 20% $150,000
Administrative Staff 10% 10% 10% 10% 10% 10% $50,000
Total 100% 100% 100% 100% 100% 100%
$175,000
ABC Company 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
ABC Company 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
ABC Company 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,000 10,000,000 12,500,000 3,750,000 6,250,000 7,500,000 12,500,000 11,250,000 18,750,000 4,500,000 6,250,000 5,000,000 6,250,000 6,000,000 8,000,000 13,750,000 8,750,000 5,000,000 5,500,000 15,000,000 13,125,000 4,500,000 189,125,000 757 Project Manager $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 9,000,000 9,000,000 22,500,000 6,750,000 11,250,000 13,500,000 11,250,000 20,250,000 33,750,000 8,100,000 11,250,000 4,500,000 11,250,000 10,800,000 14,400,000 24,750,000 7,875,000 9,000,000 9,900,000 27,000,000 23,625,000 8,100,000 307,800,000 1,368 Business Analyst $ 16,000,000 $ 8,000,000 $ 10,000,000 $ 3,000,000 $ 5,000,000 $ 12,000,000 $ 50,000,000 $ 18,000,000 $ 15,000,000 $ 3,600,000 $ 5,000,000 $ 4,000,000 $ 5,000,000 $ 9,600,000 $ 12,800,000 $ 11,000,000 $ 35,000,000 $ 16,000,000 $ 4,400,000 $ 12,000,000 $ 21,000,000 $ 3,600,000 $ 280,000,000 1,400 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Process Specialist 3,500,000 35,000,000 17,500,000 10,500,000 8,750,000 10,500,000 — 15,750,000 26,250,000 12,600,000 8,750,000 17,500,000 8,750,000 8,400,000 11,200,000 19,250,000 — 3,500,000 7,700,000 42,000,000 18,375,000 6,300,000 292,075,000 1,669 Finance Specialist $ 3,000,000 $ 6,000,000 $ 22,500,000 $ 2,250,000 $ 11,250,000 $ 9,000,000 $ 15,000,000 $ 13,500,000 $ 33,750,000 $ 2,700,000 $ 11,250,000 $ 3,000,000 $ 11,250,000 $ 7,200,000 $ 9,600,000 $ 24,750,000 $ 10,500,000 $ 3,000,000 $ 9,900,000 $ 9,000,000 $ 15,750,000 $ 8,100,000 $ 242,250,000 1,615 Administrative Staff $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000,000 2,000,000 2,500,000 750,000 1,250,000 1,500,000 2,500,000 2,250,000 3,750,000 900,000 1,250,000 1,000,000 1,250,000 1,200,000 1,600,000 2,750,000 1,750,000 1,000,000 1,100,000 3,000,000 2,625,000 900,000 37,825,000 757 Total $ 37,500,000 $ 70,000,000 $ 87,500,000 $ 27,000,000 $ 43,750,000 $ 54,000,000 $ 91,250,000 $ 81,000,000 $ 131,250,000 $ 32,400,000 $ 43,750,000 $ 35,000,000 $ 43,750,000 $ 43,200,000 $ 57,600,000 $ 96,250,000 $ 63,875,000 $ 37,500,000 $ 38,500,000 $ 108,000,000 $ 94,500,000 $ 31,500,000 $ 1,349,075,000 7,565
ABC Company 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,000 $ 9,750,000 $ 12,500,000 $ 3,625,000 $ 6,375,000 $ 7,750,000 $ 12,750,000 $ 19,750,000 $ 10,750,000 $ 5,875,000 $ 5,875,000 $ 4,750,000 $ 5,750,000 $ 5,625,000 $ 7,625,000 $ 14,125,000 $ 8,750,000 $ 5,125,000 $ 5,750,000 $ 14,000,000 $ 13,500,000 $ 4,750,000 $ 190,250,000 761 Project Manager $ 9,900,000 $ 8,775,000 $ 22,500,000 $ 6,525,000 $ 11,475,000 $ 13,950,000 $ 11,475,000 $ 35,550,000 $ 19,350,000 $ 10,575,000 $ 10,575,000 $ 4,275,000 $ 10,350,000 $ 10,125,000 $ 13,725,000 $ 25,425,000 $ 7,875,000 $ 9,225,000 $ 10,350,000 $ 25,200,000 $ 24,300,000 $ 8,550,000 $310,050,000 1,378 Business Analyst $ 17,600,000 $ 7,800,000 $ 10,000,000 $ 2,900,000 $ 5,100,000 $ 12,400,000 $ 51,000,000 $ 31,600,000 $ 8,600,000 $ 4,700,000 $ 4,700,000 $ 3,800,000 $ 4,600,000 $ 9,000,000 $ 12,200,000 $ 11,300,000 $ 35,000,000 $ 16,400,000 $ 4,600,000 $ 11,200,000 $ 21,600,000 $ 3,800,000 $ 289,900,000 1,450 Process Specialist $ 3,850,000 $ 34,125,000 $ 17,500,000 $ 10,150,000 $ 8,925,000 $ 10,850,000 $ — $ 27,650,000 $ 15,050,000 $ 16,450,000 $ 8,225,000 $ 16,625,000 $ 8,050,000 $ 7,875,000 $ 10,675,000 $ 19,775,000 $ — $ 3,587,500 $ 8,050,000 $ 39,200,000 $ 18,900,000 $ 6,650,000 $ 292,162,500 1,670 Finance Specialist $ 3,300,000 $ 5,850,000 $ 22,500,000 $ 2,175,000 $ 11,475,000 $ 9,300,000 $ 15,300,000 $ 23,700,000 $ 19,350,000 $ 3,525,000 $ 10,575,000 $ 2,850,000 $ 10,350,000 $ 6,750,000 $ 9,150,000 $ 25,425,000 $ 10,500,000 $ 3,075,000 $ 10,350,000 $ 8,400,000 $ 16,200,000 $ 8,550,000 $ 238,650,000 1,591 Administrative Staff $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,100,000 1,950,000 2,500,000 725,000 1,275,000 1,550,000 2,550,000 3,950,000 2,150,000 1,175,000 1,175,000 950,000 1,150,000 1,125,000 1,525,000 2,825,000 1,750,000 1,025,000 1,150,000 2,800,000 2,700,000 950,000 38,050,000 761 Total $ 41,250,000 $ 68,250,000 $ 87,500,000 $ 26,100,000 $ 44,625,000 $ 55,800,000 $ 93,075,000 $ 142,200,000 $ 75,250,000 $ 42,300,000 $ 41,125,000 $ 33,250,000 $ 40,250,000 $ 40,500,000 $ 54,900,000 $ 98,875,000 $ 63,875,000 $ 38,437,500 $ 40,250,000 $ 100,800,000 $ 97,200,000 $ 33,250,000 $ 1,359,062,500 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,000 $300,000,000 $250,000,000
Billing
$200,000,000 $150,000,000 $100,000,000 $50,000,000 $—