Complicated example: project has children tasks

PIM = Hour-Based

EAC Method = Roll up from tasks/ subtasks

  1. Create Project A with six tasks where Task 3 is the parent of Tasks 4 and 5 and Task 1 is the parent of Tasks 2 and 3 as shown below:
    Task 1
       Task 2
       Task 3
          Task 4
          Task 5
    Task 6

  2. Assign Tasks 2, 4, 5, and 6 to User 1 whose cost/hr rate is $100.00.

  3. Add planned/actual hours each task and % Complete according to the table below.

    NOTE
    For Tasks 1 and 3, you are only adding actual hours.
TaskPln HrsAct Hrs% Complete
Task 110 hrs
Task 25 hrs10 hrs20%
Task 310 Hrs
Task 410 hrs10 hrs40%
Task 515 hrs10 hrs50%
Task 620 hrs10 hrs60%
  1. Add 50 hours directly to the project (More>Hours>Log Hours) so that there is $5,000.00 of actual labor cost recorded directly to the project.

  2. Run Recalculate Finance

  3. CPI for Task 2 = .1 calculated as follows:
    CPI for Task 2 = IF Actual Hours > 0 THEN

    CPI = TotalBudgetedCostWorkPerformed/Actual Hours
    

    ELSE CPI = 1
    CPI for Task 2 = 1 / 10
    CPI for Task 2 = .1

  4. EAC for Task 2 = 50 hrs calculated as follows:
    EAC for Task 2 = IF CPI <> 0 THEN

    EAC = Planned Hours / CPI
    

    ELSE EAC = Planned  Hours + Actual  Hours
    EAC for Task 2 = 5 / .1
    EAC for Task 2 = 50 hrs

  5. CPI / EAC for Task 4, Task 5, and Task 6:
    Task 4 = .4 / 25 hrs
    Task 5 = .75 / 20 hrs
    Task 6 = 1.2 / 16.67 hrs

  6. CPI for Task 3 = .38
    CPI for Task 3 = IF Actual Hours > 0 THEN

    CPI = TotalBudgetedCostWorkPerformed/Actual Hours
    

    ELSE CPI = 1
    CPI for Task 3 = 11.5 / 30
    CPI for Task 3 = .38

  7. EAC for Task 3 = EAC Task 4 + EAC Task 5
    EAC for Task 3 = 25 + 20
    EAC for Task 3 = 45 hrs

  8. CPI for Task 1 = .25 calculated as follows:
    CPI for Task 1 = IF Actual Hours > 0 THEN

    CPI = TotalBudgetedCostWorkPerformed/Actual Hours
    

    ELSE CPI = 1
    CPI for Task 1 = 12.5 / 50
    CPI for Task 1 = .25

  9. EAC for Task 1 = EAC Task 2 + EAC Task 3
    EAC for Task 1 = 50 + 45
    EAC for Task 1 = 95 hrs

  10. CPI for Project = .22 calculated as follows:
    CPI for Project = IF Actual Hours > 0 THEN

    CPI = TotalBudgetedCostWorkPerformed/Actual Hours
    

    ELSE CPI = 1
    CPI for Project = 24.5 / 110
    CPI for Project = .22272
    CPI for Project = .22

  11. EAC for project = EAC Task 1 + EAC Task 6
    EAC for project = 95 + 16.67
    EAC for project = 111.67 hrs

PIM= Cost-Based

Simple example: project has no children tasks

PIM = Cost-Based

EAC Method = Roll up from tasks/ subtasks

  1. Create Project A with three tasks (no child tasks) all assigned to User 1 whose cost/ hr is $100.00.
  2. Add planned/ actual hours to each task and % Complete according to the table below:
TaskPln HrsPln Lbr CostAct HrsAct Lbr Cost% Complete
Task 15 hrs$500.0025 hrs$2,500.0020%
Task 210 hrs$1,000.0025 hrs$2,500.0030%
Task 315 hrs$1,500.0025 hrs$2,500.0040%
  1. Add expenses to each task according to the table below:
