[RFC] Earned Value Management Report

[elicoidal]

Objective

Create a Earned Value Management Report to link the information from the BR with the one from the timesheets

module: business_requirement_earned_value
dependency: hr_timesheets, business_requirement_deliverable
Menu: Reporting / Project
Entry Name: Earned Value Management

Information for dimensions:

• (A) BR name
• (B) BR description
• (C) BR Customer
• (D) BR Master Project
• (E) Product from RL
• (F) Product from Timesheet (*)

Information for measures

• (G) Planned time in RL
• (H) Product Cost from RL
• (I = G x H) Planned Value (PV)
• (J) Actual time in Timesheet
• (K) Product Cost from Timesheet product
• (L = J x K) Actual Cost (AC)
• (M = L - I) Variance
• (N = M / H) % Variance
• (O) Remaining time (**)
• (P = J + O) Total expected time
• (Q = J / P) % Project Completion
• (R = I * Q) Earned Value (EV)

Accessibility only to "BR Cost manager"
(*) based on all timesheets from tasks linked to the BR
(**) from the field remaining time of tasks related to the BR

Additional resources: http://www.brighthubpm.com/monitoring-projects/97906-calculating-earned-value/

[elicoidal]

@jbeficent What do you think?
I know that you currently have a module with similar scope but it is not integrated with BR (unfortunately I could not test it properly due to some traceback)
I dont know how we could merge the concept with BR management

[elicoidal]

fix by #107