Get documents about "Contract Closeout Desk Audit Template
Document Sample
Contract # NO1-AI-XXXXX Summary of Desk Audit
Formula used for Contract Summary
=+'2706.summary'!b3 (and then copy down)
Formula used for Actuals
=+'2706.summary'!u36 (and then copy down)
Fully Funded Contract Amount $0 Formula used for Difference
=+f10-g10 (and then copy down)
Contract Funding Actuals Difference
FY 00 $ - $ - $ -
FY 01 $ - $ - $ -
FY 02 $ - $ - $ -
FY 03 $ - $ - $ -
FY 04 $ - $ - $ -
FY 05 $ - $ - $ -
$ - $ - $ -
Summary
OFM Disbursed $0
The Contractor's Actuals were $0
Due to OA $0
OA owes Contractor $0 for Fringe Benefits
For exceeding Salary Caps, the Contractor owes OA $0
Total Due to OA $0
Labor
Contract # NO1-AI-XXXXX SALARY CAPS FISCAL YEAR FUNDING
(Contractor Name) 2000, 2001, 2002 125,000 CONTRACT
Funded Amt $0 10/1/03-9/30/04 125,900 FY 00 $ -
10/1/04-12/31/04 136,700 FY 01 $ -
1/1/05-9/30/05 141,300 FY 02 $ -
10/1/05-12/31/05 157,000 FY 03 $ -
1/1/01-4/30/01 161,200 FY 04 $ -
FY 05 $ -
Total $ -
Sample Shaded Areas exceeds Salary Cap
3. Calculations for Salary Cap/Executive Levels. Monthly Formula Used Sarlary divided by percent of effort times 12
Quarterly Formula Used Salary divided by percent of effort times 4
Salary per
Salaries as Quartly Voucher as Select "12" or "4" Labor/%worked Labor/%worked Labor/%worked Total Direct
SALARY CAP submitted: to key in below Employee A Level of Effort times a quarter Employee B Level of Effort times a quarter Employee C Level of Effort times a quarter Labor
Fiscal Year 96 Loc1 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc2 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
125000 Loc3 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc4 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Fiscal Year 97 Loc5 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc6 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
125000 Loc7 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc8 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Fiscal Year 98 Loc9 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc10 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc11 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Thru 9/30/98 125,000 Loc12 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Fiscal Year 99 Loc13 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc14 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc15 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Thru 9/30/99 125,900 Loc16 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Fiscal Year 00 Loc17 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Vou. 17 only 136,700 Loc18 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Loc19 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
V 18-20 141,300 Loc20 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
Fiscal Year 01 Loc 21 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
V 21 Only 157,000 Loc 22 MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
V 22 - 23 161,200 Loc 23 Final MM/DD/YY - MM/DD/YY $ - 0% #DIV/0! $ - 0% #DIV/0! $ - 0% #DIV/0! $ -
$ -
Sample Shaded Areas exceeds Salary Cap
Employee A Salary Cap for Fiscal Year Over Paid in Labor Over Paid In Fringe Over Paid In IDC
Loc01 $ - #DIV/0! 0 #DIV/0! 0% 0%
Sum over paid for Employee A #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Employee B Salary Cap for Fiscal Year Over Paid in Labor Over Paid In Fringe Over Paid In IDC
Loc01 $ - #DIV/0! 0 #DIV/0! 0% 0%
Sum over paid for Employee B #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Fringe Benefits
Fiscal Year Fringe Benefits FISCAL YEAR Employee A Fringe Billed Employee B Fringe Billed Employee C Fringe Billed by Quarter
Fringe Benefits MM/DD/YY - MM/DD/YY - 0% $ - 0% $ - 0% $ -
for Employees MM/DD/YY - MM/DD/YY - 0% $ - 0% $ - 0% $ -
MM/DD/YY - MM/DD/YY - 0% $ - 0% $ - 0% $ -
MM/DD/YY - MM/DD/YY - 0% $ - 0% $ - 0% $ -
MM/DD/YY - MM/DD/YY - 0% $ - 0% $ - 0% $ -
MM/DD/YY - MM/DD/YY - 0% $ - 0% $ - 0% $ -
Totals - - - $ -
Page 3
Fiscal Year Funding CONTRACT
FY 00 $ -
FY 01 $ -
FY 02 $ -
FY 03 $ -
FY 04 $ -
FY 05 $ -
Total $ - Provisional
Direct Fringe Materials Indirect
2706s as submitted Inv. # Labor Benefits Supplies Travel ODC Costs Total Cumulative
0% Loc1 mm/dd/yy-mm/dd/yy - - - - - - -
Loc2 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc3 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc4 mm/dd/yy-mm/dd/yy - - - - - - - -
0% Loc5 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc6 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc7 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc8 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc9 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc10 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc11 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc12 mm/dd/yy-mm/dd/yy - - - - - - - -
0% Loc13 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc14 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc15 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc16 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc17 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc18 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc19 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc20 mm/dd/yy-mm/dd/yy - - - - - - - -
0% Loc 21 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc 22 mm/dd/yy-mm/dd/yy - - - - - - - -
Loc 23 mm/dd/yy-mm/dd/yy - - - - - - - -
TOTAL Total Expended - - - - - - - - - - - - -
2. Total Indirect Csts.
Using Final Rates Direct Fringe Materials Indirect BASE FOR Final IDC Final IDC Rate
Inv. # Period of Perf. Labor Benefits Supplies Travel ODC Costs Total IDC Actual
1-4 mm/dd/yy-mm/dd/yy - - - - - - - - - - - - - - - 0.00% -
5-8 mm/dd/yy-mm/dd/yy - - - - - - - - - - - - - - - 0.00% -
9-12 mm/dd/yy-mm/dd/yy - - - - - - - - - - - - - - - 0.00% -
13-16 mm/dd/yy-mm/dd/yy - - - - - - - - - - - - - - - 0.00% -
17-20 mm/dd/yy-mm/dd/yy - - - - - - - - - - - - - - - 0.00% -
21-23 mm/dd/yy-mm/dd/yy - - - - - - - - - - - - - - - 0.00% -
Total - - - - - - - - - - - - - - - -
Related docs
Other docs by NIHhealth
NIH CDC and FDA SBIR STTR Program Descriptions and Research Topics - Checkpoints
Views: 136 | Downloads: 2
CRISP Abstract for PECASE Award - Ulrike A. Heberlein, Ph.D. (San Francisco General Hospital)
Views: 0 | Downloads: 0
Procedure for Reviewing the HHS-520 Request for Approval of Outside Activity
Views: 42 | Downloads: 1
CRISP Abstract for PECASE Award -Mark Von Zastrow, M.D., Ph.D. (University of California, San Francisco)
Views: 0 | Downloads: 0
CRISP Abstract for PECASE Award - Janean Holden, Ph.D. (University of Illinois, Chicago)
Views: 31 | Downloads: 0
