Learning Team: Project Costing CMGT/410
dridthwaye2
copy_of_copy_of_project_baseline2.xlsxriordan-team_project-week4_0
| Task Name | Duration | Start Date | End Date | Predecessors | % Complete | Status | Assigned To | Comments | Fixed Cost | Fixed Cost Accrual | Total Cost | Baseline | Variance | Actual | Remaining | Budget Cost | Budget Work |
| HR System Estimated cost | 166d | 05/22/17 | 01/08/18 | 0% | IT Manager | HR System estimated cost will be 100,000.00 for the project. | $100000 | PRORATED | $111940 | $100000 | $11940 | $115000 | -$3060 | ||||
| Finalization of Project | 1d | 01/08/18 | 01/08/18 | 0% | Project Manager | $0 | PRORATED | $2240 | $2000 | $240 | $2300 | -$60 | $30 | 0.5 | |||
| Meeting | 1d | 01/08/18 | 01/08/18 | 0% | HR Manager, IT Manager, Project Manager | $0 | PRORATED | $1600 | $1200 | $400 | $1677 | -$77 | $20 | 0.5 | |||
| Meeting Room A | 0.75d | 06/05/17 | 06/05/17 | 0% | IT Team | $250 | PRORATED | $5220 | $5300 | -$80 | $5516 | -$296 | $20 | 0.5 | |||
| Define problem | 0.75d | 06/05/17 | 06/05/17 | 0% | Project Manager | $1410 | PRORATED | $3370 | $3300 | $70 | $3270 | $100 | $20 | 0.5 | |||
| Discussions on documents | 0.75d | 06/05/17 | 06/05/17 | 0% | HR Manager, IT Manager, Project Manager | $0 | PRORATED | $360 | $360 | $0 | $390 | -$30 | $430 | 0.5 | |||
| Checking current system | 5d | 06/05/17 | 06/09/17 | 0% | Testing Team | $30000 | PRORATED | $62805 | $62800 | $5 | $6210 | $56595 | $25 | 0.5 | |||
| Analyzing the problem | 5d | 06/05/17 | 06/09/17 | 0% | IT Manager, Project Manager | $10000 | PRORATED | $15600 | $15400 | $200 | $15399 | $201 | $34 | 0.5 | |||
| Interview users | 3d | 06/05/17 | 06/07/17 | 0% | Project Manager | $15000 | PRORATED | $16920 | $17000 | -$80 | $16789 | $131 | $21 | 0.5 | |||
| Gathering Information | 1d | 06/05/17 | 06/05/17 | 0% | Project Team | $10000 | PRORATED | $15240 | $15000 | $240 | $14000 | $1240 | $32 | 0.5 | |||
| Report to Stakeholders | 1d | 06/05/17 | 06/05/17 | 0% | $5000 | PRORATED | $5000 | $5000 | $0 | $4700 | $300 | $45 | 0.5 | ||||
| Designing Phase | 10d | 06/05/17 | 06/16/17 | 0% | Project Manager | $50000 | PRORATED | $67760 | $67700 | $60 | $67555 | $205 | $23 | 0.5 | |||
| Design Task 1 | 10d | 06/05/17 | 06/16/17 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $2400 | $0 | $2800 | -$400 | $76 | 0.5 | |||
| Design Task 2 | 10d | 06/05/17 | 06/16/17 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $2350 | $50 | $2550 | -$150 | $23 | 0.5 | |||
| Developing and Implementationn | 20d | 08/07/17 | 09/01/17 | 0% | Project Team | $35000 | PRORATED | $44630 | $44500 | $130 | $44690 | -$60 | $34 | 0.5 | |||
| Program Task 1 | 10d | 08/07/17 | 08/18/17 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $2500 | -$100 | $2700 | -$300 | $68 | 0.5 | |||
| Program Task 2 | 10d | 08/21/17 | 09/01/17 | 16 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $2450 | -$50 | $2590 | -$190 | $34 | 0.5 | ||
| Data Migration | 20d | 06/19/17 | 07/14/17 | 0% | Project Manager | $0 | PRORATED | $12800 | $12000 | $800 | $11607 | $1193 | $44 | 0.5 | |||
| Testing Phase | 15d | 07/17/17 | 08/04/17 | 0% | Testing Team | $0 | PRORATED | $4860 | $4900 | -$40 | $5000 | -$140 | $21 | 0.5 | |||
| Testing the equipment | 8d | 07/17/17 | 07/26/17 | 0% | Testing Team | $0 | PRORATED | $960 | $800 | $160 | $850 | $110 | $10 | 0.5 | |||
| Test Task 1 | 15d | 07/17/17 | 08/04/17 | 0% | Testing Team | $0 | PRORATED | $1800 | $2000 | -$200 | $2190 | -$390 | $80 | 0.5 | |||
| Test 2--Software | 10d | 07/24/17 | 08/04/17 | 0% | Testing Team | $0 | PRORATED | $1200.0000000000000 | $1250 | -$50 | $1230 | -$30 | $30 | 0.5 | |||
| Training user guide | 0 | 12/18/17 | 12/18/17 | 0% | Project Team | $5000 | PRORATED | $5000 | $4000 | $1000 | $3000 | $2000 | $33 | 0.5 | |||
| 50 copies of the user guide | 0 | 12/18/17 | 12/18/17 | 0% | HR Admin | $0 | PRORATED | $0 | $5 | -$5 | $0 | $0 | $34 | 0.5 | |||
| Train end user | 0 | 12/18/17 | 12/20/17 | 0% | HR Admin | $0 | PRORATED | $600.0000000000000 | $650 | -$50 | $690 | -$90 | $26 | 0.5 |
Comments
Sheet1
| Task Name | Duration | Start Date | End Date | Predecessors | % Complete | Status | Assigned To | Comments | Fixed Cost | Fixed Cost Accrual | Total Cost | Baseline | Variance | Actual | Remaining | Budget Cost | Budget Work |
| HR System Estimated cost | 166d | 05/22/17 | 01/08/18 | 0% | IT Manager | HR System estimated cost will be 100,000.00 for the project. | $100000 | PRORATED | $111940 | $0 | $111940 | $0 | $111940 | $0 | 0.0h | ||
| Finalization of Project | 1d | 01/08/18 | 01/08/18 | 0% | Project Manager | $0 | PRORATED | $2240 | $0 | $2240 | $0 | $2240 | $0 | 0.0h | |||
| Meeting | 1d | 01/08/18 | 01/08/18 | 0% | HR Manager, IT Manager, Project Manager | $0 | PRORATED | $1600 | $0 | $1600 | $0 | $1600 | $0 | 0.0h | |||
| Meeting Room A | 0.75d | 06/05/17 | 06/05/17 | 0% | IT Team | $250 | PRORATED | $5220 | $0 | $5220 | $0 | $5220 | $0 | 0.0h | |||
| Define problem | 0.75d | 06/05/17 | 06/05/17 | 0% | Project Manager | $1410 | PRORATED | $3370 | $0 | $3370 | $0 | $3370 | $0 | 0.0h | |||
| Discussions on documents | 0.75d | 06/05/17 | 06/05/17 | 0% | HR Manager, IT Manager, Project Manager | $0 | PRORATED | $360 | $0 | $360 | $0 | $360 | $0 | 0.0h | |||
| Checking current system | 5d | 06/05/17 | 06/09/17 | 0% | Testing Team | $30000 | PRORATED | $62805 | $0 | $62805 | $0 | $62805 | $0 | 0.0h | |||
| Analyzing the problem | 5d | 06/05/17 | 06/09/17 | 0% | IT Manager, Project Manager | $10000 | PRORATED | $15600 | $0 | $15600 | $0 | $15600 | $0 | 0.0h | |||
| Interview users | 3d | 06/05/17 | 06/07/17 | 0% | Project Manager | $15000 | PRORATED | $16920 | $0 | $16920 | $0 | $16920 | $0 | 0.0h | |||
| Gathering Information | 1d | 06/05/17 | 06/05/17 | 0% | Project Team | $10000 | PRORATED | $15240 | $0 | $15240 | $0 | $15240 | $0 | 0.0h | |||
| Report to Stakeholders | 1d | 06/05/17 | 06/05/17 | 0% | $5000 | PRORATED | $5000 | $0 | $5000 | $0 | $5000 | $0 | 0.0h | ||||
| Designing Phase | 10d | 06/05/17 | 06/16/17 | 0% | Project Manager | $50000 | PRORATED | $67760 | $0 | $67760 | $0 | $67760 | $0 | 0.0h | |||
| Design Task 1 | 10d | 06/05/17 | 06/16/17 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | 0.0h | |||
| Design Task 2 | 10d | 06/05/17 | 06/16/17 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | 0.0h | |||
| Developing and Implementationn | 20d | 08/07/17 | 09/01/17 | 0% | Project Team | $35000 | PRORATED | $44630 | $0 | $44630 | $0 | $44630 | $0 | 0.0h | |||
| Program Task 1 | 10d | 08/07/17 | 08/18/17 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | 0.0h | |||
| Program Task 2 | 10d | 08/21/17 | 09/01/17 | 16 | 0% | Project Team | $0 | PRORATED | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | $2400.0000000000000 | $0 | 0.0h | ||
| Data Migration | 20d | 06/19/17 | 07/14/17 | 0% | Project Manager | $0 | PRORATED | $12800 | $0 | $12800 | $0 | $12800 | $0 | 0.0h | |||
| Testing Phase | 15d | 07/17/17 | 08/04/17 | 0% | Testing Team | $0 | PRORATED | $4860 | $0 | $4860 | $0 | $4860 | $0 | 0.0h | |||
| Testing the equipment | 8d | 07/17/17 | 07/26/17 | 0% | Testing Team | $0 | PRORATED | $960 | $0 | $960 | $0 | $960 | $0 | 0.0h | |||
| Test Task 1 | 15d | 07/17/17 | 08/04/17 | 0% | Testing Team | $0 | PRORATED | $1800 | $0 | $1800 | $0 | $1800 | $0 | 0.0h | |||
| Test 2--Software | 10d | 07/24/17 | 08/04/17 | 0% | Testing Team | $0 | PRORATED | $1200.0000000000000 | $0 | $1200.0000000000000 | $0 | $1200.0000000000000 | $0 | 0.0h | |||
| Training user guide | 0 | 12/18/17 | 12/18/17 | 0% | Project Team | $5000 | PRORATED | $5000 | $0 | $5000 | $0 | $5000 | $0 | 0.0h | |||
| 50 copies of the user guide | 0 | 12/18/17 | 12/18/17 | 0% | HR Admin | $0 | PRORATED | $0 | $0 | $0 | $0 | $0 | $0 | 0.0h | |||
| Train end user | 3d | 12/18/17 | 12/20/17 | 0% | HR Admin | $0 | PRORATED | $600.0000000000000 | $0 | $600.0000000000000 | $0 | $600.0000000000000 | $0 | 0.0h |
