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...
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...
The EV for a project is $100,000 and the PV is $60,000. What is the SPI?...
The EV for a project is $100,000 and the PV is $60,000. What is the SPI? Select one: a. Cannot calculate SPI with info given. b. 0.6 c. 1.66 d. 1.52 Activity A is worth $500, is finished, and cost $500 to do. Activity B is worth $1000, is 75% finished, and has cost $700 to do so far. Activity C is worth $100, is 50% finished, and has cost $90 to do so far. What is the total EV...
1. Answer questions 1-4 based on the information provided here: NechMenTin, Inc., has given the following...
1. Answer questions 1-4 based on the information provided here: NechMenTin, Inc., has given the following information to you. They want you to calculate their weighted average cost of capital. The company has always followed their ideal capital structure which the management insists is 40% debt and 60% equity capital. The company can issue bonds for 9% coupon rate. The interest is paid semi-annually. The bonds have 22 years to maturity. The bonds can be issued to net the company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT