Alpha develops an IT solution for a company having inventory management issues. Alpha estimates a 12-week...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Alpha develops an IT solution for a company having inventory management issues. Alpha estimates a 12-week timeline for successfully deliver the solution. At the end of the 7th week the project manager receives project status report (see excel attachment). 1. At the end of week 7, is the project performing according to the plan? How do you know this? (Answer using project performance metrics) 2. How much longer will the project manager need to complete the project? (Provide answer in weeks) 3. How much additional cost will the project manager need to complete the project? Use Exhibit below for weekly Actual Cost and Earned Value, Project Performance Metrics Budgeted Cost of Work Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS) WBS Task Nam TBC 1 1.1 Task 1 1.2 Task 2 1.3 1.4 1.5 1.6 Task 3 Task 4 Task 5 Task 6 insert new rows above this one Total Budgeted Cost Actual Cost and Earned Value Cumulative Actual Cost (AC) Cumulative Earned Value (EV) Project Performance Metrics 3500 4200 4500 3300 3000 6700 0 Cost Variance (CV EV- AC) Schedule Variance (SV EV- PV) Cost Performance Index (CPI = EV/AC) Schedule Performance Index (SPI = EV/PV) Estimated Cost at Completion (EAC)=BAC/CPI Estimated time at Completion original time/SPI 0 0 25200 Cumulative Planned Value (PV) 0 0 0 1000 1000 2 500 500 1000 3 2000 800 700 200 3700 4 900 2000 600 3500 5 2000 1000 1000 700 4700 6 800 1500 500 2800 7 1000 1000 8 800 700 1500 9 2000 2000 10 1000 1000 11 2000 2000 12 1000 1000 Actual Work Done Actual Cost (AC) of Work Performed WBS Task Name Wk 1 Task Name TBC Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 3500 4200 4500 3300 3000 6700 0 0 0 Insert new rows above this one Total Actual Cost Cumulative Actual Cost (AC) 800 800 Wk 2 250 900 1150 WK 3 1500 700 300 100 2600 WK 4 1200 300 500 2000 WK 5 1700 1250 900 400 4250 Wk 6 1500 700 600 2800 Wk 7 400 500 900 WK 8 0 WK 9 0 WK 10 0 Wk 11 0 Wk 12 0 Earned Value Cumulative Earned Value (EV) WBS Task Name TBC - 1.1 Task 1 1.2 Task 2 1.3 Task 3 1.4 Task 4 1.5 Task 5 1.6 Task 6 - - - Insert new rows above this one 3500 4200 4500 3300 3000 6700 0 0 OOO OO 0 0 Cumulative EV Wk 1 15% Wk 2 50% 25% WK 3 100% 30% 25% Wk 4 100% 60% 40% WK 5 100% 75% 50% 25% Wk 6 100% 90% 100% 80% 25% Wk 7 100% 100% 100% 90% 75% 50% Wk 8 Wk 9 Wk 10 Wk 11 Wk 12 Alpha develops an IT solution for a company having inventory management issues. Alpha estimates a 12-week timeline for successfully deliver the solution. At the end of the 7th week the project manager receives project status report (see excel attachment). 1. At the end of week 7, is the project performing according to the plan? How do you know this? (Answer using project performance metrics) 2. How much longer will the project manager need to complete the project? (Provide answer in weeks) 3. How much additional cost will the project manager need to complete the project? Use Exhibit below for weekly Actual Cost and Earned Value, Project Performance Metrics Budgeted Cost of Work Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS) WBS Task Nam TBC 1 1.1 Task 1 1.2 Task 2 1.3 1.4 1.5 1.6 Task 3 Task 4 Task 5 Task 6 insert new rows above this one Total Budgeted Cost Actual Cost and Earned Value Cumulative Actual Cost (AC) Cumulative Earned Value (EV) Project Performance Metrics 3500 4200 4500 3300 3000 6700 0 Cost Variance (CV EV- AC) Schedule Variance (SV EV- PV) Cost Performance Index (CPI = EV/AC) Schedule Performance Index (SPI = EV/PV) Estimated Cost at Completion (EAC)=BAC/CPI Estimated time at Completion original time/SPI 0 0 25200 Cumulative Planned Value (PV) 0 0 0 1000 1000 2 500 500 1000 3 2000 800 700 200 3700 4 900 2000 600 3500 5 2000 1000 1000 700 4700 6 800 1500 500 2800 7 1000 1000 8 800 700 1500 9 2000 2000 10 1000 1000 11 2000 2000 12 1000 1000 Actual Work Done Actual Cost (AC) of Work Performed WBS Task Name Wk 1 Task Name TBC Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 3500 4200 4500 3300 3000 6700 0 0 0 Insert new rows above this one Total Actual Cost Cumulative Actual Cost (AC) 800 800 Wk 2 250 900 1150 WK 3 1500 700 300 100 2600 WK 4 1200 300 500 2000 WK 5 1700 1250 900 400 4250 Wk 6 1500 700 600 2800 Wk 7 400 500 900 WK 8 0 WK 9 0 WK 10 0 Wk 11 0 Wk 12 0 Earned Value Cumulative Earned Value (EV) WBS Task Name TBC - 1.1 Task 1 1.2 Task 2 1.3 Task 3 1.4 Task 4 1.5 Task 5 1.6 Task 6 - - - Insert new rows above this one 3500 4200 4500 3300 3000 6700 0 0 OOO OO 0 0 Cumulative EV Wk 1 15% Wk 2 50% 25% WK 3 100% 30% 25% Wk 4 100% 60% 40% WK 5 100% 75% 50% 25% Wk 6 100% 90% 100% 80% 25% Wk 7 100% 100% 100% 90% 75% 50% Wk 8 Wk 9 Wk 10 Wk 11 Wk 12
Expert Answer:
Answer rating: 100% (QA)
ANSWER 1 At the end of week 7 the project is not performing according to th... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Recording Adjusting Entries and Reporting Balances in Financial Statements Aubrae Company is making adjusting entries for the year ended December 31, 2011. In developing information for the adjusting...
-
For what purpose are entity relationship diagrams used?
-
Entity liabilities have an effect on a partner's basis in the partnership interest. Yet entity liabilities do not have any effect on a corporate shareholder's stock basis (for either a C corporation...
-
Two companies, Energen and Hastings Corporation, began operations with identical balance sheets. A year later, both required additional manufacturing capacity at a cost of $50,000. Energen obtained a...
-
The following set of data shows the number of alcoholic drinks that students at a Kansas university reported they had consumed in the past month: a. Assume the data set is a sample. Calculate the...
-
Use estimation to select the best response in Problems 5-14. Do not calculate. If you purchase a new automobile and finance it for four years, the amount of interest you might pay is A. \(\$ 400\) B....
-
Why you should record an abstract of judgment?
-
Discuss the validity of the following two statements on authority: a. A good project manager will have more authority than his responsibility calls for. b. A good project manager should not hold a...
-
6. Records indicate that x years after the year 2000, the property tax on a four-bedroom home in a suburb of a major city was 7 (x) = 3x + 40x + 1800 dollars. [10 pts.] (a) At what rate was the...
-
1. Using the information in the table, compute the structure of the optimal portfolio W when there are two risky assets, bond fund and stock fund, as well as one risk free asset. r=0.03. Please note...
-
Lets take a $25,000 loan over six years at 8% APR once again, but this time well assume it is for a car loan that offers 0% financing for the first two years of the loan or 8% financing over six...
-
The Federal Reserve has dramatically expanded the monetary base over the past several years but the money supply and inflation have not been as impacted as one might think? Why?
-
Demonstrate project management techniques that you would use for the EHR transition to ensure efficient workflow and appropriate outcomes. Select at least two techniques (e.g., Gantt charts,...
-
What single trade discount is equivalent to the series of trade discounts 14%, 9% and 5%? Enter your answer in the blank as a percent, rounded to 2 decimal places and including the percent sign.
-
Compare the acquisition of Pfizer over Medivation company, with acquisition of Novartis over The Medicines Company? Is the role of acquisitions (size and type) similar for Novartis and Pfizer? Do...
-
You just received an email from your boss stating that as a reward for your hard work, the firm has promised to pay you $20,000 at the end of their calendar year. Provide a specific equation with all...
-
Suppose firm has returns of 8 percent, -12 percent, 14 percent, -15 percent, 16 percent, and 26 percent for six of the last seven years. If the average return of the share return over this period is...
-
Funds are separate fiscal and accounting entities, each with its own self-balancing set of accounts. The newly established Society for Ethical Teachings maintains two funds-a general fund for...
-
(Multiple choice) 1. Company X owns 40 percent of Company Y and exercises significant influence over the management of Company Y. Therefore, Company X uses what method of accounting for reporting its...
-
Cardinal Company purchased, as a long-term investment, some of the 200,000 shares of the outstanding common stock of Arbor Corporation. The annual accounting period for each company ends December 31....
-
Identifying Events as Accounting Transactions For each of the following events, which ones result in an exchange transaction for Dittman Company (Y for yes and N for no)? _____ (1) Dittman Company...
-
What forms of business organization are permitted under Rule 505-Form of Practice and Firm Name?
-
There currently are thirteen Rules of Conduct. Listed below are circumstances pertaining to some of these rules: 1. A member shall exercise due professional care in the performance of an engagement....
-
a. What aspects of a company's financial statements are covered in the first three reporting standards? b. What is the objective of the fourth standard of reporting?
Study smarter with the SolutionInn App