TaskExpensePlanned AmountActual Amount
Task 1Task 1 Exp 1$300.00$400.00
Task 1Task 1 Exp 2$500.00$0.00
Task 2Task 2 Exp$200.00$100.00
Task 3Task 3 Exp$800.00$700.00
  1. Add two expenses to the project (i.e. not tied to a task) as follows:
ExpensePlanned AmountActual Amount
Project Exp 1$1,000.00$1,500.00
Task 1 Exp 2$2,500.00$0.00
  1. Based on the above values, the Incurred/ Not Incurred Costs are determined as follows:
TaskNot Incurred Planned ExpenseIncurred Planned ExpenseIncurred Actual Expense
Task 1$500.00$300.00$400.00
Task 2$0.00$200.00$100.00
Task 3$0.00$800.00$700.00
Project$3,000.00$2,300.00$2,700.00
  1. From Project Actions, run Recalculate Finance

  2. CPI****for Task 1 = .14 calculated as follows:
    CPI****for Task 1  = IF Actual Labor Cost + IncurredActualExpenseCost  <> 0 THEN

    CPI = (TotalBudgetedCostWorkPerformed + IncurredPlannedExpenseCost) / (ActualLaborCost + IncurredActualExpenseCost)
    

    ELSE CPI = CPI_Labor
    CPI****for Task 1  = (100+300) / (2500+400)
    CPI****for Task 1  = 400 / 2900
    CPI****for Task 1  = .14

  3. EAC****for Task 1 = $13,400.00
    CPI Labor****for Task 1 = IF Actual Labor Cost <> 0 THEN

    CPI_Labor = TotalBudgetedCostWorkPerformed / Actual Labor Cost
    

    ELSE CPI_Labor = 1
    CPI Labor****for Task 1 = 100/2500
    CPI Labor****for Task 1 = .04

    EAC Labor****for Task 1 = IF CPI_Labor <> 0 THEN

    EAC Labor = Planned Labor Cost / CPI_Labor
    

    ELSE EAC  Labor = Planned Labor Cost + Actual Labor Cost
    EAC Labor****for Task 1 = 500.00/.04
    EAC Labor****for Task 1 = $12,500.00

    EAC Expense****for Task 1 = IncurredActualExpenseCost + NotIncurredPlannedExpense
    EAC Expense****for Task 1 = $400.00 + $500.00
    EAC Expense****for Task 1 = $900.00

    EAC****for Task 1 = EAC Labor + EAC Expense
    EAC****for Task 1  = $12,500.00 + $900.00
    EAC****for Task 1  = $13,400.00

  4. Here are the CPI / EAC values for Task 2 and Task 3:
    Task 2 = .19 / $8,433.33
    Task 3 = .44 / $6,950.00****

  5. The CPI for the project = .32
    CPI****for Project = IF Actual Labor Cost + IncurredActualExpenseCost  <> 0 THEN

    CPI = (TotalBudgetedCostWorkPerformed + IncurredPlannedExpenseCost)/(ActualLaborCost + IncurredActualExpenseCost)
    

    ELSE CPI = CPI_Labor
    CPI****for Project = (1000 + 2300) / (7500 + 2700)
    CPI****for Project = 3300 / 10200
    CPI****for Project = .32

  6. EAC for the project is $28,783.33
    EAC****for Project = EAC Task 1 + EAC Task 2 + EAC Task 3
    EAC****for Project = $13,400.00 + $8,433.33 + $6,950.00
    EAC****for Project = $28,783.33

Previous pageProject status will not change from Complete to Current
Next pageCalculation example - calculate EAC at the Project Level

Workfront


Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action

Workfront

Tuesday, Mar 4, 6:00 PM UTC

Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.

Register

The Perfect Blend: A New Era of Collaboration with AEM and Workfront

Adobe Customer Success Webinars

Wednesday, Apr 2, 5:00 PM UTC

Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register to learn something new

WORKFRONT

Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.

Register