80JSC027R0004 CLDC-012 Attachment CPIC DRD Template for IT Portfolio PPM Data Collection.xlsx

Template Guidance

Template Guidance

This template is designed to capture planned IT expenditures in support of the PPBE 20XX Agency IT Portfolio Data Collection. This excel template collects all IT planned obligations by NASA Project Code within the TBM+ framework. In the green tabs (Project Info, Budget Request, Solutions, Towers, and Cost Pools) prepare the report by entering the requested data.

• Mission-Theme-Program-Project (MTPP): All IT Investments shall be submitted in NASA's MTPP structure.

• Report by Project Code: The MTPP structure requires reporting by Project Code (PC) in the PPBE formulation budget structure and one template will be submitted for every Project Code that has IT content.

• Reporting Responsibility: The Contractor shall provide the required data in the CPIC report in support of the Center "Investment Owners." The "Investment Owner" of the Project Code is the government personnel responsible for the offical reporting the Project Code's IT content, regardless of which organization(s) execute the funds.

• FY Years Reported: The contractor report shall include data for Prior Year (PY)-2 through Budget Year (BY) + 4

• Budget Request: Reported IT obligations for each Project Code and shall be categorized as either Development Moderation & Enhancement(DME) and/or Steady State(SS).

• IT Towers: Each IT investment shall be categorized by the applicable IT Towers and Sub-Towers associated with investment. An investment is often comprised of multple IT Towers and Sub-Towers.

• IT Cost Pools: Each IT investment shall be categorized by the applicable IT Cost Pools and Sub-Cost Pools associated with the investment. An investment is often comprised of multiple IT Cost Pools and Sub-Cost Pools.

•Soultions: Each IT investment shall be categorized by the applicable Solution Type and Solution Category associated with the investment, unless the Federal Extension of the TBM Taxonomy applies. In this case, an IT investment shall be categorized by the applicable Solution Type, Solution Category, and Solution Name.

Project Info

Budget Request

Solutions

Use this table to capture the investment's TBM Solutions data. Definitions are provided in seperate tabs of this worksheet by Business Facing and Technical Facing Solutions.

- IT Cost is entered by Solutions Category, except for where the TBM Federal Extension applies regarding the Business Solution Type. In this case, IT Cost is entered by Solution Name (see Note).

- Total costs identified should equal the totals in the Budget Request Tab, Towers Tab, and Cost Pool Tab

- Investments will not likely have costs associated with all Solutions

- The version of the TBM Taxonomy is subject to change; the applicable version of TBM is identified in OMB Circular A-11.

Note: In addition to the generic TBM Business Solutions Type, the Federal Extension of the TBM Taxonomy provides options for agency specific "Business" Solution Types along with subsequent Categories, and Names that align to a particular agency's mission and is based on the Federal Enterprise Architecture Framework (FEAF). NASA's agency unique Business Solution Type is Transport and Space. NASA has one Solution Category under the Transport and Space Solution Type, which is Space Flight, Research, and Supporting Activities. Multiple Solution Names are available and are mostly aligned to the work within NASA's Mission Directorates.

Total 0 0 0 0 0 0 0 0 0

Business Facing Solutions Def

Business-Facing solution types are more forward-facing and obvious to every day users in supporting the organization’s operations and mission. They are said to support the“what” of IT.

include the client computing devices, software, and connectivity to enable the workforce to access business applications; to communicate with other employees, partners, and

Technologies and services that support the functions of transportation modes, including

Enable internally focused corporate services which automate and support the organization’s internal operations.

These are often referred to as business support or shared services which enable the core operating capabilities of an enterprise or organization (e.g. Finance, Human Resources, Legal, etc.). Finance Enable the financial management of the enterprise. Planning & Management Accounting Applications and services that enable the strategic allocation of funds in support of established future and current business goals, including planning, budgeting and forecasting, ad-hoc analysis and reporting to inform and guide leadership in the ongoing determination and understanding of business strategy related financial goals, incentives, progress and impact.

Specific service offerings may include: planning/budgeting/forecasting, cost accounting & control, cost management and financial performance.

Revenue Accounting Applications and services that enable the comparison of revenue targets to actual achievement. Supervisory responsibility over all transactions and entries (receivables, payables, intercompany movements) that pass into the final periodic accounts of an entity, and support int./ext. analysis and communication of profit on a monthly, quarterly or annual basis. (Determination of whether this includes the actual lifecycle processing of payments due from customers, is based on entity type, sector and scale - see Accounts Receivable).

Specific service offerings may include: customer credit, invoicing, accounts receivable, and collections.

Specific service offerings may include: general accounting, fixed asset accounting, grant management, and financial reporting including regulatory and compliance reporting.

Project Accounting Applications and services that enable managing accounts for large investment projects, often requiring significant capital outlays over multiple years. Managing investment against major milestone, product or activity expenditures during the course of a project, supporting project, portfolio and program leadership with insight to understand their progress & efficiency toward target.

Specific service offerings may include: capital planning, capital project accounting & analysis.

Payroll & Time Reporting Applications and services that enable the handling of reported time, and the ongoing processing and payment of wages, salaries and benefits, including quality assurance and error handling (but excl. benefits management). Also inclusive of time keeping, and the capture, aggregation, measurement, validation and transmission of staff time.

Specific service offerings may include: time reporting payroll, and payroll taxes.

Accounts Payables & Expense Reimbursement Applications and services that enable the processing of payments due to suppliers, lenders and other operating expenses, including those related to employees. Supports the development of policies and procedures around processing of accounts payable & employee expense reimbursement across the entity. This process often includes the receipt & review of invoices and reimbursement requests, payment processing, PO & payment issuance via check, wire transfer or other forms of payment transfer.

Specific service offerings may include: accounts payable, expense reimbursement, corporate credit cards.

Treasury Applications and services that enable the management and optimization of daily liquidity, excess cash, and financial risk via investment activities (e.g. hedging, debt instrument purchase/sale, overnight and short term institutional investments, and funds transfers) focused on supporting ongoing business operations across the entire company, or regionally. Also includes the governance, control, assessment and risk management activities required to ensure effectiveness.

Specific service offerings may include: Treasury policies & procedures, cash management, in-house bank accounts, debt & investment, hedge transactions.

Tax Applications and services that enable managing the organization's financial accounts specific to the world-wide management, optimization and payment of tax, and related evidence & documentation. This includes, planning, estimations & analysis of the tax position and impact, related transfer pricing strategies, tax return preparation, timely payment, and required authorizations. It also encompasses the orchestration of record retention in support of regulatory requirements and internal policy.

Specific service offerings may include: tax strategy, tax planning & analysis, transfer pricing, and tax processing.

Ensures the identification, detection, assessment, monitoring and communication of risk and the execution of risk management activities across all levels of the organization, including all risk facets, including but not limited to sector, organization, operations, compliance, data, personal privacy, cyber, espionage, geo-political, etc

Not intended for large scale industrial/plant construction.

Excludes Physical Security

Technical Facing Solutions Def

Technical-Facing Solution types are how Enterprise IT supports the mission of the rest of the organization. They serve as the connective tissue, and focus on the underlying technologies, tools, and processes that make up IT services, or the “how” of IT.

systems and data.

Infrastructure:

include the core infrastructure — facilities, compute, storage, and network services — that are required to deliver any technology automation. Typically, these are not directly

include the application infrastructure (database, middleware, etc.) that enables business-facing applications and services. Typically, these are not directly consumed by users. They are components required by the end user, business application and shared application services (see below for the latter two types). However, for some IT operating models, the shared “infrastructure and

Towers

- Cost is entered by Sub-Towers.

- The total costs identified should equal the totals in the Budget Request Tab, Cost Pool Tab, and Solutions Tab.

- Investments will not likely have costs associated with all IT Towers and Sub-Towers.

- The version of the TBM Taxonomy is subject to change; the applicable version of TBM is identified in OMB Circular A-11.

Total 0 0 0 0 0 0 0 0 0

Tower Def & Examples IT Towers Definitions and Examples (TBM ver 4.0) The version of the TMB Taxonomy is subject to change; the applicable version of TBM is identified in OMB Circular A-11.