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$)$ The CRM PROJECT

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$)$ sk $1$: Complete the baseline budget for this project. Assume that the budget for an activity is used uniformly during duration.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $,$ject: CRM & Budget & & & $23$ & & $4-5$ & $5$ & $6$ & & $8$ & $10$ & $10$ & $112$ & $13$ & $13|4$ & $1415$ & $1516$ & $6-17$ & $718$ & $819$ & $1920$ & $2021$ & $2122$ & $23$ & $34$ & $425$ & $25$ & $\backslash (26-27\backslash )\backslash \backslash$

$\backslash$hline $3$ess User Requirements & $\backslash$$$24,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline sess Curent System & $\backslash$$$16,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline exify System Requirements & $\backslash$$$32,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Ad RFP for Soffware Vendors & $\backslash$$$10,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline id RFP for Hardware Vendors & $\backslash$$$10,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline ect Soffware Vendor & $\backslash$$$4,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline ect Hardware Vendor & $\backslash$$$3,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline gram and Test the Module & $\backslash$$$150,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline in Users & $\backslash$$$75,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline mulative & $\backslash$$$324,000$ & & & & & & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

What is the budget at completion for this project?

$\backslash$$$324,000$

What is the expected completion time for this project? $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Project CRM & Budget & & $2$ & $3$ & $4$ & & $6$ & & & & $10$ & $11$ & $12$ & $13$ & $14$ & $15$ & $516$ & $17$ & $18$ & $8-19$ & $1920$ & $21$ & $122\backslash \backslash$

$\backslash$hline Assess User Requirements & $\backslash$$$20,000$ & $\backslash$$$5,000$ & $\backslash$$$5,000$ & $\backslash$$$5,000$ & $\backslash$$$5,000$ & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Assess Current System & $\backslash$$$30,000$ & $\backslash$$$10,000$ & $\backslash$$$10,000$ & $\backslash$$$10,000$ & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Specify System Requirements & $\backslash$$$30,000$ & & & & & $\backslash$$$15,000$ & $\backslash$$$15,000$ & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Send REP for Software Vendors & $\backslash$$$15,000$ & & & & & & & $\backslash$$$10,000$ & $\backslash$$$2,500$ & $0\backslash$$$2,500$ & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Send REP for Hardware Vendors & $\backslash$$$15,000$ & & & & & & & $\backslash$$$10,000$ & $\backslash$$$5,000$ & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Select Software Vendor & $\backslash$$$7,000$ & & & & & & & & & & $57,000$ & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Select Hardware Vendor & $\backslash$$$8,000$ & & & & & & & & & $\backslash$$$8,000$ & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Program and Test the Module & $\backslash$$$200,000$ & & & & & & & & & & & $\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000$ & & & & $\backslash \backslash$

$\backslash$hline train Users & $\backslash$$$100,000$ & & & & & & & & & & & & & & & & & & & $\backslash$$$25,000$ & $0\backslash$$$25,000$ & $\backslash$$$25,000$ & $\backslash$$$25,000\backslash \backslash$

$\backslash$hline Cumulative & $\backslash$$$425,000$ & & & & & & & & & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Week $4$

$\backslash$begin$\{$tabular$\}\{|$l$|$r$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline Activity & $\backslash \%$ Complete & AC & EV & PV & SV & CV $\backslash \backslash$

$\backslash$hline Assess User Requirements & $\backslash (100\backslash \%\backslash )$ & $\backslash (\backslash$$ $20,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Assess Current System & $\backslash (100\backslash \%\backslash )$ & $\backslash (\backslash$$ $32,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Cumulative & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Week $8$

$\backslash$begin$\{$tabular$\}\{|$l$|$r$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline Activity & $\backslash \%$ Complete & AC & EV & PV & SV & CV $\backslash \backslash$

$\backslash$hline Asses User Requirements & $\backslash (100\backslash \%\backslash )$ & $\backslash (\backslash$$ $20,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Asses Current System & $\backslash (100\backslash \%\backslash )$ & $\backslash (\backslash$$ $32,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Specify System Requirements & $\backslash (100\backslash \%\backslash )$ & $\backslash (\backslash$$ $18,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Send ReP for Software Vendors & $\backslash (75\backslash \%\backslash )$ & $\backslash (\backslash$$ $13,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Send ReP for Hardware Vendors & $\backslash (100\backslash \%\backslash )$ & $\backslash (\backslash$$ $15,000\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Cumulative & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

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$).$