Prime Contracts Management Information Summary Report

File Name: mngerp2

Description: This report provides a statistical summary report of all open prime contracts and the obligated unliquidated dollars associated with these contracts. The data is grouped by Service. Users can further tailor the query data by size of business, ACO, Buying Activity, CAGE or Part.

The report also stratifies the contract counts by obligated dollar ranges.

Designed by DCMC.

Prompt Fields:

Field Name

Type

Value

Description

SIZE OF BUSINESS

Required

Picklist

A code that distinguishes a company’s relative size.

ORG

Required

Picklist

The CAO’s organization code.

ACO

Optional

Text

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

CAGE

Optional

Text

A unique code assigned by the Government to an entity conducting business with or within the Government.

BUYING ACTIVITY (2 Pos)

Optional

Text

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

PART A OR B

Optional

Text

Contract Administration Report Part Codes assigned to the PIIN-SPIIN displayed.

 

Report Fields:

Field Name

MOCAS Name

Description

Department Name

dept name

A name identifying a Service Agency.

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.

Grand Totals

N/A

Total of individual totals combined.

Selected Criteria

N/A

The query criteria as determined by the data entered into the prompt fields by the user.

Qty Open Contracts on Hand $0-$5,000

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is between $0-$5,000.

Qty Open Contracts on Hand $5,001-$100K

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is between $5,001-$100K

Qty Open Contracts on Hand $100,001-$1M

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is between $100,001-$1M

Qty Open Contracts on Hand $1,000,000-$10M

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is between $1,000,000-$10M

Qty Open Contracts on Hand $10,000,001 & over

N/A

The number of open contracts (Section < 5) where the Obligated Contract Amount is $10,000,001 and over.

 

Report Sample:

Prime Contracts Management Information Summary Report

SIZE OF BUSINESS: 'All'
ORG:
'All'
ACO:   CAGE:   BUYING ACTIVITY:   PART:
Date: 1999-08-13
Department Name Contracts Contract Obligation Contract Unliquidated
AIR FORCE 622 $5,010,743,798.95 $682,076,861.20
ARMY 249 $1,083,721,819.52 $38,903,640.07
DLA 1,523 $101,401,294.44 $49,217,899.78
DNA 24 $2,000.00 $2,000.00
MARINE CORPS 1 $0.00 $0.00
MDA 5 $103,099,388.08 $14,384,602.26
NAVY 811 $10,136,032,449.70 $1,337,275,212.75
SDI 1 $4,147,344.00 $9,350.43
Grand Totals: 3,236 $16,439,148,094.69 $2,121,869,566.49
Qty Open Contracts on Hand:

$0-$5,000: 1,457
$5,001-$100K: 821
$100,001-$1M: 564
$1,000,001-$10M: 241
$10,000,001 & over: 153
 

8 rows returned.

Elapsed time: 4.48 seconds.

SELECT dept_name, obligated_amount, unliq_con_amount FROM contracts WHERE NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND assignment_cd = 'P' AND current_sts < '5' AND prime_cage LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND car_partno like '%' ORDER BY dept_name

 

Back to Contract Administration Menu


HOME | QUERY MENU | USERS GUIDE | ABOUT