Prime Contracts Management Information Report

File Name: mngerp1

Description: This report provides a statistical report of all open prime contracts and associated Obligated and Unliquidated dollars. The data is grouped first by fixed price contracts and other than fixed price and then within these categories the data is grouped by Service. In addition the report provides a stratification of contract counts by several obligated dollar ranges. Users can further tailor the query data by size of business, ACO, Buying Activity, CAGE or Part.

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

Size of Business

ty contrr cd

The company’s relative size code that was entered in the prompt.

Org

org cd

The CAO’s organization code that was entered in the prompt.

Aco

aco code

The Administrative Contracting Officer code that was entered in the prompt.

Cage

cage

The code assigned to an entity that was entered in the prompt.

Buying Activity

buyg acty cd

The Buying Activity code that was entered in the prompt.

Part

car partno

The Contract Administration Report Part code that was entered in the prompt.

Department Name

dept name

A name identifying a Service Agency.

Contracts

N/A

Total number of procurement instruments.

Subcontract

N/A

The number of subcontracts which have been delegated for administration (Assignment Code T).

Contract Obligation

obligation 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 con

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

Fixed Price Contract Data

N/A

Statistics on contracts which are fixed price (type ‘J’ or ‘K’)

Fixed Price Totals

N/A

Total of Contracts and Dollars of those Contracts which are fixed price (type ‘J’ or ‘K’).

Other Contract Data

N/A

Statistics on contract which are not fixed price.

Other Totals

N/A

Total of contracts and dollars of contracts which are not fixed price.

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.

Grand Totals

N/A

Total of individual totals combined.

 

Report Sample:

Prime Contracts Management Information Report

SIZE OF BUSINESS: 'All'
ORG:
'All'
ACO:   CAGE: 017N4  BUYING ACTIVITY:   PART:
Date: 1999-08-13
Department Name Contracts Contract Obligation Contract Unliquidated
 
Fixed Price Contract Data:
 
AIR FORCE 120 $384,310,594.16 $11,000,601.38
ARMY 41 $422,265,595.92 $3,726,060.66
DLA 286 $24,456,833.28 $7,904,012.78
DNA 22 $2,000.00 $2,000.00
MDA 3 $99,987,313.08 $14,384,060.76
NAVY 247 $561,758,758.37 $43,950,874.93
Fixed Price Totals: 719 $1,492,781,094.81 $80,967,610.51
Qty Open Contracts on Hand:

$0-$5,000: 235
$5,001-$100K: 251
$100,001-$1M: 146
$1,000,001-$10M: 51
$10,000,001 & over: 36
 
 
Other Contract Data:
 
AIR FORCE 49 $132,123,181.11 $1,913,387.79
ARMY 46 $177,928,927.43 $7,070,076.60
DLA 49 $23,687,263.78 $3,606,689.29
NAVY 85 $283,078,628.94 $12,207,606.96
Other Totals: 229 $616,818,001.26 $24,797,760.64
Qty Open Contracts on Hand:

$0-$5,000: 82
$5,001-$100K: 27
$100,001-$1M: 65
$1,000,001-$10M: 41
$10,000,001 & over: 14
 
Grand Totals: 948 $2,109,599,096.07 $105,765,371.15
Qty Open Contracts on Hand:

$0-$5,000: 317
$5,001-$100K: 278
$100,001-$1M: 211
$1,000,001-$10M: 92
$10,000,001 & over: 50
 

10 rows returned.

Elapsed time: 1.88 seconds.

SELECT decode(contract_type, 'J', 'Fixed Price', 'K', 'Fixed Price', 'Other') contract_type, 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('017N4',NULL,'%',LPAD('017N4',6,' ')) AND NVL(buying_activity_cd,'X') LIKE DECODE('',NULL,'%','%') AND car_partno like '%' ORDER BY contract_type, dept_name

 

Back to Contract Administration Menu


HOME | QUERY MENU | USERS GUIDE | ABOUT