The MobileGo project is making progress implementing the new systems. However, the software upgrades and the new software installation are not complete. The project sponsor has requested an update on the project. Using the MobileGo Earned Value scenario spreadsheet , complete the following tasks.
- Complete earned value metrics for each line item of the project.
- Use the metrics to create indexes for cost and schedule.
- Explain what the metrics mean in terms of the overall health of the project.
- Project where the project will end in terms of budget and schedule. What potential risks and trade-offs do you see?
- Explain any recommendations you have for improving the project schedule, budget, or both.
Prepare a 10-slide PowerPoint presentation that you can give to the project sponsor that explains your calculations, predictions, and recommendations. Remember that you are giving this information to the project sponsor, so consider what he or she would need to know as you draft your presentation.Use at least three outside sources to support your recommendations for improvement. Adhere to APA Style when creating citations and references for this assignment.You must either use speaker notes or audio to fully explain your slides. Be sure to elaborate in your speaker notes or audio; do not simply repeat the text from your slides.Please submit your calculation and presentation as an appendix after PPT presentation reference list for grading. Appendices, other supporting materials etc. are added after your reference list. Appendices are labelled, for example, Appendix A, Appendix B, Appendix C, etc. Each appendix starts on a page of its own. Appendices and other supporting materials should not be submitted separately in the Blackboard.
Activity Start Planned Duration Actual Duration Plan Date Actual Date Difference Budget Actual Difference Resource Label Resources Number Hourly $ Total $ Duration (days) Grand Total
Call Center Stations OC1 Outside consultant 1 1 $150.00 $150.00
Call center stations inventory 3/1/2020 14 14 3/15/2020 3/15/2020 0 $2,100.00 $2,100.00 $0.00 OC1 OC2 Outside consultant 2 1 $150.00 $150.00
Call center layout-new 3/15/2020 15 18 3/30/2020 4/2/2020 3 $4,500.00 $5,400.00 $900.00 C1,C2,C3 PM Project Manager: 1 $100.00 $100.00
Call center stations breakdown 4/2/2020 8 13 4/10/2020 4/15/2020 5 $2,400.00 $3,900.00 $1,500.00 C1,C2,C3 BSPL Business system project lead: 1 $125.00 $125.00
Call center stations pack 4/10/2020 5 20 4/15/2020 4/30/2020 15 $1,500.00 $6,000.00 $4,500.00 C1,C2,C3 BSIT Business system implementation team: 3 $350.00 $1,050.00
Call center stations move 4/30/2020 10 10 4/20/2020 5/10/2020 20 $2,000.00 $2,000.00 $0.00 C1,C2,C3 WSPL Wireless system project lead: 1 $100.00 $100.00
Call center stations install 5/10/2020 9 15 5/1/2020 5/25/2020 24 $1,800.00 $3,000.00 $1,200.00 C4,C5 WSIT Wireless system implementation team: 3 $85.00 $255.00
Office Furniture & Equipment Move RPL Relocation project lead: 1 $90.00 $90.00
Inventory furniture 3/15/2020 15 15 3/30/2020 3/30/2020 0 $1,350.00 $1,350.00 $0.00 RPL RT Relocation team: 2 $250.00 $500.00
Inventory equipment 3/30/2020 11 11 4/10/2020 4/10/2020 0 $6,435.00 $6,435.00 $0.00 WPL,WUT WPL Workstation project lead: 1 $85.00 $85.00
Create office layout 4/10/2020 5 5 4/15/2020 4/15/2020 0 $2,925.00 $2,925.00 $0.00 WPL,WUT WUT Workstation upgrade team: 2 $250.00 $500.00
Dissassemble 4/15/2020 5 7 4/20/2020 4/22/2020 2 $2,925.00 $4,095.00 $1,170.00 WPL,WUT C1 Contractor 1 1 $100.00 $100.00
Pack 4/22/2020 9 9 5/1/2020 5/1/2020 0 $5,400.00 $5,400.00 $0.00 WUT, C1 C2 Contractor 2 1 $100.00 $100.00
Move 5/1/2020 14 16 5/15/2020 5/17/2020 2 $8,400.00 $9,600.00 $1,200.00 WUT, C1 C3 Contractor 3 1 $100.00 $100.00
Install 5/17/2020 3 8 5/20/2020 5/25/2020 5 $1,800.00 $4,800.00 $3,000.00 WUT, C1 C4 Contractor 4 1 $100.00 $100.00
Wi-Fi C5 Contractor 5 1 $100.00 $100.00
New site survey 3/10/2020 5 5 3/15/2020 3/15/2020 0 $1,250.00 $1,250.00 $0.00 WSPL,OC2
Develop requirements 3/15/2020 15 15 3/30/2020 3/30/2020 0 $5,325.00 $5,325.00 $0.00 WSPL,WSIT
Vendor search 3/20/2020 21 21 4/10/2020 4/10/2020 0 $2,100.00 $2,100.00 $0.00 WSPL
Vendor selection 4/20/2020 10 13 4/30/2020 5/3/2020 3 $2,550.00 $3,315.00 $765.00 WSIT
Design layout 4/15/2020 5 15 4/20/2020 4/30/2020 10 $450.00 $1,350.00 $900.00 WSPL
Order Wi-Fi equipment 4/30/2020 1 5 5/1/2020 5/5/2020 4 $250.00 $1,250.00 $1,000.00 WSPL
Install Wi-Fi system 5/5/2020 10 13 5/15/2020 5/18/2020 3 $850.00 $1,105.00 $255.00 WSIT
Test Wi-Fi system 5/18/2020 7 5/25/2020 5/25/2020 0 $3,500.00 WSIT
Station Upgrade
Wireless card selection 3/30/2020 21 21 4/20/2020 4/20/2020 0 $12,600.00 $12,600.00 $0.00 WUT,C1
Order wireless cards 4/20/2020 11 11 5/1/2020 5/1/2020 0 $5,500.00 $5,500.00 $0.00 WUT
Install PC wireless cards 5/1/2020 14 18 5/15/2020 5/19/2020 4 $11,200.00 $14,400.00 $3,200.00 WUT,C1,C2,C3
Load software 5/19/2020 6 5/25/2020 5/25/2020 0 $1,200.00 C4,C5
Test wireless PC 5/25/2020 5 5/30/2020 6/2/2020 3 $3,000.00 WUT,C1
Call Center Software
Install software 5/25/2020 10 5/15/2020 5/30/2020 15 $5,850.00 WPL,WUT
Test software 5/3/2020 27 5/30/2020 6/5/2020 6 $15,795.00 WPL,WUT
Software training 6/5/2020 4 6/1/2020 6/10/2020 9 $2,340.00 WPL,WUT
Trial run 6/10/2020 5 6/15/2020 6/17/2020 2 $750.00 OC1
Cutover to new software 6/17/2020 13 6/30/2020 6/30/2020 0 $1,950.00 OC1
Business System Software
Install software 5/25/2020 5 5/30/2020 6/2/2020 3 $5,875.00 $5,875.00 BSPL, BSIT
Test software 6/13/2020 2 6/15/2020 6/15/2020 0 $2,350.00 $2,350.00 BSPL, BSIT
Software training 6/17/2020 3 6/20/2020 6/23/2020 3 $3,975.00 $3,975.00 BSPL, BSIT,OC1
Trial run 6/24/2020 6 6/30/2020 6/30/2020 0 $7,050.00 $7,050.00 BSPL, BSIT
Cutover to new software 7/12/2020 3 7/15/2020 7/18/2020 3 $3,525.00 $3,525.00 BSPL, BSIT