Given the case study information, produce a cost estimate, budget, status, forecast, and a dashboard. Components Content Cost Plan Estimates including basis, technique, constraints, risks, range, and budget s-curves. Cost Status Report Accurate assessment of the earned value, BAC, PV, AC, SPI, SV, CPI and CV Forecast Reasonable forecast with EAC, ETC, VAC and s-curves with actual and forecast. Include valid assumptions and explain why the assumptions were made. Dashboard Single page dashboard that efficiently displays the status of the project and forecasted cost and schedule. The dashboard must be written in business language. Present the curve graph showing EV, PV, and AC.Complete the Excel sheet with cost plan, cost status report, and forecast.

As of Dec. 31st

Activity Name

Resource

Hourly Rate

Estimated Effort (Hours)

Start date

End date

Estimate ($K CDN)

Dec. 31 % complete

Actual Cost (AC)

Earned Value (EV)

Basis of Estimates

Estimating technique

Constraints

Risks

Range

Low Estimate

High Estimate

Systems Architecture

IT Architect

$ 100

40

Dec. 6

Dec. 10

100%

$ 4,400

Design Education TV Package

IT Designer

$ 80

32

Dec. 13

Dec. 16

60%

$ 3,200

Identify the Billing Systems Changes

IT Designer

$ 80

32

Dec. 17

Jan. 6

0%

Build the Education TV Package

Programmer

$ 75

64

Jan. 7

Jan. 18

0%

Implement the Billing System Changes

IT Operations

$ 45

32

Jan. 19

Jan. 24

0%

IT Lab set-up for Testing

IT Tester

$ 55

32

Jan. 25

Jan. 28

25%

$ 400

Test the Education TV Package

IT Tester

$ 55

16

Jan. 31

Feb. 1

0%

Test the Billing System Changes

IT Tester

$ 55

16

Feb. 2

Feb. 3

0%

Schedule Production Maintenance Window

IT Operations

$ 45

4

Feb. 4

Feb. 4

0%

Turn-up IT systems changes in production for new TV package and billing

IT Operations

$ 45

4

Feb. 18

Feb. 18

0%

Schedule Note:

Holidays no one works Dec. 20 - Jan 3, inclusive

Production work must be scheduled 2 weeks in advance.

Item

Name

Formula

BAC

Budget at Completion

=sum all planned activity = PV

PV

Planned Value

= sum of all planned activities, to the status date.

AC

Actual Cost

= sum of all dollars spent to the status date = AC

EV

Earned Value

= sum of all earned value to the status date = EV

SPI

Schedule Performance Index

= EV/PV

Note: SPI greater than 1 is favorable i.e. ahead of schedule.

SV

Schedule Variance

= EV-PV

Note: SV greater than 0 is favorable i.e. ahead of schedule.

CPI

Cost Performance Index

= EV/AC

Note: CPI greater than 1 is favorable i.e. under budget.

CV

Cost Variance

= EV-AC

Note: CPI greater than 0 is favorable i.e. under budget.

EAC1

Estimate at Completion1

= BAC/CPI:

1Assuming cost performance will continue.

EAC2

Estimate at Completion2

=AC+((BAC-EV)/(CPI*SPI))

2Assuming the schedule is fixed.

EAC3

Estimate at Completion3

=AC+(BAC-EV)

3Assuming the cost performance to date was an anomaly.

EAC4

Estimate at Completion4

=AC+ new bottom-up ETC

4 New estimate is required.

ETC

Estimate to Complete

= EAC - AC

VAC

Variance at Completion

= BAC - EAC

Note VAC greater than 1 favorable i.e. under budget.

TCPI

To-Complete Performance Index (Schedule)

=(BAC-EV)/(BAC-AC)

To-Complete Performance Index (Cost)

=(BAC-EV)/(EAC-AC)