Member Category
Members are those customers who have paid a fixed amount to you in advance. The fixed amount to be paid depends on the different schemes you have implemented in your cyber cafe. Every scheme may have a different rate which is calculated depending on the maximum rate you charge for any customer. Every new scheme you create should have an entry in this 'Category Master' with a pair of 'Name' and 'Discount %' fields.
This menu item appears under the Masters menu as shown below in the screen-shot:
Fig. 1.6 Member Category
When this menu item is clicked you will be asked to enter Admin password. Enter the password and you will see a screen similar to the one shown below:
Note:
Click somewhere on the image to read the corresponding description.
Fig. 1.7 Category Master
How to create a Member Category?
Creating a member category can be best explained by an example as below:
Note: To proceed with, we will require the maximum rate you charge for any customer . The maximum rate would be the rate per hour you charge for a non-member (a walk-in customer). Definitely, the rates you will charge for your members would be less than this maximum rate.
Let's assume that, you charge Rs. 30/- per hour for a non-member.
You may decide to implement the following schemes for your customers (pre-paid members):
| Sr. No. |
Scheme Name |
Rate in Rupees (Rs.) |
Theoretical Value
(h x MaxR) |
Actual Value
(fixed by you) |
| 1 |
Pack10Hours |
300 |
275 |
| 2 |
Pack20Hours |
600 |
525 |
| 3 |
Pack50Hours |
1500 |
1200 |
| where, |
'h' is the number of hours in a scheme |
'MaxR' is the maximum rate you charge |
Table 1.1
As shown in Table 1.1 above, the Actual Value is less than the Theoretical Value, by a certain amount. Since, we need to enter the 'Discount %' for a category, we will have to calculate the percentage difference between the Theoretical Value and the Actual Value.
We use the following formula for calculating the percentage difference:
Discount % = (Theoretical Value - Actual Value) / (Theoretical Value) x 100
Table 1.2 below, shows the percentage difference for the above three schemes, which is calculated by using the above formula:
Sr. No. |
Scheme Name |
Discount % |
1 |
Pack10Hours |
8.33 |
2 |
Pack20Hours |
12.5 |
3 |
Pack50Hours |
20 |
Table 1.2
After you have calculated the discount % for all your schemes you can add them to the category master. |
