Site management
Powered by Squarespace
Search

This spreadsheet calculator enables you to estimate the benefits of document automation with Ezidocs. Simply enter numbers in the white boxes on the spreadsheet.  You can download as an Excel file or open in a larger window

Note: If your organisation is not sales focussed, simply enter 0 in revenue.

Calculations are divided into three categories of benefit:

  • productivity - the time cost of creation, review and publication of documents
  • risk - the cost of risk in events associated with errors
  • sales - for sales proposals, the uplift in sales profit through better quality documents.

In the default example for an enterprise in sales:

50 sales staff create 50 proposals each per year. A proposal takes 4 hours to put together on average, half an hour to review for sign-off, and a further half hour to compile and publish. Based on assumed annual salaries of $80k for sales, $100k for management and $45k for support, and assumed annual available hours of 1498, the calculator shows each document costs $524 in staff time to create, and the total outputs cost $1.3m per annum.

The cost of risk is represented here simply as a combination of the likely cost impact of a single major event due to error (e.g. consequential commercial liability not limited by contract terms), say $500,000 and the likelihood of that event occurring (0.01% is one chance in 10,000). Spread across all documents this amounts to $50 per document, or $125,000 expected cost per annum.

The illustration has average revenue per sale of $10,000, average customer relationships lasting 3 years, gross profit margins of 33%, and win-ratios of 33%. This scenario generates $8,167,500 in gross profit through sales that involve proposals.

The benefits calculation assumes:

  • productivity improvements of 70% - halving the time required to create, review, and publish
  • risk improvements of 80% - eliminating most error risk
  • a sales lift of 20% - increasing the win rate from 33% to 40%

In this example, total cumulative benefits available to the example enterprise would amount to $2.65m per annum.