0 eCPIC User Training: A-11 Funding Information These training materials are owned by the Federal Government. They can be used or modified only by FESCOM member agencies. 1 A-11 Funding Information To begin completing the A-11 Funding Tables, select the appropriate investment using the eCPIC Navigation Panel or in the Investment List. Once the Investment has been opened, select the Browse Sections tab, followed by section Ex 300A: Section C: Lifecycle Costs BY14. 2 To allocate or edit your existing A-11 funding information, begin by clicking on the cell where you wish to enter data. Users are able to edit the data rows that consist of black numerals, while grey numerals represent read only funding information. A-11 Funding Information: Lifecycle Costs Data Entry Once an editable cell is selected, the data entry is highlighted and the user can modify the funding information. The Subtotal and Total rows consist of read only cells which automatically calculate the funding information to perform more efficient and effective calculations. Read only cells will update once the user selects the icon. Editable Funding Information Read Only Funding Information Editable Funding Information 3 To ensure proper alignment between the Exhibit 300 and 53 reporting, eCPIC rolls up the Planning and Acquisition funds to DME funding. Operations and Maintenance (O&M) and Disposition Costs (optional) roll up in to SS funding. Enter Lifecycle Cost information in the appropriate DME (Planning & Acquisition), Steady State (Operations and Maintenance), and Disposition Costs (optional) rows. Be sure to enter all appropriate funding in the FTE cost rows for both DME and Steady State life cycle phases. A-11 Funding Information: Data Entry of Life Cycle Costs DME (Development, Modernizations, or Enhancements) SS (Steady State) Note: eCPIC allows system administrators to customize the Lifecycle CostsTable by adding more detailed reporting rows. The table view presented above may vary based upon agency and administrator defined settings. 4 A-11 Funding Information: Full Time Equivalent (FTE) Costs Click the icon to save and calculate the Subtotals. The system will display the icon to verify that the save was successful. 5 A-11 Funding Information: Full Time Equivalent (FTE) Costs Cost CategoryCY2013 Planning Costs50 DME (Excluding Planning) Costs150 Planning75 DME (Excluding Planning) Govt. FTE Costs150 Sub-Total DME Costs (Including Govt. FTE)425 Cost CategoryCY2013 O&M Costs75 Disposition Costs (optional)0 O&M Govt. FTE Costs50 Sub-Total O&M Costs (Including Govt. FTE)125 Cost CategoryCY2013 Sub-Total DME Costs (Including Govt. FTE)425 Sub-Total O&M Costs (Including Govt. FTE)125 Total Cost (Including Govt. FTE Costs)550 Cost CategoryCY2013 Planning Govt. FTE Costs75 DME (Excluding Planning) Govt. FTE Costs150 O&M Govt. FTE Costs50 Total Cost (Including Govt. FTE Costs)275 The four illustrative tables on the right display the cost categories used to calculate the corresponding Sub-Total (Including Govt. FTE Costs) in the Life Cycle Costs table (left side). 6 Using the Browse Sections tab, select the Full Time Equivalents subsection to continue completing your Exhibit 300s A-11 funding information. A-11 Funding Information: Full Time Equivalents 7 Appropriately allocate FTEs and click the icon to calculate the totals. A-11 Funding Information: FTE Allocation eCPIC Tip: The Full Time Equivalent Totals should align with the FTE Costs that have been allocated in the Lifecycle Costs Table. 8 Please observe that the Lifecycle Costs table in eCPIC includes more fiscal years than is reported in the OMB Exhibit 300 submission. As a result, users must indicate the lifecycle of the investment by answering the questions below. In the example shown, it has been specified that the investment began in 2001, and will reach the end of its estimated lifecycle in Update the investment's funding questions and explanation for funding changes. Once completed, click the icon to save the changes. A-11 Funding Information: Funding Questions 9 Using the Browse Sections tab, select the Funding Sources subsection to allocate funds to the appropriate Internal or External Funding Agency. A-11 Funding Information: Funding Sources Table 10 Select a funding source and type from the dropdown menus, as well as indicate in the checkbox if the funding is internal or external to your agency. Select to finish assigning the Funding Source to the table. Data entered into this table is automatically included in your agencys Exhibit 53 financial information. A-11 Funding Information: Funding Source Identification 11 To complete this table, verify the amounts (DME funding, SS funding, and Total) for each funding source. You must ensure that the total (life cycle) costs and FTE funds are appropriately accounted for in the funding sources table, even if the total is dispersed throughout multiple funding sources. Funding Sources indicated as internal are funded by your agency. Funding Sources indicated as external are funded by other agencies. These will appear in the Agency Funding and Contributions columns of the Exhibit 53, respectively. A-11 Funding Information: Funding Source Breakdown 12 A-11 Funding Information: Investment Totals and Balance Table The purpose of the Investment Financial Totals and Balance Table is to determine if the Funding Sources and Life Cycle Costs tables are consistent. To compare the amounts in the Funding Sources with the Life Cycle Costs tables, select the icon appears at the upper right of either table. 13 If the financial data does not balance in the Investment Financial Totals and Balance Table, the areas that are inconsistent will be highlighted in red showing the amount that is off and in what direction (+/-). If the red number listed in the Balance row is positive, this is indicating that the Lifecycle Costs table total is greater than the Funding Sources table (and visa versa for a negative number). A-11 Funding Information: Total Financial Breakdown Click the link to reveal the DME and SS funding, ensuring that the balance is correct at not only the highest total level, but that the DME and SS financial data is allocated consistently. Any balance other than 0 indicates a discrepancy within the funding tables 14 A-11 Funding Information: DME and SS Breakouts All funding tables must be balanced within the appropriate year and DME/SS classifications in order for the agency to submit an accurate Exhibit 53 to OMB. 15 A-11 Funding Information: DME and SS Balance The DME vs SS Breakout tables reveal where funding discrepancies exist and the amount that has been incorrectly allocated. The Select Financial View drop down menu has two viewing options. The Complete Financials view includes Exhibit 300 and Exhibit 53 Summary of Funding and Funding Source totals. The Ex 53 Financials view includes only the Summary of Funding and Funding Sources totals that are reported in the Exhibit 53. 16 A-11 Funding Information: DME and SS Balance Click the icon to open the Row Guide table key for the Investment Financial Totals and Balance Table. 17 Further Reading Refer to the following Sections of the eCPIC User Guide for additional details on the material covered in this training session: Section :Export to Word 300 Section 4.5:Updating Investment Data Section 4.6:Generating Exhibit 300 XML Section 4.21:Investment Module Tables A-11 Funding Information: Reference 18 A-11 Funding Information: Exercise Exercise Steps Step Description Reference Slides Enter DME and SS Funding in the CY After locating the Lifecycle Costs Table, enter $500,000 in the current funding years DME and SS columns. Allocate $100,000 to the Government FTE Cost section and save the your changes for eCPIC to calculate your Subtotal. 1, 3-5 Assign a Full Time Equivalent Locate the Full Time Equivalents table and assign 1.0 FTE to the Program Management row of the current funding year. 6, 7 Assign a Funding Source Assign an Internal Agency Funding Source from the dropdown menu of the Funding Sources subsection. With the funding source identified, enter the funding breakdown into the DME and SS rows Balance the Funding Tables Ensure that youve properly balanced your Lifecycle Costs and Funding Sources tables by opening the Investment Totals and Balance Table link to reveal the funding breakdown Exercise Objectives: During this exercise you will have an opportunity to practice navigating and utilizing the eCPIC A-11 Funding Tables. This exercise includes: