Top Contractors by Total Obligated Dollars

 

File Name: toptoto

Description: This report provides open prime contract totals by Obligated dollars. The data shown is the Org, ACO and Cage code, contractor name, number of contracts, dollar obligation, unliquidated and unliquidated Progress Payments. The prime sort is by contract obligation in descending order. Users can further tailor the query by selecting ACO, Section, Buying Activity (2 digit).

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

ORG

Required

Picklist

The CAO’s organization code.

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

SECTION

Required

Picklist

Contract Administration Report Section Number is a code assigned to a procurement instrument that depicts the status of a contract during its lifecycle.

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to the contract.

BUYING ACTIVITY (2 Pos)

Optional

Text

The 2 position Buying Activity code of the office issuing the contract.

IS/CMA CODE

Optional

Text

A locally assigned code identifying a specific individual to whom the contract is assigned for surveillance.

 

Report Fields:

Field Name

MOCAS Name

Description

ORG

org cd

The CAO’s organization code.

ACO

aco code

The code which identifies the Administrative Contracting Officer assigned to the contract.

CAGE

cage

Commercial and Government Entity. A code assigned by the Government to an entity conducting business with or within the Government.

Contractor

contr/payee name

The official name of the entity supplying goods and services to the Government.

Contracts

n/a

Total number of procurement instruments.

Contract Obligation

obligated amount

The dollar amount stated at a contract or call/order level, by appropriation, that a Government agency will eventually disburse.

Contract Unliquidated

unlq dv cont

The total remaining dollar obligation on a contract, call/order after disbursements have been made.

Unliquidated Progress Payments

unlq dv pp

The total unrecouped progress payments made to the contractor or subcontractor.

Totals

n/a

Total count of contracts and total dollar amount of Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments for the report.

 

Report Sample:

Top Contractors by Total Obligated Dollars

ORG:
'SE'
SIZE OF BUSINESS: 'B'
ACO:     SECTION: 'All'
BUYING ACTIVITY:     IS/CMA CODE:
Date: 1999-08-13
ORG ACO CAGE Contractor Contracts Contract Obligation Contract Unliquidated Unliquidated Progress Payments
SE SAE 64022 ENGINEERING AND PROFESSIONAL 85 $74,515,035.67 $4,883,000.30 -$5,915,309.00
SE SAH 33119 BERTOT INDUSTRIES INC 63 $4,802,083.58 $4,332,715.30 -$675,500.00
SE SAD 01852 THOMAS ELECTRONICS INC 61 $3,071,316.00 $1,940,148.44 $0.00
SE SAE 93953 MELSTROM MFG CORP 88 $2,536,339.89 $2,441,573.39 $0.00
SE SAJ 96487 VALCOR ENGINEERING CORP 23 $737,078.85 $430,022.10 $0.00
SE SAJ 07484 ACCURATE BUSHING CO INC 69 $418,923.04 $233,579.79 $0.00
SE SAE 7B953 MCKEOWN ROBERT CO INC 41 $15,991.68 $1,803.76 $0.00
SE SAD 11203 SHOW ME THE MONEY CORP 1 $0.00 $0.00 $0.00
SE SAD 38209 COUNTRYWIDE TESTERS 1 $0.00 $0.00 $0.00
SE SAD 55427 TEST FOR EDI 1 $0.00 $0.00 $0.00
Totals: 433 $86,096,768.71 $14,262,843.08 -$6,590,809.00
10 rows returned.

Elapsed time: .64 seconds.

SELECT c1,c2,c3,c4,c5,c6,c7,c8 FROM (SELECT c1,c2,c3,c4,c5,c6,c7,c8 FROM (SELECT COUNT(piin) c5, SUM(obligated_amount) c6, SUM(unliq_con_amount) c7, SUM(unliq_pp_amount) c8, prime_cage c9 FROM olap_owner.contracts WHERE current_sts < '5' AND admin_by_cao in ('SE') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND NVL(isp_code,'X') LIKE NVL('','%') AND NVL(size_of_business,' ') in ('B') AND assignment_cd = 'P' GROUP BY prime_cage ) D3, (SELECT DISTINCT prime_cage c1, admin_by_cao c2, aco_code c3, prime_name c4 FROM olap_owner.contracts WHERE current_sts < '5' AND admin_by_cao in ('SE') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(isp_code,'X') LIKE NVL('','%') AND NVL(size_of_business,' ') in ('B') AND assignment_cd = 'P') D2 WHERE (c1 = c9) ) D1 ORDER BY c6 DESC,c2 ASC

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT