Question: please use excel to solve and give step by step formula. You are doing a retrospective of a project by reviewing actual measurements during the
please use excel to solve and give step by step formula.
You are doing a retrospective of a project by reviewing actual measurements during the past 15 weeks, consisting of: The Planned Budget of the n-th week The Expenses per Week The Accomplishment (Earned Value) per Week Your record of the above is shown below: Planned Days Weekly Weekly Budget Spending Accomplishments 1 10 11 9 2 20 10 10 3 30 9 8 4 40 10 7 5 50 11 12 6 60 10 11 7 70 11 11 8 80 9 13 9 8 12 10 100 9 9 11 110 13 9 12 120 12 11 13 130 14 7 14 140 11 15 150 Easages an7 90 1. (pt) Compute the Cost Performance Index and the Schedule Performance Index for each week 2. (2pt) Compute the CSI 3. (10pt) Compute the CR 4. (15pt) Plot CSI and CR on the same graph. Ensure that the vertical scale is from 0.70 to 1.1 5. (pt) You plan to give a bonus to people every week that the project was doing well. For which weeks you will give a bonus
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
