earned_value {pmev}

Calculate the Earned Value of a Project Schedule to Date

Description

Given a set of project activities start times, end times, progress and costs, this function calculates the Earned Value at a certain Date

Usage

earned_value(
  start,
  end,
  progress,
  planned_cost,
  project_value,
  cost_to_date,
  date = today()
)

Arguments

start

Start Date of activity

end

End Date of activity

progress

Proportion between 0 and 1 representing percentage completed for each activity (1 = 100% complete)

planned_cost

The planned costs of each activity

project_value

The total value of the project

cost_to_date

The total amount spent on the project to date

date

Character date "YYYY-MM-DD". Defaults to today.

Value

A list of two data frames:

• pv Planned Value Schedule, a data frame with two columns:

  • date: Daily Dates over Project Schedule

  • planned_value: The Planned Value to be delivered at that date.

• ev Earned Value Calculations, a data frame with 15 columns:

  • date: Date of calculation

  • total_value: Total Value of the Project.

  • budget_at_completion: Aggregate costs of all of the task budgets

  • project_complete: Project Complete based on Earned Value and total Project Value.

  • schedule_complete: The difference in Earned Value and Planned value as a proportion of the Total Value.

  • planned_value: The amount of the project that is supposed to have been completed.

  • earned_value: The amount of the project that is actually completed

  • actual_cost: Actual Cost is the actual to-date cost of the project.

  • schedule_variance: The amount that the project is ahead or behind schedule.

  • cost_variance: How far the task is over or under budget.

  • cost_performance_index: Relative amount of the variance to Planned Value.

  • estimate_at_completion: What the overall project budget will be if everything else went according to plan.

  • estimate_to_complete: How much money must be spent from this point forward, to complete the project.

  • variance_at_completion: The forecasted cost variance (CV) at the completion of the project.

  • to_complete_performance_index: What CPI would be necessary to finish the project on budget.

Examples

data(project)
earned_value(start = project$start,
              end = project$end,
              progress = project$progress,
              planned_cost = project$planned_cost,
              project_value = 150000,
              cost_to_date = 10000,
              date = "2024-07-03")