Project managment - Simple inputing cost estimates

profileazizmoe
project_cost_estimate1.xlsx
Home>Business & Finance homework help>Operations Management homework help>Project managment - Simple inputing cost estimates

Sheet3

Sheet 1 - ver 1.0

Project Cost Estimate
Project Name: soccer field finder application
Project Manager: Abdulaziz Alqarni
Date: 27 OCT 2014
Version: 1.0
Internal Project Team Costs Subcontractor Costs Other Costs Total Cost (WBS Element) Total Costs (by Phase) Notes
WBS Element # Title Labor Hours $ / hour Labor Cost Material Cost Travel Expenses Other Expenses Subcontract Labor Subcontract Travel Subcontract Material Subcontractor Other
1 TOTALS - Conceptual Phase 50 $ 8,000.00 $ - 0 $ 1,000.00 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00 $ 14,000.00
1.1 Preparing application guideline 10 $ 100 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 1,000.00
1.2 Finding a programming team 10 $ 100 $ 1,000.00 $ - 0 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
1.3 Investigate commercial offerings for sponsors 10 $ 100 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 1,000.00
1.4 Develop estimates for project requirements 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00 $ 4,000.00
1.Y 30 $ 100 $ 3,000.00 $ - 0 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00 $ 6,000.00
2 TOTALS - Feasibility & Preliminary Planning Phase 130 $ 13,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 13,000.00
2.1 Develop selection criteria for programmers 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
2.2 Develop selection criteria for location 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
2.3 Develop selection criteria for sponsors 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
2.4 Develop preliminary cost estimate 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
2.5 Develop preliminary timeline 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
3 TOTALS - Detail Planning Phase 150 $ 15,000.00 $ - 0 $ 1,000.00 $ 2,000.00 $ 13,000.00 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ 36,000.00
3.1 Identify & Establish Contract with programmers 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
3.2 Identify & Establish Contract with sponsors 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
3.3 Investigate patent study 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 5,000.00
3.4 Issue request proposal for programmers 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
3.5 Issue request proposal for sponsors 30 $ 100 $ 3,000.00 $ - 0 $ 1,000.00 $ - 0 $ 13,000.00 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ 22,000.00
3.6 Issue request proposal for office location 30
4 TOTALS - Implementation Phase 150 $ 15,000.00 $ 13,000.00 $ 4,000.00 $ 3,000.00 $ 7,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 1,000.00 $ 55,000.00
4.1 Negotiate/execute final contract for programmers 50 $ 100 $ 5,000.00 $ 2,000.00 $ 7,000.00
4.2 Negotiate/execute final contract for sponsor(s) 50 $ 100 $ 5,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 8,000.00
4.3 Negotiate/execute final contract location(s) 50 $ 100 $ 5,000.00 $ 10,000.00 $ 4,000.00 $ 2,000.00 $ 6,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 1,000.00 $ 40,000.00
5 TOTALS - Conversion/Sustaining/Termination Phase 40 $ 4,000.00 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 6,000.00
5.1 Ensure delivery 40 $ 100 $ 4,000.00 $ 2,000.00 $ 6,000.00
6 TOTALS - Program Management Tasks 125 $ 10,500.00 $ - 0 $ - 0 $ - 0 $ 10,000.00 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ 25,500.00
6.1 Develop Project Conceptual Description / Overview 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
6.2 Develop Project Scope Document 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
6.3 Develop Project Requirements Document 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
6.4 Develop / Maintain Project Work Breakdown Structure (WBS) 5 $ 100 $ 500.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 500.00
6.5 Develop / Maintain Project Statement(s) of Work 5 $ 100 $ 500.00 $ - 0 $ - 0 $ - 0 $ 5,000.00 $ 2,500.00 $ - 0 $ - 0 $ - 0 $ 8,000.00
6.6 Develop / Maintain Project Risk Analysis 5 $ 100 $ 500.00 $ - 0 $ - 0 $ - 0 $ 5,000.00 $ 2,500.00 $ - 0 $ - 0 $ - 0 $ 8,000.00
6.7 Develop / Execute Project Communications Plan 20
PROJECT TOTAL (All Phases) $ 149,500.00

Sheet2 - ver 2.0

