PBSW Comptroller.doc

NAWCAD COMPTROLLER/BFMC

FINANCIAL, PROGRAM AND BUSINESS ANALYSIS SUPPORT SERVICES

1.0

INTRODUCTION

1.1 The Comptroller Department and the Program and Business Analysis Division are known as the Business and Financial Management Community (BFMC) and provide business and financial services and products that will improve performance, quality, timeliness and efficiency throughout the organization including the Naval Air Warfare Center Aircraft Division (NAWCAD) and the Naval Air Systems Command (NAVAIR). The Comptroller Department also provides liaison support with the NAVAIR Enterprise Resource Planning (ERP) Business Office and the Navy ERP Program Office. The BFMC ensures tasking for special programs, studies, and data calls are consistent with fiduciary and financial policies. Additionally, the BFMC is tasked to implement directed common financial systems and processes across the NAWCAD and NAVAIR by providing financial services support.

2.0

SCOPE

2.1 The contractor shall provide specialized analytical support in the areas of special programs, budget (formulation and execution), workload planning, data warehousing, manpower management, and technical acquisition assistance. Tasking includes non-routine internal/external action items and data calls originating from multiple sources, including NAVAIR. Tasking encompasses Strategic Planning, Economic and Business Case Analysis, Business Planning, Budgeting and Workload Planning, Performance Measurement & Improvement, Financial Reporting, Change Management and the use of information technology to enhance business efficiency and productivity. Efforts associated with the Strategic Plan, Navy ERP, Total Force Readiness (TFR), and the Data and Business Warehouse Projects especially the design and testing of reports and report validation and legacy system applications.

2.2 The contractor shall provide support to the NAWCAD Comptroller and Planning Officer in the technical analysis of various organizational, functional and management scenarios. Efforts associated with initiatives for Budget and Planning; requests from the NAWCAD Board of Directors (BOD) and Resource and Workforce Cross Functional Teams and internal and external data calls will be supported. This support shall focus on developing a consistent and organized approach to the business planning and workload planning process utilizing the Navy ERP processes and system. Tasking shall include providing technical support in meeting financial systems requirements and assessing the financial systems relative to data integrity and corporate and user reporting requirements. Additionally, support shall include processing, analyzing and distributing financial information across the NAWC from the Navy ERP and Business and Data Warehouse systems. Examples of services include: strategic, business, and action planning; assessing organizational alignment and synergism of efforts; supporting process improvements in support of BFMC activities; analyzing overhead manpower and cost reductions;; increasing productivity through improved business processes and technologies; supporting organizational development and change management; conducting operations research analysis; process modeling and simulation; performing investment analysis and financing strategies; conducting cost benefit analysis; financial planning and execution; developing plan vs. actual reports, analyzing expenditures and comparing plan vs. actual financial reports and training for improved compliancy and customer satisfaction.

2.3 The contractor shall provide support for Comptroller directed common financial system implementation and process efforts by providing financial services support. These services include data entry processes, process management, training support to all NAWCAD/NAVAIR sites, and liaison support with the NAVAIR ERP Business Office and Navy ERP Program Office. The NAWCAD accounting department performs services for NAVAIR HQ. The effort under this contract includes both Navy Working Capital Fund (NWCF) and General Fund support.

3.0

APPLICABLE DOCUMENTS

Chief Financial Officer’s Act

DOD Financial Management Regulations

MIL-STD 881

NAVCOMPT Manuals

Current NAVAIR and NAVAIRWARCENACDIV Instructions and Notices

All relevant DoD and FMR instructions, as well as any internal Comptroller policies, procedures, and guidelines necessary to complete tasking. In addition, specific NAVSUP guidelines as found in NAVSUP P-485 V1-3 Afloat Supply Procedures and NAVSUP P-409 MILSTRIP/MILSTRAP Desk Guide.

4.0

TECHNICAL REQUIREMENTS

4.1 Budget Support. The contractor shall provide budget/funding business/financial support to the NAVAIR/NAWCAD BFMC:

4.1.1 The contractor shall provide budget support to the NAWCAD BFMC and NAVAIR in preparing the annual command-wide competency and program budgets, such as A-11, NWCF, Capital Purchase Program (CPP), Information Technology (IT), Major Range Test Facility Base (MRTFB), Base Operating Support (BOS), and Foreign Military Sales (FMS); developing budget policy and providing budget process oversight.

