Financial Commentary on Cash Budget - Excel

Document Sample
Financial Commentary on Cash Budget - Excel Powered By Docstoc
					Draft Financial Status of CCOS                                                                       2/23/2005

Funds - Needed:

Funds Needed to Complete Current Table 1 Category III Projects
Table 1 Category III Phase I estimate                                                              $565,000
Table 1 Category III Phase I contingency                                                           $200,000
Table 1 Category III Phase 2 estimate                                                             $1,260,000
Table 1 Category III New projects added                                                            $455,000
Total Needed for Table 1                                                                          $2,480,000


Funds Needed for All CCOS projects and Commitments                                                $2,480,000

Funds - Available:

                                                                                               Funds in Hand Funds Committed     USDA         NOAA         Expiration Date
Available and Committed Funds
Cash and Commitments Available to the Study Agency (per CCOS
financial Report of January 2005)                                                                 $1,746,530
2004 EPA Money at EPA (See footnote 1)                                                             $497,000
2004 US Department of Agriculture (See footnote 2)                                                                                 $384,000
2004 US Department of Transportation (See footnote 3)                                               $250,000
CEC Reconciliation (See footnote 4)                                                                -$100,000
Total Available                                                                                   $2,393,530

Funds to be Unencumbered
99-2CCOS Philip M. Roth                                                                              $50,000
00-7CCOS Biospheric Research Corporation                                                             $56,645
00-21CCOS Dessert Research Institute                                                                 $60,000     (estimated)
02-1CCOS Atmospheric, Meteorological and Environmental Technology                                     $8,400
Total to be unencumbered                                                                            $175,045

Funds in hand after all CCOS projects, and Commitments                                               $88,575

Commitments Secured for FY05

Commitments Secured during the last Fundraising Effort
2005 EPA/HUD                                                                                                          $375,000
2005 US Department of Agriculture (See footnote 2)                                                                                 $404,000
2005 US Department of Transportation                                                                                  $500,000
2005 US Department of Commerce (See footnote 5)                                                                                                 $250,000
Total Secured Commitments to Study Agency                                                                             $875,000

Footnotes:
1. Grant approved from EPA 7/17/04. Transfer to Study Agency in progress. Expires
7/15/07.
2. This money will go directly to other institutions; TC/PC does not have any control
over it. Thus, it is not accounted for in this spreadsheet, but it is listed here since it a
part of the CCOS fund raising.
4. This is has needed to on transportation related projects.
3. Money sum to be spentreconcile the difference between the $3 million originally
expected from CEC and the $2.9 million now projected to be received from CEC. The
Study Agency has already received $2,573,864 from CEC and the rest is now being
invoiced by ARB. ARB expenditures were based on the original CEC commitment.
Available funds are adjusted to compensate for this shortfall in payment for ARB work
elements.
5. This money will go directly to NOAA, but TC/PC have some control over it. It is not
accounted for in this spreadsheet because the Study Agency does not receive that
money, but it is listed here since it a part of the CCOS fund raising.
                              CCOS Field Studies


Project   Project                                                                                                                       Funding   Funding                                                  Estimated
                    Project                                                                                                                                                 Funding        Estimated
Number    Number                                              Projects                                 Contract Number   Investigator   (x1000)   (x1000)     Status                                    Completion Date
                   Category                                                                                                                                                Mechanism       Start Date