Project Cost Estimate
Project Name: Sample Project
Project Manager: Jane Doe
Date: 03 NOV 2014
Version: 2.0
Internal Project Team Costs Subcontractor Costs Other Costs Total Cost (WBS Element) Total Costs (by Phase) Notes
WBS Element # Title Labor Hours $ / hour Labor Cost Material Cost Travel Expenses Other Expenses Subcontract Labor Subcontract Travel Subcontract Material Subcontractor Other
1 TOTALS - Conceptual Phase 120 $ 12,000.00 $ - 0 $ 2,000.00 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ 6,000.00 $ 21,000.00
1.1 10 $ 100 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 1,000.00
1.2 10 $ 100 $ 1,000.00 $ - 0 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
1.3 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00
1.4 20 $ 100 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00 $ 4,000.00
1.X 30 $ 100 $ 3,000.00 $ - 0 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00 $ 6,000.00
1.Y 30 $ 100 $ 3,000.00 $ - 0 $ 1,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 2,000.00 $ 6,000.00
2 TOTALS - Feasibility & Preliminary Planning Phase 190 $ 19,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 19,000.00
2.1 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
2.2 30 $ 100 $ 3,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 3,000.00
2.3 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
2.4 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
2.X 50 $ 100 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 5,000.00
3 TOTALS - Detail Planning Phase 340 $ 34,000.00 $ - 0 $ 1,000.00 $ 2,000.00 $ 13,000.00 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ 55,000.00
3.1 60 $ 100 $ 6,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 6,000.00
3.2 60 $ 100 $ 6,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 6,000.00
3.3 70 $ 100 $ 7,000.00 $ - 0 $ - 0 $ 2,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 9,000.00
3.4 70 $ 100 $ 7,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 7,000.00
3.X 80 $ 100 $ 8,000.00 $ - 0 $ 1,000.00 $ - 0 $ 13,000.00 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ 27,000.00
4 TOTALS - Implementation Phase 440 $ 44,000.00 $ 15,000.00 $ 6,000.00 $ 3,000.00 $ 33,000.00 $ 6,000.00 $ 6,000.00 $ 20,000.00 $ 5,000.00 $ 138,000.00
4.1 80 $ 100 $ 8,000.00 $ 2,000.00 $ 10,000.00
4.2 80 $ 100 $ 8,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 11,000.00
4.3 90 $ 100 $ 9,000.00 $ 10,000.00 $ 4,000.00 $ 2,000.00 $ 6,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 1,000.00 $ 44,000.00
4.4 90 $ 100 $ 9,000.00 $ 1,000.00 $ 1,000.00 $ 13,000.00 $ 1,000.00 $ 1,000.00 $ 8,000.00 $ 2,000.00 $ 36,000.00
4.X 100 $ 100 $ 10,000.00 $ 1,000.00 $ 1,000.00 $ 13,000.00 $ 1,000.00 $ 1,000.00 $ 8,000.00 $ 2,000.00 $ 37,000.00
5 TOTALS - Conversion/Sustaining/Termination Phase 160 $ 16,000.00 $ 15,000.00 $ 6,000.00 $ 3,000.00 $ 33,000.00 $ 6,000.00 $ 6,000.00 $ 20,000.00 $ 5,000.00 $ 110,000.00
5.1 40 $ 100 $ 4,000.00 $ 2,000.00 $ 6,000.00
5.2 40 $ 100 $ 4,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 7,000.00
5.3 40 $ 100 $ 4,000.00 $ 10,000.00 $ 4,000.00 $ 2,000.00 $ 6,000.00 $ 4,000.00 $ 4,000.00 $ 4,000.00 $ 1,000.00 $ 39,000.00
5.4 20 $ 100 $ 2,000.00 $ 1,000.00 $ 1,000.00 $ 13,000.00 $ 1,000.00 $ 1,000.00 $ 8,000.00 $ 2,000.00 $ 29,000.00
5.X 20 $ 100 $ 2,000.00 $ 1,000.00 $ 1,000.00 $ 13,000.00 $ 1,000.00 $ 1,000.00 $ 8,000.00 $ 2,000.00 $ 29,000.00
6 TOTALS - Program Management Tasks 135 $ 13,500.00 $ - 0 $ - 0 $ - 0 $ 10,000.00 $ 5,000.00 $ - 0 $ - 0 $ - 0 $ 28,500.00
6.1 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
6.2 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
6.3 40 $ 100 $ 4,000.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 4,000.00
6.4 5 $ 100 $ 500.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 500.00
6.X 5 $ 100 $ 500.00 $ - 0 $ - 0 $ - 0 $ 5,000.00 $ 2,500.00 $ - 0 $ - 0 $ - 0 $ 8,000.00
6.Y 5 $ 100 $ 500.00 $ - 0 $ - 0 $ - 0 $ 5,000.00 $ 2,500.00 $ - 0 $ - 0 $ - 0 $ 8,000.00
PROJECT TOTAL (All Phases) $ 371,500.00