1. Based on the following attachment, determine the updated total cost of the project based on the progress information at the end of week 15.

Justify your answer, stating your assumptions, if any.

Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat Q Tell me Conditional Format Cell Formatting as Table Styles - Z AA AB AC AD AE AF 1 2 Using Earned Value Analysis technique and given the following project, determine the updated 3 Total Cost (EAC cost) of the Project starting on Week 15. Justify your answers and explain your 4 - ' ' 5 Fred Resources Total Cost Weekly Cost 6 Team 1 $5,000 $1,000 7 A Team 1 $9,000 $3,000 8 A, B Team 1 $6,000 $857 9 0 Team 2 $5,000 $833 10 A Team 3 $30,000 $8,000 11 E Team 4 $4,000 $1,000 12 D Team 2 $3,000 $1,000 13 F, G Team4 $12,000 $3,000 14 Total $74,000 15 16 17 18 19 20 2 1 22 23 24 25 26 At the end of Week 15, this is the status per activity: 27 28 Activity Status Weeks worked Actual Cost I l 29 A Completed 6 $5,500 30 B Completed 3 $9,600 3 1 C Completed 6 $6,750 32 D Not Started 0 $0 33 E Completed 9 $29,900 34 F Not Started 0 $0 35 G 0 36 H 0 37 38 39 40 41 42 43 44 a Sheet1