Adaptive Case Management (ACM) practitioners have a need to periodically assess progress toward Case Goals/Objectives at individual Cases.
In an environment where tasks are part of a workflow that has a start and an end, it is fairly easy to identify milestones. Not so, in an environment that accommodates ad hoc interventions.
I will describe here a figure of merit matrix approach where case managers can input progress information and immediately gain a reading on progress toward an overall Case Objective.
The starting position is a list of Objectives with a quantitative assessment of relative contribution in terms of an overall Case Objective. In the example below we see three Objectives O1, O2 and O3 with relative weights of 70/20/10.
Objective 1 has four deliverables D11, D12, D13, D14 with relative weights of 40/20/30/10. Objective 2 has three deliverables D21, D22, D23 with relative weights of 20/30/50. Objective 3 has one deliverable D31.
The model calculates a contribution for each deliverable (sub-objective)
Contribution= Earned Value X Weight
The range of Earned Values per deliverable runs from 0 to 100. A recording of 0 implies no value, a recording of 100 implies that a deliverable is ‘ready’. No assumptions are made as to the unit of measure (time, cost, performance) but users of the model should be consistent in the selection of a unit of measure at a particular case. For cross-case statistical calculations units should not be mixed ( i.e. a choice of percent complete will understate progress at the start and overstate progress at the end because of “S” curve).
The sum of Deliverable Contributions for an Objective must equal 100.
Case Earned Value derives as follows:
Earned Value = (O1 Contribution X O1 Weight) + (O2 Contribution X O2 Weight)+ . . .
Objective Weights appear at row 5 (user inputs)
Deliverable Earned Values appear in column B (user inputs)
Deliverable Weights appear in column C (user inputs)
Calculated Deliverable Contributions appear in columns D, E, F (excluding row 5)
Calculated Objective Contributions appear in column G
Calculated Case Earned Value appears in cell I24.
The model accommodates any number of Objectives plus any number of Deliverables per Objective.
Calculated control totals are recommended for across Objectives (Cell H5) and across Deliverables at each Objective (C12, C18, C22). If the sum of Objective weights or Deliverable weights does not add up to 100 in each category, the model will fail.
Each Case should have its own spreadsheet attached to the Case as a ‘document’. Workflows can be set up to force “case reviews” every week/month, as appropriate.
Copies of the CASE MATRIX MANAGER are available from Civerex Systems Inc. by e-mailing firstname.lastname@example.org
Comments on the validity of the model would be appreciated. Clearly, this is a very simple model but it can be set up with a pre-blocked set of objectives and deliverables such that no customization is needed per case.