Cost Modelling Tool Now Available

Business chart by S Falkow CC BY NC 2.0

Business chart by S Falkow CC BY NC 2.0

This cost modelling tool is intended to be used to help establish an internal business case to set up an APC fund for Open Access publishing. It allows you to model different cost projections based on variables such as FTE, number of articles, REF submission targets, and % Green vs Gold OA.

There are two Excel files available: one is blank and the other contains sample values to show a worked example and so that you can get an idea of the kinds of results it provides.

JISC OA Cost Model Version 0.17 Example

JISC OA Cost Model Version 0.17 Blank

Both files include a Powerpoint Quickstart guide embedded within the home page. This steps you through the workflow and shows how to edit the various variables to customise your model.

The tool is a development of initial work undertaken Northumbria University in 2014 which led to the University Executive approving a £100K/annum internal fund for Gold Open Access costs.

We anticipate that this will be most useful to institutions which have received a lower/no block grant from RCUK, but there may be other use cases that we have not yet considered.

This is an interim version of the tool and it is still under development. Our Pathfinder would welcome any comments or questions about this tool in order to improve and widen usability.

Mark Harland, Senior Planning Analyst, and part of our Pathfinder team at Northumbria, has done most of the work on this tool. Please email or alternatively leave a comment on this blog post.

This tool is released under a Creative Commons Attribution license.


About David Young

I'm a Research Funding & Policy Manager based in Research & Business Services at Northumbria University. I support research funding bids to a range of funders, focusing on the Faculty of Engineering and Environment. I also support a number of research policy areas across the university: open access, research data management, CRIS, research strengths, and REF impact.
This entry was posted in Project and tagged , . Bookmark the permalink.

2 Responses to Cost Modelling Tool Now Available

  1. Pingback: Establishing a business case for an OA APC fund: Northumbria Pathfinder’s Cost Modelling tool | Open Access Good Practice

  2. Pingback: Pathfinder Update 3 | Optimising resources to develop a strategic approach to Open Access

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s