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.
please use excel to solve and give step by step
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 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!