Question

calculate the

1.percent scedule variance?

2.percent cost variance?

3.total scedule variance?

4. total cost variance?

M uit ve tal Cost Variance (5 points)? Planned Budget Cost/Time review as of Day 55 Planned Actual Percent Percent Duration Duration Scheduled Performed Budgeted Cost Work Performed Actual Cost Work Performed 210 Budgeted Cost Work Scheduled 240 100% 100% 100% 1009 8 100% $ . 150 $ $ $ 6 8 15 100% 400 100% 100% 100% 100% 23 $ - $ 100% 100% 100% 70% $ - $ 450 Demo and Earhwork UG Plumbing / Piping Foundations Slab on Grade Order/ Deliver Steel Steel Erection Tilt-up Panels Deck & Roofing Interior Rough Mechanical Fire Protection Electrical Interior Finish Paving / Landscape 60 150 400 - 800 600 200 120 320 200 160 90 240 . 8 6 0 0 100% 60% 40% 30% 0% $ $ $ $ $ $ $ $ $ 50$ . 8 10 0% 0% Cumulative cost Google Chro...

Answer 1

We will first calculate budgeted cost of work scheduled and budgeted cost of work performed as shown below:

B E H K L M N A Planned Budget Planned Planned Duration planned Actual Duration Actual Percent Scheduled Percent Percent Performed percent bude com G Budgeted cost work performed $ 240 $ 60 $ 150 $ 400 00 $ $ $ 240 60 150 400 8 6 6 8 15 F2*B2 F3*B3 same Actual cost work performed $ 210 $ 100 $ 150 $ 400 Budegted cost work scheduled $ 240 $ 60 $ 150 $ 400 E2*B2 E3*B3 same same - 6 8 9 23 00 - 0 same - 100% 100% 100% 100% 100% 100% 70% 30% 100% 100% 100% 100% 100% 100% 100% 100% 60% 40% 10% same $ 2 Demo and E. UG PI. 4 Found Slab. Order. Steel. Tilt. Deck. 10 Interior. 11 Mechanical. 12 Fire. 13 Electrical. 14 Interior. 15 Paving. 16 Cumulative cost 10 $ $ $ 800 420 60 same $ $ 950 450 50 $ $ $ same same same same - 8 same 800 600 200 72 128 T$ - 6 0% 800 600 200 120 320 200 160 90 240 S - 0 | $ same 8 100 8 $ $ $ $ $ $ $ $ same 20 16 - 0% 0% 0% 0% 0% 10% same 0% 0% 12 $ $ $ 2,130 SUM(G2:615) 2,310 SUM(12:115) $ 2,686 SUM(12:J15)

Planned Value is the approved value of the work to be completed in a given time.

PV= $2,686

Actual Cost is the total expense incurred for the actual work completed to date ( Day 55),

AC = $2,310

Earned Value is the work actually completed to date (Day 55),

EV = $2,130

3. Total schedule variance, SV = EV – PV

SV = $2,130 - $2,686

SV= - $556

Project is behind schedule since Schedule Variance is negative.

4. Total cost variance, CV = EV – AC

CV = $2,130 - $2,310

CV = - $180

Project is over budget since Cost Variance is negative.

1. Percent schedule variance, SV % = Schedule Variance (SV) / Planned Value

SV % = - $556/   $2,686

SV % = - 20.70%

2. Percent cost variance, CV % = Cost Variance (CV) / Earned Value

CV% = - $180 / $2,130

CV% = -8.45%

Please give thumbs up/ likes if you find this answer helpful. Thank you!