Home / Questions / In the Microsoft Excel, add a new worksheet called Earned Value with the exception of the ...
In the Microsoft Excel, add a new worksheet called “Earned Value.” with the exception of the following:Instead of BAC=$200,000, use the total project cost for your project.Instead of PV=$100,000, use the Week 16 Cumulative Cost from your Project Cash Flow Report generated above.Assume that you have completed three months of the project. The BAC was $200,000 for this six-month project. You can also make the following assumptions:PV Â¼ $120,000EV Â¼ $100,000AC Â¼ $90,000a. What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?b. How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget?c. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?d. Use the SPI to estimate how long it will take to finish this project.e. Sketch an earned value chart using the preceding information. See Figure 7-5 as a guide.Term FormulaEarned value (EV) EV Â¼ PV to date * RPCost variance (CV) CV Â¼ EV _ ACSchedule variance (SV) SV Â¼ EV _ PVCost performance index (CPI) CPI Â¼ EV/ACSchedule performance index (SPI) SPI Â¼ EV/PVEstimate at completion (EAC) EAC Â¼ BAC/CPIEstimated time to complete Original time estimate/SPI
Aug 09 2020 Read more Less More
On October 11, 2014, Usher Company purchased a building for $2,250,000. The building, land, and land improvements were valued at $1,440,000, $840,000, and $120,000 respec...
Apr 19 2020Wembley Stadium is afootball stadium inWembley, London, England, which opened in 2007, on the site of the originalWembley Stadium, which was demolished from 2002–2003. Th...
Jul 09 2020Special Motors Corporation’s stock price S is $59, the strike price K is $60, the maturity T is forty-four days, the implied volatility S is 30 percent per year, and the ...
May 11 2020For each of the following annuities, calculate the present value. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Prese...
Apr 06 2020Consider water flowing through a pipe. If conservation of mass holds, which one are the considerations?
Apr 16 2020Case Study: Dr. Maxwell Stark is a PAR provider with Blue Cross and Blue Shield; Dr. Forrest Wilson is nonPAR with the same insurer. Both providers are specialists in ga...
Aug 25 2020On April 19, 2016, Millipede Machinery sold a tractor to Thomas Hartwood, accepting a note promising payment of $120,000 in five years. The applicable effective interes...
Mar 28 2020A mass of 0.05 kg of carbon dioxide (molar mass 44 kg/kmolk occupying a volume of 0.03 ms at 1.025 bar, is compressed reversibly until the pressure is 6.15 bar. Calculate...
Jun 06 2020One state lottery has 1,100 prizes of $1; 145 prizes of $10; 20 prizes of $75; 5 prizes of $285; 2 prizes of $1,080; and 1 prize of $2,300. Assume that 24,000 lottery tic...
Apr 06 2020List and briefly describe the factors that affect a firm’s dividend policy.
Nov 27 2019Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.