# Membership scenario modelling - **To access the modelling tool please click here 👉 [Copim Opening the Future revenue projections modeller v5.xlsx](https://compass.copim.ac.uk/attachments/6)** - **Your rate of conversion to OA on the frontlist will rely on how many library subscriptions you can gain. These are, of course, subject to market conditions and the financial picture for HEIs.** - **Funder mandates may make the market more amenable in the coming years.** Below are the financial models, calculators and plans that we used with our first two publishers in 2021, and which our ongoing work is still based on. The first step towards implementing an Opening the Future model is understanding your own press’s finances and what the transformation could look like. To that end, we produced a membership modelling tool that allows you to insert your own figures and then to model the resulting scenarios. **Disclaimer**: this is just a 'ballpark' modelling tool to help you understand and model how a portion of backlist could be used to fund new OA frontlist books, it doesn't constitute financial advice. There are many variables, chief among them being that we can never know how many libraries will get on board, but the modeller will give you a good idea of what might be achieved under certain conditions. The spreadsheet defaults to £GBP currency but you can change that to your own currency if you like, the calculations remain the same. **To access the modelling tool (an MS Excel spreadsheet) please click here 👉 [Copim Opening the Future revenue projections modeller v5.xlsx](https://compass.copim.ac.uk/attachments/6)** The table below describes what's in the Excel spreadsheet:
**Variable Name** | **Description** | **Example figures** |
Base cost per book | The basic cost per book to get to first digital copy. | £8,900.00 |
Approx. billing agent fee per membership transaction (presses may wish to add a slightly higher figure in this box to also account for sales agent fees, if applicable) | The fee requested by a billing agent per membership transaction. | £85.00 |
Bank fee per transaction | The fee requested by the Press’s bank per transaction | £15.00 |
Higher Band | The fee rate for ‘large’ band (biggest) library subscribers. | £1,200.00 |
Middle Band | The fee rate for ‘middle’ band (middle size) library subscribers. | £800.00 |
Lower Band | The fee rate for ‘lower’ band (smallest) library subscribers. | £350.00 |
Number of titles in backlist | The number of titles that are offered in the ‘backlist’ package (i.e. how many books does the library get as an exclusive reward for joining?) | 50 |
Number of yearly titles in frontlist | The number of titles that the press aspires to make openly accessible every year under this scheme. | 25 |
OA deposit fee per book (e.g. OAPEN per-title fee) | The fee to deposit each OA book (for example, in OAPEN). | £10.00 |
OA deposit annual membership fee (e.g. OAPEN annual membership fee) | The annual membership fee to be able to deposit books (for example, the OAPEN annual fee). | £175.00 |
Secondary annual OA deposit location fee (e.g. JSTOR) | The annual membership fee to be able to deposit books in a secondary location (for example, JSTOR). | £100.00 |
One-time setup fee | The one-off staff labour cost of sorting out the backlist titles into packages. | £2,000.00 |
Approx. annual fee (based on 300 members) | The annual fee from a platform provider to provide access to the backlist. | £3,000.00 |
Approx. annual deposit fee per backlist title | The annual fee per backlist title book for a platform provider, to provide access to the title. | £100.00 |
Creation of metadata records per backlist title | The cost of creating metadata records for an item of backlist content. | £50.00 |
Format-shift costs (e.g. improved digital copies, OCRing PDF text, creating epub) per title | The costs of ensuring that the backlist is in a viable format for digital delivery. | £100.00 |