Revised   original                                                                                                                      Revised   Original                                                or Duration
                              A Study of Mesoscale Transport and Boundary Layer Processes in the                                                             completed                                     completed
                                                                                                            00-1           NOAA          $564                                 CEC
                              Central Valley of California
                              Deployment of Tower and Ground-Based Remote Sensors for the                                                                    completed                                     completed
                              Acquisition of Surface and Upper-Air Meteorological Data in the San           00-2           NOAA          $123                                 CEC
                              Joaquin Valley
                              Continuous Upper-Air Meteorological Monitoring Using Four Radar                                                                completed                                     completed
                                                                                                            00-3             STI         $425                                 CEC
                              Wind Profilers and Rass
                              Ozonesonde Operations for the CCOS                                            00-4           T&BS          $195                completed                                     completed
                              Instrumented Aircraft Measurements                                            00-5             STI         $483                completed                                     completed
                              Acquisition and Testing of Air Quality Analyzers for CCOS Supplemental                                                         completed                                     completed
                                                                                                            00-6            UCR          $288
                              Monitoring Sites and TDLAS Measurements
                              Supplemental Monitoring Setup                                                 00-8           ENSR          $257                completed        CEC                          completed
                              Supplemental Surface Measurement Installation and Site Operation              00-11           DRI          $601                completed        CEC                          completed
                              Supplemental Site Operation                                                   00-12          T&BS          $77                 completed                                     completed
                              Checkout, Installation, and Tear Down NOx Analyzers by BAAQMD                 00-13           UCR          $63                 completed                                     completed
                              Meteorological Monitoring                                                     00-15          PG&E          $20                 completed                                     completed
                              Plume measurements using Aircrafts                                            00-17           TVA          $253                completed        CEC                          completed
                              Planning Study for Power Plume Measurements                                   00-18           AER          $20                 completed        CEC                          completed
                              Quality Assurance of CCOS data                                                00-19          Parsons       $200                completed   CEC - $176 ?-24                   completed
                              Measurement of Carbonyl Compounds                                             00-20          AtmAA         $285                completed                                     completed
                              Updaing Point Source Emission Inventories in the Sacramento Valley and                                                         completed                                     completed
                                                                                                            00-22           UCD          $36
                              Mountain Counties using Student Assistants
                              Aircraft Rental for Power Plant Plume Measurements                            00-23        Twin Otter      $55                 completed        CEC                          completed
                              Surface and Upper Air Monitoring in the Bay Area                              00-27          T&BS          $254                completed        CEC                          completed
                              Mobile Monitoring Station for CCOS                                            00-29        Lewis Potter     $1                 completed                                     completed
                              Ozone Lidar Measurements                                                      00-30        Elight Laser    $11                 completed                                     completed
                              Sonic Anemometer Measurements of Atmospheric Turbulences                      00-31           UCD           $8                 completed                                     completed
                                                            SUBTOTAL                                                                    $4,219



                              CCOS Data Analysis and Modeling Studies


Project   Project                                                                                                                       Funding   Funding                                                  Estimated
                    Project                                                                                                                                                 Funding        Estimated
Number    Number                                              Projects                                 Contract Number   Investigator   (x1000)   (x1000)     Status                                    Completion Date
                   Category                                                                                                                                                Mechanism       Start Date
Revised   original                                                                                                                      Revised   Original                                                or Duration

CATEGORY I. COMPLETED OR ON-GOING PROJECTS
  I-1       I-1     P&D       Validation of CCOS Data                                                       00-21           DRI          $120      $120       Funded         EPA II            -             3/03
  I-2       I-2       EI      Biogenic Emissions Model Expansion                                            00-16          UC-Ext.       $80        $80       Funded        EPA III-4          -           completed
  I-3       I-3       EI      Point and Area Source Emissions Update                                                      UCD,STI        $100      $100       Funded                           -           completed
  I-4       I-4       EI      Area Source Surrogates                                                        00-24            STI         $230      $150       Funded                           -           completed
  I-5       I-5       EI      Source Sampling of Power Plants                                               00-28           UCR          $29        $39       Funded          CEC              -           completed
  I-6       I-6       EI      Day-Specific Traffic Count Data (CRPAQS-$325K, total $600K)                                   UCD          $275      $275       Funded         EPA II            -           completed
  I-7       I-7      DA       Characterization of CCOS Episodes - Phase 1                                   01-02           T&B          $110      $110       Funded         EPA II            -           completed
  I-8     I-8      DA    Advanced Data Analysis - Phase 1                                       01-03      UCD          $115      $115     Funded     EPA II      -     Completed
  I-9     I-9     MD&E   Enhancement of Plume-in-Grid Modeling in Central California            01-01      EPRI        $143      $143      Funded      CEC        -       12/03
                         SUBTOTAL                                                                                      $1,202    $1,132


CATEGORY II. SHORT-TERM STUDIES TO SUPPORT SIP PROCESS
  II-1    II-1    P&D    Completion of Project Planning for CCOS                                00-21      DRI          $70       $70      Funded     EPA II      -       6/03
  II-2            P&D    PAN and NO2 Data Processing                                            02-04    CE-CERT         $8                Funded                 -     Completed
  II-3   III-16   P&D    Database Development for CCOS                                          02-03   Capitol Data    $238      $250     Funded     EPA II      -     Completed
  II-4   II-10     EI    Analysis of Remote Sensing Data                                        00-14     Works
                                                                                                           UCB          $60       $60      Funded     EPA II      -       9/03
  II-5   II-11     EI    Analysis of VOC Data                                                   00-14      UCB          $50       $50      Funded                 -       9/03
  II-6             EI    Emission Inventory Technical Support                                             Alpine        $57                Funded                 -         -
  II-7             DA    Analysis of Elevated NOx Plumes (CEC/EPRI-$140K)                               Geophysics
                                                                                                          TVA                              Funded                 -     Completed
  II-8    II-2     DA    Characterize of Summertime 2000 Measurement Period in Central          01-02      T&B          $100      $100     Funded                 -     Completed
                         California - Phase 2
  II-9    II-8     DA    Evaluation of Pollutant Transport (Episode and Seasonal)                          ARB         in-kind   in-kind   in-kind               4/03       -
 II-10    II-6    MD&E   Characterization of Atmospheric Processes and Improve Boundary Layer             NOAA          $250      $250     Funded                 -         -
                         & Mixing Depth Calculations (Met and Air Quality Models)

 II-11    II-7    MD&E   Evaluation of CMAQ and CAMx in the CCOS Domain with Process            02-02      UCR          $120      $120     Funded    EPA III-4    -       9/03
 II-12    II-9    MD&E   Analysis
                         Evaluation of Deposition Algorithm and Soil NOx                                   ARB         in-kind   in-kind   in-kind               4/03       -
 II-13            MD&E   Modification of the SAQM and its Meteorological Preprocessor for the   02-05     Environ       $15                Funded                       Completed
                         CCOS Modeling Domain
 II-14    III-1   I&S    Summary of Air Quality Studies Conducted in Central California and a   99-02     Envair        $30                Funded                 -         -
                         Commentary on Selected Issues - Phase 1

                         SUBTOTAL                                                                                      $998      $900
Project    Project                                                                                                           Funding   Funding                                                      Estimated
                     Project                                                                                                                                        Funding         Estimated
Number     Number                                                Projects                                     Investigator   (x1000)   (x1000)       Status                                      Completion Date   Priority
                    Category                                                                                                                                       Mechanism        Start Date
Revised    original                                                                                                          Revised   Original                                                    or Duration

CATEGORY III. FUNDED CCOS PROJECTS

  III-3     III-8      EI      Update Intregated Transport Network                                    04-02       AG          $40        $40        Funded                                          4/30/2005
  III-5                EI      Emissions Processing for Modeling                                      02-02      UCR          $20                   Funded                                         Completed
  III-7      II-3     DA       Advanced Data Analysis - Phase 2                                       01-03      UCD          $65       $250        Funded                                          6/30/2005
 III-13a             MD&E      Long-Term Seasonal Modeling - Phase 1                                  04-01   UCB/LBNL        $100                  Funded                                         12/31/2005
  III-22             P&D       Database Maintainance ($50k per year for 3 years)                      02-03    CDWorks        $150                  Funded                                         12/31/2007
  III-23             MD&E      Compare MM5 generated meteorology fields with observations             01-02      T&B          $30                   Funded                                         12/31/2004
  III-24             MD&E      Model the September 2000 CCOS episode ($158k from SJVAPCD)             03-01       AG                                Funded             SJV                         Completed
  III-25             MD&E      Funding to replace NOAA FY04 Earmark                                   04-04     NOAA          $250                  Funded       EPA III-1 $100 ?                       -
                                                                                                                                                                     -$150
  III-26             P&D       Improvements to the Database                                           02-03   Capitol Data    $150                  Funded                                            2007
  III-30             MD&E      Development of a fast Chemistry Solver                                 04-03     Works
                                                                                                                 UCD          $30                   Funded                                          9/30/2005
  III-31              I&S      Research Program Evaluator                                             04-05    Reynolds       $100
                               SUBTOTAL                                                                                       $935      $290


CATEGORY III. UNCOMMITTED CCOS PROJECTS PHASE I
  III-1     III-3      EI      Emissions Inventory Evaluation and Reconciliation                                              $160       $70         RFP
  III-4     III-9      EI      Development of CEFS Control Rule Profiles                                                     In-kind    $200      Uncommitted
  III-8      II-4     DA       Corroborative Data Analysis                                                    Envair/UCR      $80        $80      Augmentation
  III-9      II-5     DA       Multivariate Trend Analysis                                                                    $75        $50         RFP?                             5/03
 III-10a    II-12    MD&E      Link Data Analysis and Modeling Efforts - Phase I                                              $50       $100      Uncommitted
  III-12    III-13   MD&E      Improve Aloft Model Performance                                                                $150      $150      Uncommitted       EPA III-5
  III-14             MD&E      Web Access of Modeling Results                                                                 $20                 Uncommitted       EPA IV -2
  III-15             MD&E      Cloud Effects                                                                                  $30                 Uncommitted       EPA IV -3
                               SUBTOTAL                                                                                       $565      $650


CATEGORY III. UNCOMMITTED CCOS PROJECTS - CONTINGENCY                                                                         $200      $200      Uncommitted


CATEGORY III. UNCOMMITTED CCOS PROJECTS PHASE II
  III-2  III-4     EI  Review of Emission Estimation and Projection Methodology                                               $100      $100      Uncommitted
  III-6     III-5      EI      Refinement of Stack Parameters                                                                 $40        $40      Uncommitted
 III-10b    II-12    MD&E      Link Data Analysis and Modeling Efforts - Phase II                                             $50                 Uncommitted
 III-11a    III-10   MD&E      Improve Mass Conservation Module (Met and AQ Models) - Phase 1                                 $100      $300      Uncommitted       EPA III-3
 III-11b    III-10   MD&E      Improve Mass Conservation Module (Met and AQ Models) - Phase 2                                 $200      $300      Uncommitted       EPA III-3
 III-13b             MD&E      Long-Term Seasonal Modeling (Phase 2)                                          UCB/LBNL        $200                 Committed
  III-16    III-2    MD&E      Extend Previous Analysis Effort                                                                $150      $150      Uncommitted
  III-17    III-11   MD&E      Conduct Uncertainty Analysis and Suggest Improvements                                          $100      $200      Uncommitted       EPA III-4
  III-18    III-1     I&S      Summary of Air Quality Studies Conducted in Central California and a                           $80       $110      Uncommitted
                               Commentary on Selected Issues - Phase 2
  III-19    III-14    I&S      Refine Conceptual Model from CCOS Results (Concluding Element and                              $150      $150      Uncommitted       EPA III-5
                               Final Report)
  III-20    III-15    I&S      Integration of Findings of CCOS and CRPAQS                                                     $60        $60      Uncommitted
  III-21              I&S      Preparation and Publication of CCOS Summary Document                                           $30                 Uncommitted
                               SUBTOTAL                                                                                      $1,260    $1,410


CATEGORY III. PROJECTS ADDED
 III-27             P&D   Design of a Technical Support Study for Deposition                                       $75                Uncommitted
 III-28             P&D   Cost estimation of enhancements to the long-term monitoring network                      $100               Uncommitted
 III-32             DA    Further Data Validation                                                   05-01   STI    $200
 III-29                   CCOS Conference, publications, Final sysntheis document (add to III-21)                  $80                Uncommitted

                          TOTAL                                                                                    $455


CATEGORY IV. ADDITIONAL LONG-TERM PROJECTS
 IV-1                EI   Day-of-Week Variations in Emissions of Ozone Precursor                                   $350               Uncommitted   EPA IV-1
 IV-2               DA,   Enhancement of Existing Air Quality and Meteorological Monitoring for                   $10,000   $10,000   Uncommitted
                   MD&E   Data Analysis and Modeling
 IV-3              MD&E   Deposition Studies                                                                      $3,500    $3,500    Uncommitted
                          TOTAL                                                                                   $13,850   $13,500



                   P&D    Planning and Database
                   EI     Emission Inventory Development and Evaluation
                   MD&E   Model Development and Evaluation
                   DA     Data Analysis
                   I&S    Integration and Synthesis


          III-12   MD&E   Evaluate/Improve Chemistry (deleted by TC 12/12/02 )                                               $100     Uncommitted
          III-7      EI   Review/improve Speciation Profiles (now combined with III-7 )                                      $110     Uncommitted
 III-3    III-6      EI   Improve Live Stock Emission Estimation (USDA-$400K)                               UCD

				
DOCUMENT INFO
Description: Financial Commentary on Cash Budget document sample