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


projected 4 years with 1 quit member  (also see projected 2 years, and 4 years with new or inactive members)


 avg members                       2.1
 service months                                48
 member months                                           102

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

 service cost       1590.00      748.24      33.12      15.59
 + equipment         170.67       80.32       3.56       1.67
                    -------      ------     ------     ------
 = costs total      1760.67      828.55      36.68      17.26
 - others income    -312.00     -146.82      -6.50      -3.06
                    -------      ------     ------     ------
 = members cost     1448.67      681.73      30.18      14.20
 - members income  -1446.54     -680.72     -30.14     -14.18
                    -------      ------     ------     ------
 = members owe         2.13        1.00       0.04       0.02

       

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

 members paid    1464.00      688.94      30.50      14.35
 + others paid    312.00      146.82       6.50       3.06
 - costs paid   -1760.67     -828.55     -36.68     -17.26
                 -------      ------     ------     ------
 = bank total      15.33        7.21       0.32       0.15
 + others owe       0.00        0.00       0.00       0.00
 - payables         0.00        0.00       0.00       0.00
 - mbr refunds    -17.46       -8.22       -.36       -.17
                 -------      ------     ------     ------
 = net money       -2.13       -1.00       -.04       -.02
 + equipment      170.67       80.32       3.56       1.67
 - deprec        -160.00      -75.29      -3.33      -1.57
                 -------      ------     ------     ------
 = net assets       8.54        4.02       0.18       0.08



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  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2010 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2011 jan  feb

 service
                   48   33.12  1590.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   33   33   33   33   33   33   33   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33
                                       1590.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   33   33   33   33   33   33   33   33   33   33        33   33   33   33   33   33   33   33   33   33   33   33        33   33
 equipment
                   48    3.56   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  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2010 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2011 jan  feb

 dale & karen
            3.96   48   14.02   673.07  662.00    1.07      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   15   15   15   15   15   15   15   15   15   15        15   15   15   15   15   15   15   15   15   15   15   15        15   15
            46%   100%   99%            672.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   15   15   15   15   15   15   15   15   15   15        15   15   15   15   15   15   15   15   15   15   15   15        15   15

 chris
            3.96   48   14.02   673.07  662.00    1.07      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   15   15   15   15   15   15   15   15   15   15        15   15   15   15   15   15   15   15   15   15   15   15        15   15
            46%   100%   99%            672.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   15   15   15   15   15   15   15   15   15   15        15   15   15   15   15   15   15   15   15   15   15   15        15   15

 kara & mark
            0.60   6    17.09   102.54  110.00  -17.46      bill  50        10                                      10   10        10   10   10
            7%    12%   120%            120.00              paid       50   50                                                     20

 neal
            0      0    17.53     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  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2010 jan  feb  mar  apr  may  jun  jul  aug  sep  oct  nov  dec  2011 jan  feb

 bob
                  24    13.00   312.00            0.00      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   21
                  50%    92%            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

 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    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2010   jan    feb    mar    apr    may    jun    jul    aug    sep    oct    nov    dec    2011   jan    feb

 member-months                     3      5      7      9      11     13     15     17     20     23            26     29     32     34     36     38     40     42     44     46     48     50            52     54     56     58     60     62     64     66     68     70     72     74            76     78     80     82     84     86     88     90     92     94     96     98           100    102
 costs / mbr-month              120.00  78.40  60.57  50.67  44.45  40.15  36.80  34.41  34.43  31.38         29.03  23.89  22.68  22.31  21.99  21.70  21.44  21.21  20.99  20.80  20.62  20.45         20.30  17.94  17.89  17.84  17.79  17.75  17.71  17.68  17.64  17.61  17.58  17.55         17.52  17.50  17.47  17.45  17.42  17.40  17.38  17.36  17.34  17.33  17.31  17.29         17.28  17.26
 income / mbr-month             100.00  60.14  45.14  37.48  32.88  29.82  27.63  26.01  25.21  24.16         23.21  21.75  21.13  20.81  20.53  20.28  20.07  19.87  19.70  19.54  19.39  19.26         19.14  17.94  17.89  17.84  17.79  17.75  17.71  17.68  17.64  17.61  17.58  17.55         17.52  17.50  17.47  17.45  17.42  17.40  17.38  17.36  17.34  17.33  17.31  17.29         17.28  17.24
 money / mbr-month              -20.00 -18.26 -15.43 -13.19 -11.57 -10.33  -9.17  -8.40  -9.22  -7.22         -5.81  -2.14  -1.55  -1.51  -1.46  -1.42  -1.38  -1.34  -1.30  -1.26  -1.23  -1.19         -1.16   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00          0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00   0.00          0.00   -.02

 avg members                      3.00   2.50   2.33   2.25   2.20   2.17   2.14   2.12   2.22   2.30          2.36   2.42   2.46   2.43   2.40   2.37   2.35   2.33   2.32   2.30   2.29   2.27          2.26   2.25   2.24   2.23   2.22   2.21   2.21   2.20   2.19   2.19   2.18   2.18          2.17   2.17   2.16   2.16   2.15   2.15   2.15   2.14   2.14   2.14   2.13   2.13          2.13   2.12
 assets / avg member             79.11  75.73  67.23  58.37  49.39  40.81  33.94  26.19  20.22  21.93         22.48  34.51  35.56  32.24  29.01  25.89  22.89  20.00  17.24  14.60  12.08   9.67          7.37  18.96  17.98  17.04  16.15  15.30  14.48  13.71  12.98  12.29  11.63  11.00         10.41   9.84   9.31   8.81   8.33   7.87   7.45   7.04   6.66   6.29   5.95   5.62          5.31   4.02


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.