Homework Help is Here – Start Your Trial Now!
Engineering
Civil Engineering
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)
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
See similar textbooks
icon
Related questions
Question

fill out the chart below (formulas are the bottom left) using excel. show the cell formulas 

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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Engineering Fundamentals: An Introduction to Engi…
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning
Architectural Drafting and Design (MindTap Course…
Architectural Drafting and Design (MindTap Course…
Civil Engineering
ISBN:
9781285165738
Author:
Alan Jefferis, David A. Madsen, David P. Madsen
Publisher:
Cengage Learning
Residential Construction Academy: House Wiring (M…
Residential Construction Academy: House Wiring (M…
Civil Engineering
ISBN:
9781285852225
Author:
Gregory W Fletcher
Publisher:
Cengage Learning
Fundamentals Of Construction Estimating
Fundamentals Of Construction Estimating
Civil Engineering
ISBN:
9781337399395
Author:
Pratt, David J.
Publisher:
Cengage,
Construction Materials, Methods and Techniques (M…
Construction Materials, Methods and Techniques (M…
Civil Engineering
ISBN:
9781305086272
Author:
William P. Spence, Eva Kultermann
Publisher:
Cengage Learning
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS