ML20199L744

From kanterella
Jump to navigation Jump to search
Ltr Contract:Mod 1 to Task Order 8, Account Reconciliation, Under Contract NRC-09-97-205
ML20199L744
Person / Time
Issue date: 01/21/1999
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 9901280126
Download: ML20199L744 (8)


Text

.

hO g ner 1

UNITED STATES g

j NUCLEAR REGULATORY COMMISSION WASHINGTON, D.C. 20066-0001

\\*****

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

SUBJECT:

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

Dear Mr. O'Neill:

In accordance with Section B.21(c), " Task Order Procedures," of the subject contact, this letter definitizes Modification No.1 to Task Order No. 8 which: (1) extends the period of performance from

" November 20,1998" to " September 30,1999" to allow the contractor to complete the reconciliation of general ledger accounts and detailed capitalized property inventory listings (All work for the extended period shall be performed in u:cordance with the attached Statement of Work.); and (2) increases the fixed price amount of the task order by $296,844 from $33,790 to $330,634. The effective date of this modification is January 12,1998. Accordingly, the task order is hereby revised as follows:

The second paragraph of the definitization letter of the basic task order is deleted in its entirety and the following is substituted in lieu thereof:

"The period of performance for Task Order No. 8 shall be from October 1,1998 through October 15,1999 at the firm-fixed-price amount of $330,634."

Accounting data for Modification No.1 to Task Order No. 8 is as follows:

j B & R N o.:

97N-15-532-105

/

FI N N o.:

L1965

/

Appropriation No.:

31X0200.97N BOC No.:

252A OBLIGATED AMOUNT: $296,844 J3 The issuance of this modification does not amend any other terms and conditions of the subject task order.

9901280126 990121 PDR CONTR NRC-09-97-205 PDR

. _ _.. - _.. - -. ~.... _ _. _..

h l

3 e

- Contract No. NRC-09-97-205

~

Mod 1 to Task Order No. 8 l

. A summary of obligations for the subject taskorder, from award date through the date of this action, is given below:

Total FY98 Obligation Amount: $ 33,790 Total FY99 Obligation Amount: $293,844 l

Cumulative Total of NRC Obligationsi $330,634.

This modification obligates FY99 funds in the amount of $296,844.

l Please indicate your acceptance of this task order by having an official, authorized to bilid your organization, execute three (3) copies of this document in the space provided and return two (2) -

copies to the U.S. Nuclear Regulatory Commission, ATTN: Ms. Anita Hughes, Division of Contracts and Property Management, T-712, ADM/DCPM/CMB2, Washington, D.C. 20555. You should retain i

the third copy for your records.

Sincerely, e

i s

lois J. Wiggins, Co ing Officer Contract Managemen Branch No. 2 Division of Contracts and Property Management Office of Administration i

Enclosure:

As stated

'TED-

'ACOE P t[

"Th /

e we/> n

- Dat6

STATEMENT OF WORK Modification No.1 to Task Order No. 08 Under Job Code L1965 Contract No'/ NRC-09-97-205 u

Title:

Account Reconciliation

))

Technical Monitor:

Robert E. Rakowski, OCFO - (301) 415-7340 Designated A!ternates:

Anthony C. Rossi, OCFO - (301) 415-7379 Barbara K. Gusack, OCFO - (301) 415-6054 Backarounj;f Since the passage of the Chief Financial Officers Act of 1990, the Nuclear Regulatory Commission (NRC) must comply 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 9ccounting 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 obta.a accounting support to reconcile various general ledger accounts and to provide complete detailed capitalized property inventory listings.

Work Reauirements 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 anaiyze payment documents (invoices) for 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 equipment inventory system.

2 c)

Develop a depreciation s,chedule based on invoices and the useful life of the equipment to refle'ct the amounts to be charged on a monthly basis.

P 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 generalledger ADP capitalized software account balances and the associated monthly amortization expense.

3.

Leasehold improvements Inventory Determine the value of leasehold improvements by direct review and analysis af payment documents and maintain detailed accounting data sufficient for support of the generai ledger capitalized leasehold improvement account balances and the associated monthly amortization expense.

4.

Payroll Review payroll data maintained in the payroll system for each pay - eriod (commencing the first pay period after November 20,1998) and reconcile with the payroll data recorded in the generalledger by account and object class.

5.

Cash Reconciliation Review Review the cash reconciliation report each month (commencing December 1, 1998) to ensure that balances are accurate and all payments are recorded.

l 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.

(!IN 3-c)

Reviews should be.thorouhh enough to en:, ore that year-end compilation work papers can be acco~mplished 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.

Pe,iod of Performance Modification No.1 shall commence on January 12,1999, and expire on September 30, 1999.

Deliverables 1.

Equipment Inventory Within 20 working days after the close of the monthly accounting period, provide the following:

a)

A list of discrepancies identified between the DCPM system and the detailed accounting property system; b)

