Question: Question The tables below documented the time and cost structure of a project with 8 activities (A-H). The green dollar numbers are the weekly budgeted
Question The tables below documented the time and cost structure of a project with 8 activities (A-H). The green dollar numbers are the weekly budgeted baseline cost estimations (e.g. A was planned to take 2 weeks to finish and budgeted fort $3,500 each wk). The red dollar numbers represent the actual costs incurred for completing that activity (e.g. E was actually started in wk 8, 1 wk later than budgeted. We have worked on it for 2 wks at this point, and have spent $ 2,000, and $2,500 respectively.) We are currently at the end of wk 9 and would like to evaluate the overall progress of this project. Since wk 10 and beyond are in the future, we do not have actual costs for those weeks yet. Please populate the Status Report Table below based on the information given, and then interpret the results. Budgeted Cost by Week 1st week 2nd week 3rd week 4th week 5th week 6th week A $3,500 $3,500 B $4,200 $2,800 $3,000 C $5,000 $2,000 $5,500 $3,200 $5,000 D $2,500 $2,500 $2,500 $5,500 E $2,000 $2,000 $3,800 $3,800 F $4,000 $4,000 $4,500 $6,000 $4,000 $4,000 G $3,200 $3,000 $3,000 $3,500 H $2,600 $2,600 Total budgeted cost for the entire project: $106,700 Wk 1 Wk 2 Wk 3 Wk 4 Wk 5 wk 6 Wk 7 Wk 8 Wk 9 Wk 10 Wk 11 Wk 12 Wk 13 Wk 14 Wk 15 Wk 16 A Actual $4,000 $4,150 A budgeted $3,500 $3,500 B Actual $4,000 $6,200 B budgeted $4,200 $2,800 $3,000 C Actual $4,800 $2,000 $5,500 $3,400 $5,000 C budgeted $5,000 $2,000 $5,500 $3,200 $5,000 D Actual $2,500 $2,500 $2,500 $2,500 $2,500 D budgeted $2,500 $2,500 $2,500 $5,500 E Actual $2,000 $2,500 E budgeted $2,000 $2,000 $3,800 $3,800 F Actual $4,800 $4,000 F budgeted $4,000 $4,000 $4,500 $6,000 $4,000 $4,000 G Actual $4,000 G budgeted $3,200 $3,000 $3,000 $3,500 H Actual H budgeted $2,600 $2,600 Status Report Table: At the end of Week 9 ACTIVITY Status PV EV AC CV SV SPI CPI PCIB TCPI A Completed B Completed C Completed D Completed E 45% completed F 35% completed G 15% completed H Not Started N/A N/A Cumulative Totals The overall scheduling status of the project at the end of week 9 (i.e. Is the project ahead or behind schedule cumulatively? And by how much?) The overall budget and cost status of the project at the end of week 9 (i.e. Is the finished work so far under or over budget? And by how much?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
