Activity # Activity Time Estimate Planned Value($) Basis of…

Activity # Activity Time Estimate Planned Value($) Basis of Estimates Estimating technique Constraints Risks Level of Confidence % Range Low Estimate High Estimate Precision Units Measure % Accuracy
2.3.1.1 Document the Technical Architecture 1 week
3.3.1.1 Docment the Signal Acquisition Design 7 days
3.3.1.2 Document the Signal Distribution Design 2 days
4.3.1.1 Order Signal Acquisition equipment 2 days
4.3.1.2 Install Signal Acquisition Equipment 10 days
4.3.1.3 Configure Signal Acquisition Equipment 3 days
4.3.1.4 Configure Signal Distribution Equipment 3 days
5.3.1.1 Engineering Lab set-up for Testing 4 days
5.3.2.1 Audio Testing 2 days
5.3.3.1 Video Testing 2 days
6.3.1.1 Schedule Production Maintenance Window 4 hours
6.3.1.2 Distribute UNB TV Channel on VIP TV Network and generate test results 4 Overtime hours
Labour Rates
$/hour Human Resources # available
$ 100 Engineering Architect $/hour 1
$ 80 Engineering Designer $/hour 1
$ 60 Engineering Technician $/hour 1
$ 40 Engineering Video Tester $/hour 2
$ 40 Engineering Audio Tester $/hour 2
$ 50 Operations Manager $/hour 1
$ – Lab Manager – does not charge to capital projects 1
$ – Engineering Manager – does not charge to capital projects 1
Unit Cost Material and Equipment Resources
$100.0 K Electronics on a similar channel add project
$3.0 K Cables and miscellaneous parts – Optimistically
$5.0 K Cables and miscellaneous parts – Realistically
$10.0 K Cables and miscellaneous parts – Pessimistically
$0.2 K Lab testing positions per day
This is an individual assignment!
1) Estimate the cost (Planned Value) for each of the engineering activities using the in formation in the Estimating work book spreadsheet.
2) Given the project status on May 24th determine the Earned Value and forecast the projects outcome.
3) Prepare a one page dashboard to communicate the project status with the stakeholders
Earned Value Management Formulas
Activity # Activity Eng Mgr Lab Mgr Ops Mgr Eng Architect Eng Designer Eng Tech Video Tester #1 Video Tester #2 Audio Tester #1 Audio Tester #2 Project Manager
2.3.1.1 Document the Technical Architecture A R I
3.3.1.1 Document the Signal Acquisition Design A C R I
3.3.1.2 Document the Signal Distribution Design A C R I
4.3.1.1 Order Signal Acquisition equipment A C R I
4.3.1.2 Install Signal Acquisition Equipment A C R I
4.3.1.3 Configure Signal Acquisition Equipment A C R I
4.3.1.4 Configure Signal Distribution Equipment A C R I
5.3.1.1 Engineering Lab set-up for Testing A C R I
5.3.2.1 Audio Testing A C R I
5.3.3.1 Video Testing A C R I
6.3.1.1 Schedule Production Maintenance Window A R C I
6.3.1.2 Distribute UNB TV Channel on VIP TV Network and generate test results A C R I
WBS Task Name Duration Planned Start Planned Finish % Complete Predecessors Resource Names Planned Value Actual Cost Actual Finish
1 UNB TV Channel Project 1 day? 2-May 2-May 18% $128.8 K $ 28,891
1.1 Authorization 1 day? 2-May 2-May 0% $0.0 K $ –
1.1.1 Project Management Charter 1 day? 2-May 2-May 0% $0.0 K $ –
1.1.2 Project Start 0 days 2-May 2-May 0% 3 $0.0 K $ –
1.2 Planning Phase 5 days? 3-May 9-May 50% 4 $4.0 K $ 3,556
1.2.1 Project Management Plan 1 day? 3-May 3-May 0% $0.0 K $ –
1.2.2 Procurement Plan 1 day? 3-May 3-May 0% $0.0 K $ –
1.2.3 Engineering 5 days 3-May 9-May 100% $4.0 K $ 3,556
1.2.3.1 Engineering Architecture 5 days 3-May 9-May 100% $4.0 K $ 3,556
1.2.3.1.1 Document the technical architecture 5 days 3-May 9-May 100% Engineering Architect $4.0 K $ 3,556 9-May
1.2.4 IT System Architecture 1 day? 3-May 3-May 0% $0.0 K $ –
1.2.5 Operational Plan 1 day? 3-May 3-May 0% $0.0 K $ –
1.2.6 Market Plan 1 day? 3-May 3-May 0% $0.0 K $ –
1.2.7 Planning phase complete 0 days 9-May 9-May 0% 8,6,7,11,12,13 $0.0 K $ –
1.3 Designing Phase 11 days? 10-May 24-May 44% 14 $5.8 K $ 3,799
1.3.1 Project Reports 1 day? 10-May 10-May 0% $0.0 K $ –
1.3.2 Procurement agreements 1 day? 10-May 10-May 0% $0.0 K $ –
1.3.3 Engineering 9 days 12-May 24-May 69% $5.8 K $ 3,799
1.3.3.1 Engineering Designs 9 days 12-May 24-May 69% $5.8 K $ 3,799
1.3.3.1.1 Document the signal acquisition design 7 days 12-May 20-May 60% 10 Engineering Designer $4.5 K $ 2,545 In progress
1.3.3.1.2 Document the signal distribution design 2 days 23-May 24-May 100% 10,20 Engineering Designer $1.3 K $ 1,254 24-May
1.3.4 IT Systems Designs 1 day? 10-May 10-May 0% $0.0 K $ –
1.3.5 Operational Processes 1 day? 10-May 10-May 0% $0.0 K $ –
1.3.6 Marketing Campaings 1 day? 10-May 10-May 0% $0.0 K $ –
1.3.7 Design phase complete 0 days 24-May 24-May 0% 16,17,18,22,23,24 $0.0 K $ –
1.4 Build Phase 48 days? 25-May 29-Jul 13% 25 $114.5 K $ 21,080
1.4.1 Project Reports 1 day? 25-May 25-May 0% $0.0 K $ –
1.4.2 Procurement Audits 1 day? 25-May 25-May 0% $0.0 K $ –
1.4.3 Engineering 48 days 25-May 29-Jul 17% $114.5 K $ 21,080
1.4.3.1 Video Channel 48 days 25-May 29-Jul 17% $114.5 K $ 21,080
1.4.3.1.1 Order signal acquistion equipment 2 days 25-May 26-May 100% 20 Engineering Designer $1.3 K $ 1,534 24-May
1.4.3.1.2 Install signal acquistion equipment 10 days 8-Jul 21-Jul 10% 31FS+6 wks Engineering Technician ,Cables and misc parts[1],Electronics[1] $110.3 K $ 19,546 In progress
1.4.3.1.3 Configure Signal Acquistion equipment 3 days 22-Jul 26-Jul 0% 32 Engineering Technician $1.4 K $ –
1.4.3.1.4 Configure signal distribution equipment 3 days 27-Jul 29-Jul 0% 33 Engineering Technician $1.4 K $ –
1.4.4 IT Systems 1 day? 25-May 25-May 0% $0.0 K $ –
1.4.5 Operational Procedures 1 day? 25-May 25-May 0% $0.0 K $ –
1.4.6 Marketing Content 1 day? 25-May 25-May 0% $0.0 K $ –
1.4.7 Build phase complete 0 days 29-Jul 29-Jul 0% 27,28,29,35,36,37 $0.0 K $ –
1.5 Test Phase 6 days? 1-Aug 8-Aug 0% 38 $4.0 K $ 456
1.5.1 Project reports 1 day? 1-Aug 1-Aug 0% $0.0 K $ –
1.5.2 Procurement Settlements 1 day? 1-Aug 1-Aug 0% $0.0 K $ –
1.5.3 Engineering 6 days 1-Aug 8-Aug 0% $4.0 K $ 456
1.5.3.1 Lab Environment 4 days 1-Aug 4-Aug 0% 30 $1.9 K $ 456
1.5.3.1.1 Engineering lab set-up for testing 4 days 1-Aug 4-Aug 20% Engineering Technician $1.9 K $ 456
1.5.3.2 Video Test Results 2 days 5-Aug 8-Aug 0% $1.0 K $ –
1.5.3.2.1 Video Testing 2 days 5-Aug 8-Aug 0% 44 Engineering Video Tester,Lab testing positions $1.0 K $ –
1.5.3.3 Audio Test Results 2 days 5-Aug 8-Aug 0% $1.0 K $ –
1.5.3.3.1 Audio Testing 2 days 5-Aug 8-Aug 0% 44 Engineering Audio Tester,Lab testing positions $1.0 K $ –
1.5.4 IT Systems Test Results 1 day? 1-Aug 1-Aug 0% $0.0 K $ –
1.5.5 Operations Test Results 1 day? 1-Aug 1-Aug 0% $0.0 K $ –
1.5.6 Marketing Reports 1 day? 1-Aug 1-Aug 0% $0.0 K $ –
1.5.7 Test phase complete 0 days 8-Aug 8-Aug 0% 40,41,42,49,50,51 $0.0 K $ –
1.6 Market Launch 21.25 days? 9-Aug 7-Sep 0% 52 $0.6 K $ –
1.6.1 Project final report 1 day? 9-Aug 9-Aug 0% $0.0 K $ –
1.6.2 Procurement 1 day? 9-Aug 9-Aug 0% $0.0 K $ –
1.6.3 Engineering Services 11.25 days 9-Aug 24-Aug 0% $0.6 K $ –
1.6.3.1 Schedule Production maintenance window 4 hrs 9-Aug 9-Aug 0% Operations Manager $0.2 K $ –
1.6.3.2 Distribute TV Channel and record test results 6 hrs 23-Aug 24-Aug 0% 57FS+2 wks Engineering Technician $0.4 K $ –
1.6.4 IT Systems Service 1 day? 9-Aug 9-Aug 0% $0.0 K $ –
1.6.5 Operations 1 day? 9-Aug 9-Aug 0% $0.0 K $ –
1.6.6 Market Reports 1 day? 9-Aug 9-Aug 0% $0.0 K $ –
1.6.7 Contingency 10 days 24-Aug 7-Sep 0% 54,55,56,59,60,61 $0.0 K $ –
1.6.8 Service Launch Ready 0 days 7-Sep 7-Sep 0% 62 $0.0 K $ –
Criteria
Outstanding
5 points
Good
4 points
Average
3 points
Poor
2 points
Flawed
1 point
Criterion Score
Plan
Accurate Estimates including basis, technique, constraints, risks, range and budget s-curves.
Missing 1 planning information items.
Missing 2 planning information items
Missing 3 planning information items or are inaccurate.
Missing most or Inaccurate estimate without basis, constraints, risk, range or s-curves.
Score of Plan,
/ 5
Actual
Accurate assessment of the earned value, BAC, PV, AC, SPI, SV, CPI and CV.
Missing an item from the actual state assessment.
Missing 2 items from the actual state assessment.
Missing 3 items from the actual state or are inaccurate.
Missing most or inaccurate assessment of to current situation.
Score of Actual,
/ 5
Forecast
Reasonable forecast with EAC, ETC, VAC and s-curves with actual and forecast. Includes valid assumptions.
Missing 1 forecast item
Missing 2 items from the forecast.
Missing 3 items from the forecast or are not presented with valid assumptions.
Missing most forecasts and assumptions about the future state.
Score of Forecast,
/ 5
Dashboard
Single page dashboard that efficiently displays the current status of the project. Includes current and forecasted status.
Missing 1 item on the dashboard.
Missing 2 items on the dasboard.
Missing 3 items on the dashboard or are inaccurately presented.
Missing dashboard.
Score of Dashboard,