Membership Fees

1. Membership Fees Robin Marsh

2. Initial cash flow forecast

3. Feedback • Add colours to make the spread sheet easy to read off, with contrasting colours that aren’t too intimidating • Add conditional formatting so that when the total is a surplus or a deficit, the cell with turn green or red • Use borders to highlight the different sections of the cash flow forecast, such as the incomings and outgoings • Use colours and shading to make the spread sheet have a professional appeal whilst making it easier for the user to understand.

4. Formatting Cells I applied a conditional formatting rule so that when there was a DEFICIT the cell would turn red, and when there was a SURPLUS the cell would turn green. This visually indicated if there was a profit or a loss. I used clashing colours so that a clear contrast could be made between the incomings and outgoings. I also used colours to make the spread sheet easy for the user to read off, as they can see the separate sections. I formatted the appropriate cells to be in a currency form so that they would automatically have a £ sign to 2 decimal places.

5. Formulas This shows all the formulas used to get the values in the spread sheet.

6. Membership Research From my research I discovered that the annual fees were rounded up to the nearest £10, however with a senior membership the fee was rounded to 1 decimal place. Similarly with the monthly fees, the cost was to the nearest 5p. In order to reach a breakeven profit, I may have to round the fees to the nearest 5p; I will apply this to the children and teen’s membership fees if possible as their fees are discounted from the original adult membership fee.

7. Getting to Breakeven These show the cost values I entered in attempt to breakeven and reach zero. The circled cost is the total which should be ask close to zero as possible.

8. Getting to Breakeven I managed to get closer to zero with values ‘£15.30’ and ‘£12.73’, however from my research I discovered that these were not realistic fees. Therefore I used the fees ‘£15.30’ and ‘£12.75’ which were rounded to the nearest 5. I reached a £59 profit, which was under £100 more than breakeven.

9. Testing the Spread Sheet I put all the original costs down to £0 to test that the formulas within the database linked with each other. My test was successful and the total profit and loss came to £0.

10. Testing the Spread Sheet I made the total Outgoings to be £10 and the total Incomings to be £100, and the test confirmed that the Net Cash Flow totalled at £90. This proves that the formulas for my Net Cash Flow are working successfully along with the Outgoings and Incomings.