A list of adjustments for the general ledger and the DCPM system; c)

A summary of the effect on the general ledger account balances (i.e.,

beginning 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:

i e)

A deia!!ad financial equipment inventory, including the current period depreciation schedule.

2.

ADP Software inventory Within 20 working days after the close of the monthly accounting period, provide

?

1 4

the following:

a)

A list of adjustment to"thigeneral ledger ADP property accounts as necessary; b)

A summary of 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 ADP software inventory, including the current period amortization schedule.

3.

Leasehold inventory Within 20 working days after the close of the morithly accounting period, provide the following:

a)

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

A summary of 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 general ledger; I

b)

A summary of the effect on general ledger account balances;

\\

l

. c)

An analysis of chronic proble,ms 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, prov.ide the following:

A summary of any problems encountered and suggested corrective action.

7.

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

a)

A list of adjustments necessary for the generai ledger; 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.

Meetinos The contractor shall be required to attend approximately eight (8) status meetings at the 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.

I

. NRC Furnished Materials /Eauinment

\\t-The NRC shall-provide the contractdr with the following items for support of this task order:

Computer reports of generalledger 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,

{

telephone, copy and facsimile machine.

Proaress Payments Payments under this task order shall be made in accordance with contract clause B.24 entitled, " Progress Payments - Commercial items."

j i

xm an xx

,,.\\

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

Total FY98 Obligation Amount: $119,660 Total FY99 Obligation Amount: $138,980 Cumulative Total of NRC Obligations: $258,640 This modification obligates FY99 funds in the amount of $138,980.

Please indicate your acceptance of this task order by having an official, authorized to bind your organization, execute three (3) copics of this document in the space provided and return two (2) copies to the U.S. Nuclear Regulatory Ccmmission, ATTN: Ms. Anita Hughes, Division of Contracts and Property Management, T-712, ADM/C CPM /CMB2, Washington, D.C. 20555. You should retain the third copy for your records.

Sincerely, Bois J. Wiggins, Qo eting Officer Contract Manage erit Branch No. 2 Division of Contracts and Property Management Office of Administration

Enclosure:

As stated ACC PT D:

Narne" l'

Ohd/e/

Title

[ S/

va t

Y$

JAN 2 01999 1

'NE YOQ qq l

l l

1

'E E"b d$ Ed 1

e STATEMENT OF WORK Modification No.1 to Task Order No. 07 Under Job Code L1965 Contract NoeNRC-09-97-205

Title:

Financial Statement Compilation and Audit Interface Technical Monitor:

Robert F Rakowski, OCFO - (301) 415-7340 Designated Altemates:

Anthony C. Rossi, OCFO - (301) 415-7379 Barbara K. Gusack, OCFO - (301) 415-6054 Backaround Since the passage of the Chief Financial Officers Act of 1990, the Nuclear Regulatory Commission (NRC) must comply 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 suppon tasks.

Objective The objective of this task order is to obtain financial management assistance in preparing NRC's FY 1998 unaudited financial statemen'.s. These statements are to be prepared in accordance with OMB Bulletin 97-01, Form and Content of Agency Financial Statements; Statements of Federal Financial Accounting Standards; NRC Management Directive 4.1, Accounting Policy and Practices; and other appropriate guidance and standards.

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

l 1.

NRC's FY 1998 Annual Unaudited Financial Statements a)

Prepare draft financial statements and accompanying footnotes from the appropriate general ledger account balances as recorded in the agency's I

accounting system, in accordance with OMB Bulletin 97-01, Form and Content of Agency Financial Statements. The following draft financial statements shall be prepared: Balance Sheet, Statement of Net Cost, Statement of Changes in Net Position, Statement of Financing, and Statement of Budgetary Resources.

b)

Assemble, prepare, and compile records and data to support the dollar amounts, classifications, and footnotes reflected in the draft financial statements. This supporting documentation should be properly and easily cross-referenced to data provided in the draft financial statements. In addition, the supporting documentation shall be stored at an on-site repository designated by the NRC for review by the NRC Project Officer or designated alternates.

\\

- 3.

Make necessary audit adjustments ththe January 22,1999 financial statement, including. suggested ledger postings, and prepare FINAL financial statement 4.

Provide comments on draft inspector General February 3,1999 audit report 5.

Comment and recommend changes, if any, February 9,1999 resulting from review of the supplemental information in the accountability report.

Meetinas The contractor shall attend approximately eight (8) status meetings at NRC's 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 Fumished Materials /Eauioment The NRC shall provide the contractor with the following items for use under this task order:

Computer reports of generalledger account balances, audit reports, and other transaction data and documents relevant to the tasks.

Personal computers, calculators, telephones, copy and facsimile m9 chines will be provided to certain on-site contractor staff for support of this task order.

Proaress Payments Payments under this task order shall be made in accordance with contract clause B.24, " Progress Payments - Commercial items."

I 1

_ _ _ _ _