# Contract Closeout Desk Audit Template

Shared by:
Categories
-
Stats
views:
70
posted:
7/9/2008
language:
English
pages:
4
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