$68,640

Position Overview:

The Program and Business Analysis Department (PBAD), Code D/EC40000, provides essential financial and administrative support to the scientific, technical, and administrative communities of the Naval Air Warfare Center Weapons Division (NAWCWD) China Lake and Point Mugu. This support includes budget analysis, budget execution, budget estimates, and financial tracking and reporting. This support enables NAWCWD Command to accomplish its mission of supporting the warfighter by providing strategic and tactical advice and support in business and financial management.

This Statement of Work covers comprehensive financial and budget related tasking in support of the Program and Business Analysis Department (PBAD) and the variety of products delivered to its various customers. The Contractor shall support budget analysis and administration for input into financial excel reports and/or Management Information Systems. Responsibilities included populating standard reports by extracting and/or consolidating numerical and financial information from the Navy Enterprise Resource Planning (N-ERP) application, identify discrepancies between actual budget transactions and reports of transactions, tracking the execution and status of any necessary correction report requests, modify and update project structures and other pertinent budget data (labor hours, material, travel and contract costs) in N-ERP, process routine requests for funds to cover payment of travel, rentals, services and supplies, assist with reconciliation of financial commitments and financial obligations and other financial functions.

Primary/Major Duties and Responsibilities:

The Contractor shall support budget analysis and administration by utilizing financial data provided by the PBAD customer for input into financial excel reports and/or Management Information Systems. This task may include compiling, consolidating, verifying, and arranging data. Contractor shall be skilled in Microsoft Excel. The Contractor shall populate standard reports by extracting and/or consolidating numerical and financial information from the Navy Enterprise Resource Planning (N-ERP) application, related budget forms and documents (e.g. worksheets, schedules, and reports) for use by PBAD customers. The Contractor shall identify discrepancies between actual budget transactions and reports of transactions. The Contractor shall make data entries required to correct transactions and then provides data to PBAD customers for review/approval. The Contractor shall track the execution and status of any necessary correction report requests. The Contractor shall modify and update project structures and other pertinent budget data (labor hours, material, travel, and contract costs) provided by the PBAD customer in N-ERP. The Contractor shall process routine requests for funds to cover payment of travel, rentals, services and supplies as requested by the PBAD customer. This tasking may include examining the requests to verify that all necessary prior approval and concurrences have been obtained, requests contain required information, organization budget procedures provided by the PBAD customer have been followed and funds are available in the amount requested. Request is then returned to PBAD customer for approval and execution. The Contractor shall assist the PBAD customer with reconciliation of financial commitments and financial obligations utilizing reports provided by PBAD customer. The Contractor shall follow up on any outstanding commitment or obligation transactions. The Contractor shall retrieve unliquidated obligation reports from N-ERP and forward the information to the appropriate PBAD customer. The Contractor shall record obligations, expenditures, transfers of funds, and similar budgetary transactions (i.e. CDAs, DPAs, PRs) in accordance with processes provided by the PBAD customer. The Contractor shall independently reconcile incorrect chargeable objects with the individuals who provided the chargeable objects. The Contractor shall type, edit, and transmit correspondent reports, spreadsheets, and other documents and uses office automation software to manipulate standard databases and systems in support of assigned areas. The contractor shall update, revise, sort, calculate, and manipulate data to meet correspondence and report formats that are produced on standard documents within various Microsoft Office products. The Contractor shall provide resource assistance by utilizing and acquiring skills of specialized software applications, including those that are unique to the Navy (e.g., N-ERP and Rapid Business Operations Management (rBOM)). The Contractor shall provide resource support to management or analysts by collecting and inputting data into Government owned systems. The Government shall provide any training in the use of these unique software applications required under this effort. The Contractor shall prepare financial reports and budgets and provide analysis and recommendations to the Government. The Contractor shall provide input and recommendations for program, plans, program budgets, work unit plans, and proposed development or product improvement plans. The Contractor shall provide recommendations for short- and long-range financial plans, life-cycle cost studies, and design-to-cost studies. The Contractor shall provide analyses of the impact of changes and deviations from plans and schedules. The Contractor shall prepare technical reports, test plans, yellow sheets, reports of test results, technical memoranda, deficiency reports, message reports and quick response reports from disk, rough or handwritten drafts on appropriate forms and plain bond paper. These documents shall be completed in rough or final draft. Final documents prepared shall meet requirements of applicable instructions. Turnaround time shall be 30 pages typed per day for routine documents. Turnaround time for urgent documents may vary and will be specifically noted. The Contractor shall provide input in establishing standard rates for customer(s), monitoring, and analyzing account financial execution, and preparing year-end projections for Direct Product Accounts (DPA). The Contractor shall provide analysis to Government personnel who determine the final actions/approvals based on the provided data to ensure charges are posted accurately, and in compliance with applicable DOD and DON federal regulations and directives. The Contractor shall provide a DPA/ Cost Distribution Account costs vs. revenue analysis, and provide recommendations to the Government. The Contractor shall compile financial data to illustrate and analyze historical trends. The Contractor shall perform administrative and technical work in support of budget analysis and administration. The Contractor shall provide recording, reporting, processing, and monitoring of budgetary transactions and provide data as requested to the Government. Assists with the budget execution process by identifying, dating, and recording receipt of and sorting budget related documents. Populates standard reports by extracting and/or consolidating numerical and financial information. Process financial documentation, perform data entry action, identify discrepancies, maintain records, process request for funds or payments and compile reports. Use prepopulated formulas to analyze and compare prior year expenditures across accounts. Makes modifications and updates on project structure charts, charts, and other pertinent budget data. The PBAD requires the Contractors to complete the Financial Workforce Development New Employee Cohort Orientation to fulfill the tasking as laid out herein no later than 30 days after on-boarding. This orientation is hosted by the NAWCWD Financial Workforce Development free of charge and is available to contractor employees on a space-available basis. The Contractor shall not be required to travel in performance of this task order. A Junior level person is responsible for assisting more senior positions and/or performing functional duties under the oversight of more senior positions.