Docstoc

Resource Planner Template

Document Sample
Resource Planner Template Powered By Docstoc
					                                     Oversight Executive                                                                                                                                        11-Jan-08
                                        John Wilcox
                                                                                      FY09-12 AS&C JCTD Funding Template
                                                                            (For use in presenting FY-09 JCTD Candidate funding fair-share profiles)
                                Funding Risk:       Green

                                                                                                                                                  Yellow $$ cells are formula driven.
                                                            Project Title - SAMPLE                                                                     (Dollars in Thousands)
                                                                                 2              3
                                                    (Note 1)      Type of          Funding        Program
                               Organization      Commitment       Funding       Description    Element (PE)     Project #         FY-09           FY-10           FY-11           FY-12           Total
                            USN                 Committed      RDT&E/6.3            Cash     0602123N             N/A         $      2,000    $      2,000    $       1,000   $           - $         5,000
                            USA                 TBD            TBD                  Cash     N/A                  N/A         $           -   $           -   $           -   $           - $              -
                            USAF                Committed      RDT&E/6.3            Cash     0603401F             5021        $      1,000    $      1,000    $       2,000   $           - $         4,000
                            SOCOM               TBD            TBD                  Cash                                      $           -   $           -   $           -   $           - $              -
                            DISA                TBD            TBD                  Cash                                      $        500    $        500    $           -   $           - $         1,000
                            DTRA                Committed      RDT&E/6.3            Cash     0602715BR             BF         $      1,000    $      1,000    $       2,000   $           - $         4,000
                            USMC                TBD            TBD                  Cash                                      $           -   $           -   $           -   $           - $              -
                            DISA                Uncommitted    TBD                  Cash                                      $           -   $      1,000    $       1,000   $           - $         2,000
                            NIMA                Committed      RDT&E/6.3            Cash     0305102BQ            TBD         $      6,500    $      6,500    $           -   $           - $        13,000
                                                                       Total Service & Defense Agency (committed)             $     10,500    $     10,500    $       5,000   $           - $        26,000
                            DUSD (AS&C)        TBD             RDT&E/6.3            Cash     0603648D8Z            648        $      4,000    $      4,000    $       2,000   $           - $        10,000
                                                                              Total Cash Committed Funding:                   $     14,500    $     14,500    $       7,000   $           - $        36,000
                                                                              Stated JCTD Cash Requirement                    $     15,000    $     16,000    $       8,000   $           - $        39,000
                                                                              Delta to Cash Requirement                       $       (500)   $     (1,500)   $     (1,000)   $           - $        (3,000)
                                     Service/Agency Committed:    $26,000
                                       Percent Cash Committed       92%                                                               AS&C Percent Total: Cash Only                               28%
                                         Funding Risk (Cash):      Green                                                                       AS&C Percent Cash:                                 28%

                             DinK Section
                                                                                 2               3
                                                    (Note 1)      Type of          Funding         Program
                              Organization       Commitment       Funding       Description     Element (PE)    Project #         FY-09           FY-10           FY-11           FY-12           Total
                            USAF                Committed      TBD                  Dink                                      $      5,000    $      3,000    $           -   $           - $         8,000
                            USN                 Uncommitted    TBD                  Dink                                      $           -   $      2,000    $           -   $           - $         2,000
                            USA                 TBD            TBD                  Dink                                      $           -   $           -   $           -   $           - $              -
                            USMC                TBD            TBD                  Dink                                      $           -   $           -   $           -   $           - $              -
                                                                               Total Cash & Dink Committed Funding:           $     19,500    $     19,500    $      7,000    $           - $        46,000
                                                                               Stated JCTD Cash & Dink Requirement            $     20,000    $     21,000    $      8,000    $           - $        49,000
                                                                               Delta to Cash & Dink Requirement               $       (500)   $     (1,500)   $     (1,000)   $           - $        (3,000)




                               Notes:

                               (1)

                               POC: Questions on chart, contact Trey Carson, JCTD Resource Mgr at 703 -693-0459.




59b2cfc1-e75f-4a57-af93-b40f795d800f.xls                                                                                                                                                                       JCTD Candidate Funding Chart
                                                     FY-2009 JCTD Candidate Funding Risk Coding

  FY-09 JCTD                                                                             Definition of JCTD Risk Coding
Candidate Funding
                              Two Criteria for each color code - must meet both criteria to gain that color. Not meeting one of the criteria defaults to the appropriate
                           1. 90% of all Service/Agency Cash resources Committed by Hdqtr Service Reps and/or Flag/SES level (for other components).
       Green
                           2. AS&C Share no greater than 70% Cash or AS&C waiver.
                           1. 60% of all Service/Agency Cash resources Committed by Hdqtr Service Reps and/or Flag/SES level (for other components)
      Yellow
                           2. AS&C Share between 70-90% Cash Share without AS&C waiver.
                           1. Less than 60% of all Service/Agency Cash resources Committed by Hdqtr Service Reps and/or Flag/SES level (for other components)
        RED
                           2. AS&C Share of Cash greater than 90% without DUSD (AS&C) waiver.


Notes:
(1) Cash Vs. Dedicated-in-Kind (DINK),:

DINK = Dedicated In-kind funding. A PE is only required for DINK funding when the item(s) have not already been purchased.
CASH: Funding that can be traced to a Service or Agency Budget at a Program Element (PE) and project level detail. This funding isuniquely tied directly to the support of the JCTD and
is usually “new funding” required for the JCTD. POM action or a reprogramming of resources is usually required to establish “cash” funding.
(Cash = green background; DINK = white background).

Please refer to the AS&C White Paper entitled, "JCTD Funding Requirements ( Rev F)." This memo, dated January 17, 2008 provides guidance on the appropriate JCTD funding model
(Cash percentage and spread of resources). It also gives insight for determinig how to define cash vs. DINK resources. Dedicated In-Kind (DINK): Resources (materials or personnel)
that were/are being purchased or are being utilized for other fully justified programs, but are also being uniquely and directly used for the JCTD program. Without this “in-kind” asset, the
JCTD project would have to purchase the resources in order to conduct a successful demonstration (i.e., these assets are partof the critical path of the project). This “leveraged”
relationship should be measurable and appropriately costed---allocating only the portion of costs directly and uniquely associated with the JCTD. A detailed financial analysis may be
required to justify the “in-kind” funding being identified.

(2) Committed vs Uncommitted:

"Committed" means resources have been tentatively approved in writing by Service Resource Planner or Flag/SES Official.
"Uncommitted" means these resources have been specifically not committed (i.e., the drafter has been told resources are not available).
"TBD" means a determination between committed and uncommitted has not been made.
(Committed = color coded black; Uncommitted, TBD color coded red).

(3) A Program Element (PE) is critical for all Cash directly associated with the successful completion of the JCTD. The PE is a seven digit number followed by a Component identifier
(e.g., "F" is for USAF). Include a project number when warrented--for DINK use a one word description (or a footnote) to briefly descripe the DINK. DINK must be an item that is in the
critical path of the JCTD.

(4) Any cell that is colored Green or White background may be modified by the user.




   C:\Docstoc\Working\pdf\59b2cfc1-e75f-4a57-af93-b40f795d800f.xls                                                                                                       JCTD Funding Risk - FY09

				
DOCUMENT INFO
Description: Resource Planner Template document sample