Project Tracking Excel Template

Billing Chart Hours Chart Actual Project Totals Planned Project Totals Project Tracking Project Planning Project Parameters error Project_type Company Confidential A. Datum Corporation Adventure Works Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Winery Coho Vineyard & Winery 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 Sarbanes-Oxley Total TOTAL Cost TOTAL Hours [Company Name] [Date] Project name Project type Estimated start Estimated finish Business continuity planning Business process re-engineering Cost reduction Process improvement Strategic planning Account manager Project manager Business analyst Process specialist Finance specialist Actual start Actual finish Estimated work (hours) Duration (days) Project Parameters Project Planning Project Tracking Planned Project Totals Actual Project Totals Actual work (hours) Actual duration (days) Blended rates Gray cells will be calculated for you. You do not need to enter anything in them. Alpine Ski House Contoso, Ltd. Administrative staff TOTAL HOURS Planned Billings Actual Billings Billing Billing per Skill Type Account manager Account manager Project manager Project manager Business analyst Business analyst Process specialist Process specialist Finance specialist Finance specialist Administrative staff Administrative staff 189125.00 190250.00 307800.00 310050.00 280000.00 289900.00 292075.00 292162.50 242250.00 238650.00 37825.00 38050.00 Planned Hours Actual Hours Hours Hours per Skill Type Account manager Project manager Business analyst Process specialist Finance specialist Administrative staff 756.50 761.00 1368.00 1378.00 1400.00 1449.50 1669.00 1669.50 1615.00 1591.00 756.50 761.00 [Company Name] Project name Account manager Project manager Business analyst Process specialist Finance specialist Administrative staff A. Datum Corporation $5,500.00 $9,900.00 $17,600.00 $3,850.00 $3,300.00 $1,100.00 $41,250.00 Adventure Works $9,750.00 $8,775.00 $7,800.00 $34,125.00 $5,850.00 $1,950.00 $68,250.00 Alpine Ski House $12,500.00 $22,500.00 $10,000.00 $17,500.00 $22,500.00 $2,500.00 $87,500.00 Baldwin Museum of Science $3,625.00 $6,525.00 $2,900.00 $10,150.00 $2,175.00 $725.00 $26,100.00 Blue Yonder Airlines $6,375.00 $11,475.00 $5,100.00 $8,925.00 $11,475.00 $1,275.00 $44,625.00 City Power & Light $7,750.00 $13,950.00 $12,400.00 $10,850.00 $9,300.00 $1,550.00 $55,800.00 Coho Vineyard $12,750.00 $11,475.00 $51,000.00 $0.00 $15,300.00 $2,550.00 $93,075.00 Coho Vineyard & Winery $19,750.00 $35,550.00 $31,600.00 $27,650.00 $23,700.00 $3,950.00 $142,200.00 Coho Winery $10,750.00 $19,350.00 $8,600.00 $15,050.00 $19,350.00 $2,150.00 $75,250.00 Consolidated Messenger $5,875.00 $10,575.00 $4,700.00 $16,450.00 $3,525.00 $1,175.00 $42,300.00 Contoso, Ltd. $5,875.00 $10,575.00 $4,700.00 $8,225.00 $10,575.00 $1,175.00 $41,125.00 Contoso Pharmaceuticals $4,750.00 $4,275.00 $3,800.00 $16,625.00 $2,850.00 $950.00 $33,250.00 Fabrikam, Inc. $5,750.00 $10,350.00 $4,600.00 $8,050.00 $10,350.00 $1,150.00 $40,250.00 Fourth Coffee $5,625.00 $10,125.00 $9,000.00 $7,875.00 $6,750.00 $1,125.00 $40,500.00 Graphic Design Institute $7,625.00 $13,725.00 $12,200.00 $10,675.00 $9,150.00 $1,525.00 $54,900.00 Humongous Insurance $14,125.00 $25,425.00 $11,300.00 $19,775.00 $25,425.00 $2,825.00 $98,875.00 Litware, Inc. $8,750.00 $7,875.00 $35,000.00 $0.00 $10,500.00 $1,750.00 $63,875.00 Lucerne Publishing $5,125.00 $9,225.00 $16,400.00 $3,587.50 $3,075.00 $1,025.00 $38,437.50 Margie's Travel $5,750.00 $10,350.00 $4,600.00 $8,050.00 $10,350.00 $1,150.00 $40,250.00 Northwind Traders $14,000.00 $25,200.00 $11,200.00 $39,200.00 $8,400.00 $2,800.00 $100,800.00 Proseware, Inc. $13,500.00 $24,300.00 $21,600.00 $18,900.00 $16,200.00 $2,700.00 $97,200.00 School of Fine Art $4,750.00 $8,550.00 $3,800.00 $6,650.00 $8,550.00 $950.00 $33,250.00 $190,250.00 $310,050.00 $289,900.00 $292,162.50 $238,650.00 $38,050.00 $1,359,062.50 761.00 1378.00 1449.50 1669.50 1591.00 761.00 7610.00 [Company Name] Project name Account manager Project manager Business analyst Process specialist Finance specialist Administrative staff A. Datum Corporation $5,000.00 $9,000.00 $16,000.00 $3,500.00 $3,000.00 $1,000.00 $37,500.00 Adventure Works $10,000.00 $9,000.00 $8,000.00 $35,000.00 $6,000.00 $2,000.00 $70,000.00 Alpine Ski House $12,500.00 $22,500.00 $10,000.00 $17,500.00 $22,500.00 $2,500.00 $87,500.00 Baldwin Museum of Science $3,750.00 $6,750.00 $3,000.00 $10,500.00 $2,250.00 $750.00 $27,000.00 Blue Yonder Airlines $6,250.00 $11,250.00 $5,000.00 $8,750.00 $11,250.00 $1,250.00 $43,750.00 City Power & Light $7,500.00 $13,500.00 $12,000.00 $10,500.00 $9,000.00 $1,500.00 $54,000.00 Coho Vineyard $12,500.00 $11,250.00 $50,000.00 $0.00 $15,000.00 $2,500.00 $91,250.00 Coho Vineyard & Winery $11,250.00 $20,250.00 $18,000.00 $15,750.00 $13,500.00 $2,250.00 $81,000.00 Coho Winery $18,750.00 $33,750.00 $15,000.00 $26,250.00 $33,750.00 $3,750.00 $131,250.00 Consolidated Messenger $4,500.00 $8,100.00 $3,600.00 $12,600.00 $2,700.00 $900.00 $32,400.00 Contoso, Ltd. $6,250.00 $11,250.00 $5,000.00 $8,750.00 $11,250.00 $1,250.00 $43,750.00 Contoso Pharmaceuticals $5,000.00 $4,500.00 $4,000.00 $17,500.00 $3,000.00 $1,000.00 $35,000.00 Fabrikam, Inc. $6,250.00 $11,250.00 $5,000.00 $8,750.00 $11,250.00 $1,250.00 $43,750.00 Fourth Coffee $6,000.00 $10,800.00 $9,600.00 $8,400.00 $7,200.00 $1,200.00 $43,200.00 Graphic Design Institute $8,000.00 $14,400.00 $12,800.00 $11,200.00 $9,600.00 $1,600.00 $57,600.00 Humongous Insurance $13,750.00 $24,750.00 $11,000.00 $19,250.00 $24,750.00 $2,750.00 $96,250.00 Litware, Inc. $8,750.00 $7,875.00 $35,000.00 $0.00 $10,500.00 $1,750.00 $63,875.00 Lucerne Publishing $5,000.00 $9,000.00 $16,000.00 $3,500.00 $3,000.00 $1,000.00 $37,500.00 Margie's Travel $5,500.00 $9,900.00 $4,400.00 $7,700.00 $9,900.00 $1,100.00 $38,500.00 Northwind Traders $15,000.00 $27,000.00 $12,000.00 $42,000.00 $9,000.00 $3,000.00 $108,000.00 Proseware, Inc. $13,125.00 $23,625.00 $21,000.00 $18,375.00 $15,750.00 $2,625.00 $94,500.00 School of Fine Art $4,500.00 $8,100.00 $3,600.00 $6,300.00 $8,100.00 $900.00 $31,500.00 $189,125.00 $307,800.00 $280,000.00 $292,075.00 $242,250.00 $37,825.00 $1,349,075.00 756.50 1368.00 1400.00 1669.00 1615.00 756.50 7565.00 [Company Name] Project name A. Datum Corporation 1/4/2005 3/9/2005 220.00 65.00 Adventure Works 1/25/2005 2/28/2005 390.00 33.00 Alpine Ski House 2/10/2005 4/23/2005 500.00 73.00 Baldwin Museum of Science 2/22/2005 4/29/2005 145.00 67.00 Blue Yonder Airlines 3/9/2005 3/28/2005 255.00 19.00 City Power & Light 3/19/2005 5/5/2005 310.00 46.00 Coho Vineyard 4/12/2005 4/27/2005 510.00 15.00 Coho Vineyard & Winery 4/17/2005 5/16/2005 790.00 29.00 Coho Winery 5/15/2005 6/24/2005 430.00 39.00 Consolidated Messenger 5/24/2005 7/24/2005 235.00 60.00 Contoso, Ltd. 6/16/2005 8/16/2005 235.00 60.00 Contoso Pharmaceuticals 7/2/2005 9/25/2005 190.00 83.00 Fabrikam, Inc. 1/18/2005 8/16/2005 230.00 208.00 Fourth Coffee 7/19/2005 9/15/2005 225.00 56.00 Graphic Design Institute 7/26/2005 10/20/2005 305.00 84.00 Humongous Insurance 8/1/2005 10/14/2005 565.00 73.00 Litware, Inc. 8/28/2005 10/21/2005 350.00 53.00 Lucerne Publishing 9/4/2005 11/15/2005 205.00 71.00 Margie's Travel 9/13/2005 11/29/2005 230.00 76.00 Northwind Traders 10/22/2005 12/24/2005 560.00 62.00 Proseware, Inc. 10/14/2005 12/10/2005 540.00 56.00 School of Fine Art 11/4/2005 11/20/2005 190.00 16.00 7610.00 [Company Name] 1/4/2005 3/4/2005 200.00 60.00 1/20/2005 2/21/2005 400.00 31.00 2/6/2005 4/16/2005 500.00 70.00 2/24/2005 4/25/2005 150.00 61.00 3/8/2005 3/18/2005 250.00 10.00 3/19/2005 4/29/2005 300.00 40.00 4/10/2005 4/20/2005 500.00 10.00 5/12/2005 6/22/2005 450.00 40.00 4/18/2005 5/12/2005 750.00 24.00 6/30/2005 8/30/2005 180.00 60.00 5/23/2005 7/21/2005 250.00 58.00 6/14/2005 8/12/2005 200.00 58.00 1/16/2005 8/15/2005 250.00 209.00 7/17/2005 9/1/2005 240.00 44.00 7/25/2005 9/30/2005 320.00 65.00 8/1/2005 10/1/2005 550.00 60.00 8/20/2005 10/2/2005 350.00 42.00 9/2/2005 11/12/2005 200.00 70.00 9/12/2005 11/25/2005 220.00 73.00 10/12/2005 12/20/2005 600.00 68.00 10/24/2005 12/14/2005 525.00 50.00 11/4/2005 11/24/2005 180.00 20.00 7565.00 0.10 0.20 0.40 0.10 0.10 0.10 1.00 0.10 0.10 0.10 0.50 0.10 0.10 1.00 0.10 0.20 0.10 0.20 0.30 0.10 1.00 0.10 0.20 0.10 0.40 0.10 0.10 1.00 0.10 0.20 0.20 0.20 0.20 0.10 1.00 0.10 0.10 0.50 0.00 0.20 0.10 1.00 $250.00 $225.00 $200.00 $175.00 $150.00 $50.00