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


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


 avg members                       3.1
 service months                                48
 member months                                           150

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

 service cost       1590.00      508.80      33.12      10.60
 + equipment         170.67       54.61       3.56       1.14
                    -------      ------     ------     ------
 = costs total      1760.67      563.41      36.68      11.74
 - others income       0.00        0.00       0.00       0.00
                    -------      ------     ------     ------
 = members cost     1760.67      563.41      36.68      11.74
 - members income  -1760.67     -563.41     -36.68     -11.74
                    -------      ------     ------     ------
 = 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    1848.00      591.36      38.50      12.32
 + others paid      0.00        0.00       0.00       0.00
 - costs paid   -1760.67     -563.41     -36.68     -11.74
                 -------      ------     ------     ------
 = bank total      87.33       27.95       1.82       0.58
 + others owe       0.00        0.00       0.00       0.00
 - payables         0.00        0.00       0.00       0.00
 - mbr refunds    -87.33      -27.95      -1.82       -.58
                 -------      ------     ------     ------
 = net money        0.00        0.00       0.00       0.00
 + equipment      170.67       54.61       3.56       1.14
 - deprec        -160.00      -51.20      -3.33      -1.07
                 -------      ------     ------     ------
 = net assets      10.67        3.41       0.22       0.07



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.38   48   11.64   558.53  566.00  -17.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   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            32%   100%   99%            576.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   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 chris
            3.38   48   11.64   558.53  566.00  -17.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   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            32%   100%   99%            576.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   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 bob
            3.38   48   11.64   558.53  566.00  -17.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   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11
            32%   100%   99%            576.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   11   11   11   11   11   11   11   11   11   11        11   11   11   11   11   11   11   11   11   11   11   11        11   11

 kara & mark
            0.52   6    14.18    85.09  110.00  -34.91      bill  50        10                                      10   10        10   10   10
            5%    12%   121%            120.00              paid       50   50                                                     20

 neal
            0      0    14.54     0.00    0.00    0.00      bill  50                                                                   -25                                                              -25 
            0%     0%   124%              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     81     84     87     90     93     96     99    102    105    108           111    114    117    120    123    126    129    132    135    138    141    144           147    150
 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.37  12.32  12.27  12.23  12.19  12.15  12.12  12.08  12.05  12.02         12.00  11.97  11.95  11.92  11.90  11.88  11.86  11.84  11.82  11.80  11.78  11.77         11.75  11.74
 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.37  12.32  12.27  12.23  12.19  12.15  12.12  12.08  12.05  12.02         12.00  11.97  11.95  11.92  11.90  11.88  11.86  11.84  11.82  11.80  11.78  11.77         11.75  11.74
 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   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

 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.24   3.23   3.22   3.21   3.21   3.20   3.19   3.19   3.18   3.18          3.17   3.17   3.16   3.16   3.15   3.15   3.15   3.14   3.14   3.14   3.13   3.13          3.13   3.12
 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.43  11.76  11.14  10.54   9.97   9.43   8.92   8.43   7.97   7.54          7.13   6.74   6.37   6.02   5.69   5.37   5.08   4.80   4.54   4.29   4.05   3.82          3.61   3.41


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.