4.1.2 The contractor shall provide support for planning, developing, implementing, and evaluating financial directives, instructions, and procedures for the budget formulation/justification and execution.

4.2 Accounting Support. The contractor shall provide accounting business/financial support to the NAVAIR/NAWCAD BFMC:

4.2.1 The contractor shall provide NAVAIR/NAWC support in executing NWCF budget programs and policies to include defining system requirements; analysis of various general ledger accounts, financial statement exhibits, cost data, and budget vs. actual; guidance and resolution of discrepancies, erroneous charges, cost overruns, process cost inquiries, carryover, net operating results, etc.

4.2.2 The contractor shall provide analytical support to complete data calls from the Navy/Department of Defense Comptroller and other activities with diversified missions and requirements, including data calls at both the field activity level and headquarters level.

4.2.3 The contractor shall provide the research, analysis, and documentation necessary to support the implementation and evolution of ERP including system analysis to insure data integrity, financial stability, and timely reporting for NAWC business requirements. Contractor shall support the following ERP modules: Sales and Distribution (SD), Material Management (MM), Financial (FI), and Funds Management (FM).

4.2.4 The contractor shall provide support for the Cost Accounting Department in the areas of contract obligation, contract audits, pre validation support for invoice processing, outgoing funding documents, unmatched disbursement resolution and triennial reviews.

4.2.5 The contractor shall provide support for the General Ledger Accounting Department in the areas of key financial indicator analysis, detail general ledger analysis, fixed asset accounting, labor reconciliation, MILSTRIP and reimbursable billing.

4.2.6 The contractor shall provide support for the Commercial Accounts Department in the areas of invoice processing, entitlement process, and contract closeouts.

4.2.7 The contractor shall provide the management support, including analysis and planning, to the Comptroller for the development and transition of common standardized financial systems and processes across the NAWC.

4.3 Program and Business Analysis. The contractor shall provide program and analysis business/financial management support to the NAVAIR/NAWCAD BFMC:

4.3.1 The contractor shall provide administrative business and financial support to the budget formulation and execution, accounting, workload, and manpower activities, data collection and coordination; internal metric tracking; and data calls at both the corporate and competency/program level. The contractor shall provide support to the Joint Advocate General (JAG) office in supporting command military personnel. Support includes preparation of legal documents, notary services, and income tax filing.

4.3.2 The contractor shall provide business and analysis support for special command-wide programs. The contractor shall provide documentation, management/coordination, and analyses in support of various command-wide programs.

4.4 Workload Planning. The contractor shall provide planning business/management support to the NAVAIR/NAWCAD BFMC:

4.4.1 The contractor shall provide workload planning course instruction and support. Course instruction includes developing training packages and exercises, conducting classroom instruction, and providing on-site instruction as requested by management/users.

4.4.2 The contractor shall provide guidance and support to competencies and programs in developing Technical Work Packages, Work Breakdown Structures (WBS), and Networks and Activities. The contractor shall provide expertise to meet NAVAIR/NAWCAD requirements, business rules, and processes to the Project Structures Module.

4.4.3 The contractor shall provide data collection support, conducting workload analysis studies and responding to workload related data calls.

4.5 Manpower Management. The contractor shall provide manpower business/management support to the NAVAIR/NAWCAD BFMC:

4.5.1 The contractor shall conduct manpower, organizational, and management analyses and studies of productivity, skills mix, manpower ratios, training, and personnel composition. The contractor shall provide reports on issues, alternatives, and recommended solutions.

4.5.2 The contractor shall provide Organizational Breakdown Structure/Workforce Shaping support and analyses of workforce shaping initiatives; identify organizational relationships, process role mapping Navy ERP requests; and develop guidelines and workforce demographics.

4.6 Acquisition Assistance. The contractor shall provide acquisition assistance and support to the NAVAIR/NAWCAD BFMC:

4.6.1 The contractor shall support the government in the development of acquisition plans, work statements, Contract Data Requirements List (CDRL) requirements, DOD Contract Security Classification Specification (DD-254), personnel qualifications, justification and approval documents, modifications, change orders, and small purchase requirements.

4.7 Business Warehouse/Financial Systems Support. The contractor shall provide data warehouse support to the NAVAIR/NAWCAD BFMC:

4.7.1 The contractor shall perform analyses of BFMC information systems and provide input for a data warehouse design that will meet the requirements for business reporting, data calls, and other business data requests, such as BRAC.

4.7.2 The contractor shall design, develop and implement tasks, such as initiation of software change requests, analysis of database table design, data storage estimation, data extraction, data analysis, and documentation.

4.7.3 The contractor shall support NAWC legacy, Central Design Agency (CDA), Enterprise Resource Planning (ERP), and data warehouse business and financial systems/subsystems. The contractor shall perform tasking related to incorporating new requirements or changes to business practices or processes that will affect/impact how the NAWC workforce does business and how systems/subsystems process data. The contractor shall perform functions, such as requirements analysis, managing, interfacing, testing, training, implementing, and maintaining various business and financial legacy, Central Design Agency (CDA), ERP, and stand-alone systems/subsystems.

4.8 Strategic Planning. The contractor shall participate in preparing a Strategic Plan that assesses the long-range needs of the Navy. This plan will concentrate primarily on the external environment over the next 10 to 15 years. The plan shall evaluate the changes in economics, finance, politics and technology and assess how these factors will affect future Navy goals. The focus of the Strategic Plan is to ensure that the organization reaches its goals over the long term and serve as a basis for future actions. The contractor shall provide support in developing guidance and defining a process, format and approach for the development and preparation of a Strategic Plan.

4.9 Economic & Business Case Analysis (BCA). The contractor shall provide support for the preparation of an Economic and BCA. The contractor shall evaluate the cost and benefits, consider the return on investment, the payback period and ensure the programs are in accordance with the BODs strategic initiatives and the guidance provided by the Resource Cross Functional Team (RCFT). Narratives including justifications, alternatives and recommendations shall be prepared.

4.10 Enterprise Resource Planning and Reporting Support. The contractor shall support the development of Work Breakdown Structures (WBS) and Networks and Activities in support of the Navy ERP solution. The contractor must be proficient in the development of work breakdown structures and knowledgeable of MIL-STD-881. The contractor shall support the planning process from both a project and competency and corporate perspective, including the functional process. The contractor shall support the Post Production phase of the Navy ERP deployment by providing hands on support to the user community with the Program Management aspects of the application as well as the business and financial planning and workload analysis features. The contractor shall support the Navy ERP financial planning process, reporting requirements, the business rules and the interaction between the various financial (Fiduciary and Controlling) Human Resources, Material Management and the Project Systems Modules.

4.10.1 The contractor shall support the on-going efforts associated with the deployment and training of the Navy ERP system. This support shall include preparing training packages and related materials, conducting classroom exercises and providing hands-on training support to the user community. The contractor shall research suggestions or problems identified during the training sessions by the users for applicability and provide possible solutions or recommendations for system or process improvements. The contractor may be required to train others to be trainers in support of the deployment.

4.11 Industry Best Practices Analysis. The contractor shall conduct an analysis of Public Law and Governmental policy in conjunction with economic and management theory and best commercial practices to determine optimal business and financial policy for the NAWC. Policy recommendations shall be supported by clearly articulated objectives, detailed implementation plans, and a description of suitable performance measures and incentives.

4.12 Workload Planning and Analysis. The contractor shall analyze financial planning data extracted from the Navy ERP, the Business Warehouse and the Data Warehouse to ensure the data meets the planning needs of the user community and the Corporation. The contractor shall perform trend analyses, prepare out year plans, conduct a workload analysis by project, competency and appropriation, compare Plans to Actual (PVA) and analyze work force requirements to provide support in developing a balanced workload across the NAWC.

4.12.1 The contractor shall conduct an analysis of the planning process and provide recommendations in support of the change management process. The NAWCAD Planning Manual and Comptroller Compendium shall be revised or updated as required based on changes resulting from the deployment of Navy ERP and any organizational and managerial changes that impact the document.

4.13 Business Warehouse Support. The contractor shall support the requirements definition and functional testing efforts related to planning and financial reports using the Business Warehouse reporting tool. The support shall include designing reports that meet the functional needs of the user community and participating in the actual testing and validation of the reports.

4.13.1 The contractor shall provide support with reports documentation and definition. The contractor shall support the associated training efforts by conducting classroom training and providing side-by-side assistance to the user community as follow-up to the classroom training.

4.14 Environmental Scan Database Support. The contractor shall review White House, Office of Management and Budget, Department of Defense (DoD), Navy and congressional reports, budgets and press releases for information affecting NAVAIR/NAWCAD operations, business and infrastructure. The contractor shall provide documents in digital format for uploading to the NAVAIR/NAWC environmental scan website.

4.15 Business Plan and Environmental Scan Team Support. The contractor shall support the preparation and development of the NAWCAD Business Plan. Support shall include participating in defining the process, developing a format and preparing the instructions for completing the Business Plan. The contractor shall provide functional support for the design and development of Business Plans for the NAWCAD.

4.15.1 In conjunction with the business planning process, the contractor shall perform an Environmental Scan assessment in support of the NAWCAD/NAVAIR business initiatives, including an up-to-date analyses of current external sources of information that directly affect the business unit’s financial and technical workload.

4.16 Data Warehouse Support. The contractor shall provide technical analyses and functional support of the Data Warehouse Project through all phases of development, testing and maintenance. The contractor shall collect information from Navy ERP and the various legacy transactional systems for data mapping and loading. The contractor shall review and research data warehouse table discrepancies. The contractor shall prepare test plans, conduct testing and perform system and functional validation. The contractor shall provide updates and corrections to the mapping and validation processes, and validate the data warehouse output reports. The contractor shall also provide functional support for the restructuring or redesigning of existing data that will result in improved reporting capability. The contractor shall also support live systems, which are currently housed in the data warehouse as well as any that are planned to be included in the warehouse. The contractor shall also write System Change Requests and provide support in the production testing processes. The contractor shall provide functional knowledge and expertise as a member of the Software Configuration Board for the Data Warehouse Project.

4.17 Data Management Support. The contractor shall support the Data Manager in documenting and mapping the data elements from the various transactional systems for the Data Warehouse Project. The contractor shall maintain and update the appropriate spreadsheets and forms required for the data management process. This includes researching information and interacting with the functional team members.

4.18 Configuration Management Support. The contractor shall provide support in the management of all Data Warehouse Project documentation. The contractor shall update planning and process documents (e.g., Plan of Action and Milestones (POA&M)); maintain team rosters; update system user ID, repository, and folder privileges; and document/flowchart daily run schedules. The contractor shall monitor and document software activity via the process Max and StarTeam tools to ensure project compliance with Level II/III Capability Maturity Model (CMM) software certification guidelines. The contractor shall also enter, update, and maintain version control of the documentation in the various electronic product management tools (e.g., StarTeam, local tracking system, etc.), and maintain hard copy files of manuals, correspondence, System Change Requests and other pertinent documents as applicable.

4.19 Documentation Library and Records Management. The contractor shall manage the documentation library by cataloging, filing, distributing, and researching any documentation received internal or external to NAWCAD. The contractor shall manage the electronic shared access files and an issues records database, interacting with the DFAS Customer Support Desk and NAWCAD’s functional points of contact in reconciling system issues. Overall general and administrative tasks performed by the contractor shall include preparing and updating various spreadsheets and briefs; recording, tracking, disseminating, balancing, reconciling, and copying reports; attending and participating in various meetings; preparing office supplies orders for government processing and researching information as requested.

4.20 Board of Directors and Cross Functional Team (CFT) Management Support. The contractor shall analyze specific technical issues assigned by the NAWCAD BOD and CFTs and conduct tradeoff analyses and provide recommendations and the potential impact of the decisions relative to the issues. The contractor shall support the development of current and historical data, analysis of the trends and definition of the potential ramifications of actions that might be taken. The contractor shall support team studies to respond to external data calls that deal with technical mission functions, resources and organizational relationships.

5.0 DELIVERABLES

5.1 The contractor shall provide a monthly status report in accordance with CDRL A001.

5.2 The contractor shall provide training services and participate in the development of training materials as required by the Navy ERP deployment effort in accordance with CDRL A002.

5.3 The contractor shall prepare point papers and presentation material as required in accordance with CDRL A003.

6.0 Place of Performance.

6.1 Work in support of this effort shall be performed at NAWCAD Patuxent River, MD, NAWCAD Lakehurst, NJ including the Voyage Repair Team (VRT) locations at Norfolk, VA and Mayport, FL.

7.0 Travel.

7.1 Travel is anticipated in support of this effort. Detailed travel requirements will be defined in specific task orders.

8.0 Material.

8.1 Material is anticipated in support of this effort. Detailed material requirements will be defined in specific task orders.

9.0

NMCI.

9.1 NMCI requirements are not anticipated in support of this effort.

10.0 Security Classification.

10.1 Work to be performed under this contract is classified SECRET. A DOD Contract Security Classification Specification (DD-254) is provided.

�Delete “provide”

PAGE