KEMBAR78
Project Cost Tracking Excel Template | PDF | Software | Computing
Scribd
Upload
120 views4 pages

Project Cost Tracking Excel Template

The document outlines the estimated costs for a project including human resources and other resources like servers and printers over a 9 month period broken down by week. It estimates the total costs for human resources will be $616,500, other resources will be $135,000, and the grand total including a 10% contingency will be $826,650.

Uploaded by

HemantSharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
120 views4 pages

Project Cost Tracking Excel Template

The document outlines the estimated costs for a project including human resources and other resources like servers and printers over a 9 month period broken down by week. It estimates the total costs for human resources will be $616,500, other resources will be $135,000, and the grand total including a 10% contingency will be $826,650.

Uploaded by

HemantSharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Project Team Rate (Daily) 1-Jun 8-Jun 15-Jun 22-Jun 29-Jun 6-Jul 13-Jul 20-Jul 27-Jul

John C $1,200 5 5 5 5 5 5 5 5 5

Richard Gale $800 5 5 5 5 5 5 5 5 5

Neel Wale $800 5 5 5 5 5 5 5 5 5

Sheen John $750 5 5 5 5 5 5 5 5 5

Rachel Rade $850 5 5 5 5 5 5 5 5 5

Rob Roy $850 5 5 5 5 5 5 5 5 5

Clacy Mike $950 5 5 5 5 5 5 5 5 5

John Temper $650 5 5 5 5 5 5 5 5 5


$34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250

Other Resources 1-Jun 8-Jun 15-Jun 22-Jun 29-Jun 6-Jul 13-Jul 20-Jul 27-Jul
Rate (Daily)
Remote Server $1,200 5 5 5 5 5 5 5 5 5

Printer $300 5 5 5 5 5 5 5 5 5

$7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500

Total Costs
Human Resources $616,500
Other Resources $135,000
Other Expenses $0
Total $751,500
Contingency (%) 10
Contingency Amount $75,150
Grand Total $826,650
3-Aug 10-Aug 17-Aug 24-Aug 31-Aug 7-Sep 14-Sep 21-Sep 28-Sep Cost
5 5 5 5 5 5 5 5 5 $108,000
5 5 5 5 5 5 5 5 5 $72,000
5 5 5 5 5 5 5 5 5 $72,000
5 5 5 5 5 5 5 5 5 $67,500
5 5 5 5 5 5 5 5 5 $76,500
5 5 5 5 5 5 5 5 5 $76,500
5 5 5 5 5 5 5 5 5 $85,500
5 5 5 5 5 5 5 5 5 $58,500
$34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $616,500

3-Aug 10-Aug 17-Aug 24-Aug 31-Aug 7-Sep 14-Sep 21-Sep 28-Sep Cost
5 5 5 5 5 5 5 5 5 $108,000
5 5 5 5 5 5 5 5 5 $27,000
$0
$0
$7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $135,000

$616,500
$135,000
$0
$751,500
10
$75,150
$826,650
Project Team Rate (Daily) 1-Jun 8-Jun 15-Jun 22-Jun 29-Jun 6-Jul 13-Jul 20-Jul 27-Jul

John C $1,200 5 5 5 5 5 5 5 5 5

Richard Gale $800 5 5 5 5 5 5 5 5 5

Neel Wale $800 5 5 5 5 5 5 5 5 5

Sheen John $750 5 5 5 5 5 5 5 5 5

Rachel Rade $850 5 5 5 5 5 5 5 5 5

Rob Roy $850 5 5 5 5 5 5 5 5 5

Clacy Mike $950 5 5 5 5 5 5 5 5 5

John Temper $650 5 5 5 5 5 5 5 5 5


$34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250

Other Resources 1-Jun 8-Jun 15-Jun 22-Jun 29-Jun 6-Jul 13-Jul 20-Jul 27-Jul
Rate (Daily)
Remote Server $1,200 5 5 5 5 5 5 5 5 5

Printer $300 5 5 5 5 5 5 5 5 5

$7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500

Total Costs Estimated


Human Resources $616,500
Other Resources $135,000
Other Expenses $0
Total $751,500
Contingency (%) 10
Contingency Amount $75,150
Grand Total $826,650
3-Aug 10-Aug 17-Aug 24-Aug 31-Aug 7-Sep 14-Sep 21-Sep 28-Sep Cost
5 5 5 5 5 5 5 5 5 $108,000
5 5 5 5 5 5 5 5 5 $72,000
5 5 5 5 5 5 5 5 5 $72,000
5 5 5 5 5 5 5 5 5 $67,500
5 5 5 5 5 5 5 5 5 $76,500
5 5 5 5 5 5 5 5 5 $76,500
5 5 5 5 5 5 5 5 5 $85,500
5 5 5 5 5 5 5 5 5 $58,500
$34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $34,250 $616,500

3-Aug 10-Aug 17-Aug 24-Aug 31-Aug 7-Sep 14-Sep 21-Sep 28-Sep Cost
5 5 5 5 5 5 5 5 5 $108,000
5 5 5 5 5 5 5 5 5 $27,000
$0
$0
$7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $135,000

Estimated Actual
$616,500 $616,500
$135,000 $135,000
$0 $0
$751,500 $751,500
10 10
$75,150 $75,150
$826,650 $826,650

You might also like