A project manager surveyed his earned value table at the conclusion of month 24 The results...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A project manager surveyed his earned value table at the conclusion of month 24 The results are shown in the table below. ($ values shown) The planned payment schedule is shown with % Complete which can be used to calculate earned value for each activity. Pay attention to the Actual Costs (payments). Copy the table below into Excel and show your work by expanding or adding the necessary rows and columns and then add a small table at below the main table for the Calculate the Total Budget at Completion (BAC) for the project Calculate the Schedule Variance and the SPI for this project at the end of the 24th month Calculate the Cost Variance and the CPI for the project at the end of the 24th month Calculate the Estimate at Completion Is the project on budget/ over budget / under budget? What is showing you this? What might this mean in terms of upcoming payments for this project? Is the project on schedule / ahead of schedule / behind schedule? What is showing you this? How do you feel overall about the way this project is proceeding? What would you report to the project sponsor? Submit the result as a single MS Excel spreadsheet with your name in cell A1 and your student number in cell B1 TOTAL % Complete 4 8 $500 $1,500 $450 12 16 $2,000 $3,000 20 24 $3,000 $1,500 $100 $4,500 $11,500 $4,500 $100 $9,650 $500 $1,200 $1,700 $500 Activity Concept Design Proposal Negotiations Resource Acquisition Training Modeling Planning Testing Control Quality Assurance Scope Verification Contract Closure Total Cumulative Total Actual Cost Cumulative Actual Cost $100 $500 $300 $750 $2,000 $400 $1,000 $1,400 $2,000 $500 $3,000 $2,000 $7,500 $500 $500 $1,000 $6,000 $4,000 $2,000 $3,200 $500 $500 $1,000 $950 $1,200 $500 $500 $1,000 $2,000 28 $500 $5,000 $11,000 $5,500 $8,000 $8,000 $3,500 $5,600 $6,000 $8,000 $4,000 $6,000 85% 90% 100% 100% 100% 75% 60% 10% 30% 50% 30% 40% A project manager surveyed his earned value table at the conclusion of month 24 The results are shown in the table below. ($ values shown) The planned payment schedule is shown with % Complete which can be used to calculate earned value for each activity. Pay attention to the Actual Costs (payments). Copy the table below into Excel and show your work by expanding or adding the necessary rows and columns and then add a small table at below the main table for the Calculate the Total Budget at Completion (BAC) for the project Calculate the Schedule Variance and the SPI for this project at the end of the 24th month Calculate the Cost Variance and the CPI for the project at the end of the 24th month Calculate the Estimate at Completion Is the project on budget/ over budget / under budget? What is showing you this? What might this mean in terms of upcoming payments for this project? Is the project on schedule / ahead of schedule / behind schedule? What is showing you this? How do you feel overall about the way this project is proceeding? What would you report to the project sponsor? Submit the result as a single MS Excel spreadsheet with your name in cell A1 and your student number in cell B1 TOTAL % Complete 4 8 $500 $1,500 $450 12 16 $2,000 $3,000 20 24 $3,000 $1,500 $100 $4,500 $11,500 $4,500 $100 $9,650 $500 $1,200 $1,700 $500 Activity Concept Design Proposal Negotiations Resource Acquisition Training Modeling Planning Testing Control Quality Assurance Scope Verification Contract Closure Total Cumulative Total Actual Cost Cumulative Actual Cost $100 $500 $300 $750 $2,000 $400 $1,000 $1,400 $2,000 $500 $3,000 $2,000 $7,500 $500 $500 $1,000 $6,000 $4,000 $2,000 $3,200 $500 $500 $1,000 $950 $1,200 $500 $500 $1,000 $2,000 28 $500 $5,000 $11,000 $5,500 $8,000 $8,000 $3,500 $5,600 $6,000 $8,000 $4,000 $6,000 85% 90% 100% 100% 100% 75% 60% 10% 30% 50% 30% 40%
Expert Answer:
Related Book For
Basic Business Statistics Concepts And Applications
ISBN: 9780132168380
12th Edition
Authors: Mark L. Berenson, David M. Levine, Timothy C. Krehbiel
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
Factor each trinomial. 4(m 5)2 4(m 5) 15
-
Hemera SA had a defined benefit obligation of R$3,100,000 and plan assets of R$2,900,000 at January 1, 2019. Hemera's discount rate is 6%. In 2019, actual return on plan assets is R$160,000. Hemera...
-
Jane Geddes Engineering Corporation purchased conveyor equipment with a list price of $10,000. Presented below are three independent cases related to the equipment. (a) Geddes paid cash for the...
-
Show that \[S S_{T}=S S_{\text {Treat }}+S S_{E},\] where $S S_{T}=\sum_{i=1}^{k} \sum_{j=1}^{n_{i}}\left(y_{i j}-\bar{y} . ight)^{2}, S S_{\text {Treat }}=\sum_{i=1}^{k}...
-
On January 1, 2014, Emporia Country Club purchased a new riding mower for $15,000. The mower is expected to have an 8-year life with a $3,000 salvage value . What journal entry would Emporia make at...
-
Evaluate log3 1 243
-
Mid-Valley Travel Agency (MVTA) has offices in 12 cities. The company believes that its monthly airline bookings are related to the mean income in those cities and has collected the following data:...
-
Provide a draft/outline of legal research involving an indigenous Canadian woman charged with assault causing bodily harm under (Sec 267b) of the Criminal Code, where the crown wants a 12-month jail...
-
Is there any resource that you could consider as a distinctive competence for Yunnan Lucky Air?
-
On July 31, 2022, Edgmont Co. purchased $ 44 comma 000 of inventory on a one-year, 9-percent note payable. Interest payable on December 31, 2022, was $1 comma 650. Show what Edgmont Co. reports for...
-
How do I post this to the ledger they rented a cotton candy machine for the day cost of $7,750 for the machine rental and cotton candy supplies And $250 tip?
-
Why did we use the terminology of Deferred Gross Profit in Module 2 assignments yet in Chapter 6 assignment it was termed as Deferred Unrealized Gain?
-
In 2023, USCO, which is subject to a 21% U.S. corporate tax rate, has $1 Million of worldwide active income which is all from foreign sources in Country X. Assume USCO's foreign-source active income...
-
What power is required to raise a mass of 47 kg to a height of 12 m in 15 s.
-
For the following exercises, rewrite the sum as a product of two functions or the product as a sum of two functions. Give your answer in terms of sines and cosines. Then evaluate the final answer...
-
A chef in a restaurant that specializes in pasta dishes was experiencing difficulty in getting brands of pasta to be al dente-that is, cooked enough so as not to feel starchy or hard but still feel...
-
Let n1 = 100, X1 =50, n2 = 100, and X2 = 30. a. At the 0.05 level of significance, is there evidence of a significant difference between the two population proportions? b. Construct a 95% confidence...
-
Undergraduate students at Miami University in Oxford, Ohio, were surveyed in order to evaluate the effect of price on the purchase of a pizza from Pizza Hut. The students were asked to suppose that...
-
Write a one-page summary addressing the topic, How improving safety and health at the Hotel Paris will contribute to us achieving our strategic goals.
-
Based on what you read in this chapter of Dessler, Human Resource Management, whats the first step you would have advised the Hotel Paris to take as part of its new safety and health program, and why?
-
How would you suggest the Carters get all employees to behave more safely at work? Also, how would you advise them to get those who should be wearing goggles to do so?
Study smarter with the SolutionInn App