Spreadsheet: 137180d1326990173-if-if-if-and-if-book1
Sheet: Other Operating (2)

Projection Methodology (PM) Timeframes
PM A-MFR month and preceeding 2 months; Apply to remaining months in year following MFR month
PM B-3rd, 4th, and 5th month preceeding MFR month; Apply to remaining months in year including MFR month and 1st and 2nd month preceeding MFR month
[NAME] dollar amount of contract; Update quarterly based on feedback by Contract Manager
PM D-Dollar amount of pre-encumbrances, encumbrances, and expense associated with all current fiscal year purchase requisitions
Notes: (1) If expense exists and projection methodology yields less than expense, projection should equal expense;
(2) If EO is associated with both a contract and purchase requisition (PR), projection is based on PR as it is more specific in obligation amount
(3) investigation stipend is treated as employee salary (PMA)
DEPTID | PROGRAM_CODE | LBB_ACCT | REQ_ID | CNTRCT_ID | Direct Expense | 07 | 08 | 09 | 10 | 11 | 12 | Enc/Pre-Enc | Grand Total | Req. Expense | Req. Projection | Contract Expense | Con Exp Projection | Direct Expense | Dir Exp Projection | [NAME] Amt | Calculated Projection
020 | 11000 | L2009 | A000038939 |  | DE |  | -1.989519660128281e-13 | 0 | 0 | 0 | 0 | 0 | -1.989519660128281e-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000036646 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037329 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037356 |  |  |  | 0 | 0 | 0 | 0 | 0 | 72.95 | 72.95 | 72.95 | 72.95 | 0 | 0 | 0 | 0 | 0 | 72.95
020 | 11000 | L2009 | A000037642 |  |  |  | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 4
020 | 11000 | L2009 | A000037649 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037672 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037689 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037729 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037826 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037827 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000037860 |  |  |  | 0 | 0 | 0 | 0 | 0 | 350 | 350 | 350 | 350 | 0 | 0 | 0 | 0 | 0 | 350
020 | 11000 | L2009 | A000038031 |  |  |  | 0 | 0 | 0 | 0 | 0 | 19.75 | 19.75 | 19.75 | 19.75 | 0 | 0 | 0 | 0 | 0 | 19.75
020 | 11000 | L2009 | A000038131 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000038409 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000038558 |  |  |  | 0 | 0 | 0 | 0 | 0 | 174.42 | 174.42 | 174.42 | 174.42 | 0 | 0 | 0 | 0 | 0 | 174.42
020 | 11000 | L2009 | A000038632 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000038667 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000038744 |  |  |  | 0 | 0 | 0 | 0 | 0 | 95.48 | 95.48 | 95.48 | 95.48 | 0 | 0 | 0 | 0 | 0 | 95.48
020 | 11000 | L2009 | A000038747 |  |  |  | 0 | 0 | 0 | 0 | 0 | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 30
020 | 11000 | L2009 | A000038791 |  |  |  | 0 | 0 | 0 | 0 | 0 | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 30
020 | 11000 | L2009 | A000038885 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000039141 |  |  |  | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 5000
020 | 11000 | L2009 | A000039306 | 530-1-A000039306 |  | 1771 | 0 | 0 | 0 | 0 | 0 | 0 | 1771 | 0 | 0 | 0 | 0 | 0 | 0 | 12731 | 12731
020 | 11000 | L2009 | A000039306 |  |  |  | 0 | 0 | 0 | 0 | 0 | 3008 | 3008 | 3008 | 3008 | 0 | 0 | 0 | 0 | 0 | 3008
020 | 11000 | L2009 | A000039429 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000039615 |  |  |  | 0 | 0 | 0 | 0 | 0 | 1.88 | 1.88 | 1.88 | 1.88 | 0 | 0 | 0 | 0 | 0 | 1.88
020 | 11000 | L2009 | A000039732 | 530-1-A000039306 |  |  | 0 | 217 | 434 | 0 | 880 | 0 | 1531 | 880 | 880 | 0 | 0 | 0 | 0 | 12731 | 12731 | Should be 880.00
020 | 11000 | L2009 | A000039732 |  |  |  | 0 | 0 | 0 | 0 | 0 | 8843 | 8843 | 8843 | 8843 | 0 | 0 | 0 | 0 | 0 | 8843
020 | 11000 | L2009 | A000039767 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | [NAME] |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000039925 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000040206 |  |  | 11.6 | 0 | 0 | 0 | 0 | 0 | 0 | 11.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000040235 |  |  |  | 0 | 0 | 0 | 0 | 0 | 49.44 | 49.44 | 49.44 | 49.44 | 0 | 0 | 0 | 0 | 0 | 49.44
020 | 11000 | L2009 | A000040393 |  |  | 292.8 | 0 | 0 | 0 | 0 | 0 | 0 | 292.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000040653 |  |  |  | 80 | 0 | 0 | 0 | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A000040654 |  |  | 35 | 0 | 0 | 0 | 0 | 0 | 5 | 40 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 5
020 | 11000 | L2009 | A000040663 | 530-0-35217 |  |  | 0 | 0 | 0 | 0 | 79.5 | 0 | 79.5 | 79.5 | 79.5 | 0 | 0 | 0 | 0 | 5567.1 | 5567.1
020 | 11000 | L2009 | A000040663 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A00036552A |  |  |  | 0 | 0 | 0 | 0 | 0 | 111.3 | 111.3 | 111.3 | 111.3 | 0 | 0 | 0 | 0 | 0 | 111.3
020 | 11000 | L2009 | A110075148 |  |  |  | 0 | 0 | 0 | 12.35 | 0 | 0 | 12.35 | 12.35 | 12.35 | 0 | 0 | 0 | 0 | 0 | 12.35
020 | 11000 | L2009 | A110075341 |  |  |  | 0 | 0 | 0 | 0 | 0 | 160 | 160 | 160 | 160 | 0 | 0 | 0 | 0 | 0 | 160
020 | 11000 | L2009 | A110075365 |  |  |  | 0 | 0 | 0 | 11.6 | 0 | 0 | 11.6 | 11.6 | 11.6 | 0 | 0 | 0 | 0 | 0 | 11.6
020 | 11000 | L2009 | A110075382 |  |  |  | 0 | 0 | 0 | 0 | 0 | 165 | 165 | 165 | 165 | 0 | 0 | 0 | 0 | 0 | 165
020 | 11000 | L2009 | A110075603 |  |  |  | 0 | 0 | 0 | 15.04 | 0 | 0 | 15.04 | 15.04 | 15.04 | 0 | 0 | 0 | 0 | 0 | 15.04
020 | 11000 | L2009 | A110075706 |  |  |  | 0 | 0 | 0 | 0 | 0 | 125 | 125 | 125 | 125 | 0 | 0 | 0 | 0 | 0 | 125
020 | 11000 | L2009 | A110075791 |  |  |  | 0 | 0 | 0 | 12.35 | 0 | 0 | 12.35 | 12.35 | 12.35 | 0 | 0 | 0 | 0 | 0 | 12.35
020 | 11000 | L2009 | A110075842 |  |  |  | 0 | 0 | 70 | 0 | 0 | 0 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | A110075847 |  |  |  | 0 | 0 | 0 | 12.35 | 0 | 0 | 12.35 | 12.35 | 12.35 | 0 | 0 | 0 | 0 | 0 | 12.35
020 | 11000 | L2009 | A110076076 |  |  |  | 0 | 0 | 0 | 0 | 12.35 | 0 | 12.35 | 12.35 | 12.35 | 0 | 0 | 0 | 0 | 0 | 12.35
020 | 11000 | L2009 | A110076202 |  |  |  | 0 | 0 | 0 | 0 | 15.04 | 0 | 15.04 | 15.04 | 15.04 | 0 | 0 | 0 | 0 | 0 | 15.04
020 | 11000 | L2009 | A110076230 | 53000-2-A110076230 |  |  | 0 | 0 | 0 | 0 | 240 | 0 | 240 | 240 | 240 | 0 | 0 | 0 | 0 | 2260 | 2260
020 | 11000 | L2009 | A110076230 |  |  |  | 0 | 0 | 0 | 0 | 0 | 2260 | 2260 | 2260 | 2260 | 0 | 0 | 0 | 0 | 0 | 2260
020 | 11000 | L2009 | A110076473 |  |  |  | 0 | 0 | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 5000
020 | 11000 | L2009 | A120076885 |  |  |  | 0 | 0 | 0 | 0 | 0 | 40 | 40 | 40 | 40 | 0 | 0 | 0 | 0 | 0 | 40
020 | 11000 | L2009 | Z000035712 |  |  | 43.75 | 43.75 | 0 | 0 | 0 | 0 | 43.75 | 131.25 | 43.75 | 43.75 | 0 | 0 | 0 | 0 | 0 | 43.75
020 | 11000 | L2009 | Z000035991 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | Z000039356 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020 | 11000 | L2009 | Z110075090 |  |  |  | 0 | 43.75 | 43.75 | 43.75 | 43.75 | 350 | 525 | 437.5 | 437.5 | 0 | 0 | 0 | 0 | 0 | 437.5
020 | 11000 | L2009 |  | 5300000866 |  | 30.3 | 0 | 0 | 0 | 0 | 0 | 0 | 30.3 | 0 | 0 | 0 | 0 | 0 | 0 | 33643.1 | 33643.1
020 | 11000 | L2009 |  | 5300000878 |  |  | 0 | 0 | 0 | 19.28 | 0 | 0 | 19.28 | 0 | 0 | 19.28 | 0 | 0 | 0 | 39217.17 | 39236.45
020 | 11000 | L2009 |  | 53000-E11-00031 |  |  | 425.5 | 174.44 | 0 | 12.39 | 0 | 0 | 612.33 | 0 | 0 | 12.39 | 2199.78 | 0 | 0 | No Max | 2199.78
020 | 11000 | L2009 |  |  | DE | 272.5 | 293.12 | 0 | 154 | 299.25 | 141.48 | 187.1 | 1347.45 | 0 | 0 | 0 | 0 | 627.83 | 2511.32 | 0 | 2511.32