Question

Project ABC Scope = 10 chairs @ $10.00 = $100.00 PV = Timeframe = 10 days...

Project ABC

Scope = 10 chairs @ $10.00 = $100.00 PV = Timeframe = 10 days AC = At the End of the 5th day 4 chairs were EV = Completed at a cost of $11.00 each CV = CPI= SV = SPI= CR = To install a 10,000 feet fence at a cost of $10.00/per foot. It is estimated that 500 feet of fence can be installed per week for a total of 20 weeks. After 12 weeks and with 50% of work completed $45,000.00 has been spent. Calculate the following and submit the exercise results in a Word document.

Budget at Completion (BAC) = ___________________________ #feet fence * cost/foot

Planned Value (PV) - ________________________________ BAC * (%time passed)

Earned Value (EV) _______________________________________ BAC * % completed

Actual Cost (AC) _________________________________________

Cost Variance (CV) _________________________________________ EV - AC

Schedule Variance (SV) _________________________________________ EV - PV

Cost Performance Index (CPI) ____________________________________ EV/AC %

Schedule Performance Index (SPI) ___________________________________ EV/PV %

Estimate at Completion (EAC) _____________________________________ BAC/CPI

Estimate to Complete (ETC) ____________________________________ EAC - AC

Variance at Completion (VAC) ____________________________________

BAC-EAC To Complete Performance Index ______________________________ (BAC-EV)/(BAC/AC)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

