1. Home
  2. Docs
  3. SARM 8.9 User Guide
  4. The SARM Spreadsheet Tool
  5. Benefits


This worksheet is one of two worksheets that together enable you to conduct a cost benefit analysis alongside your architecture evaluation.  It is not, therefore, formally, part of SARM, but the approach, and guidance on how to apply it, are provided in the optional cost benefit analysis section of the User Guide.

While it is beyond the scope of SARM to discuss benefits mapping and benefits realisation methods, this worksheet allows a choice of three different methods for estimating and allocating tangible financial benefits to the solution.  They require you to have an overall understanding of total benefits associated with your new or updated system or service.  This information is captured in the box in the top-left corner of the worksheet, with input data in cells C3 to C5.  Some new solutions will generate a one-off financial benefit.  If this applies to your project, enter the value of the one-off benefit in cell C3.  Some projects will realise an annual benefit, and if this applies, enter the annual value of the benefit in C4.  Of course, projects can achieve either or both types of financial benefit.  Cell C5 captures the period across which you wish to calculate total benefit (which will be compared with total cost of the competing solutions over the same period).  Indicate the number of years you wish to use for your cost benefit analysis in cell C5.

Cell C6 will then calculate the ‘Maximum benefit’, representing the result of the simple calculation of totalling the benefits across the number of years. It is called ‘Maximum’, because it is assumed that this is the highest level of possible benefits that can be achieved only if all of the scenarios are to be fully realised.  If any solution option is unable to satisfactorily achieve some scenarios, then it is reasonable to assume that some of the benefits will also not be realised.

The remainder of this worksheet is concerned with apportioning the ‘Maximum benefit’ across the set of scenarios that have been documented in the ‘Scenarios & Stakeholders’ worksheet.  Each scenario occupies a row with its description from that worksheet replicated in column B, and the risk Impact, also from that worksheet, replicated in column C.  Column D, entitled ‘Weight’, shows the corresponding numeric value of the Impact from the Risk Model.

Derived, Assigned or Hybrid benefit
This is where we come to the choice between three methods of apportioning benefit across the scenarios.  If a detailed benefit map has been developed by the project team, following the adoption of a benefits realisation method, then it should be possible to allocate the Maximum benefit amount (as shown in cell C6) across the set of scenarios.  Some scenarios are likely to derive more benefit than others, and so column F, ‘Assigned Benefit’, can be used to allocate a specific financial benefit to each scenario.  To adopt this method of apportioning benefit, you should select Assigned in cell F5.  This will cause the ‘Tangible Benefit’ column (column I) to pick up the values you’ve entered in ‘Assigned Benefit’ column (column F).  Note that the total amount allocated across the entire column will need to add up to the Maximum benefit amount displayed in C6, and if there is a difference between these amounts, a warning message will be displayed in row 7.  Be aware that you may have up to 100 scenarios, so agreeing a separate benefit amount for each scenario may require a considerable amount of work.

An alternative to this approach that is available in the SARM spreadsheet tool is to allow the levels of impact that have been assigned to each scenario to act as a weight in the distribution of the Maximum benefit across the set of scenarios.  The assumption here is that if failure to achieve a scenario will have a greater level of impact, it is likely that a greater amount of total benefit will be at risk.  The simple (but somewhat dangerous) approach adopted here is to assume that the amount of benefit attributable to each scenario is in the same proportion as the level of impact as defined in the Risk Model.  How reasonable this assumption may be is for you to decide, and you can see the consequences of it in column E (‘Derived Benefit’).  It is for you to determine whether this approach will give you a good enough approximation to make the cost benefit analysis valuable, or whether you have to explore the benefits that will be derived from each individual scenario in detail.

A third option available to you is a hybrid of the other two approaches.  If you have assigned a benefit amount to a scenario in column F (‘Assigned Benefit’), then that amount will be adopted as the tangible benefit for that scenario in column I.  If you have left the assigned benefit with a value of 0, the system will allocate a proportion of the total unassigned benefit (the difference between the total maximum benefit and the total assigned benefit) using the same method adopted for the ‘Assigned’ approach described above.  The result is a hybrid of the two approach, allowing you to assign some key benefits to specific scenarios while letting the system apportion the rest of the total benefit across the remaining scenarios weighted by Impact.

Finally, columns J to M are used to address non-financial benefits.  For these columns, in row 8, you can give specific names to up to four non-financial benefits.  To associate a scenario with a given non-financial benefit, select X in the corresponding cell.  For example, if the second scenario is associated with the first non-financial benefit, cell J10 should be set to X.  These associations then set up the ability to explore trade-offs between solution options as they relate to the non-financial benefits.  This facility is discussed in the section that describes the Tradeoff Analysis worksheet.

How can we help?