F7 × ✓ fx v A B C D E F G H J K L M Activity Budget $ Actual $ Planned % Actual % BCWP BCWS ACWP SV CV SPI CPI ECAC 1 Win $ es $ 100% 100% $ 2 Order Material es $ $ 100% 100% $ 3 Mobilize $ 800 $ 1,100 100% 100% $ 1,100 4 Appoint Sub $ $ 100% 100% $ 5 Build Slab $ 3,500 $ 4,700 100% 100% $ 4,700 Build Walls $ 5,500 $ 6,100 50% 100% $ 6,100 7 Paint $ 1,800 $ 400 0% 20% $ 400 8 Roof $ 5,600 $ 1,400 0% 20% $ 1,400 9 Finish $ 800 $ 0% 0% $ - 10 Totals $ 18,000 $13,700 $ 13,700 11 CV = BCWP - ACWP 12 CPI = BCWP/ACWP SV = BCWP - BCWS SPI = BCWP/BCWS ECAC = ACWP/BCWP x BCAC
F7 × ✓ fx v A B C D E F G H J K L M Activity Budget $ Actual $ Planned % Actual % BCWP BCWS ACWP SV CV SPI CPI ECAC 1 Win $ es $ 100% 100% $ 2 Order Material es $ $ 100% 100% $ 3 Mobilize $ 800 $ 1,100 100% 100% $ 1,100 4 Appoint Sub $ $ 100% 100% $ 5 Build Slab $ 3,500 $ 4,700 100% 100% $ 4,700 Build Walls $ 5,500 $ 6,100 50% 100% $ 6,100 7 Paint $ 1,800 $ 400 0% 20% $ 400 8 Roof $ 5,600 $ 1,400 0% 20% $ 1,400 9 Finish $ 800 $ 0% 0% $ - 10 Totals $ 18,000 $13,700 $ 13,700 11 CV = BCWP - ACWP 12 CPI = BCWP/ACWP SV = BCWP - BCWS SPI = BCWP/BCWS ECAC = ACWP/BCWP x BCAC
Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
5th Edition
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Saeed Moaveni
Chapter14: Computational Engineering Tools Electronic Spreadsheets
Section14.4: Matrix Computation With Excel
Problem 1BYG
Related questions
Question
fill out the chart below (formulas are the bottom left) using excel. show the cell formulas
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning