Finance project

You are the sponsor for project XY. The project manager has provided you the following three status reports. The project started on 2/1 and it is now the end of the 4th week. For this assignment, complete this packet in its entirety to include all tables, blanks, and questions. Complete the file and submit as your completed assignment. Percent: Completion Report Activity

Date Started

Percent completed

Time to Complete (weeks)

AB

2/1

100

Completed

AC

2/1

60

2

AD

2/1

100

Completed

DE

Not started—delayed

n/a

3

BF

2/14

40

3

Project Planning Budget: Dollars Budgeted Per Week for Each Activity, Project Starting 2/1 Activity

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Total $

AB

2,000

2,000

2,000

 

 

 

 

 

6,000

AC

3,000

4,000

4,000

4,000

5,000

 

 

 

20,000

AD

2,000

3,000

2,500

 

 

 

 

 

7,500

BF

 

 

 

2,000

3,000

4,000

3,000

3,000

15,000

CE

 

 

 

 

 

2,500

 

 

2,500

DE

 

 

 

3,500

3,500

3,500

 

 

10,500

EF

 

 

 

 

 

 

3,000

 

3,000

Total:

7,000

9,000

8,500

9,500

11,500

10,000

6,000

3,000

64,500

Cost Summary

Week Ending

Cumulative to Date

 

 

 

 

Activity

Budget Cost

Actual

(Over) / Under

Budget Cost

Actual

(Over) / Under

AB

6,000

6,200

(200)

AC

4,000

4,500

(500)

15,000

12,500

2,500

AD

2,400

(2,400)

7,500

7,400

100

BF

2,000

2,800

(800)

2,000

4,500

(2,500)

DE

3,500

3,500

3,500

3,500

Total

9,500

9,700

(200)

34,000

30,600

3,400

It is now the end of Week 4 and you want to determine the status of the project using earned value management. Complete the table and earned value metrics below. Some of the information has already been entered for you. Activity

% Complete

Planned Value (PV)

Earned Value (EV)

Actual Cost (AC)

Cost Variance

Schedule Variance

Total Budget

AB

 

 

 

6200

 

 

6000

AC

60

 

12000

 

 

 

20000

AD

 

 

 

 

 

 

7500

BF

 

 

6000

 

 

 

15000

CE

0

 

0

 

 

 

2500

DE*

0

 

0

 

 

 

10500

EF

0

 

0

 

 

 

3000

TOTAL

 

 

 

 

 

 

64500

* Note that activity DE has been delayed and does not impact the calculations.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Calculate each of the following:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cost Variance ($) = EV – AC

 

 

 

 

 

 

 

Schedule Variance ($) = EV – PV

 

 

 

 

 

 

 

Schedule Variance (weeks) = Schedule Variance ($) / Average Weekly PV

 

 

 

 

 

 

 

Cost-at-Completion = (Rate of Spending x Total Budget) = ([AC / EV] * Total Budget)

 

 

 

 

 

 

 

CPI = EV / AC

 

 

 

 

 

 

 

SPI = EV / PV

 

 

 

 

 

 

Add your written analysis below by answering three questions: 1. What is the state of the project? 2. Which activity has had the most positive impact on the project? Which activity has had th

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)