1 / 18

Membership Fees Evidence

WILDCARE. Membership Fees Evidence. SPREAD SHEET RESEARCH. http:// www.aol-soft.com /mileage-report-spreadsheet/screenshot . This spread sheet just gave me an idea of what a professional spread sheet should look like. FEES RESEARCH.

sai
Download Presentation

Membership Fees Evidence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WILDCARE Membership FeesEvidence

  2. SPREAD SHEET RESEARCH http://www.aol-soft.com/mileage-report-spreadsheet/screenshot This spread sheet just gave me an idea of what a professional spread sheet should look like

  3. FEES RESEARCH I did some research on other companies typical membership fees so that my prices are appropriate, I looked mainly at other adoption schemes but I also looked at things like cinema ticket prices as this demonstrated the difference in adult, teen and child prices. For example, at Vue the child’s ticket is £5.25, the teen ticket is £5.60 and the adult ticket is £7.05 so the ration of Child: Teen: Adult is around 3:3:4 (29.32960894:31.2849162:39.38547486). While at the National trust the ratio is around 1:1:2. I can use this knowledge to chose appropriate fees.

  4. FORMATTING AND FORMULAE: Cell Formatting: Borders to show different sections 3D referencing: Inserts values from other sheets Formulas: Calculates sum of memberships incomings

  5. FORMATTING AND FORMULAE: 3D referencing: Inserts values from other sheets Cell Formatting: Borders to make different sections clear Formulas: Calculates sum of memberships incomings Absolute cell referencing: Inserting values from other sheets to multiple cells IF statements: Using the ‘IF’ function to enter ‘Surplus’ or ‘deficit’ when necessary Conditional formatting: Shading a colour red or green depending on weather it is a profit/surplus or loss/deficit

  6. FEEDBACK: Rosie Bell: “Add an Open and Closing Cash balance to make it clear what is happening.” Tania Velez-Perez: “Your spread sheet is neat and easy to use and it has worked for all my tests.” I made the changes suggested by my test buddy, and added coloured shading to make it more user friendly.

  7. TESTING: Test 1: By making all my outgoings and incomings £0, I expected to get a total (profit/loss) of £0. The screenshot below shows that my spread sheet works according to this test.

  8. TESTING: Test 2: By making the sum of all my outgoings £1000 and my incomings £999; I expected to get a Net Cash Flow of -£1 as £900-£1000=-£1 The screenshot below shows that my spread sheet passed this test

  9. TRAILINGNUMBERS Proposal one: No membership fees for Kids and Teens However, there was too much loss To much loss

  10. TRAILINGNUMBERS Proposal two: Fees rising in multiples of five, for easy, marketable prices; however there was still too much loss: -£27354.00 To much loss

  11. TRAILINGNUMBERS Proposal three: When I added £5 to the price of each type of membership in proposal 2, the profit was too high. Profit too high

  12. TRAILINGNUMBERS Proposal four: When I decreased the price of each type of membership in proposal 3 by £3, the profit was still too high and the prices were bad for marketing. Profit too high My research suggested that these prices were too high in comparison to other companies and they were not good numbers for marketing Bad marketing prices

  13. TRAILINGNUMBERS Proposal five: When I decreased the Teen and Kids prices and increased the adult prices from Proposal 4 by £1 I still had a too high profit (surplus) and my prices were bad for marketing. Profit too high Bad marketing prices

  14. TRAILINGNUMBERS Proposal six: Reconsidering all my prices I put them as low as possible to produce the lowest profit whilst still breaking even, however after looking at my research I discovered these were bad marking prices: e.g. £5.04 as most other companies’ prices were rounded to the nearest whole number at least. E.g. A Born Free Gold Membership was £39. Bad marketing prices

  15. TRAILINGNUMBERS Proposal seven: Using my results from proposal 6, I decreased my prices slightly to make no profit and to break even with £0 surplus/deficit. However, the prices are bad for marketing and unrealistic as they are not whole numbers. Reaches £0 But bad marketing prices and unrealistic numbers (£8.506)

  16. FINAL FEES Proposal eight - Final: Using my results from proposal 6 and 7, I increased all my prices slightly in order to make them good for marketing, so they are either whole pounds or halves as these are appropriate numbers for sales. Final Membership fees: My research shows that these are suitable values for membership as they are similar to those of other organisations, if not cheaper: The WildCare Kids membership costs £5, which is the same as the Animal Care Children's price.

  17. CORPORATE IDENTITY In order to show my corporate identity I then formatted the spread sheet to match my other publications.

More Related