Question

In: Finance

Based on the information provided for a one-year project, answer the following questions. PV =$100,000     AC...

Based on the information provided for a one-year project, answer the following questions.

PV =$100,000     AC =$60,000     BAC=$125,000    ETC = $100,000

  1. If 75% of the Planned Value was completed to date, what is the Earned Value of the work completed (round to nearest whole number)?
  1. What is the Cost Variance (round to nearest whole number)?
  1. What is the Schedule Variance (round to nearest whole number)?
  1. What is the Cost Performance Index (round to 2 decimals)?
  1. What is the Schedule Performance Index (round to 2 decimals)?
  1. How is the project progressing in terms of schedule (ahead, behind or on-schedule) and budget (under, over or on-budget)?
  1. If spending remains the same as the current rate to date, what is the Estimate at Completion for this project (round to nearest whole number)?
  1. If spending varies from current rate to date, what is the Estimate at Completion for this project (round to nearest whole number)?
  1. If spending remains the same as the current rate to date, what is the Variance at Completion (round to nearest whole number)?
  1. What is the % of the Project Complete (round to nearest whole %)?
  1. What is the % of budget spent (round to nearest whole %)?
  1. What is the To-Complete Performance Index required to achieve the original budget plan (round to 2 decimals)?

  2. Is the To-Complete Performance Index required to achieve the original budget plan harder, easier or the same as the efficiency performance to date?
  1. What is the To-Complete Performance Index required to achieve the revised budget plan if spending is the same as the current rate to date (round to 2 decimals)?

  1. Is the To-Complete Performance Index required to achieve the revised budget plan harder, easier or the same as the efficiency performance to date?

Solutions

Expert Solution

Since you have asked a question with numerous sub parts, I will address first five. Please post the balance sub parts as separate question.

This is a fairly formula driven question. Let's address them one by one.

PV = $100,000 AC = $60,000 BAC = $125,000 ETC = $100,000

===================

If 75% of the Planned Value was completed to date, what is the Earned Value of the work completed (round to nearest whole number)?

EV = % complete x Planned Value = 75% x 100,000 = $75,000


====================

What is the Cost Variance (round to nearest whole number)?

Cost Variance, CV = Earned Value, EV – Actual Cost, AC = 75,000 - 60,000 = $15,000

================

What is the Schedule Variance (round to nearest whole number)?

Schedule Variance, SV = Earned Value, EV – Planned Value, PV = 75,000 - 100,000 = - $ 25,000

================
What is the Cost Performance Index (round to 2 decimals)?

Cost Performance Index, CPI = EV / AC = 75,000 / 60,000 = 1.25

===================
What is the Schedule Performance Index (round to 2 decimals)?

Schedule Performance Index, SPI = EV / PV = 75,000 / 100,000 = 0.75

Please post the balance sub parts as separate question.


Related Solutions

Given the following information for a one-year project, answer the following questions. Remember the following terms;...
Given the following information for a one-year project, answer the following questions. Remember the following terms; planned value (PV), earned value (EV), actual cost (AC), and budget at completion (BAC). PV    =      $44,000 EV    =      $53,000 AC    =      $45,000 BAC =    $140,000 a).    Use the formulas provided in Table 1, to determine the project’s cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? Table 1: Earned Value Formulas Term Formula Earned value EV =...
Given the following information for a one-year project, answer the following questions. Remember the following terms;...
Given the following information for a one-year project, answer the following questions. Remember the following terms; planned value (PV), earned value (EV), actual cost (AC), and budget at completion (BAC). PV = $44,000 EV = $53,000 AC = $45,000 BAC = $140,000 a). Use the formulas provided in Table 1, to determine the project’s cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? Table 1: Earned Value Formulas Term Formula Earned value EV...
Answer the following questions based on the information provided below: You are conducting a study to...
Answer the following questions based on the information provided below: You are conducting a study to determine the impact of a new reading intervention on students test scores. You randomly assign 40 students to either the intervention group or the control group (those not participating in the intervention). You also break the students into morning and afternoon classes to determine which is the best time of day to conduct the intervention. 1. What is the dependant variable? 2. What is/are...
Question 12 Please answer the following set of questions, based on the information provided below. The...
Question 12 Please answer the following set of questions, based on the information provided below. The data listed below give information for 10 middle-level managers at a particular company. The first column is years of experience [X] and the second column is annual salary (in thousands) [Y]. We are going to examine the relationship between salary in thousands [Y] and years of experience[X]. Below is the regression output. Manager#     (X)     (Y) 1 xx 66 2 xx 69 3...
Question 15 Please answer the following set of questions, based on the information provided below. A...
Question 15 Please answer the following set of questions, based on the information provided below. A service company is curious to know whether customer age is crucial in deciding to subscribe. The company has collected a random sample of 1000 people, and asked everyone whether he or she would subscribe to the service. The company knows which age group the person falls into: under 18 years of age, 18 - 29 years of age, 30-45 years of age and 46...
Question 14 Please answer the following set of questions, based on the information provided below. A...
Question 14 Please answer the following set of questions, based on the information provided below. A service company is curious to know whether customer age is crucial in deciding to subscribe. The company has collected a random sample of 1000 people, and asked everyone whether he or she would subscribe to the service. The company knows which age group the person falls into: under 18 years of age, 18 - 29 years of age, 30-45 years of age and 46...
Answer the following sub-questions based on the information provided. You will draw explanatory graphs associated with...
Answer the following sub-questions based on the information provided. You will draw explanatory graphs associated with each market structure as is relevant to the explanation. Consider an (inverse) demand curve P = 30 - Q. And a total cost curve of C(Q) = 12Q. Assume a monopolist is operating in this market. (i) Calculate the quantity (qM) chosen by a profit-maximizing monopolist. (ii) At the profit-maximizing quantity, what is the monopolistic market price (pM) of the product. (iii) Calculate the...
QUESTION ONE: Refer to the information provided below and answer the following questions: 1.1 Calculate the...
QUESTION ONE: Refer to the information provided below and answer the following questions: 1.1 Calculate the Payback period of the first alternative ( answer expressed in years, months and days) 1.2 Calculate the Accounting Rate of Return (on average investment) of the first alternative. 1.3 On the basis of the Net Present Value, which alternative should be chosen? provide relevant calculations (annuity discount factor @ 12% = 3.6048) 1.4 Calculate the internal Rate of Return of the first alternative (Annuity...
1. A project has a PV of $65,000, an EV of $75,000 and an AC of...
1. A project has a PV of $65,000, an EV of $75,000 and an AC of $82,000. Is the project over or under budget? How can you tell? 20. Is the project ahead of or behind schedule? How can you tell? 2. A project has a PV of $10,000, a SPI of 0.92 and a CPI of 0.90. What is the project’s EV? What is the project’s AC?
Revise your calculations based the new information provided below and then answer the questions that follow....
Revise your calculations based the new information provided below and then answer the questions that follow. A company lends $372,000 to an owner and accepts a three year, 7% note in return. The note was issued on June 1st of the current year, and will be due on June 1st of the final year of the note. Required: (a) Prepare the journal entry to be made when the company makes the loan and accepts the note in return. (If no...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT