Short acrivity
mbo87
project_budget_template_2.xlsxSource of Project Cost
| Source of Project Cost | ||||||||
| PROJECT TASKS | LABOR HOURS | LABOR COST ($) | MATERIAL COST ($) | TRAVEL COST ($) | OTHER COST ($) | TOTAL PER TASK | ||
| PROJECT DESIGN | Develop Functional Specifications | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Develop System Architecture | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Develop Preliminary Design Specification | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Develop Detailed Design Specifications | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Develop Acceptance Test Plan | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| PROJECT DEVELOPMENT | Develop Components | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Procure Software | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Procure Hardware | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Development Acceptance Test Package | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Perform Unit/Integration Test | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| PROJECT DELIVERY | Install System | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Train Customers | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Perform Acceptance Test | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Perform Post Project Review | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Provide Warranty Support | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Archive Materials | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| PROJECT MANAGEMENT | Customer Progress Meetings/Reports | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Internal Status Meetings/Reports | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Third-Party Vendor Interface | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Interface to Other Internal Departments | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Configuration Management | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Quality Assurance | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Overall Project Management | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| OTHER COST | Other cost | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Other cost | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Other cost | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotal | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Subtotals | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Risk (Contingency) | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Total (Scheduled) | 0.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Expenditures Over Time
| Expenditures Over Time | ||||||
| ITEM | COST | DATE | REASON FOR EXPENDITURE | |||
| INSTALLATION | Install System | $0.00 | ||||
| Train Customers | $0.00 | |||||
| Perform Acceptance Test | $0.00 | |||||
| Perform Post Project Review | $0.00 | |||||
| Provide Warranty Support | $0.00 | |||||
| Achieve Materials | $0.00 | |||||
| Subtotal | $0.00 | |||||
| PLANNING (RFP) | Install System | $0.00 | ||||
| Train Customers | $0.00 | |||||
| Perform Acceptance Test | $0.00 | |||||
| Perform Post Project Review | $0.00 | |||||
| Provide Warranty Support | $0.00 | |||||
| Achieve Materials | $0.00 | |||||
| Subtotal | $0.00 | |||||
| PLANNING 2 | Install System | $0.00 | ||||
| Train Customers | $0.00 | |||||
| Perform Acceptance Test | $0.00 | |||||
| Perform Post Project Review | $0.00 | |||||
| Provide Warranty Support | $0.00 | |||||
| Achieve Materials | $0.00 | |||||
| Subtotal | $0.00 | |||||
| CONSTRUCTION | Install System | $0.00 | ||||
| Train Customers | $0.00 | |||||
| Perform Acceptance Test | $0.00 | |||||
| Perform Post Project Review | $0.00 | |||||
| Provide Warranty Support | $0.00 | |||||
| Achieve Materials | $0.00 | |||||
| Subtotal | $0.00 | |||||
| TEST & DELIVERY | Install System | $0.00 | ||||
| Train Customers | $0.00 | |||||
| Perform Acceptance Test | $0.00 | |||||
| Perform Post Project Review | $0.00 | |||||
| Provide Warranty Support | $0.00 | |||||
| Achieve Materials | $0.00 | |||||
| Subtotal | $0.00 | |||||
| PROJECT TOTAL | $0.00 |
Cumulative Project Costs
| Projected vs. Actual Costs | ||||||||||||||||
| MONTHLY COST | ||||||||||||||||
| CUMULATIVE COST | ||||||||||||||||
MONTH OF PROJECT
COST
ACTUAL MONTHLY COST 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1610 3190 1930 1370 3680 1180 2390 4040 1330 1140 4210 3910 1580 3850 4000 3700 2900 1870 2180 2790 2550 3890 1850 1740 PROJECTED MONTHLY COST 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1940 1480 1390 4030 3640 2480 3040 2160 1600 2300 3070 2300 1920 3140 2850 2060 1760 3740 3670 3230 2140 1260 3750 2880
MONTH OF PROJECT
COST
Data Worksheet
| Project Data Worksheet | ||||||
| MONTH | PROJECTED MONTHLY COST | ACTUAL MONTHLY COST | PROJECTED CUMULATIVE COST | ACTUAL CUMULATIVE COST | ||
| 1 | $1,940.00 | $1,610.00 | $2,360.00 | $2,750.00 | ||
| 2 | $1,480.00 | $3,190.00 | $1,490.00 | $2,950.00 | ||
| 3 | $1,390.00 | $1,930.00 | $1,720.00 | $2,510.00 | ||
| 4 | $4,030.00 | $1,370.00 | $1,590.00 | $2,330.00 | ||
| 5 | $3,640.00 | $3,680.00 | $4,040.00 | $3,650.00 | ||
| 6 | $2,480.00 | $1,180.00 | $3,430.00 | $1,840.00 | ||
| 7 | $3,040.00 | $2,390.00 | $1,700.00 | $1,660.00 | ||
| 8 | $2,160.00 | $4,040.00 | $3,330.00 | $3,300.00 | ||
| 9 | $1,600.00 | $1,330.00 | $1,050.00 | $2,980.00 | ||
| 10 | $2,300.00 | $1,140.00 | $2,450.00 | $2,990.00 | ||
| 11 | $3,070.00 | $4,210.00 | $3,620.00 | $3,540.00 | ||
| 12 | $2,300.00 | $3,910.00 | $1,330.00 | $2,230.00 | ||
| 13 | $1,920.00 | $1,580.00 | $4,210.00 | $3,910.00 | ||
| 14 | $3,140.00 | $3,850.00 | $1,580.00 | $1,500.00 | ||
| 15 | $2,850.00 | $4,000.00 | $3,520.00 | $3,020.00 | ||
| 16 | $2,060.00 | $3,700.00 | $1,320.00 | $2,590.00 | ||
| 17 | $1,760.00 | $2,900.00 | $3,220.00 | $2,990.00 | ||
| 18 | $3,740.00 | $1,870.00 | $3,480.00 | $3,660.00 | ||
| 19 | $3,670.00 | $2,180.00 | $3,980.00 | $1,230.00 | ||
| 20 | $3,230.00 | $2,790.00 | $3,710.00 | $2,190.00 | ||
| 21 | $2,140.00 | $2,550.00 | $1,550.00 | $1,940.00 | ||
| 22 | $1,260.00 | $3,890.00 | $2,620.00 | $2,470.00 | ||
| 23 | $3,750.00 | $1,850.00 | $2,490.00 | $2,170.00 | ||
| 24 | $2,880.00 | $1,740.00 | $2,220.00 | $2,140.00 |
