Docstoc

Total

Document Sample
Total Powered By Docstoc
					ANALYSIS

Last 3 Months
Renewal Rate




New and
Regained Members


Revenue




Comparing Against Projections
Combined Revenue




Combined Count




YTD & YTG Count




YTD & YTG Revenue
Renewal Rate
           Campuses renewed at the highest rate (90%) since Oct 2008, just before the AASHE 2008             Renewal Rates by Count f
           Conference. Businesses renewed at the highest rate since February (60%). The handful of           (if n<5, not included)
           Other members renewed at a rate of 43%. The overall renewal rate pegged our projection of         100%
           83% dead-on. In fact, since our first projections went into effect in April, our *overall*         90%
           projection of renewals has been off by only +1.3% at the most each month.                          80%
                                                                                                              70%
           For the second straight month, more new and regained members (58) joined this month                60%
           (August) than any previous month this year. This is in keeping with the historical trend of        50%
           higher new memberships coming at the start of the Fall semester.                                   40%
                                                                                                              30%
                                                                                                              20%
           Overall membership revenue was the highest of the year in August ($85k) but was lower than
                                                                                                              10%
           our projection of ($98), primarily because: a) we did not achieve our new business member
                                                                                                               0%
           goals in August; and b) most of the campus members we lost in August tended to be on the




                                                                                                                    Jul-08
           higher end of the pay scale (Cornell, University of Guelph, Johnson & Wales University,
           Providence, Lenoir-Rhyne).

                                                                                                              All Combined Revenue
                                                                                                              (new & renewal from all
ainst Projections
            August combined revenue was $10,000 less than projected, primarily becase a) we did not           $180,000
            achieve our new business member goals in August, and b) most of the campus members we             $160,000
            lost in August tended to be the higher end of the pay scale. Halfway through the month of         $140,000
            September, we have already reached the combined revenue we projected for September. This          $120,000
            is primarily thanks to strong campus renewals and Johnson Controls renewing at the Business       $100,000
            Supporter level.                                                                                   $80,000
                                                                                                               $60,000
                                                                                                               $40,000
           At the end of August, we were 6 members ahead of our combined membership count                      $20,000
           projection. Thanks to strong renewals and new member growth that we've seen in the first half            $-
           of September, we expect to increase the lead over our combined membership projection in
           September.
           We were at 533 new & renewed members at the end of August. This is 63% of our projected
           end-of-year count (of 843), and we are 66% of the way through the year. This is a good place to
           be given that 42% of our members have Sep-Dec renewal dates and that fall semester months
           have traditionally been strong months for new member recruitment. As for our originally
           budgeted end-of-year count (of 1,178) we're only 45% of the way there at 66% of the way
           through the year (but we are not using the original count for our projections)..

           Our YTD revenue is $478k as of September 1. This is 59% of our projected revenue of $807k for
           the year. We're 66% of the way through the year. This is not necessarily a cause for concern,
           given that 41% of our membership renewal revenue is due between July and December. Our
           YTD revenue is 68% of our originally budgeted YTD membership revenue.
Our YTD Renewal Rate by count is 72.2%. Our Q2 projection anticipates a renewal rate for the
year of 73.9%, so we expect to see an uptick in the overall renewal rate. Our originally
budgeted renewal rates were 100.5% for the year, and 104% YTD.
Renewal Rates by Count for Each Sector
                                                                                                   Campus
(if n<5, not included)
                                                                                                   Business
                                                                                                   Others
                  Aug-…




                                                                                                                            Aug-…
                                            Nov-…

                                                    Dec-…




                                                                               Mar-…



                                                                                                  May-…
                                                                                       Apr-09
       Jul-08



                          Sep-08




                                                                     Feb-09




                                                                                                                   Jul-09
                                   Oct-08




                                                            Jan-09




                                                                                                          Jun-09

 All Combined Revenue
 (new & renewal from all sectors)                                                               Actual
                                                                                                Projected
$180,000                                                                                        Budgeted
$160,000
$140,000
$120,000
$100,000
 $80,000
 $60,000
 $40,000
 $20,000
      $-
                                                                                                          Oc

                                                                                                                     No
                                                     ay




                                                                                                                                De
                          Fe




                                            Ap




                                                                                       Au

                                                                                                 Se
                                   M




                                                                Ju
                Jan




                                                                              Jul
                                   ar



                                                     M


                                                                n
                          b




                                                                                                 p
                                                                                        g




                                                                                                                                 c
                                                                                                                      v
                                                                                                           t
                                             r
Q2 Projections based on Sept '08 -Feb '09 renewal rate (for renewals) / # members joined Oct '08
 1000        Membership Totals by Month                                                                                                                                                                                                                                  2000       Path to Mem
  900                                                                                                                                                                                                                                                                    1800
  800                                                                                                                                                                                                                                                                    1600
  700                                                                                                                                                                                                                                                                    1400
  600                                                                                                                                                                                                                                                                    1200
  500                                                                                                                                                                                                                                                                    1000
                                                                                                                                                                                                      Other Members
  400                                                                                                                                                                                                                                                                     800
                                                                                                                                                                                                      Business Members
  300                                                                                                                                                                                                                                                                     600
                                                                                                                                                                                                      Campus Members
  200                                                                                                                                                                                                                                                                     400
  100                                                                                                                                                                                                                                                                     200
    0                                                                                                                                                                                                                                                                       0




                                                                                                                                                                                                            7/31/2…
                   1/31/2…
                             2/29/2…
                                       3/31/2…
                                                 4/30/2…
                                                             5/31/2…
                                                                       6/30/2…
                                                                                 7/31/2…
                                                                                           8/31/2…
                                                                                                     9/30/2…
                                                                                                                 10/31/…
                                                                                                                           11/30/…
                                                                                                                                     12/31/…
                                                                                                                                               1/31/2…
                                                                                                                                                         2/28/2…
                                                                                                                                                                   3/31/2…
                                                                                                                                                                             4/30/2…
                                                                                                                                                                                        5/31/2…
                                                                                                                                                                                                  6/30/2…


                                                                                                                                                                                                                      8/31/2…
                                                                                                                                                                                                                                9/30/2…
                                                                                                                                                                                                                                          10/31/…
                                                                                                                                                                                                                                                    11/30/…
                                                                                                                                                                                                                                                               12/31/…
         Jan 1st




 12 Month Renewal Rate Trends                                                                                                                                                                                                                                              New Member Reven
                                                                                                                                                                                                                                                                           60000
  110%

Renewals (All Sectors)
  100%                                                                                                                                                                                                                                                                     50000

   90%                                                                                                                                                                                                                                                                     40000
   80%
                                                                                                                                                                                                                                                                           30000
   70%                                           Budget (by #)
                                                                                                                                                                                                                                                                           20000
   60%                                           Projection (by #)

                                                 Renewal Rate (by #)
   50%                                                                                                                                                                                                                                                                     10000
                                                 Renewal Rate (by $)
   40%
                                                                                                                                                                                                                                                                                0
                                 Jun-08




                                                                                                                                                                               Jun-09
                                                                                 Oct-08




                                                                                                                                                                                                                                Oct-09
         Apr-08




                                                                                                                                                         Apr-09
                                                           Aug-08




                                                                                                                                                                                                        Aug-09
                                                                                                                                 Feb-09
                                                                                                        Dec-08




                                                                                                                                                                                                                                                      Dec-09




                                                                                                                                                                                                                                                                                    Apr-08




  Renewals & Targets                                                                                                                                                                                                                                                      New Members & Tar
                                                                                                                                                                                                                 YTD
                                                                                                                                                                                                                 YTD Budgeted
                                                                                                                                                                                                                 Annual Projection
                                                                                                                                          Annual Projection
                                                                                                                                          Annual Budget




0          100                 200                  300             400                500          600                     700                      800            900      0             50



    Renewals Revenue: 2008 to Present                                                                                                                                         New Members: 200
$90,000                                 2008                                                                                                                                 50
$80,000                                 2009                                                                                                                                 45
$70,000                                                                                                                                                                      40
$60,000                                                                                                                                                                      35
                                                                                                                                                                             30
$50,000
                                                                                                                                                                             25
$40,000
                                                                                                                                                                             20
$30,000
                                                                                                                                                                             15
$20,000                                                                                                                                                                      10
$10,000                                                                                                                                                                       5
      $-                                                                                                                                                                      0


                                                                                                                                                       Nov
                                                                                                            Aug
                                                          Apr


                                                                    May




                                                                                             Jul




                                                                                                                                                                    Dec
                               Feb


                                              Mar




                                                                                                                           Sep


                                                                                                                                          Oct
                                                                               Jun
                Jan




                                                                                                                                                                                    Jan
 Renewal Rates by Count for Each Sector
                                                                                                                                   Campus                                        All Combined Reven
 (if n<5, not included)
                                                                                                                                                                                 (new & renewal from
                                                                                                                                   Business
 100%
                                                                                                                                   Others
    90%
                                                                                                                                                                                 $180,000
    80%
                                                                                                                                                                                 $160,000
    70%
                                                                                                                                                                                 $140,000
    60%
                                                                                                                                                                                 $120,000
    50%
    40%                                                                                                                                                                          $100,000

    30%                                                                                                                                                                           $80,000
    20%                                                                                                                                                                           $60,000
    10%                                                                                                                                                                           $40,000
     0%                                                                                                                                                                           $20,000
                                                                                                   Mar-09




                                                                                                                                            Jun-09
                                                Oct-08




                                                                              Jan-09




                                                                                                                  Apr-09

                                                                                                                                 May-09
                      Aug-08




                                                           Nov-08




                                                                                                                                                                    Aug-09
           Jul-08




                                     Sep-08




                                                                                         Feb-09




                                                                                                                                                           Jul-09
                                                                     Dec-08




                                                                                                                                                                                      $-
mbers joined Oct '08-Mar '09 (for new members)

            Path to Membership Strategic Goal

                     Realized/Projected Other Members
                     Realized/Projected Business Members
                     Realized/Projected Campus Members




    New Member Revenue by Month
                                                                            Budget

                                                                            Projection

                              New Members (All Sectors)
                                                      New




        0
                     Jun-08




                                                                                  Jun-09
                                        Oct-08




                                                                                                    Oct-09
            Apr-08




                                                                   Apr-09
                               Aug-08




                                                                                           Aug-09
                                                 Dec-08


                                                          Feb-09




                                                                                                               Dec-09




   New Members & Targets
                                                                                           YTD
                                                                                           YTD Budgeted
                                                                                           Annual Projection
                                                                                                Annual Projection
                                                                                                Annual Budget




          50            100             150           200         250            300             350          400



New Members: 2005 to Present




                                                                                                              2005
                                                                                                              2006
                                                                                                              2007
                                                                                                              2008
                                                                                                              2009
                  Mar




                                                                         Oct

                                                                                 Nov
                                              Jun



                                                            Aug
                          Apr




                                                    Jul
                                      May




                                                                                          Dec
           Feb




                                                                  Sep




All Combined Revenue
(new & renewal from all sectors)                                                 Actual

                                                                                 Projected

$180,000                                                                         Budgeted
$160,000
$140,000
$120,000
$100,000
 $80,000
 $60,000
 $40,000
 $20,000
     $-
                                                                                                        Nov
                                                                           Aug
                                            Apr

                                                    May




                                                                   Jul




                                                                                                                Dec
                    Feb




                                                                                       Sep
                                Mar




                                                                                                 Oct
                                                            Jun
            Jan
Monthly Membership Report - July 2009


YEAR-TO-DATE
                                              Year To Go (To
                                       YTD        Meet            Q2 Projections
                         YTD '09     Budgeted  Projections)         (for year)   Budgeted
New                        200          250          71                271          391
Renewals                   333          481         239                572          786
Renewal Rate (by count) 72.2%          104%       72.6%               73.9%       100.5%
Lost                       128          -20          90                218           4
Total Members              533          730         310                843         1178
New Mem Revenue         $ 149,258   $ 245,256 $       97,419      $     246,677 $ 384,357
Renewals Revenue        $ 328,990   $ 462,257 $      231,387      $     560,377 $ 741,417
Renewal Rate (by revenue) 73.8%        102%       77.8%               75.4%        99.8%
Total Revenue           $ 478,248   $ 707,513 $      328,806      $     807,054 $ 1,125,774

RENEWALS



                        Total Up
                          for       # Arrived On   % Arrived On                    % Arrived
               Month Renewal            Time          Time        # Arrived Late     Late
                Jan-08      1            n/a            n/a             n/a           n/a
               Feb-08                    n/a            n/a             n/a           n/a
               Mar-08      55            n/a            n/a             n/a           n/a
               Apr-08      38            n/a            n/a             n/a           n/a
               May-08      17             9            53%               8           47%
                Jun-08     10             6            60%               2           20%
                 Jul-08    63             29           46%              25           40%
               Aug-08      49             31           63%              13           27%
               Sep-08      40             22           55%               8           20%
               Oct-08      26             10           38%              14           54%
               Nov-08      87             54           62%              21           24%
               Dec-08      48             21           44%              19           40%
                Jan-09     33             12           36%              13           39%
               Feb-09      27             12           44%               8           30%
               Mar-09      81             27           33%              28           35%
               Apr-09      64             28           44%              15           23%
               May-09      51             25           49%              15           29%
                Jun-09     38             20           53%               7           18%
                 Jul-09    87             50           57%               7            8%
               Aug-09      80             53           66%              13           16%
               Sep-09      83             50           60%               2            2%
               Oct-09      63             0             0%               0            0%
              Nov-09     111          0            0%               0             0%
              Dec-09     72           0            0%               0             0%



NEW MEMBERS

                                                                                  % of
                         Total    # of Total    Projection                     Projection
             Month      Joined   "Regained"    (Revised Q2)   # Budgeted       Achieved
              Jan-08      34           0
             Feb-08       30           0
             Mar-08       38           0
             Apr-08       33           0
             May-08       30           0
              Jun-08      19           0
               Jul-08     37           0
             Aug-08       48           0
             Sep-08       41           0
             Oct-08       39           2
             Nov-08       25           0
             Dec-08       28           0
              Jan-09      20           0            20             28            100%
             Feb-09       21           0            21             20            100%
             Mar-09       18           2            18             35            100%
             Apr-09       15           2            23             28            65%
             May-09       27           5            21             28            129%
              Jun-09      28          12            15             21            187%
               Jul-09     31           8            25             38            124%
             Aug-09       40          18            34             50            118%
             Sep-09       25          10            25             38            100%
             Oct-09                                 24             36             0%
             Nov-09                                 24             36             0%
             Dec-09                                 21             31             0%

GROWTH IN TOTAL MEMBERS + TOTAL REVENUE EACH MONTH
                       Total
                      Members                                   Difference      Projected
                       Each     Combined                      (Proj v Actual      Count
                       Month     Revenue   Projected Rev           Rev)        (Combined)
              Jan 1st      466
           1/31/2008       500 $    30,250
           2/29/2008       530 $    25,250
           3/31/2008       567 $    76,750
           4/30/2008       598 $    63,250
           5/31/2008       628 $    45,500
           6/30/2008       645 $    23,250
 7/31/2008   679   $   77,100
 8/31/2008   722   $   85,250
 9/30/2008   754   $   65,500
10/31/2008   792   $   47,750
11/30/2008   805   $   91,875
12/31/2008   824   $   55,225
 1/31/2009   836   $   46,700   $    46,700   $       -      836
 2/28/2009   850   $   39,400   $    39,400   $       -      850
 3/31/2009   841   $   68,350   $    67,350   $     1,000    843
 4/30/2009   835   $   50,710   $    65,690   $   (14,980)   845
 5/31/2009   851   $   59,576   $    53,536   $     6,040    839
 6/30/2009   867   $   44,717   $    40,858   $     3,859    855
 7/31/2009   868   $   83,305   $    77,907   $     5,398    863
 8/31/2009   894   $   85,490   $    96,107   $   (10,617)   888
 9/30/2009   919   $   78,650   $    78,766   $      (116)   894
10/31/2009   919                $    65,498
11/30/2009   919                $   104,391
12/31/2009   919                $    70,851
              2008
 Variance    Actuals
   -120        401
   -214        423
   -27%       88.1%
    214        57
   -335        824
$ (137,680) $ 333,350
$ (181,040) $ 404,800
   -24%       90.0%
$ (318,720) $ 738,150




            Renewal                                                         Renewal Rate
  Total    Projections                          % of Lost                     based on
Renewals    (Rev Q2) # Budgeted   Total Lost   "Declined"   Still Pending      count
    1                                n/a           n/a            n/a            n/a
    0                                n/a           n/a            n/a            n/a
   53                                 1            n/a            n/a           96%
   36                                 2            n/a            n/a           95%
   17                                 0            n/a            n/a           100%
    8                                 2            n/a            n/a           80%
   54                                 9           11%             n/a           86%
   44                                 5           20%             n/a           90%
   30                                10            0%             n/a           75%
   24                                 2            0%             n/a           92%
   75                                12           38%             n/a           86%
   40                                 8           56%             n/a           83%
   25          25        36           8           38%               0           76%
   20          20        29           7           14%               0           74%
   55          56        94          26           19%               0           68%
   43          45        72          21           10%               0           67%
   40          34        56          11           36%               0           78%
   27          27        37           0            0%               0           71%
   57          58        78           0          5229%              0           66%
   66          66        79           0           218%              0           83%
   52          58        78           0            0%              31           63%
    0          46        55           0            0%              63            0%
    0             83           119      0   0%   111   0%
    0             54            54      0   0%   72    0%




               Revenue
              Projection
  Total        (Revised    Revenue
 Revenue         Q2)       Budgeted
$ 29,750
$ 25,250
$ 26,250
$ 30,000
$ 26,750
$ 17,000
$ 25,100
$ 40,750
$ 34,250
$ 29,250
$ 14,250
$ 25,050
$ 21,200      $   21,200   $   27,912
$ 15,750      $   15,750   $   20,133
$ 11,900      $   11,900   $   34,775
$    6,360    $   21,919   $   27,912
$ 18,226      $   19,068   $   27,454
$ 22,727      $   13,836   $   20,591
$ 23,155      $   23,427   $   37,063
$ 29,940      $   31,740   $   49,417
$ 16,350      $   23,427   $   37,521
              $   22,497   $   35,690
              $   22,497   $   35,690
              $   19,416   $   30,199




Difference
(Proj count   Budgeted
 v Actual)    Revenue
   0   $    64,034
   0   $    51,368
   2   $   123,705
(10)   $    92,257
 12    $    82,857
 12    $    55,677
  5    $   110,005
  6    $   119,102
 25    $   112,861
       $    85,605
       $   153,496
       $    74,807
 Renewal                 Renewal        Total
   Rate       Renewal      Rate        Possible                     Revenue
Projections     Rate     based on       Dues       Realized Dues   Projections   Revenue
 (Rev Q2)     Budgeted   revenue       Revenue       Revenue        (Rev Q2)     Budgeted
                           100.0%    $       500   $         500
                               n/a   $        -    $         -
                            96.2%    $    52,500   $      50,500
                            86.4%    $    38,500   $      33,250
                           100.0%    $    18,750   $      18,750
                            78.1%    $     8,000   $       6,250
                            94.5%    $    55,000   $      52,000
                            94.7%    $    47,000   $      44,500
                            81.7%    $    38,250   $      31,250
                            93.7%    $    19,750   $      18,500
                            87.6%    $    88,625   $      77,625
                            82.3%    $    36,675   $      30,175
   76%          109%        78.0%    $    32,700   $      25,500   $   25,500    $   36,123
   74%          109%        74.5%    $    31,750   $      23,650   $   23,650    $   31,235
   69%          116%        67.1%    $    84,100   $      56,450   $   55,450    $   88,930
   70%          112%        71.3%    $    62,200   $      44,350   $   43,771    $   64,345
   67%          110%        78.8%    $    52,450   $      41,350   $   34,468    $   55,403
   71%           96%        60.9%    $    36,100   $      21,990   $   27,022    $   35,087
   67%           90%        81.8%    $    73,500   $      60,150   $   54,480    $   72,942
   83%           99%        76.4%    $    72,700   $      55,550   $   64,367    $   69,685
   70%           94%        77.2%    $    80,700   $      62,300   $   55,339    $   75,341
   73%           87%         0.0%    $    54,050   $         -     $   43,001    $   49,915
75%   107%   0.0% $   115,000 $   -   $   81,894 $ 117,805
75%    76%   0.0% $    47,550 $   -   $   51,435 $ 44,607
Campuses

YEAR-TO-DATE
                                               Year To Go                  Q2
                                       YTD      (To Meet              Projections
                           YTD '09   Budgeted Projections)             (for year) Budgeted     Variance
New                          151        204         34                    185        320         -135
Renewals                     280        403        177                    457        636         -179
Renewal Rate (by count)     78.4%     112.8%      74.1%                  76.7%     106.8%        -30%
Lost                          77        -46         62                    139        -40          179
Total Campus Members         431        607        211                    642        957         -315
New Mem Revenue           $ 116,108 $ 200,322 $      50,842           $ 166,950 $ 313,937     $ (146,987)
Renewals Revenue          $ 281,140 $ 394,617 $ 168,350               $ 449,490 $ 623,706     $ (174,216)
Renewal Rate (by revenue)   78.2%     149.9%      80.0%                  78.9%     109.5%        -31%
Total Campus Revenue      $ 397,248 $ 594,938 $ 219,192               $ 616,440 $ 937,642     $ (321,202)

RENEWALS
n/a = under 5 members; or data not available




                             Total Up for # Arrived On % Arrived On   # Arrived   % Arrived     Total
                  Month       Renewal         Time        Time          Late        Late      Renewals
                   Jan-08          1            1         100%           n/a         n/a          1
                  Feb-08           0           n/a          n/a          n/a         n/a          0
                  Mar-08          41           n/a          n/a          n/a         n/a         40
                  Apr-08          26           n/a          n/a          n/a         n/a         26
                  May-08          16            9          56%            7          44%         16
                   Jun-08          9            5          56%            2          22%          7
                    Jul-08        48            23         48%           21          44%         44
                  Aug-08          41            27         66%           11          27%         38
                  Sep-08          27            16         59%            5          19%         21
                  Oct-08          19            6          32%           12          63%         18
                  Nov-08          73            48         66%           17          23%         65
                  Dec-08          37            18         49%           15          41%         33
                   Jan-09         30            11         37%           11          37%         22
                  Feb-09          20            8          40%            6          30%         14
                  Mar-09          68            23         34%           25          37%         48
                  Apr-09          47            22         47%           13          28%         35
                  May-09          41            22         54%           12          29%         34
                   Jun-09         27            16         59%            7          26%         23
                    Jul-09        61            40         66%            7          11%         47
                  Aug-09          63            47         75%           10          16%         57
                  Sep-09          53            38         72%            2          4%          40
                  Oct-09          40                        0%                       0%           0
              Nov-09        91                            0%                        0%           0
              Dec-09        55                            0%                        0%           0



NEW MEMBERS
                                                                       % of
                                        # of Total    Projection    Projection   # Members      Total
              Month Total Joined       "Regained"    (Revised Q2)   Achieved      Budgeted     Revenue
               Jan-08    26                  0                                               $ 16,750
              Feb-08     27                  0                                               $ 24,500
              Mar-08     22                  0                                               $ 19,500
              Apr-08     25                  0                                               $ 24,250
              May-08     20                  0                                               $ 17,000
               Jun-08    15                  0                                               $ 15,000
                Jul-08   28                  0                                               $ 16,250
              Aug-08     30                  0                                               $ 26,750
              Sep-08     24                  0                                               $ 17,250
              Oct-08     27                  2                                               $ 24,250
              Nov-08     15                  0                                               $ 11,250
              Dec-08     12                  0                                               $ 12,000
               Jan-09    16                  0            16          100%          23       $ 13,600
              Feb-09     11                  0            11          100%          17       $     9,250
              Mar-09     13                  2            13          100%          29       $     8,550
              Apr-09     10                  0            14          71%           23       $     4,560
              May-09     23                  5            13          177%          23       $ 15,376
               Jun-09    20                 10             9          222%          17       $ 15,877
                Jul-09   28                  8            18          156%          31       $ 21,805
              Aug-09     30                 17            24          125%          41       $ 27,090
              Sep-09     16                  7            18          89%           31       $ 12,800
              Oct-09                                      17           0%           30
              Nov-09                                      17           0%           30
              Dec-09                                      15           0%           25

GROWTH IN TOTAL CAMPUS MEMBERS + TOTAL REVENUE FROM CAMPUS MEMBERS EACH MONTH

                           Total                                   Difference   Projected  Difference
                         Members       Combined                      (Proj v      Count   (Proj count v
                        Each Month      Revenue      Projected Rev Actual Rev) (Combined)    Actual)
              Jan 1st            366
           1/31/2008             392   $   17,250
           2/29/2008             419   $   24,500
           3/31/2008             440   $   62,250
           4/30/2008             465   $   53,500
           5/31/2008             485   $   35,250
           6/30/2008             498   $   20,750
           7/31/2008             522   $   60,000
 8/31/2008     550   $   63,250
 9/30/2008     569   $   38,000
10/31/2008     596   $   40,500
11/30/2008     603   $   72,875
12/31/2008     611   $   33,500
 1/31/2009     619   $   33,550   $   33,550   $      -     619    0
 2/28/2009     624   $   22,350   $   22,350   $      -     624    0
 3/31/2009     617   $   60,700   $   59,450   $    1,250   617    0
 4/30/2009     615   $   45,510   $   44,100   $    1,410   615    0
 5/31/2009     631   $   53,426   $   38,550   $   14,876   614   17
 6/30/2009     647   $   35,617   $   26,990   $    8,627   632   15
 7/31/2009     661   $   72,655   $   63,780   $    8,875   652    9
 8/31/2009     685   $   73,440   $   79,160
 9/30/2009     701   $   51,350   $   57,900
10/31/2009     701   $      -     $   47,170
11/30/2009     701   $      -     $   86,370
12/31/2009     701   $      -     $   57,070
     Jan-10
    Feb-10
    Mar-10
    Apr-10
    May-10
     Jun-10
      Jul-10
    Aug-10
    Sep-10
    Oct-10
    Nov-10
    Dec-10
     Jan-11
    Feb-11
    Mar-11
    Apr-11
    May-11
     Jun-11
      Jul-11
    Aug-11
    Sep-11
    Oct-11
    Nov-11
    Dec-11
     Jan-12
2008 Actuals                Weighted Avg Price Per
    271                     Member in this Sector:
    342                                  $         980
   91.4%
     30
    613
 $ 233,250
 $ 330,125
   91.7%
 $ 563,375




                                                                                       Renewal
 Renewal                                                                  Renewal        Rate
Projections    # Renewals                  % of Lost                     Rate based   Projections
 (Rev Q2)       Budgeted     Total Lost   "Declined"     Still Pending    on count     (Rev Q2)
                                 0            n/a                0           n/a
                                 0            n/a                0           n/a
                                 1            n/a                0           98%
                                 0            n/a                0          100%
                                 0            n/a                0          100%
                                 2            n/a                0           78%
                                 4           25%                 0           92%
                                 3           33%                 0           93%
                                 6            0%                 0           78%
                                 1            0%                 0           95%
                                 8           38%                 0           89%
                                 4           50%                 0           89%
     22            32            8           38%                 0           73%         73%
     14            23            6           17%                 0           70%         70%
     48            83           20           10%                 0           71%         71%
     31            59           12            0%                 0           74%         66%
     27            51            7           29%                 0           83%         66%
     19            28            4            0%                 0           85%         70%
     48            67           14           29%                 0           77%         79%
     58            60            6           17%                 0           90%         92%
     42            57            0                              13           75%         79%
     32            36                                           40           0%          80%
    72             103                            91          0%   79%
    44              38                            55          0%   80%




 Revenue
Projection     Revenue
(Rev. Q2)      Budgeted




                            Weighted Avg Price Per *NEW*
                            Member in this Sector at end of
                            Q2:
                                            $           930




$   13,600     $   22,798
$    9,250     $   16,444
$    8,550     $   28,404
$   13,720     $   22,798
$   12,090     $   22,424
$    8,370     $   16,818
$   16,740     $   30,272
$   22,320     $   40,363
$   16,740     $   30,646
$   15,810     $   29,151
$   15,810     $   29,151
$   13,950     $   24,666




 Path to
Strategic
Plan Goal

         392
         419
         440
         465
         485
         498
         522
550
569
596
603
611 Q2 Projections
619
624
617
615
614
615
620
639
646
655
653
657
667 Art Work
677
687
697
707
717
727
737
747
757
767
777
787
797
807
817
827
837
847
857
867
877
887
897
907
 Renewal
   Rate                         Realized      Revenue
based on     Total Possible      Dues        Projections   Revenue
 revenue     Dues Revenue       Revenue       (Rev Q2)     Budgeted
     100%    $         500    $        500
n/a          $          -     $        -
      98%    $      43,750    $    42,750
     100%    $      29,250    $    29,250
     100%    $      18,250    $    18,250
      77%    $       7,500    $      5,750
      96%    $      45,750    $    43,750
      95%    $      38,500    $    36,500
      79%    $      26,250    $    20,750
      94%    $      17,250    $    16,250
      87%    $      71,125    $    61,625
      84%    $      25,500    $    21,500
      73%    $      27,150    $    19,950    $   19,950    $   31,642
      64%    $      20,450    $    13,100    $   13,100    $   22,586
      71%    $      73,500    $    52,150    $   50,900    $   81,176
      78%    $      52,400    $    40,950    $   30,380    $   57,873
      84%    $      45,100    $    38,050    $   26,460    $   49,810
      80%    $      24,650    $    19,740    $   18,620    $   27,224
      85%    $      59,600    $    50,850    $   47,040    $   65,825
      82%    $      56,550    $    46,350    $   56,840    $   58,480
      77%    $      50,250    $    38,550    $   41,160    $   55,498
        0%   $      32,350                   $   31,360    $   35,729
0% $   91,000   $   70,560 $ 100,504
0% $   36,750   $   43,120 $ 37,358
Businesses


YEAR-TO-DATE
                                               Year To Go        Q2
                                      YTD       (To Meet    Projections
                          YTD '09  Budgeted   Projections)   (for year)   Budgeted
New                         35         31           26           61           49
Renewals                    32         42           39           71           86
Renewal Rate (by count)    50.8%     66.9%        66.1%        58.2%        70.3%
Lost                        31         21           20           51           36
Total Business Members      67         73           65          132          134
New Mem Revenue          $ 29,600 $    39,307 $      42,716 $     72,316 $ 61,600
Renewals Revenue         $ 41,600 $    53,504 $      52,671 $     94,271 $ 108,891
Renewal Rate (by revenue) 56.3%      72.4%        68.9%        62.7%        72.4%
Total Business Revenue   $ 71,200 $    92,810 $      95,387 $ 166,587 $ 170,491

RENEWALS
n/a = under 5 members; or data not available


                             Total Up
                               for      # Arrived On % Arrived On   # Arrived   % Arrived
                  Month      Renewal        Time        Time          Late        Late
                   Jan-08       n/a          n/a          n/a          n/a         n/a
                  Feb-08        n/a          n/a          n/a          n/a         n/a
                  Mar-08         8           n/a          n/a          n/a         n/a
                  Apr-08         5           n/a          n/a          n/a         n/a
                  May-08         1            0           0%            1         100%
                   Jun-08        1            1         100%                       0%
                    Jul-08       6                        0%            3          50%
                  Aug-08         6            4          67%            1          17%
                  Sep-08        10            5          50%            3          30%
                  Oct-08         5            3          60%            1          20%
                  Nov-08         9            5          56%            3          33%
                  Dec-08         7            3          43%            2          29%
                   Jan-09        2            1          50%            1          50%
                  Feb-09         7            4          57%            2          29%
                  Mar-09         9            2          22%            2          22%
                  Apr-09        12            4          33%            1          8%
                  May-09         8            2          25%            2          25%
                   Jun-09        8            1          13%            0          0%
                    Jul-09       7            4          57%            0          0%
                  Aug-09        10            3          30%            3          30%
                  Sep-09        18            9          50%                       0%
                  Oct-09        14                        0%                       0%
              Nov-09       16                       0%                         0%
              Dec-09       11                       0%                         0%



NEW MEMBERS

                                                                  % of
                          Total    # of Total    Projection    Projection   # Members
              Month      Joined   "Regained"    (Revised Q2)   Achieved      Budgeted
               Jan-08       7           0
              Feb-08        1           0
              Mar-08       11           0
              Apr-08        6           0
              May-08        7           0
               Jun-08       4           0
                Jul-08      5           0
              Aug-08       10           0
              Sep-08       10           0
              Oct-08        8           0
              Nov-08        6           0
              Dec-08       11           0
               Jan-09       4           0            4           100%           4
              Feb-09        9           0            9           100%           3
              Mar-09        2           0            2           100%           4
              Apr-09        2           2            6           33%            4
              May-09        3                        5           60%            3
               Jun-09       5          1             4           125%           3
                Jul-09      3                        5           60%            5
              Aug-09        7          1             7           100%           6
              Sep-09        6          3             5           120%           5
              Oct-09                                 5            0%            5
              Nov-09                                 5            0%            5
              Dec-09                                 4            0%            4

GROWTH IN TOTAL BUSINESS MEMBERS + TOTAL REVENUE FROM BUSINESS MEMBERS EACH MONTH
                        Total
                       Members                           Difference   Projected
                         Each     Combined                 (Proj v      Count
                        Month      Revenue Projected Rev Actual Rev) (Combined)
               Jan 1st        60
            1/31/2008         67 $    12,750
            2/29/2008         68 $       250
            3/31/2008         79 $    11,750
            4/30/2008         83 $     7,500
            5/31/2008         90 $     9,000
            6/30/2008         94 $     2,500
 7/31/2008      96   $    9,750
 8/31/2008     105   $   19,250
 9/30/2008     114   $   24,500
10/31/2008     121   $    6,000
11/30/2008     126   $   17,250
12/31/2008     135   $   17,000
 1/31/2009     139   $   12,900   $   12,900   $       -      139
 2/28/2009     147   $   16,800   $   16,800   $       -      147
 3/31/2009     144   $    5,850   $    5,850   $       -      144
 4/30/2009     139   $    3,450   $   18,747   $   (15,297)   147
 5/31/2009     138   $    5,650   $   13,719   $    (8,069)   142
 6/30/2009     136   $    7,600   $   12,498   $    (4,898)   140
 7/31/2009     136   $    8,650   $   11,181   $    (2,531)   138
 8/31/2009     139   $   10,300   $   14,892   $    (4,592)   138
 9/30/2009     145   $   24,550   $   17,526
10/31/2009     145   $      -     $   14,988
11/30/2009     145   $      -     $   16,257
12/31/2009     145   $      -     $   11,229
     Jan-10
    Feb-10
    Mar-10
    Apr-10
    May-10
     Jun-10
      Jul-10
    Aug-10
    Sep-10
    Oct-10
    Nov-10
    Dec-10
     Jan-11
    Feb-11
    Mar-11
    Apr-11
    May-11
     Jun-11
      Jul-11
    Aug-11
    Sep-11
    Oct-11
    Nov-11
    Dec-11
     Jan-12
                 2008
  Variance      Actuals               Weighted Avg Price Per Member
     12            86                 in this Sector:
     -15           49                                 $        1,269
    -12%         77.6%
     15            14
      -2          135
$      10,716 $ 82,250
$     (14,620) $ 63,750
    -10%         84.0%
$      (3,904) $ 146,000




              Renewal                                                                       Renewal
   Total     Projections # Renewals                       % of Lost                        Rate based
 Renewals     (Rev Q2)    Budgeted      Total Lost       "Declined"        Still Pending    on count
     0                                      0                0%                    0           n/a
     0                                      0                0%                    0           n/a
     7                                      0                0%                    0          88%
     3                                      2                0%                    0          60%
     1                                      0                0%                    0           n/a
     1                                      0                0%                    0           n/a
     3                                      3                0%                    0          50%
     5                                      1                0%                    0          83%
     8                                      2                0%                    0          80%
     4                                      1                0%                    0          80%
     8                                      1               100%                   0          89%
     5                                      2               100%                   0          71%
     2            2          3              0                0%                    0           n/a
     6            6          6              1                0%                    0          86%
     4            4          5              5                60%                   0          44%
     5            9          5              7                14%                   0          42%
     4            6          4              4                50%                   0          50%
     1            6          6              7                0%                    0          13%
     4            4          5              3                67%                   0          57%
     6            5          8                       4                0%           0          60%
     9            9         15                       0                             9          50%
     0            7         11                                                    14           0%
                0             8            13                               16          0%
                0             5             5                               11          0%




                           Revenue
                          Projection
              Total        (Revised    Revenue
             Revenue         Q2)       Budgeted
         $       12,750
         $          250
         $        5,000
         $        5,250
         $        8,500
         $        2,000
         $        4,000
         $       11,500
         $       14,250
         $        4,250                            Weighted Avg Price Per *NEW*
         $        1,750                            Member in this Sector at end of
         $       11,750                            Q2:
         $        7,600   $   7,600    $   4,473                      $         1,221
         $        6,250   $   6,250    $   3,227
         $        2,300   $   2,300    $   5,573
         $        1,050   $   7,326    $   4,473
         $        2,600   $   6,105    $   4,400
         $        6,350   $   4,884    $   3,300
         $        1,350   $   6,105    $   5,940
         $        2,100   $   8,547    $   7,920
         $        1,800   $   6,105    $   6,013
                          $   6,105    $   5,720
                          $   6,105    $   5,720
                          $   4,884    $   4,840

RS EACH MONTH

          Difference       Path to
         (Proj count v    Strategic
            Actual)       Plan Goal

                                  67
                                  68
                                  79
                                  83
                                  90
                                  94
      96
     105
     114
     121
     126 Q2 Projections
     135
 0   139
 0   147
 0   144
-8   147
-4   150
-4   152
-2   154
 1   156
     152
     150
     147
     151 Art Work
     155
     159
     163
     167
     171
     175
     179
     183
     187
     191
     195
     199
     203
     207
     211
     215
     219
     223
     227
     231
     235
     239
     243
     247
     251
 Renewal       Renewal        Total
   Rate          Rate        Possible                   Revenue
Projections   based on        Dues       Realized Dues Projections   Revenue
 (Rev Q2)      revenue      Revenue        Revenue      (Rev Q2)     Budgeted
              n/a          $        -    $         -
              n/a          $        -    $         -
                    87%    $     7,750   $       6,750
                    30%    $     7,500   $       2,250
                   100%    $       500   $         500
                   100%    $       500   $         500
                    88%    $     6,500   $       5,750
                    97%    $     8,000   $       7,750
                    91%    $ 11,250      $      10,250
                    88%    $     2,000   $       1,750
                    98%    $ 15,750      $      15,500
                    72%    $     7,250   $       5,250
   n/a             100%    $     5,300   $       5,300 $     5,300   $    3,840
   86%              93%    $ 11,300      $      10,550 $ 10,550      $    8,187
   44%              37%    $     9,600   $       3,550 $     3,550   $    6,955
   75%              30%    $     8,050   $       2,400 $ 11,421      $    5,832
   75%              45%    $     6,850   $       3,050 $     7,614   $    4,963
   75%              12%    $ 10,200      $       1,250 $     7,614   $    7,390
   57%              84%    $     8,650   $       7,300 $     5,076   $    6,267
   50%              59%    $ 13,900      $       8,200 $     6,345   $   10,070
   50%              87%    $ 26,200      $      22,750 $ 11,421      $   18,982
   50%                0%   $ 18,450                    $     8,883   $   13,367
50%   0% $   22,750   $   10,152 $   16,482
45%   0% $    9,050   $    6,345 $    6,557
Other Members (NGO's, Gov't, K-12)


YEAR-TO-DATE
                                             Year To Go
                                     YTD       (To Meet         Q2 Projections
                          YTD '09 Budgeted Projections)           (for year)     Budgeted     Variance
New                         14        14           11                 25            22            3
Renewals                    21        36           23                 44            64           -20
Renewal Rate (by count)    51.2%    87.5%        74.2%              61.1%          89.2%        -28%
Lost                        20        5            8                  28             8           20
Total "Other" Members       35        50           34                 69            87           -18
New Mem Revenue          $ 3,550 $     5,628 $       3,861      $        7,411   $ 8,820    $      (1,409)
Renewals Revenue         $ 6,250 $ 14,136 $        10,366       $       16,616   $ 25,300   $      (8,684)
Renewal Rate (by revenue) 51.0%    115.4%        98.7%              73.0%         111.2%        -38%
Total "Other" Revenue    $ 9,800 $ 19,764 $        14,227       $       24,027   $ 34,120   $ (10,093)

RENEWALS
n/a = under 5 members; or data not available


                             Total Up
                               for    # Arrived On % Arrived On                % Arrived       Total
                  Month      Renewal      Time        Time      # Arrived Late   Late        Renewals
                   Jan-08       n/a        n/a          n/a           n/a         n/a            0
                  Feb-08        n/a        n/a          n/a           n/a         n/a            0
                  Mar-08         6         n/a          n/a           n/a         n/a            6
                  Apr-08         7         n/a          n/a           n/a         n/a            7
                  May-08         0          0           n/a            0          n/a            0
                   Jun-08        0          0           n/a            0          0%             0
                    Jul-08       9          6          67%             1         11%             7
                  Aug-08         2          0           0%             1         50%             1
                  Sep-08         3          1          33%             0          0%             1
                  Oct-08         2          1          50%             1         50%             2
                  Nov-08         5          1          20%             1         20%             2
                  Dec-08         4          0           0%             2         50%             2
                   Jan-09        1          0           0%             1         100%            1
                  Feb-09         0          0           0%             0          0%             0
                  Mar-09         4          2          50%             1         25%             3
                  Apr-09         5          2          40%             1         20%             3
                  May-09         2          1          50%             1         50%             2
                   Jun-09        3          3         100%                                       3
                    Jul-09      19          6          32%                                       6
                  Aug-09         7          3          43%                                       3
                  Sep-09        12          3          25%                                       3
                  Oct-09         9                                                               0
                Nov-09       4                                                             0
                Dec-09       6                                                             0



NEW MEMBERS
                                                                 % of
                            Total    # of Total Projection    Projection      #          Total
                Month      Joined   "Regained" (Revised Q2)   Achieved     Budgeted     Revenue
                 Jan-08       1           0                                           $        250
                Feb-08        2           0                                           $        500
                Mar-08        5           0                                           $      1,750
                Apr-08        2           0                                           $        500
                May-08        3           0                                           $      1,250
                 Jun-08       0           0                                            $         -
                  Jul-08      4           0                                           $      4,850
                Aug-08        8           0                                           $      2,500
                Sep-08        7           0                                           $      2,750
                Oct-08        4           0                                           $        750
                Nov-08        4           0                                           $      1,250
                Dec-08        5           0                                           $      1,300
                 Jan-09       0           0          0                        2       $        -
                Feb-09        1           0          1          100%          1       $        250
                Mar-09        3           0          3          100%          2       $     1,050
                Apr-09        3           0          3          100%          2       $        750
                May-09        1           0          3           33%          2       $        250
                 Jun-09       3           1          2          150%          1       $        500
                  Jul-09      0           0          2           0%           2       $        -
                Aug-09        3                      3          100%          3       $        750
                Sep-09        3                      2          150%          2       $     1,750
                Oct-09                               2           0%           2
                Nov-09                               2           0%           2
                Dec-09                               2           0%           2

GROWTH IN TOTAL "OTHER" MEMBERS + TOTAL REVENUE FROM "OTHER" MEMBERS EACH MONTH
                        Total                                            Projected
                       Members                             Difference      Count   Difference
                        Each      Combined               (Proj v Actual (Combined (Proj count v
                        Month      Revenue Projected Rev      Rev)           )       Actual)
               Jan 1st        40
            1/31/2008         41 $       250
            2/29/2008         43 $       500
            3/31/2008         48 $     2,750
            4/30/2008         50 $     2,250
            5/31/2008         53 $     1,250
            6/30/2008         53 $       -
            7/31/2008         61 $     7,350
            8/31/2008         67 $     2,750
 9/30/2008     71   $   3,000
10/31/2008     75   $   1,250
11/30/2008     76   $   1,750
12/31/2008     78   $   4,725
 1/31/2009     78   $     250   $     250   $      -      78    0
 2/28/2009     79   $     250   $     250   $      -      79    0
 3/31/2009     80   $   1,800   $   2,050   $     (250)   82   -2
 4/30/2009     81   $   1,750   $   2,843   $   (1,093)   83   -2
 5/31/2009     82   $     500   $   1,267   $     (767)   83   -1
 6/30/2009     84   $   1,500   $   1,370   $      130    83    1
 7/31/2009     71   $   2,000   $   2,946   $     (946)   73   -2
 8/31/2009     70   $   1,750   $   2,055   $     (305)   70    0
 9/30/2009     73   $   2,750   $   3,340
10/31/2009     73   $     -     $   3,340
11/30/2009     73   $     -     $   1,764
12/31/2009     73   $     -     $   2,552
     Jan-10
    Feb-10
    Mar-10
    Apr-10
    May-10
     Jun-10
      Jul-10
    Aug-10
    Sep-10
    Oct-10
    Nov-10
    Dec-10
     Jan-11
    Feb-11
    Mar-11
    Apr-11
    May-11
     Jun-11
      Jul-11
    Aug-11
    Sep-11
    Oct-11
    Nov-11
    Dec-11
     Jan-12
  2008
 Actuals                Weighted Avg Price Per
   44                   Member in this Sector:
   32                                  $    394
  73.7%
   11
   76
$ 17,850
$ 10,925
  78.7%
$ 28,775




                                                                               Renewal Renewal
 Renewal                                                            Renewal      Rate        Rate
Projection # Renewals                  % of Lost                   Rate based Projections based on
s (Rev Q2) Budgeted      Total Lost   "Declined"   Still Pending    on count   (Rev Q2)    revenue
                             0            n/a             0            n/a                n/a
                             0            n/a             0            n/a                n/a
                             0            n/a             0           100%                     100%
                             0            n/a             0           100%                     100%
                             0            n/a             0            n/a                n/a
                             0            n/a             0            n/a                n/a
                             2            0%              0           78%                       91%
                             1            0%              0            n/a                      50%
                             2            0%              0            n/a                      33%
                             0            0%              0            n/a                     100%
                             3           20%              0           40%                       29%
                             2           25%              0            n/a                      87%
    1          1             0            0%              0            n/a        n/a          100%
    0          0             0            0%              0            n/a        n/a     n/a
    4          5             1            0%              0            n/a        n/a           75%
    5          8             2           50%              0           60%        100%           57%
    1          1             0            0%              0            n/a        n/a           50%
    2          3             0            0%              0            n/a        n/a           80%
    6          6            13            0%              0           32%         32%           38%
    3          12            4            0%              0           43%         43%           44%
    7          7                                          9           25%         58%           24%
    7          8                                          9            0%         78%             0%
    3            3                         4          n/a   n/a   0%
    5            11                        6          0%    83%   0%




 Revenue
Projection   Revenue
 (Revised    Budgeted




                         Weighted Avg Price Per
                         *NEW* Member in this
                         Sector at end of Q2:
                                      $         291


$     -      $     641
$     250    $     462
$   1,050    $     798
$     873    $     641
$     873    $     630
$     582    $     473
$     582    $     851
$     873    $   1,134
$     582    $     861
$     582    $     819
$     582    $     819
$     582    $     693




 Path to
Strategic
Plan Goal

        41
        43
        48
        50
        53
        53
        61
        67
 71
 75 Q2 Projections
 76
 78
 78
 79
 82
 85
 87
 88
 77
 76
 73
 73
 77 Art Work
 81
 85
 89
 93
 97
101
105
109
113
117
121
125
129
133
137
141
145
149
153
157
161
165
169
173
177
181
  Total
Possible    Realized     Revenue
  Dues       Dues       Projections   Revenue
Revenue     Revenue      (Rev Q2)     Budgeted
$     -    $      -
$     -    $      -
$ 1,000    $ 1,000
$ 1,750    $ 1,750
$     -    $      -
$     -    $      -
$ 2,750    $ 2,500
$    500   $      250
$    750   $      250
$    500   $      500
$ 1,750    $      500
$ 3,925    $ 3,425
$    250   $      250   $      250    $     234
$     -    $      -     $      -      $     -
$ 1,000    $      750   $    1,000    $   2,106
$ 1,750    $ 1,000      $    1,970    $   3,277
$    500   $      250   $      394    $     468
$ 1,250    $ 1,000      $      788    $   1,170
$ 5,250    $ 2,000      $    2,364    $   2,340
$ 2,250    $ 1,000      $    1,182    $   4,540
$ 4,250    $ 1,000      $    2,758    $   2,574
$ 3,250                 $    2,758    $   3,043
$ 1,250   $   1,182 $   1,170
$ 1,750   $   1,970 $   4,377
Staff Notes and Guidelines for Preparing this document

HEASC                          Count HEASC members just like any other NGOs, but make a note if their renewal numbers s
Business Alliance Members      Any businesses that join at the higher levels should be counted in the business tab as normal
International Members          All international members should be counted as their type - i.e. an international nonprofit sh

Monthly Update Quirks
All Orange cells ned to have their formulas updated to incorporate the new month of data
The last two charts on the charts page need to have their data ranges updated to incorporate the new month of data

Color Key
                               Indicates cells whose formula must be updated every time a new month closes. This is becau
                               YTG formulas change each time a month closes.
                               Indicates cells that should not have data entered directly into them. They are populated by f
                               entered into cells elsewhere in the spreadsheet.

                               Indicates cells whose data should not be changed at all. This applies to the original Budget #s
                               reference point) and the previous year's data, which should not change since that year is clos
                               Measured data that has been checked and double-checked against the database.


Supplemental Data Used in Historic Charts (DO NOT REMOVE)
                                                                                             Retired Charts
             Pre-2008 New Member Data
         MonthJoined            New Members
Aug 02                                                 1
                                                                                                 Membership Renewals: Exp
Jan 05                                                 3
                                                                                                     140
Feb 05                                                 2
Mar 05                                                 3                                             120
Apr 05                                                 2                                             100
May 05                                                 2                                              80
Jun 05                                                 4                                              60
Jul 05                                                 4
                                                                                                      40
Aug 05                                                 3
                                                                                                      20
Sep 05                                                 5
Oct 05                                                 3                                                 0
Nov 05                                                 5
Dec 05                                                 6
Jan 06                                                 3
Feb 06                                                 6
Mar 06                                                 7
Apr 06                                                12                                      $100,000
May 06                                                11
                                                                                               $90,000
Jun 06                                                10
Jul 06                                                13                                       $80,000
Aug 06                                                33                                       $70,000
Sep 06                                                16                                       $60,000
                    $60,000
Oct 06    9         $50,000
Nov 06    9
                    $40,000
Dec 06   12
Jan 07   24         $30,000
Feb 07    8         $20,000
Mar 07   31         $10,000
Apr 07   16             $-
May 07   19




                              Jan-08
Jun 07   16
Jul 07   31
Aug 07   27
Sep 07   25


Oct 07   30
Nov 07   44
Dec 07   27
              Jan
              Feb
              Mar
              Apr
              May
              Jun
              Jul
              Aug
              Sep
              Oct
              Nov
              Dec
 note if their renewal numbers skew the data.
ed in the business tab as normal.
i.e. an international nonprofit should be counted in the NGO section, and an international institutions should be counted in the campuses




e the new month of data



 new month closes. This is because the months in the YTD and the

o them. They are populated by formulas that draw on data


 applies to the original Budget #s (static reference points
not change since that year is closed.
against the database.



 Retired Charts



     Membership Renewals: Expected, Realized, Projections
         140                           Budget
         120                           Projection

         100                           Total Up for Renewal

          80                           Total Renewals

          60
          40
          20
             0
                  Jan-08


                                    Mar-08




                                                               Jun-08




                                                                                                                              Jan-09


                                                                                                                                                Mar-09




                                                                                                                                                                           Jun-09
                                                                                                   Oct-08




                                                                                                                                                                                                               Oct-09
                                             Apr-08
                                                      May-08




                                                                                                                                                         Apr-09
                                                                                                                                                                  May-09
                           Feb-08




                                                                                 Aug-08
                                                                                          Sep-08


                                                                                                            Nov-08




                                                                                                                                       Feb-09




                                                                                                                                                                                             Aug-09
                                                                                                                                                                                                      Sep-09


                                                                                                                                                                                                                        Nov-09
                                                                        Jul-08




                                                                                                                                                                                    Jul-09
                                                                                                                     Dec-08




                                                                                                                                                                                                                                 Dec-09




  $100,000                 Membership Revenue by Month                                                                                                        Other Members
   $90,000                                                                                                                                                    Business Members
   $80,000                                                                                                                                                    Campus Members
   $70,000
   $60,000
$60,000
$50,000
$40,000
$30,000
$20,000
$10,000
                                               May-08




                                                                                                                                                           May-09
                                      Apr-08




                                                                          Aug-08




                                                                                                     Nov-08




                                                                                                                                                  Apr-09




                                                                                                                                                                                      Aug-09




                                                                                                                                                                                                                 Nov-09
                    Feb-08




                                                                 Jul-08


                                                                                   Sep-08




                                                                                                                                Feb-09




                                                                                                                                                                             Jul-09


                                                                                                                                                                                               Sep-09
                                                                                                              Dec-08




                                                                                                                                                                                                                          Dec-09
          Jan-08


                             Mar-08




                                                        Jun-08




                                                                                            Oct-08




                                                                                                                       Jan-09


                                                                                                                                         Mar-09




                                                                                                                                                                    Jun-09




                                                                                                                                                                                                        Oct-09
                   2009 Q1 Renewals                              2009 Q1 Renewals
                      Projections                                 Rev Projections
                          25                                                25500
                          20                                                23650
                          52                                                55450
                          45                                                43771
                          34                                                34468
                          27                                                27022
                          52                                                50061
                          58                                                57980
                          60                                                60205
                          46                                                45329
                          88                                                88825
                          50                                                49843
ounted in the campuses tab




              New Members by Month                                                       Budget
            60
                                                                                         Projection
            50
                                                                                         New
            40

            30

            20

            10

             0
                 Jan-08

                          Mar-08




                                                                       Jan-09

                                                                                Mar-09
                                   May-08




                                                                                         May-09
                                            Jul-08


                                                     Sep-08

                                                              Nov-08




                                                                                                  Jul-09

                                                                                                           Sep-09

                                                                                                                    Nov-09

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:12/4/2011
language:English
pages:46