ML20237A359

From kanterella
Jump to navigation Jump to search
Ltr Contract:Mod 1 to Task Order 3 Entitled Account Reconciliation, Under Contract NRC-09-97-205
ML20237A359
Person / Time
Issue date: 08/10/1998
From: Wiggins E
NRC OFFICE OF ADMINISTRATION (ADM)
To: Oneill M
AFFILIATION NOT ASSIGNED
References
CON-FIN-L-1965, CON-NRC-09-97-205, CON-NRC-9-97-205 NUDOCS 9808130313
Download: ML20237A359 (7)


Text

" *

) C })

f* ** 0 g 3 UNITED STATES j

'+

j 2

NUCLEAR REGULATORY COMMISSION WASHINGTON, D.C. 20666-0001

% ,,, g

  • E 13199B Foxx and Company, CPAs ATTN: Mr. Martin O'Neill 700 Goodall Complex 324 West North Street Cincinnati, Ohio 45202.-1908 2

SUBJECT:

MODIFICATION NO.1 TO TASK ORDER NO. 3 ENTITLED " ACCOUNT RECONCILIATION" UNDER CONTRACT NO. NRC-09-97-205

Dear Mr. O'Neill:

This confirms verbal authorization granted to you on June 29,1998 and on July 2,1998 by I Anita Hughes of my staff to commence work under the subject task order. i l

The purpose of this modification is to: (1) increase the level of effort by 755 professional hours, j (2) extend the expiration date of the task order from " June 29,1998" to

  • September 30,1998",

and (3) obligate additional funds in the amount of $37,359, thereby increasing the obligated and I

fixed price amounts of the subject task order by $37,359 from $223,860 to $261,219. The effective date of this modification is June 30,1998. Accordingly, the subject task order is .

hereby modified as follows:

In accordance with Section B.22 of the subject contract entitled " Accelerated Task Order Procedures (JUN 1988)," this letter definitizes Modification No.1 to Task Order No. 3. All work l' shall be performed in accordance with the enclosed Statement of Work.

l Modification No.1 to Task Order No. 3 obligates funds in the amount of $37,359. The f accounting data for Modification No.1 is as follows: J B & R N o.: 87N-15-331-025 FIN No.: L1965 Appropriation No.: 31X0200.87N BOC No.: 252A OBLIGATED AMOUNT: $37,359 The third paragraph of the definitization letter of the basic task order is deleted in its entirety \ l and substituted with the following in lieu thereof: <

)

"The period of performance for Task Order No. 3 shall be from October 31,1997 through -

September 30,1998, at the fixed price amount of $261,219." ,

?'

I v .;

l' 1

i j

9908130313 990810 PDR CONTR (p

NRC-09-97-205 PDR [

._____________________________________a

2 Contract No. NRC-09-97-205 Task Order No. 3, Mod No.1 A summary of obligations for the subject task order, from award date through the date of this action, is given below:

Total FY98 Obligation Amount: $261,219 Cumulative Total of NRC Obligations: $261,219 This modification obligates FY98 funds in the amount of $37,359.

Please indicate your acceptance of this modification by having an official, authorized to bind your organization, execute three copies of this document in the spaces provided and return two copies to the Contract Specialist.

If you have any questions conceming this modification, please contact Ms. Anita Hughes, Contract Specialist, on (301) 415-6525.

Sincerely, b& f" Elois J. Wiggins, Cp p. ting Officer Contract Managemb'nt Branch No. 2 Division of Contracts and Property Management Office of Administration ACC ED:

/

W. '

GV NAMET"lTLE Slo lW DATe

/ ' t .3" ' .

J Ma W j i

ihE EQXX W e-____-_____-__-.

f STATEMENT OF WORK for Modification No.1 to Task Order No. 03 Under Job Code L1965 Contract No. NRC-09-97-205

Title:

Account Reconciliation Technical Monitor: Robert E. Rakowski, OCFO - (301) 415-7340 Designated Afternates: Anthcny C. Rossi, OCFO - (301) 415-7379 Barbara K. Gusack, OCFO - (301) 415-7379 Backaround Since the passage of the Chief Financial Officers Act of 1990, the Nuclear Regulatory Commission (NRC) must : mply with new Federal financial accounting standards and reporting requirements. The Office of the Chief Financial Officer (OCFO) of the NRC requires financial management advice and guidance concerning accounting and audit issues that affect the NRC's annual financial statements, accounting policy and operations. The OCFO also seeks assistance in the preparation of the annual financial statements and compilation documentation, account reconciliations and other general financial and accounting support tasks.

Objective The objective of this task order is to obtain accounting support to reconcile various general ledger accounts and to provide complete detailed capitalized property inventory listings.

Work Requirements The contractor shall provide the qualified personnel to complete the following tasks:

1. Equipment inventory (includes capital leases and contractor-held equipment) a) Review and analyze payment documents (invoices) fcr leased and contractor-held equipment to identify each piece of equipment's property value. Maintain detailed accounting data (e.g., contract invoices, receiving reports) to sufficiently support the property value. (This data is to be entered into the general ledger property account balances.)

b) Prepare adjustments (e g. excess equipment) to the general ledger property accounts as necessary and reconcile the ledger with the Division of Contracts and Property Management's (DCPM) property management l

