Question
The table below shows the planned and actual monthly budgets (in thousands of dollars) through the end of June. Complete the table and then determine
The table below shows the planned and actual monthly budgets (in thousands of dollars) through the end of June. Complete the table and then determine the schedule and cost variances by filling in the missing values highlighted in yellow. Activity Jan Feb Mar Apr May Jun Plan % C Value Staffing 10 8 18 100 18 Blueprinting 4 10 14 100 14 Prototyping 2 8 10 70 7 Full Design 3 8 10 21 67 14 Construction 2 30 32 25 8 Transfer 10 10 0 0 = 61 Monthly Plan Cumulative Plan Monthly Actual 12 15 9 14 9 42 Cumulative Actual The above project was planned with a 6-month duration (January through June), with the planned budget specified by the Monthly Plan and Cumulative Plan values from the completed table above. Calculate the schedule and cost variance values below. (Some values below are directly pulled from the completed chart above. Other values are calculated values, indicated by the (*) asterisk and longer blanks. For the calculated values, please include the values that were multiplied or divided as well as the resulting answer.) Schedule Variances Planned Value of Work Scheduled (PV) ______ Earned Value (EV) ______ Schedule Performance Index (SPI)* ____________________________ Estimated Time to Completion* ____________________________ Cost Variances Actual Cost of Work Performed (AC) ______ Earned Value (EV) ______ Cost Performance Index (CPI)* ____________________________ Estimated Cost to Completion* ____________________________ *calculated values, please show your work
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started