I want EARNED VALUE CHART and MANUAL CALCULATIONS:
Rotate the team leader role to a new member for this module. The leader should delegate tasks to team members to “divide and conquer” the requirements.
There are four deliverables for this team assignment:
Project Cost Estimate m09-cost-estimate.xlsx
Project Cost Baseline m09-cost-baseline.xlsx
Earned Value Chart m09-earned-value-chart.xlsx
Manual Calculations m09-manual-calculations.txt
COST ESTIMATE: Prepare a one-page cost estimate Download cost estimatefor the project, similar to the model provided in Figure 7-2. Use the attached WBS, and be sure to document your assumptions in preparing the cost model. Assume a labor rate of $20/hour for yourself (the project manager) and team members (Kim, Ashok, and Alfreda). You will pay Bobby, your IT guy, $30/hour. The project will fund refreshments for the four shark tank events and prizes for the winners, at a cost of $1,000 per event.
COST BASELINE: Using the cost model you created in the first task above, prepare a cost baseline Download cost baselinesimilar to the model provided in Figure 7-4 by allocating the costs by WBS for each month of the project. Add rows to the spreadsheet template as needed.
EARNED VALUE CHART: Assume that you have completed three months of the project. Use the EVM template to produce an earned value chart Download earned value chartfor your project.
On settings tab, set date range from August 1, 2019 to January 31, 2020.
Choose monthly, cost, cost change, and US$.
On plan tab, type the names of each WBS item from the baseline spreadsheet.
Take the totals for each WBS item, plug values into each month from the baseline spreadsheet.
On the actual tab, enter the % of work done for each WBS item for each of the first three months.
On the actual cost tab, enter 0 if no change from plan, a positive number if we spent more, and a negative number if we spent less. Use fictitious but realistic values to simulate what may have happened during those first three months. Annotate any assumptions you are making about this fictitious data.
On EVM tab, set the snapshot date to 31-OCT-2019 to view data for the current state of the project. View other dates for additional estimations.
MANUAL CALCULATIONS: After you have completed the EVM spreadsheet, consider the following. The BAC was $120,000 for this six-month project. You can make the following assumptions:
PV = $60,000
EV = $55,000
AC = $50,000
Based on these assumptions, perform the following calculations manually:
What is the cost variance, schedule variance, CPI, and SPI for the project?
How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget?
Use the CPI to calculate the EAC for this project. Is the project performing better or worse than planned?
Use the SPI to estimate time to complete this project.
Show as much of your math as you can.
Type these manual calculations into a text file.
When the four deliverables are complete, the team leader should attach the completed deliverables to this assignment: one submission for the entire team. Do not attach the deliverables unless the team has chosen you as the leader for this module. All files must be attached together in a single submission.
