Description of calculations

All calculations are made when the user access the Results Page (results.htm), utilising the latest inputs to the Setup, Costs and Benefits Pages. All data is lost when the user selects Exit.


Summary of costs report

Area analysed column: shows, for costs that would be borne by the organisation as a whole, the total cost x (number of these users in the part of the organisation you wish to analyse / size of your organisation's total projected intranet user population)

Start-up capital costs

New PCs: cost of a new PC x number within the target population who will need new PCs

Networking: cost of providing a network connection to a PC x number within the target population who are currently not networked

Server hardware and software: direct from Costs

Information publishing: (number of bespoke applications x cost per bespoke application) + (number of off-the-shelf applications x cost per off-the-shelf applications)

E-mail (server): direct from Costs

E-mail (clients): cost per e-mail client x target population

Document management: (number of bespoke applications x cost per bespoke application) + (number of off-the-shelf applications x cost per off-the-shelf applications)

Training: (number of bespoke applications x cost per bespoke application) + (number of off-the-shelf applications x cost per off-the-shelf applications)

Workflow: (number of simple applications x cost per simple application) + (number of bespoke applications x cost per bespoke application) + (number of off-the-shelf applications x cost per off-the-shelf applications)

Databases/bespoke systems: number of bespoke applications x cost per bespoke application

Discussion: (number of bespoke applications x cost per bespoke application) + (number of off-the-shelf applications x cost per off-the-shelf applications)

Start-up revenue costs

Design consultancy: direct from Costs

Promotion: direct from Costs

Training: training cost x target population

Ongoing capital costs

Server upgrades: upgrades to server hardware and software % x server hardware and software cost

Application upgrades: upgrades to off-the-shelf applications % x total of all start-up off-the-shelf applications costs (including e-mail clients)

Ongoing revenue costs

Editorial/design personnel: number of editorial and design personnel x cost per editorial and design person

Technical personnel: number of technical personnel x cost per technical person

Internet access: cost per PC of providing Internet access x number within the target population who will have Internet access

Maintenance of bespoke apps: maintenance of bespoke applications % x total of all start-up bespoke application costs

Design consultancy: ongoing consultancy % x start-up consultancy cost

Promotion: ongoing promotion % x start-up promotion cost

Training: ongoing training % x start-up training cost


Summary of benefits report

In each case, population = target population x numbers affected % and minutes per year = 60 x average working hours in a day x average working days in a year.

Information publishing

Direct cost savings: total of (units x cost x proportion %) x population. Figures in pence must be converted to pounds. Where units are per day, they must be multiplied by average working days in a year.

Labour savings: ((total of minutes saved x average working days in a year) / minutes per year) x population x average annual salary and benefits.

Productivity benefits: (total of productivity percentages / (100 + total of productivity percentages)) x population x average annual salary and benefits.

E-mail

As information publishing

Document management

As information publishing

Training

Direct cost savings: (1) courses x cost per person x proportion + (2) ((population x courses) / number of attendees) x cost per course x proportion

Labour savings: (1) hours x 60 + (2) average length in hours x courses x reduction in time % x 60; (total of (1) and (2) / minutes per year) x population x average annual salary and benefits.

Productivity benefits: As information publishing.

Workflow

Direct cost savings: As information publishing.

Labour savings: (1) mins x number of forms x population + (2) (days x average working hours in a day x 60) x (number of bespoke and off-the-shelf workflow applications); (total of (1) and (2) / minutes per year) x average annual salary and benefits.

Productivity benefits: As information publishing.

Databases/bespoke systems

Direct cost savings: None

Labour savings: As information publishing.

Productivity benefits: As information publishing.

Discussion

As information publishing.


Profit and loss report

Benefits

Benefits totals are all taken from Summary of Benefits Report. For year 1, total is multiplied by percentage of full year's benefit expected in year one of implementation. Years 2 to 5 are identical.

Capital costs

Start-up and ongoing capital costs are spread over the number of years in the write off period.

Revenue costs

Editorial/design personnel, technical personnel, Internet access: identical each year.

Maintenance of bespoke apps: nil in year 1; thereafter identical.

Design consultancy, promotion, training: start-up cost in year 1; ongoing cost thereafter.


Return on investment report

Total investment

Totals of start-up capital and revenue costs.

Return on investment

Benefits: for year 1, total is multiplied by percentage of full year's benefit expected in year one of implementation. Years 2 to 5 are identical.

Ongoing capital costs: nil in year 1; thereafter identical.

Ongoing revenue costs: year 1 is a total of ongoing editorial/design personnel, technical personnel and Internet access. Years 2-5 include all ongoing costs and are identical.

Return on investment: total return / total investment x 100.

Accumulated ROI: total of ROI to date.

Payback period

If return in year 1 exceeds total investment, then program states this.

If accumulated return after five year is less than total investment, then program states this.

In all other cases, program gives the number of months required for return to equal total investment. Calculated as (amount still to be paid back after year 1 / (total return in year 2 / 12) + 12.