- File 5 EX Home InsertPage LayoutFormulas DataReview View DeveloperNitro Pro8 Cut Copy 11, A-=-9- Ewrap Text General Fll Z в 1 u. 田? 上,A, a-A, 国Merge & Center. 掴Merge & Center. % , aiog Conditional Format Cell | Insert Delete Format % , -28鼎Conditional Format- CellInsert Delete Format Sort & Find & Blu- ロ. 迴 ! Format Painter Clipboard Format Painter Formatting as Table, Styles 2 Clear Filter Select Font Alignment Number Cells Sr. Particulars Formula Feet fence Cost foot BAC*(me p Computation 10000 feet $10 per feet $100000 1220 $100000 0.50 Amount Budget at Completion BAC) 2Planned Value (P 3Earned Value 4Actual Cost (AC) 5Cost Variance (C 6 Schedule Variance (SV) 7 Cost Performance Index (CP 100000 AC%work Given EV-AC EV-PV EV/AC $50000-S45000 $50000-$60000 $50000 S45000 $50000 S60000 $1000001 11.11% (S10000) Adverse 111.11% 83.339 90000 9 Estimate at Completion (EAC) CPI EAC-AC Estimate to Complete (ETC) 11 Variance at Completion (VAC) BAC-EAC $100000-$90000 $10000 ($100000 S45000) 41 H Sheetl Sheet2 Sheet3 Ready !File Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX Define Name Trace Precedents calculate Now | 嚃Trace Dependents ◆Error Checking . Remove Arrows Evaluate Formula ruse in Formula- watch Calculation Calculate Sheet Window | Options Insert Autosum Recently Financial Logical Text Date & Lookup & Math More - Time- Reterence - & Trig - FunctionsManager ECreate from SelectionRemove Arrows-Evaluate Formula Windo Options Function Library Defined Names Formula Auditing Calculation Particulars Budget at Completion (BA Formula Feet fence*Cost foot BAC(%tree passed) BAC%work completed 10000 feet $10 per feet $100000 12/20 $100000 0.50 Amount -10000*10 -100000 12/20 -100000 0.5 Earned Value Actual Cost (AC EV-AC $50000-$45000 50000-S60000 $50000 $45000 $50000 S60000 $100000 111.11% ariance Schedule Variance (SV) EV-PV EV/AC ($10000) Adverse -50000/45000 10 7 Cost Performance Index (CPI) Schedule Performance Index (SPD Estimate at Completion (EAC Estimate to Complete (ET 0000 60000 F4 F10 BAC CPI EAC-AC BAC-EAC BAC-EV BAC/AC 12 9 letion $100000-$90000 10000 $100000 $45000 Complete Performance Index 41 H Sheetl Sheet2 Sheet3 ,ウ

"If you have any Query, then please put it in the comment box."

Add a comment
Know the answer?
Add Answer to:
Project ABC Scope = 10 chairs @ $10.00 = $100.00 PV = Timeframe = 10 days...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Complete the following exercises and submit them in a word document (10 points). Project ABC Scope...

    Complete the following exercises and submit them in a word document (10 points). Project ABC Scope = 10 chairs @ $10.00 = $100.00 PV = Timeframe = 10 days At the End of the 5th day 4 chairs were EV = Completed at a cost of $11.00 each CPLE SV = SPIE To install a 10,000 feet fence at a cost of $10.00/per foot. It is estimated that 500 feet of fence can be installed per week for a total...

  • To install a 10,000 feet fence at a cost of $10.00/per foot. It is estimated that...

    To install a 10,000 feet fence at a cost of $10.00/per foot. It is estimated that 500 feet of fence can be installed per week for a total of 20 weeks. After 12 weeks and with 50% of work completed $45,000.00 has been spent. Calculate the following and submit the exercise results in a Word document. #feet fence Budget at Completion (BAC) cost/foot BAC * (%time Planned Value (PV) passed) Earned Value (EV) ВАС * % Actual Cost (AC) Cost...

  • Remaining Time: 57 minutes, 05 seconds Less than half of the team Question Comeletion Status Question...

    Remaining Time: 57 minutes, 05 seconds Less than half of the team Question Comeletion Status Question 10 Save A You have a project to be completed in 12 months. The budget for the project is 100.000 USD. Six months have passed, and 60.000 USD has been spent. On closer review, you find that only 40% of the work has become to date. Based on these figures, answer the following questions to receive full grade you must show your work 1....

  • Scope = 10chairs @ $10.00-$100.00 Timeframe 10 days At the End of the 5th day 4...

    Scope = 10chairs @ $10.00-$100.00 Timeframe 10 days At the End of the 5th day 4 chairs were Completed at a cost of $11.00 each PV: AC EV CPI- sv=

  • Using the below information answer only part e bolded. Given the following information for a one-year...

    Using the below information answer only part e bolded. Given the following information for a one-year project, answer the following questions. Note that PV is the planned value, EV is the earned value, AC is the actual cost, and BAC is the budget at completion. PV = $22,000 EV = $20,000 AC = $25,000 BAC = $120,000 a.What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? (CV) is -$5,000 (SV)...

  • to chapter 1. Given the following information for a one-year project, answer the following questions. Recall...

    to chapter 1. Given the following information for a one-year project, answer the following questions. Recall that PV is the planned value, EV is the earned value, AC is the actual cost, and BAC is the budget at completion. PV = $22,000 EV = $20,000 AC = $25,000 BAC = $120,000 a. 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...

  • Canyouhelpme with this questionYou are managing a project to expand a major county road in your...

    Canyouhelpme with this questionYou are managing a project to expand a major county road in your area. The project is expected to take 1 year and the expenses are budgeted to be $12,500 per month. Six months after the project started, you find out that the project is 50% complete, and that you have spent $70,000. Fill in the information in the table below: Item Value BAC PV EV AC CV = EV-AC SV = EV – PV CPI =...

  • At week 10 of a project below to improve distance learning platform, assume that the planned...

    At week 10 of a project below to improve distance learning platform, assume that the planned values (PV) are based on time proportionality but the “% Complete” values for earned values (EV) are from the workers actually doing the tasks. ACTIVITY PRE- DECESSORS DURATION (WEEKS) BUDGET ($) ACTUAL COST ($) % COMPLETE A - 5 500 640 100 B A 3 300 400 100 C B 4 320 310 80 D B 6 600 250 60 E C,D 3 300...

  • 2. You are 4.5 months into a 6-month, $12,000 project with a planned linear spend rate....

    2. You are 4.5 months into a 6-month, $12,000 project with a planned linear spend rate. You have an earned value of $8,500 and you have spent $10,000. What is your EAC? (2 points) 3. The earned value on your project is $15,000, the planned value is $20,000, and the actual cost is $18,000. What is your current schedule variance (in $)? (1 point) 5. You are working on a large project and have determined that your cost variance is...

  • You are given the following information for a one-year project: Planned Value (PV) - $23,000, Earned...

    You are given the following information for a one-year project: Planned Value (PV) - $23,000, Earned Value (EV) - $20,000, Actual Cost (AC) = $20,000, and Budget at Completion (BAC) = $120,000. Answer each of the questions below to complete your assignment. Use the same numbers as the assignment when you give your answer, I only grade answers that correspond the assignment questions. 1. For this one-year project calculate: a. cost variance, b. schedule variance, C. cost performance index (CPI),...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT