Docstoc

Legal Contracts Software

Document Sample
Legal Contracts Software Powered By Docstoc
					                                          WREGIS
                       Fiscal Year End (FYE) Budget vs. Actual Report
                    September 30, 2009 (100% of Fiscal Year - 12 months completed)

                                                                                             FYE
                                                  ANNUAL           FYE                      ACTUAL                     FYE
Expenses                                                                         FYE BUDGET
                                                  BUDGET           ACTUAL                     vs. FYE              VARIANCE ($)
                                                                                            BUDGET (%)

Labor: Salaries, Benefits, and WECC
                                                   $498,350         $407,339         $498,350         81.74%             $91,011
Executive & Administrative Support

Professional Services: Contracts, Legal,
                                                    $78,100            $3,531          $78,100        4.52%              $74,569
and Auditing


Computer Systems: Software, Contracting,
Hardware, Communications, and Licenses &            $21,694          $41,269           $21,694       190.23%             ($19,575)
Services


Program Development                                 $40,000                 $0         $40,000        0.00%              $40,000

Travel: WREGIS Committee, and Staff                 $33,100            $7,537          $33,100        22.77%             $25,563

Meeting Costs                                         $8,300             $740           $8,300        8.92%                $7,560

Office: Staff Training, Subscriptions & Dues,
                                                    $81,564          $75,414           $81,564        92.46%               $6,150
and Office Overhead

Insurance                                           $72,688          $29,594           $72,688        40.71%             $43,094

Total Expenses                                    $833,796         $565,424         $833,796         67.81%            $268,372


Net (accrual)                                                        $46,366



                                                 COLLECTED      BILLED           PAST DUE              PROJECTED ANNUAL
Revenue
                                                    FYE              FYE           90+ days¹
                                                                                                   BASE CASE*       HIGH CASE**

                                                  $566,282         $611,790              $978         $542,406         $681,888
BASE CASE* (%)                                    104.40%         112.79%
HIGH CASE** (%)                                    83.05%          89.72%

1 excludes pending Account Holders

*includes annual fees for all active account holders as of April 20,2009 . The forecast also includes production estimates for all
billable plant approved in the system as of April 20, 2009. Estimates for production were based on actual where available and
reasonable CF estimates where actual production is not available. The estimate also includes trades where a pattern of behavior
was readily discernable or necessary to get the certificates to the purchasers of such. The estimate does not include any
California IOU retirements for fiscal 09 because of the delay in filing deadlines now anticipated by the CEC.
*calculated upon billed transaction timelines.
**increase of 30% over Base Case.
                                             WREGIS at WECC Budget and Actual
                                                    FYE - September 30, 2009


                                              Actual        Actual          Actual                     Proposed Budget*
              BUDGET LINE-ITEMS              FY2007         FY2008          FY2009         FY2010         FY2011          FY2012
                                               (Year 1)       (Year 2)        (Year 3)      (Year 4)       (Year 5)        (Year 6)
Salaries                                          189,784        251,331         238,456       355,000        369,200          383,968
Benefits                                           63,142        108,651          89,323       159,750        166,140          172,786
WECC Executive & Administrative Support            30,827         66,271          79,561        80,447         83,665           87,011
Allocated Benefits                                 15,598                                            0              0                0
Professional Services: Contracts                   59,011         15,350           1,613        10,000         10,400           10,816
Professional Services: Legal                      105,400         16,957           1,918        55,000         57,200           59,488
Professional Services: Auditing                                    2,100                         2,184          2,271            2,362
Computer Systems: Software                         11,350          6,777           7,566        24,440         25,418           26,434
Computer Systems: Contracting                         224            787           1,058         3,300          3,432            3,569
Computer Systems: Hardware                          8,521          6,600           2,303        10,000         10,400           10,816
Computer Systems: Communications                    4,176          8,506           5,667         5,100          5,304            5,516
Computer Systems: Licenses & Services                                             24,675        27,000         28,080           29,203
Program Development                                                1,642                             0              0                0
Program Marketing                                  7,986                                             0              0                0
Program Outreach                                   9,953                                        10,000         10,400           10,816
Travel: WREGIS Committee                           1,725           1,127           1,495        10,000         10,400           10,816
Travel: Staff                                     18,792          10,750           6,043        40,000         41,600           43,264
Meeting Costs                                          0             500             740         8,800          9,152            9,518
Staff Training                                         0                           3,016         5,000          5,200            5,408
Subscriptions & Dues                                  79          10,000          10,000        14,700         15,288           15,900
Furniture & Equipment                              2,813                                             0              0                0
Office Overhead                                   34,869          40,000         62,398         42,612         44,316           46,089
Insurance                                         10,725         110,583         30,257         75,596         78,619           81,764
TOTAL                                         $574,975.96     $657,930.41    $566,087.32    $938,928.52    $976,485.66    $1,015,545.09


*annual increase of 4% (FY2011 and FY2012)
                                                                             WREGIS Revenue vs. Expenses
                                                                          January 1, 2008 - September 30, 2009
$90,000


$80,000


$70,000


$60,000


$50,000


$40,000
                                                                                                                                                                                                     Collected

                                                                                                                                                                                                     Billed
$30,000                                                                                                                                                                                              Expenses



$20,000


$10,000


     $0
                               Apr-Jun 2008




                                                                                                                                              May 2009




                                                                                                                                                                               Aug 2009
                                                                                                             Feb 2009




                                                                                                                                   Apr 2009




                                                                                                                                                                                          Sep 2009
                                                               Oct 2008


                                                                            Nov 2008




                                                                                                                                                                    Jul 2009
                Jan-Mar 2008




                                                                                       Dec 2008
                                              July-Sept 2008




                                                                                                  Jan 2009




                                                                                                                        Mar 2009




                                                                                                                                                         Jun 2009
 Jan-Sept 2008 are reported quarterly with monthly averages, Oct 2008 going forward are monthly actuals
                                            WREGIS Cumulative Revenue vs. Expenses
                                               FY2009 as of September 30, 2009
$900,000



$800,000



$700,000



$600,000



$500,000
                                                                                                                                                Collected

                                                                                                                                                Billed

$400,000                                                                                                                                        Base Case Revenue Forecast

                                                                                                                                                Budget

                                                                                                                                                Expenses
$300,000



$200,000



$100,000



     $0
                                                                              Apr 2009
                                                        Feb 2009




                                                                                         May 2009




                                                                                                               Jul 2009




                                                                                                                                     Sep 2009
                      Nov 2008




                                                                                                                          Aug 2009
                                 Dec 2008



                                             Jan 2009
           Oct 2008




                                                                   Mar 2009




                                                                                                    Jun 2009
                                           WREGIS Monthly Billing Fee Breakdown
                                             FY2009 as of September 30, 2009
$80,000



$70,000



$60,000



$50,000

                                                                                                                                                Other Services
                                                                                                                                                Exported
$40,000
                                                                                                                                                Reserved
                                                                                                                                                Retired
                                                                                                                                                Transfer
$30,000
                                                                                                                                                Issuance
                                                                                                                                                Annual

$20,000



$10,000



    $0
          Oct 2008




                                Dec 2008



                                             Jan 2009




                                                                   Mar 2009




                                                                                                    Jun 2009
                                                                                         May 2009
                                                                              Apr 2009




                                                                                                                          Aug 2009
                     Nov 2008




                                                        Feb 2009




                                                                                                               Jul 2009




                                                                                                                                     Sep 2009
                                               WREGIS Monthly Billing
                                                 Annual Fee Growth
                                           FY2009 as of September 30, 2009
$45,000


$40,000


$35,000


$30,000


$25,000


$20,000


$15,000


$10,000


 $5,000


    $0
                                                                             Apr 2009




                                                                                        May 2009
                     Nov 2008




                                                                                                                         Aug 2009
                                                       Feb 2009




                                                                                                              Jul 2009




                                                                                                                                    Sep 2009
                                Dec 2008




                                                                  Mar 2009




                                                                                                   Jun 2009
          Oct 2008




                                            Jan 2009
                                               WREGIS Monthly Billing
                                                Issuance Fee Growth
                                           FY2009 as of September 30, 2009
$45,000


$40,000


$35,000


$30,000


$25,000


$20,000


$15,000


$10,000


 $5,000


    $0                                                                                  May 2009
                                                                             Apr 2009




                                                                                                                         Aug 2009
                     Nov 2008




                                                       Feb 2009




                                                                                                              Jul 2009




                                                                                                                                    Sep 2009
                                Dec 2008




                                                                                                   Jun 2009
                                                                  Mar 2009
          Oct 2008




                                            Jan 2009
                                               WREGIS Monthly Billing
                                                Transfer Fee Growth
                                           FY2009 as of September 30, 2009

$16,000



$14,000



$12,000



$10,000



 $8,000



 $6,000



 $4,000



 $2,000



    $0                                                                                  May 2009
                     Nov 2008




                                                                             Apr 2009
                                                       Feb 2009




                                                                                                                         Aug 2009
                                                                                                              Jul 2009




                                                                                                                                    Sep 2009
                                Dec 2008




                                                                                                   Jun 2009
                                                                  Mar 2009
          Oct 2008




                                            Jan 2009
                                               WREGIS Monthly Billing
                                                 Retired Fee Growth
                                           FY2009 as of September 30, 2009

$16,000



$14,000



$12,000



$10,000



 $8,000



 $6,000



 $4,000



 $2,000



    $0
                                Dec 2008




                                            Jan 2009
          Oct 2008




                                                                  Mar 2009




                                                                                                   Jun 2009
                                                       Feb 2009




                                                                             Apr 2009




                                                                                        May 2009




                                                                                                                         Aug 2009
                     Nov 2008




                                                                                                              Jul 2009




                                                                                                                                    Sep 2009
                WREGIS at WECC Actuals, Budgets, and Revenues inclusive of WECC/CEC Contract (Total Amount = $2,202,750)
                                                                 (contract term: 09/15/2006 to 03/30/2011)
                                                                         FYE - September 30, 2009

                                                                Actual             Actual             Actual           Actual                  Proposed Budgets
                                                               FY2007              FY2008             FY2009           FY2010           FY2011            FY2012
                                                                 (Year 1)            (Year 2)           (Year 3)         (Year 4)          (Year 5) 15     (Year 6) 16
WREGIS at WECC Budget and Actual*                                $574,975.96         $657,930.41        $566,087.32      $938,928.52       $976,485.66    $1,015,545.09
SD&TO Contractor (O&M) † 1                                                                                               $180,000.00       $180,000.00      $180,000.00
SD&TO Change Control † 2                                                                                                  $60,750.00       $243,000.00      $100,000.00
TOTAL WREGIS at WECC and SD&TO                                   $574,975.96        $657,930.41         $566,087.32    $1,179,678.52     $1,399,485.66    $1,295,545.09
Revenues Collected                                                      $0.00        $138,718.83        $566,282.39
Cumulative Surplus/(Deficit) - YTD Actual w/o CEC backstop 3     ($574,975.96)    ($1,094,187.54)    ($1,093,992.47)
Cumulative Surplus/(Deficit) - YTD Actual 4                     $1,627,774.04      $1,108,562.46      $1,108,757.53
Base Case Revenue Forecast 5                                                                                             $881,926.29       $960,350.14    $1,046,616.37
High Case Revenue Forecast 6                                                                                           $1,195,495.98     $1,302,346.16    $1,419,881.36
Cumulative Surplus/(Deficit) - Base Case 7                                                                               $811,005.30       $591,437.54
Cumulative Surplus/(Deficit) - Base Case w/o SD&TO 8                                                                   $1,051,755.30     $1,043,687.54
Cumulative Surplus/(Deficit) - Base Case after 03/30/2011 9                                                                               ($219,567.76)    ($468,496.48)
Cumulative Surplus/(Deficit) - Base Case w/o CEC backstop 10                                                            ($297,752.23)     ($736,887.75)    ($985,816.47)
Cumulative Surplus/(Deficit) - High Case 11                                                                            $1,124,574.99     $1,076,005.24
Cumulative Surplus/(Deficit) - High Case w/o SD&TO 12                                                                  $1,365,324.99     $1,528,255.24
Cumulative Surplus/(Deficit) - High Case after 03/30/2011 13                                                                               ($48,569.75)      $75,766.52
Cumulative Surplus/(Deficit) - High Case w/o CEC backstop 14                                                              $15,817.46       ($81,322.04)      $43,014.23



                                                          CEC/WECC Contract Balances
                        Starting Balance                        Actual           Actual             Actual              Projected Contract Balances
                                                               FY2007              FY2008             FY2009
                         $2,202,750.00                            (Year 1)           (Year 2)           (Year 3)         FYE 2010        3/30/2011 15

WREGIS at WECC retained revenues 17                                                                      $78,625.54
Cumulative Surplus/(Deficit) - YTD Actual 18                    $1,627,774.04      $1,108,562.46      $1,030,131.99
Cumulative Surplus/(Deficit) - Base Case 19                                                                              $973,129.76       $965,062.00
Cumulative Surplus/(Deficit) - High Case 20                                                                            $1,286,699.45     $1,449,629.70




                                                                                       10 of 11
                                                                                                  Assumptions
*proposed budgets increase of 4% annually.

† reflects the WREGIS at WECC fiscal year and not the CA State or APX fiscal years.

1 reviewed semi-annually. This amount will be paid by the Energy Commission until the Energy Commission and WECC determine sufficient revenues exist (after projecting that retained revenues will be sufficient to
support the WREGIS program and administrative operations at WECC) to pay to the SD&TO Contractor (on behalf of the Energy Commission)

2 paid by the Energy Commission until 6/25/2010. After that, any expenditure on upgrades to the software must be funded by WREGIS and will not be paid or reimbursed by the Energy Commission.

3 includes TOTAL WREGIS at WECC and SD&TO, and Revenues Collected.

4 includes CEC/WECC Contract Starting Balance, TOTAL WREGIS at WECC and SD&TO, and Revenues Collected.

5 includes annual fees for all active account holders as of April 20,2009 . The forecast also includes production estimates for all billable plant approved in the system as of April 20, 2009. Estimates for production
were based on actual where available and reasonable CF estimates where actual production is not available. The estimate also includes trades where a pattern of behavior was readily discernable or necessary to get
the certificates to the purchasers of such. The estimate does not include any California IOU retirements for fiscal 09 because of the delay in filing deadlines now anticipated by the CEC.

5 calculated upon billed transaction timelines.

6 increase of 30% over Base Case.

7 includes CEC/WECC Contract Starting Balance, TOTAL WREGIS at WECC and SD&TO, Revenues Collected through YTD Actual FY2009 (Year 3), and Base Case Revenue Forecast(s).

8 includes CEC/WECC Contract Starting Balance, WREGIS at WECC Budget and Actual, Revenues Collected through YTD Actual FY2009 (Year 3), and Base Case Revenue Forecast(s).

9 includes TOTAL WREGIS at WECC and SD&TO, Base Case Revenue Forecast(s). Shows surplus deficit after WECC/CEC contract ends on 03/30/2011.

10 includes TOTAL WREGIS at WECC and SD&TO, Base Case Revenue Forecast(s). Does not include CEC backstop.

11 includes CEC/WECC Contract Starting Balance, TOTAL WREGIS at WECC and SD&TO, Revenues Collected through YTD Actual FY2009 (Year 3), and High Case Revenue Forecast(s).

12 includes CEC/WECC Contract Starting Balance, WREGIS at WECC Budget and Actual, Revenues Collected through YTD Actual FY2009 (Year 3), and High Case Revenue Forecast(s).

13 includes TOTAL WREGIS at WECC and SD&TO, High Case Revenue Forecast(s). Shows surplus deficit after WECC/CEC contract ends on 03/30/2011.

14 includes TOTAL WREGIS at WECC and SD&TO, High Case Revenue Forecast(s). Does not include CEC backstop.

15 includes 6 months of CEC back stop, any remaining balance will be kept by the CEC.

16 does not include CEC backstop, WREGIS at WECC/CEC contract ends 03/30/2011.

17 revenues exceeding expenses in any given month are applied toward the next month's reimbursement request of allowable expenses incurred in the performance of the WECC/CEC contract.

18 includes CEC/WECC Contract Starting Balance, TOTAL WREGIS at WECC and SD&TO, Revenues Collected, and WREGIS at WECC retained revenues.
19 includes CEC/WECC Contract Starting Balance, WREGIS at WECC Budget and Actual, Revenues Collected through YTD Actual FY2009 (Year 3), Base Case Revenue Forecast(s), and WREGIS at WECC retained
revenues.
20 includes CEC/WECC Contract Starting Balance, WREGIS at WECC Budget and Actual, Revenues Collected through YTD Actual FY2009 (Year 3), High Case Revenue Forecast(s), and WREGIS at WECC retained
revenues.




                                                                                                       11 of 11

				
DOCUMENT INFO
Description: Legal Contracts Software document sample