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


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


 avg members                       2.6
 service months                                48
 member months                                           126

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

 service cost       1590.00      605.71      33.12      12.62
 + equipment         170.67       65.02       3.56       1.35
                    -------      ------     ------     ------
 = costs total      1760.67      670.73      36.68      13.97
 - others income       0.00        0.00       0.00       0.00
                    -------      ------     ------     ------
 = members cost     1760.67      670.73      36.68      13.97
 - members income  -1707.87     -650.62     -35.58     -13.55
                    -------      ------     ------     ------
 = members owe        52.80       20.11       1.10       0.42

       

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

 members paid    1776.00      676.57      37.00      14.10
 + others paid      0.00        0.00       0.00       0.00
 - costs paid   -1760.67     -670.73     -36.68     -13.97
                 -------      ------     ------     ------
 = bank total      15.33        5.84       0.32       0.12
 + others owe       0.00        0.00       0.00       0.00
 - payables         0.00        0.00       0.00       0.00
 - mbr refunds    -68.13      -25.95      -1.42       -.54
                 -------      ------     ------     ------
 = net money      -52.80      -20.11      -1.10       -.42
 + equipment      170.67       65.02       3.56       1.35
 - deprec        -160.00      -60.95      -3.33      -1.27
                 -------      ------     ------     ------
 = net assets     -42.13      -16.05       -.88       -.33



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
          -15.52   48   13.51   648.53  662.00  -23.47      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
            37%   100%   97%            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
          -15.52   48   13.51   648.53  662.00  -23.47      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
            37%   100%   97%            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

 bob
           -7.47   24   15.20   364.80  302.00   52.80      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
            18%   50%   109%            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
           -2.36   6    16.47    98.80  110.00  -21.20      bill  50        10                                      10   10        10   10   10
            6%    12%   118%            120.00              paid       50   50                                                     20

 neal
            0      0    16.89     0.00    0.00    0.00      bill  50                                                                   -25                                                              -25 
            0%     0%   121%              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

 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                     4      7      10     13     16     19     22     25     29     33            37     41     45     48     51     54     57     60     63     66     69     72            75     78     80     82     84     86     88     90     92     94     96     98           100    102    104    106    108    110    112    114    116    118    120    122           124    126
 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  12.52  12.62  12.71  12.80  12.88  12.96  13.04  13.11  13.18  13.25         13.32  13.38  13.44  13.50  13.55  13.61  13.66  13.71  13.76  13.80  13.85  13.89         13.93  13.97
 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  12.52  12.62  12.71  12.80  12.85  12.89  12.93  12.98  13.02  13.05         13.09  13.13  13.17  13.21  13.25  13.28  13.32  13.35  13.39  13.42  13.46  13.49         13.52  13.55
 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   0.00   0.00   0.00   0.00   -.03   -.07   -.10   -.14   -.17   -.20          -.22   -.25   -.27   -.29   -.31   -.32   -.34   -.35   -.37   -.38   -.39   -.40          -.41   -.42

 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   3.20   3.15   3.11   3.07   3.03   3.00   2.97   2.94   2.91   2.88          2.86   2.83   2.81   2.79   2.77   2.75   2.73   2.71   2.70   2.68   2.67   2.65          2.64   2.62
 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  12.58  12.05  11.53  11.03   9.69   8.00   6.34   4.73   3.15   1.62          0.12  -1.34  -2.75  -4.13  -5.48  -6.78  -8.06  -9.29 -10.50 -11.67 -12.81 -13.92        -15.00 -16.05


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.