equipment inventory system.

i c) Develop a deprecation schedule based cn invoices and the usefullife of the

! equipment to reflect the amounts to be charged on a monthly basis.

l 2. ADP Software Inventory Determine the value of ADP contractor-developed and off-the-shelf software by direct

review and analysis of payment documents (invoices) and maintain detailed accounting data sufficiently to support the general ledger ADP capitalized software account l balances and the associated monthly amortization expense.

l l 3. Leasehold improvements inventory Determine the value of leasehold improvements by direct review and analysis of payment documents and maintain detailed accounting data sufficient for support of the l

general ledger capitalized leasehold improvement account balances and the associated l monthly amortization expense.

4. Payroll Review payroll data maintained in the payroll system for each pay period (commencing after the first pay period in October 1997) and reconcile with the payroll data recorded in I

the generalledger by account and object class.

5. Cash Reconciliation Review Review the cash reconciliation report each month (commencing October 1,1997) to ensure that balances are accurate and all payments are recorded.
6. Deposit Clearing Account Review Review the deposit and clearing account reconciliation report each month to ensure that balances are accurate and all payments are recorded.
7. Other General Ledger Accounts a) Perform a review and oversight of all generalledger accounts to ensure accuracy, b) Perform reviews of selected general ledger accounts that contain material account balances.

c) Reviews should be thorough enough to easure that year-end compilation work papers can be accomplished without major adjustments.

8. Task Order Management The Contractor shall provide supervision of junior and senior accountants, and review the general ledger account reconciliations and detailed financial inventory listings.

Provide appropriate partner oversight of managers, work products and deliverables.

Period of Performance Task Order No. 3 shall commence on October 31,1997 and expire on September 30,1998.

l

j j ,

Deliverables

1. Equipment inventory )

i Within 20 working days after the close of the monthly accounting period, provide the l following:

I a) A list of discrepancies identified between the DCPM system and the detailed accounting property system; b) A list of adjustments for the genersl ledger and the DCPM system; c) A summary of the effect on the generalledger account balances (i.e., beginning j balance, adjustments, ending balance);

d) An analysis of chronic problems and recommended solutions.

Within 30 working days after the close of the quarterly accounting period, provide the following:

e) A detailed financial equipment inventory, including the current period depreciation schedule.

l l

2. ADP Software Inventory Within 20 working days after the close of the monthly accounting period, provide the following:

a) A list of adjustment to the general ledger ADP property accounts as necessary; b) A summary of the effect on the general ledger account balances; c) An analysis of chronic problems and recommended solutions.

Within 30 working days after the close of the quarterly accounting period, provide the following: ,

i d) A detailed financial ADP software inventory, including the current period amortization schedule.

3. Leasehold inventory Within 20 working days after the close of the monthly accounting period, provide the  !

following:

a) A list of adjustments to the general ledger leasehold improvement accounts as necessary;

b) A summary c,f the effect on the generalledger account balances; c) An analysis of chronic problems and recommended solutions.

Within 30 working days after the close of the quarterly accounting period, provide the following:

d) A detailed financial leasehold improvement inventory, including the current period amortization schedule.

4. Payroll Within 20 working days after the close of the monthly accounting period, provide the following:

a) A list of adjustments necessary for the generalledger; b) A summary of the effect on generalledger account balances; c) An analysis of chronic problems and recommended solutions.

5. Cash Reconciliation Review Within 20 working days after the close of the monthly accounting period, provide the following:

A summary of any problems encountered and suggested corrective action.

6. Deposit Clearing Account Review Within 20 working days after the close of the monthly accounting period, provide the following:

A summary of any problems encountered and suggested corrective action.

I

7. Other General Ledger Accounts Within 20 working days after the close of the monthly accounting period, provide the following:

a) A list of adjustments necessary for the generalledger; b) A summary of the effect on general ledger account balances; c) An analysis of chronic problems and recommended solutions.

8. Effective supervision and training of senior and junior accountants assigned to this task.

Review of work products to help assure 100 percent accuracy of deliverables.

Meetings The contractor shall be required to attend approximately thirteen (13) status meetings at the i

Two White Flint North Building located at 11545 Rockville Pike, Rockville, Maryland. The date and time of each meeting will be coordinated between the contractor and the NRC Project Officer or designated alternates.

NRC Furnished Materials /Ecuioment The NRC shall provide the contractor with the following items for support of this task order

- Computer reports of general ledger account balances for property, ADP capitalized software, capitalized leasehold improvement, and other general ledger accounts, and >

financial and accounting documents relevant to the tasks.

- Certain contractor staff will be provided with a personal computer, calculator, I telephone, copy and fascimile machine.

PROGRESS PAYMENTS Payments under this task order shall be made in accordance with contract clause B.24 entitled l

' PROGRESS PAYMENTS-COMMERCIAL ITEMS."

i 1