wild west end internet co-op... a practical demonstration of elephant economics
    about wwe - accounts - projections - journal - netstat


projected 2 years - thru 2009 february  (also see projected 4 years with new or quit or inactive members)


 avg members                       3.2
 service months                                24
 member months                                            78

                      total     avg per     avg per    avg per
costs               to-date      member      month    mbr-month

 service cost        798.00      245.54      33.25      10.23
 + equipment         170.67       52.51       7.11       2.19
                    -------      ------     ------     ------
 = costs total       968.67      298.05      40.36      12.42
 - others income       0.00        0.00       0.00       0.00
                    -------      ------     ------     ------
 = members cost      968.67      298.05      40.36      12.42
 - members income   -968.67     -298.05     -40.36     -12.42
                    -------      ------     ------     ------
 = members owe         0.00        0.00       0.00       0.00

       

                   total     avg per     avg per    avg per
assets           to-date      member      month    mbr-month

 members paid    1056.00      324.92      44.00      13.54
 + others paid      0.00        0.00       0.00       0.00
 - costs paid    -968.67     -298.05     -40.36     -12.42
                 -------      ------     ------     ------
 = bank total      87.33       26.87       3.64       1.12
 + others owe       0.00        0.00       0.00       0.00
 - payables         0.00        0.00       0.00       0.00
 - mbr refunds    -87.33      -26.87      -3.64      -1.12
                 -------      ------     ------     ------
 = net money        0.00        0.00       0.00       0.00
 + equipment      170.67       52.51       7.11       2.19
 - deprec        -128.00      -39.38      -5.33      -1.64
                 -------      ------     ------     ------
 = net assets      42.67       13.13       1.78       0.55



costs           months   rate    cost     paid    owed           2007 feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2008 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2009 jan  feb

 service
                   24   33.25   798.00                      cost  15        30   32   32   32   33   33   30   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33
                                        798.00              paid            30   30   30   30   30   33   33   26   27             66   32   33   33   33   33   33   33   33   33   33   33        33   68
 equipment
                   24    7.11   170.67                      cost 215  100                                         70.67                -95                                                             -120
                                        170.67              paid      100                                         70.67


members    share   use   rate   actual   bl/pd     owe           2007 feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2008 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2009 jan  feb

 dale & karen
           12.94   24   12.24   293.81  302.00  -18.19      bill  50        10   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11
            30%   100%   99%            312.00              paid            70   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11

 chris
           12.94   24   12.24   293.81  302.00  -18.19      bill  50        10   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11
            30%   100%   99%            312.00              paid       50   20   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11

 bob
           12.94   24   12.24   293.81  302.00  -18.19      bill  50        10   10   10   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11
            30%   100%   99%            312.00              paid            60   10   20   10   10   10   10   10   10   10        10   10   11   11   11   11   11   11   11   11   11   11        11   11

 kara & mark
            3.84   6    14.54    87.23  110.00  -32.77      bill  50        10                                      10   10        10   10   10
            9%    25%   117%            120.00              paid       50   50                                                     20

 neal
            0      0    15.30     0.00    0.00    0.00      bill  50                                                                   -25                                                              -25 
            0%     0%   123%              0.00              paid


non-members       use    rate     bill    paid     owe           2007 feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2008 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2009 jan  feb

 guests
                   0              0.00            0.00      bill
                   0%     0%              0.00              paid



history / proj      2007   feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2008   jan    feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2009   jan    feb

 member-months                     4      7      10     13     16     19     22     25     29     33            37     41     45     48     51     54     57     60     63     66     69     72            75     78
 costs / mbr-month               90.00  56.00  42.40  35.08  30.56  27.47  25.09  23.40  23.75  21.87         20.40  16.89  16.13  15.81  15.52  15.27  15.05  14.84  14.66  14.49  14.34  14.20         14.08  12.42
 income / mbr-month              72.50  41.70  31.87  26.24  22.89  20.68  19.10  17.93  17.45  16.84         16.30  15.49  15.13  14.84  14.59  14.37  14.18  14.00  13.85  13.71  13.58  13.46         13.35  12.42
 money / mbr-month              -17.50 -14.30 -10.53  -8.84  -7.67  -6.80  -5.99  -5.47  -6.30  -5.02         -4.10  -1.40  -1.00   -.96   -.93   -.90   -.87   -.84   -.81   -.79   -.77   -.74          -.72   0.00

 avg members                      4.00   3.50   3.33   3.25   3.20   3.17   3.14   3.12   3.22   3.30          3.36   3.42   3.46   3.43   3.40   3.37   3.35   3.33   3.32   3.30   3.29   3.27          3.26   3.25
 assets / avg member             56.83  51.58  47.86  41.56  35.38  29.55  24.95  19.75  14.47  15.35         15.64  25.69  26.68  24.29  22.00  19.80  17.70  15.69  13.78  11.96  10.23   8.59          7.03  13.13


notes

 internal calculations accurate to .000001, display amounts rounded to nearest cent.
 each member's % share of net assets = % share paid of total member costs.
 actual monthly rate for each member depends on months use of service - higher use, lower rate.
 members who owe more than their monthly rate may not have access to the service.
 negative debt = positive credit.  isp equipment costs waived after first 2 years.
 some isp service bills yet to be reconciled...
 please inform the treasurer of any errors or omissions.