Top Buying Activities by Total Obligated Dollars

 

File Name: topbaco

Description: This report provides open prime contract totals by buying activity for a specific ORG specified by the user on the prompt screen. The primary sort is by Contract Obligation in descending order. Users can further tailor the query data by Cage, ACO, Section, IS/CMA Code, Part, or any combination of these fields.

Last page of report should reflect totals for the following cumulative column headings: Contracts, Contract Obligation, Contract Unliquidated, and Unliquidated Progress Payments.

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.

PART

Required

Picklist

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

CAGE

Optional

Text

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

ACO

Optional

Text

The code which identifies the Administrative Contracting Officer assigned to 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

Buying Activity

buyg acty cd

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

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

Contract Unliquidated Obligation.

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 Buying Activities by Total Obligated Dollars

CAGE:     ACO:     SECTION: 'All'
IS/CMA CODE:     PART: 'All'
ORG:
'JF'
SIZE OF BUSINESS: 'B'
Date: 1999-08-13
Buying Activity Contracts Contract Obligation Contract Unliquidated Unliquidated Progress Payments
Q7 47 $31,990,114.25 $370,852.48 $0.00
SC 15 $25,600,000.00 $25,500,000.00 -$1,359,000.00
BR 20 $10,480,426.00 $10,430,426.00 -$801,000.00
GB 7 $1,782,373.00 $1,735,257.92 $0.00
UB 98 $1,727,648.40 $1,597,274.78 $0.00
TY 60 $1,706,601.90 $1,499,228.33 $0.00
UD 154 $1,344,455.98 $1,198,604.48 -$18,000.00
SD 1 $1,200,000.00 $1,200,000.00 $0.00
SA 5 $1,093,470.83 $837,403.83 $0.00
QP 1 $1,000,000.00 $1,000,000.00 -$90,000.00
TZ 91 $828,677.90 $690,921.57 $0.00
BA 1 $500,000.00 $500,000.00 -$27,000.00
XJ 69 $390,287.59 $320,520.50 $0.00
EE 2 $250,000.00 $174,600.00 $0.00
SG 1 $102,000.00 $44,855.00 $0.00
TW 5 $50,000.00 $40,000.00 $0.00
W4 10 $309.00 $309.00 $0.00
EP 2 $203.76 $203.76 $0.00
Totals: 589 $80,046,568.61 $47,140,457.65 -$2,295,000.00

18 rows returned.

Elapsed time: .42 seconds.

SELECT buying_activity_cd, count(*) num_con, SUM(obligated_amount) obligated_amount, SUM(unliq_con_amount) unliq_con_amount, SUM(unliq_pp_amount) unliq_pp_amount FROM contracts WHERE assignment_cd = 'P' AND current_sts < '5' AND admin_by_cao in ('JF') AND NVL(aco_code,'X') LIKE DECODE('',NULL,'%','%') AND NVL(isp_code,'X') LIKE NVL('','%') AND NVL(prime_cage,'X') LIKE DECODE('',NULL,'%',LPAD('',6,' ')) AND NVL(size_of_business,' ') in ('B') GROUP BY buying_activity_cd ORDER BY obligated_amount DESC,buying_activity_cd ASC

 

Back to Contract Administration Menu

 

HOME | QUERY MENU | USERS GUIDE | ABOUT