earned_value: Calculate the Earned Value of a Project Schedule to Date

In pmev: Calculates Earned Value for a Project Schedule

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")

pmev documentation built on Sept. 11, 2024, 8:49 p.m.