Question: please help me with this assignment: Calculate status and forecasting for a sample project using earned value management (EVM) formulas. Instructions Now it's time to

please help me with this assignment:

please help me with this assignment: Calculate status and forecasting for asample project using earned value management (EVM) formulas. Instructions Now it's timeto practice statusing and forecasting a project. You'll be using the cost

Calculate status and forecasting for a sample project using earned value management (EVM) formulas. Instructions Now it's time to practice statusing and forecasting a project. You'll be using the cost baseline you developed in a previous lesson. We've added status information for the first five weeks of the project. You'll calculate status using the earned value formulas. Remember to round to two decimal points only. Week one has been done for you as an example. Complete the calculations (use Microsoft Excel functions to create your formulas; do not use a calculator) for the cumulative status of the entire project for weeks 2-5 in the spreadsheet provided. You will turn it in to your facilitator for grading. NOTE: Please verify your calculations and formulas, because an error in one week will create errors in all subsequent weeks. You must complete the following activities in the spreadsheet for this assignment: 1. Calculate PV, EV, and AC for weeks 2-5: Calculate the project or cumulative (up to and including current week) PV, EV and AC for weeks 2-5. The data for both planned and actuals has been populated in the spreadsheet. The steps to complete this step are as follows: 1. Total the PV for all Work Packages during week 2. (incremental value for current week) 2. Add the total PV from week 2 to the total PV from week 1. (cumulative "project" level value for current week) 3. Place the cumulative total in the Project PV cell for week 2 under the Statusing Info section. 4. Repeat these steps to calculate EV and AC for week 2. 5. Repeat all steps for weeks 3-5. 2. Calculate schedule variance (SV): Calculate a cost-based SV for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 3. Calculate cost variance (CV): Calculate CV for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 4. Cost performance index (CPI): Calculate CPI for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 5. Schedule performance index (SPI): Calculate SPI for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 6. Percent complete (\%Complete): Calculate percent complete for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 7. Percent spent (\%Spent): Calculate percent spent for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 8. Estimate at Completion (EAC): Calculate EAC (typical) for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. 9. Estimate at completion (EAC): Calculate EAC (atypical) for the project by week. Enter your answer in the correct cell located at the end of the spreadsheet. Statusing Info: Schedule Variance Cost Variance SPI CPI \%Complete \%Spent \begin{tabular}{|rr|} \hline$ & (400) \\ \hline$ & (3,900) \\ \hline 0.94 \\ \hline 0.61 \\ \hline 6.1% \\ \hline 10.0% \\ \hline \end{tabular} EAC (typical) EAC (atypical) \begin{tabular}{|ll|} \hline$ & 163,279 \\ \hline$ & 103,500 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!