You are the manager if an IT project to develop and install a customer relationship management (CRM) module within your company's enterprise IT system. So far, you have planned only the first phase of the project, which doesn't include the soft launch (to test the system live), user input, corrections, or final launch. A network diagram showing the first phase of project schedule appears below. Costs are spread evenly over the activity times. Use the tabs in this spreadsheet to complete this assignment. Task 1- Create a Baseline Budget for this project (use Tab: Task 1 - Baseline Budget) (25 Points) Task 2 - The project plan gets revised and you now have a new baseline budget given to you (Tab: Revised Budget) go to this worksheet and complete all the entries the EVM tables given for each update. Then, at the end period 8, give an assessment on project's progress in terms of its budget and schedule, if the project progress continues in this way. (50 Points) Assess User Requirements (4 Weeks, $24,000) Assess Current System (2 Weeks, $16,000) Send RFP for Software Vendors (1 Week, $10,000) The CRM PROJECT Specify System Requirements (2 Weeks, $32,000) Send RFP for Hardware Vendors (2 Weeks, $10,000) Select Software Vendor and Prep. Contract (1 Week, $4,000) Program and Test the Module (6 Weeks, $150,000) Select Hardware Vendor and Prep. Contract (1 Week, $3000) Train Users (3 Weeks, $75,000) Task 1: Complete the baseline budget for this project. Assume that the budget for an activity is used uniformly during its duration. Task 1- Create a Baseline Budget for this project (use Tab: Task 1 - Baseline Budget) (25 Points) Project: CRM Budget 3 Assess User Requirements Assess Current System Specify System Requirements Send RFP for Software Vendors Send RFP for Hardware Vendors Select Software Vendor Select Hardware Vendor Program and Test the Module Train Users Cumulative Assess User Requirements (4 Weeks, $24,000) Assess Current System (2 Weeks, $16,000) $24,000 $16,000 $32,000 $10,000 $10,000 $4,000 $3,000 $150,000 $75,000 Send RFP for Software Vendors (1 Week, $10,000) Specify System Requirements (2 Weeks, $32,000) Send RFP for Hardware Vendors (2 Weeks, $10,000) Select Software Vendor and Prep. Contract (1 Week, $4,000) Program and Test the Module (6 Weeks, $150,000) Select Hardware Vendor and Prep. Contract (1 Week, $3000) Train Users (3 Weeks, $75,000) 6 8 9 10 11 12 13 What is the budget at completion for this project What is the expected completion time for this pr 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Task 1: Complete the baseline budget for this project. Assume that the budget for an activity is used uniformly during its duration. Task 1- Create a Baseline Budget for this project (use Tab: Task 1 - Baseline Budget) (25 Points) Project: CRM Budget 3 Assess User Requirements Assess Current System Specify System Requirements Send RFP for Software Vendors Send RFP for Hardware Vendors Select Software Vendor Select Hardware Vendor Program and Test the Module Train Users Cumulative Assess User Requirements (4 Weeks, $24,000) Assess Current System (2 Weeks, $16,000) $24,000 $16,000 $32,000 $10,000 $10,000 $4,000 $3,000 $150,000 $75,000 Send RFP for Software Vendors (1 Week, $10,000) Specify System Requirements (2 Weeks, $32,000) Send RFP for Hardware Vendors (2 Weeks, $10,000) Select Software Vendor and Prep. Contract (1 Week, $4,000) Program and Test the Module (6 Weeks, $150,000) Select Hardware Vendor and Prep. Contract (1 Week, $3000) Train Users (3 Weeks, $75,000) 6 8 9 10 11 12 13 What is the budget at completion for this project What is the expected completion time for this pr 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Project: CRM Assess User Requirements Assess Current System Specify System Requirements Send RFP for Software Vendors Send RFP for Hardware Vendors Select Software Vendor Select Hardware Vendor Program and Test the Module Train Users Cumulative Activity Assess User Requirements Assess Current System Cumulative Week 8 Activity Assess User Requirements Budget Assess Current System Specify System Requirements Send RFP for Software Vendors Send RFP for Hardware Vendors Cumulative 2 $20,000 $5,000 $5,000 $30,000 $10,000 $10,000 $30,000 $15,000 $15,000 $7,000 $8,000 $200,000 $100,000 % Complete AC 100% $20,000 100% $32,000 % Complete AC 100% $20,000 100% $32,000 100% $18,000 75% 100% $13,000 $15,000 EV 3 $5,000 $5,000 $10,000 EV PV PV SV SV CV $15,000 CV 6 $15,000 7 $10,000 $2,500 $10,000 $5,000 CPI SPI 8 sk 2 - The project plan gets revised and you now have a new baseline budget given to you (Tab: Revised Budget) go to this worksheet and complete all the entries the EVM tables given for each update. Then, at the end period 8, give an assessment on project's progress in terms of its budget and schedule, ? if the project progress continues in this way. (50 Points) Week 4 CPI SPI 9 $2,500 $8,000 BAC Planned Duration Forecast for cost (EAC)? Forecast for completion time (ETC Time)? TCPI 10 Forecast for cost (EAC)? Forecast for completion time (ETC Time)? TCPI $7,000 11 12 13 $25,000 $25,000 $25,000 14 15 $25,000 $25,000 What is your overall assessment at this period (Week 8), does it appear that the project is likely to finish on-time and on-budget? Why or why not? Explain your assessment (your response should not exceed the space provided here). 16 $25,000 17 $25,000 18 $25,000 19 $25,000 20 21 22 $25,000 $25,000 $25,000 Project: CRM Assess User Requirements Assess Current System Specify System Requirements Send RFP for Software Vendors Send RFP for Hardware Vendors Select Software Vendor Select Hardware Vendor Program and Test the Module Train Users Cumulative Activity Assess User Requirements Assess Current System Cumulative Week 8 Activity Assess User Requirements Assess Current System Specify System Requirements Budget Send RFP for Software Vendors Send RFP for Hardware Vendors Cumulative 2 $20,000 $5,000 $5,000 $5,000 $5,000 $30,000 $10,000 $10,000 $10,000 $30,000 $15,000 $15,000 $7,000 $8,000 $200,000 $100,000 % Complete AC 100% $20,000 100% $32,000 % Complete AC 100% $20,000 100% $32,000 100% $18,000 75% 100% $13,000 $15,000 EV EV PV PV SV SV CV 5 $15,000 CV $15,000 Task 2 - The project plan gets revised and you now have a new baseline budget given to you (Tab: Revised Budget) go to this worksheet and complete all the entries the EVM tables given for each update. Then, at the end period 8, give an assessment on project's progress in terms of its budget and schedule, if the project progress continues in this way. (50 Points) Week 4 $10,000 $2,500 $10,000 $5,000 8 CPI SPI 9 CPI SPI $2,500 $8,000 BAC Planned Duration Forecast for cost (EAC)? Forecast for completion time (ETC Time)? TCPI 10 Forecast for cost (EAC)? Forecast for completion time (ETC Time)? TCPI $7,000 11 12 13 ? ? 14 15 16 What is your overall assessment at this period (Week 8), does it appear that the project is likely to finish on-time and on-budget? Why or why not? Explain your assessment (your response should not exceed the space provided here). 17 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 18 19 20 21 22 $25,000 $25,000 $25,000 $25,000