Admin
Food co-ops need to have good administrative systems to keep records of orders, sales and also contact details for members and customers.
There are a variety of systems that you could use including:
This involves using a note book or record sheets to write down orders, amounts sold, and customer details. You can buy pre-printed cash books from many stationers. But you may need to have to have several different books to record different information.
The advantage with a paper-based system is that its simple and you don't need access to a computer or any technical knowledge. However, you need to make sure that volunteers always have the relevant books, so they have be taken to every food co-op session. Also it is more difficult to create a back up copy, apart from with carbon paper or making photocopies - so if your books were ever mislaid then you could lose a lot of valuable data.
The other disadvantage is that as everything has to be handwritten it could also take a lot of time to fill in, especially if there are a lot of members. It may also be more open to error due to misreading the information or adding up wrong.
You can use Microsoft Excel or a similar spreadsheet programme to type your information into a table on the computer. Excel is designed to record both contact details and financial information and can be used to do various calculations, including working out your prices or calculating your overall expenditure.
The advantages with using a computer-based spreadsheet are that the data is in a standardised format and it can be e-mailed to different people involved in the food co-op. It is also possible to cut and paste information from other spreadsheets, for example catalogues from wholefood suppliers.
The main disadvantage is that you need to have a copy of the software, as well as IT equipment and so this is another on-going cost you will need take into account when doing your budget. Anyone responsible for updating the records will need to have IT skills, although spreadsheets are relatively easy to use.
Access databases are quite sophisticated but are also simple to use for entering information. You may need a dedicated admin person who is responsible for entering all the orders - but it is also important that everyone else at the food co-op understands how to use it in case of sickness or absence.
The main advantage of using a database is once you have set it up and entered all the products and customer details it can speed up order compilation and reduces errors. You can also produce reports so you can see easily whether your sales have increased. An Access database works well if you have regular customers and they order similar items every time e.g. if you run a bag or box scheme or a wholefood co-op.
The main disadvantage is that Access databases do not handle finances apart from putting in total prices of goods per customer. So you will still need other software to do your accounts, such as Excel or Sage. Also they can be quite complicated to set up if you are not fully trained in how to use Access.
Having a web-based database allows your customers to place their orders and pay on-line. Most web-based systems will manage all finances as well as customer details and orders and also have other functions such as enabling you to print off invoices. This sort of system is good if you have large numbers of customers and also if you have several different outlets or multiple drop offs.
The main advantage is that all your orders will be handled by one system rather than lots of different spreadsheets and databases. Also if designed well they are generally very user friendly and easy to use.
The main disadvantage is that anyone using the system needs to have Internet access. However in some cases if a lot of your customers don't have computers then you may be able to identify someone who could enter orders on their behalf e.g. a school receptionist entering orders on behalf of parents. Also there is always a cost whenever you pay on-line, as payment systems like Paypal charge a fee per order and a percentage of the cost. Therefore paying on-line is really only cost effective if you spending quite a lot. However, it is also possible for people to order on-line but still pay by cash, cheque or standing order. A web-based system may also cost quite a lot to develop so you may need to secure funding for this and there will be an on-going web hosting cost.
Sustain is currently working with various food projects to trial IT systems in particular web-based databases to work out if they offer a cost effective solution and help to reduce time spent on admin. To find out more e-mail foodcoops@sustainweb.org
