project team budget calculator

Budget to Actual Worksheet FORMULAS IN BLUE COLUMNS; DO NOT INSERT NUMBERS [Insert Project Name] Cost Item Budget Total Budget This Period [insert month, quarter, FY] Actual This Period [insert month, quarter, FY] Budget This Period [insert month, quarter, FY] Actual This Period [insert month, quarter, FY] Actual Total Budget Remaining Percent Budget Remaining Hardware $0 $0 $0 $0 $0 $0 $0 #DIV/0! Software $0 $0 $0 $0 $0 $0 $0 #DIV/0! Facilities $0 $0 $0 $0 $0 $0 $0 #DIV/0! Supplies $0 $0 $0 $0 $0 $0 $0 #DIV/0! Telecommunications $0 $0 $0 $0 $0 $0 $0 #DIV/0! Network $0 $0 $0 $0 $0 $0 $0 #DIV/0! Documentation $0 $0 $0 $0 $0 $0 $0 #DIV/0! Operations, Maintenance $0 $0 $0 $0 $0 $0 $0 #DIV/0! Other Non-Personnel $0 $0 $0 $0 $0 $0 $0 #DIV/0! Consultants (see Vendor Worksheet) $0 $0 $0 $0 $0 $0 $0 #DIV/0! Sub-Total Non-Personnel $0 $0 $0 $0 $0 $0 $0 #DIV/0! Employees (see Personnel Worksheet) $0 $0 $0 $0 $0 $0 $0 #DIV/0! Other Personnel $0 $0 $0 $0 $0 $0 $0 #DIV/0! Sub-Total Personnel $0 $0 $0 $0 $0 $0 $0 #DIV/0! Total $0 $0 $0 $0 $0 $0 $0 #DIV/0! Template-Budget to Actual Worksheet v1 7-19-05 2/5/2008 1Consultants Cost Worksheet for [insert name] Deliverable FORMULAS IN BLUE COLUMNS; DO NOT INSERT NUMBERS Role Cost Per Hour Number of Persons Total Budgeted Hours [insert month, quarter, FY] Total Budgeted Cost Hours This Period [insert month, quarter, FY] Total Hours Remaining Total % Used Actual Cost this Period Budget Remaining Project Manager $0 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Sr. Development Manager $1 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Sr. Developer $2 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Developer $3 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Tester $4 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Sr. DBA $5 0 0 $0 0.00 0.00 #DIV/0! $0 $0 DBA $6 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Trainer $7 0 0 $0 0.00 0.00 #DIV/0! $0 $0 QA/QC Lead $8 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Business Analysts $0 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Total 0 0 $0 0 0 #DIV/0! $0 $0 Template-Consultants Cost Worksheet v1 7-19-05 2/5/2008 2Employees Cost Worksheet for [insert name] Deliverable FORMULAS IN BLUE COLUMNS; DO NOT INSERT NUMBERS Role Cost Per Hour Number of Persons Total Budgeted Hours [insert month, quarter, FY] Total Budgeted Cost Hours This Period [insert month, quarter, FY] Total Hours Remaining Total % Used Actual Cost this Period Budget Remaining Project Manager $0 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Sr. Development Manager $1 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Sr. Developer $2 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Developer $3 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Tester $4 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Sr. DBA $5 0 0 $0 0.00 0.00 #DIV/0! $0 $0 DBA $6 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Trainer $7 0 0 $0 0.00 0.00 #DIV/0! $0 $0 QA/QC Lead $8 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Executive $9 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Support (HR, fiscal, facilities) $10 0 0 $0 0.00 0.00 #DIV/0! $0 $0 Total 0 0 0 0.00 0.00 #DIV/0! $0 $0 Template-Employees Cost Worksheet v1 7-19-05 2/5/2008 3