The file's text, extracted by GovTribe without its formatting.
FA3002-06-R-0004
Amendment 13
APPENDIX 5B
5B.1. WORKLOAD DATA
5.B.1.1. EXAMPLE OF WORKLOAD: 1-30 Nov 2005
| INSTL/FAC # |
| Description |
| Journal # |
| PNQS/Grant |
| Delete Grant for Environmental Monitoring at Riverside Hts |
| 2006001239 |
| PNQS/Grant |
| Delete Grant for Environmental Monitoring at Riverside Hts |
| 2006001274 |
| PNQS/Grant |
| Delete Grant for Environmental Monitoring at Riverside Hts |
| 2006001259 |
| PNQS/1488 |
| Process Work Order for $188,829 |
| 2006001252 |
| JUBJ/814 |
| Add new Shoppette to Real Property Records |
| 2006001264/Multi |
| JUBJ/814 |
| Process Work Order for $4124 |
| 2006001296 |
| JUBJ/2033 |
| Update Parking Records due to 814 Construction |
| 2006001301 |
| JUBJ/2036 |
| Update Sidewalk Records due to 814 Construction |
| 2006001305 |
| JUBJ/2044 |
| Update Curbs/Gutters Records due to 814 Construction |
| 2006001310 |
| JUBJ/2039 |
| Update Storm Drainage Records due to 814 Construction |
| 2006001314 |
| JUBJ/2025 |
| Update San Sewer Records due to 814 Construction |
| 2006001318 |
| JUBJ/2042 |
| Update Water Non-Potable Records due to 814 Construction |
| 2006001322 |
| JUBJ/2020 |
| Update Exterior Lighting Records due to 814 Construction |
| 2006001325 |
| JUBJ/2029 |
| Update Fire Hydrant Records due to 814 Construction |
| 2006001328 |
| JUBJ/2051 |
| Update Interior Fence Records due to 814 Construction |
| 2006001333 |
| JUBJ/2026 |
| Update Water Main Records due to 814 Construction |
| 2006001339 |
| JUBJ/2024 |
| Update Gas Main Records due to 814 Construction |
| 2006001344 |
| PNQS/693 |
| Process Work Order for $19,407 |
| 2006001351 |
| PNQS/1285 |
| Update Inspection Date |
| 2006001351 |
| PNQS/1153/1156 |
| Process Work Order for $22,800 |
| 2006001354 |
| JUBJ/1516 |
| Process Work Order for $12,700 |
| 2006001359 |
| PNQS/Multi |
| Process Work Order for $1,240,620 for 9 facilities |
| 2006001363 |
| PNQS/Multi |
| Process Work Order for $3,414,094 for 12 facilities |
| 2006001366 |
| PNQS/Multi |
| Process Work Order for $1,440,003, for 12 facilities |
| 2006001403 |
| JUBJ/1415 |
| Pick Up Future Facility (Heating Plant) |
| 2006010489 |
| PNQS/119 |
| Process Work Order for $39,944 |
| 2006005877 |
| JUBJ/900 |
| Process Work Order for $6,155 |
| 2006005882 |
| PNQS/1 |
| Update Inspection Date |
| 2006010489 |
| PNQS/1 |
| Update X Line Item from inspection |
| 2006010489 |
PNQS/1171/1172
1174/1175
| Update Inspection Date |
| Multi |
PNQS/1171/1172/
1174/1175
| Change Category Code from “1” to “2” |
| Multi |
| PNQS/1110 |
| Update Inspection Date |
| 2006005911 |
| PNQS/1413 |
| Update Inspection Date |
| 2006005916 |
| JUBJ/2008 |
| Update Inspection Date |
| 2006005921 |
| PNQS/1457 |
| Update Inspection Date |
| 2006005928 |
| JUBJ/205/811/900 |
| Process Work Order for $1317 |
| Multi |
| JUBJ/856 |
| Process Work Order for $107,763 |
| 2006005936 |
| PNQS/1067 |
| Process Work Order for $3,232 |
| 2006005940 |
PNQS/842/1207/
1405/1470
| Process Work Order for $1878 |
| 2006005944/945 |
943/946
| PNQS/942 |
| Process Work Order for $9,513 |
| 2006005951 |
| PNQS/80 |
| Process Work Order for $3500 |
| 2006005955 |
| PNQS/804 |
| Process Work Order for $35,803 |
| 2006005962 |
| PNQS/1403 |
| Process Work Order for $98,895 |
| 2006005967 |
| PNQS/1402 |
| Process Work Order for $93,946 |
| 2006005971 |
| PNQS/1401 |
| Process Work Order for $499,900 |
| 2006005975 |
| JUBJ/856 |
| Update X Line Item (HVAC) |
| 2006005978 |
5B.1.2. REAL ESTATE DISPOSAL PLAN:
Example of Workload: JUBJ=Gunter-Annex; PNQS=Maxwell AFB
INSTL-
CODE
Amount Disp
FY
Disposal
Date AETC/base real estate remarks
| JUBJ |
| Gunter-Annex |
| 401 |
| 5,826 |
| 03 |
Moved to FY06
| JUBJ |
| Gunter-Annex |
| 402 |
| 5,568 |
| 03 |
| 15 May 03 |
| Demolished |
| JUBJ |
| Gunter-Annex |
| 810 |
| 5,013 |
| 03 |
| 5 Dec 02 |
| Demolished |
| PNQS |
| Maxwell AFB |
| 833 |
| 10,605 |
| 03 |
| 24 Oct 02 |
| Demolished |
| PNQS |
| Maxwell AFB |
| 834 |
| 15,285 |
| 03 |
| 22 May 03 |
| Added & Demolished |
| PNQS |
| Maxwell AFB |
| 837 |
| 7,039 |
| 03 |
| 24 Oct 02 |
| Demolished |
| PNQS |
| Maxwell AFB |
| 840 |
| 1,080 |
| 03 |
| 24 Oct 02 |
| Demolished |
| PNQS |
| Maxwell AFB |
| 1113 |
| 2,116 |
| 03 |
| 15 May 03 |
| Added & Demolished |
| PNQS |
| Maxwell |
| 1323 |
| 756 |
| 04 |
| 1 Jul 2004 |
| PNQS |
| Maxwell AFB |
| 1324 |
| 110 |
| 03 |
| 9 Jan 03 |
| Added & Demolished |
| PNQS |
| Maxwell AFB |
| 1325 |
| 2,111 |
| 03 |
| 15 May 03 |
| Added & Demolished |
| PNQS |
| Maxwell AFB |
| 1326 |
| 3,350 |
| 03 |
| 15 May 03 |
| Added & Demolished |
| PNQS |
| Maxwell AFB |
| 1349 |
| 2,450 |
| 03 |
| 15 May 03 |
| Added & Demolished |
| PNQS |
| Maxwell AFB |
| 1412 |
| 24,746 |
| 03 |
Moved to FY 05
| PNQS |
| Maxwell AFB |
| 1414 |
| 24,593 |
| 03 |
| 31 Mar 03 |
| PNQS |
| Maxwell AFB |
| 1415 |
| 24,593 |
| 03 |
| 31 Mar 03 |
135,524
| PNQS |
| Maxwell AFB |
| 78 |
| 38,700 |
| 04 |
| 20 Apr 04 |
| Demolished |
| PNQS |
| Maxwell AFB |
| 1413 |
| 24,593 |
| 04 |
Move to FY06
| PNQS |
| Maxwell AFB |
| 1449 |
| 24,500 |
| 04 |
| 28 Jun 05 |
| Demolished |
87,793
| PNQS |
| Maxwell AFB |
| 1412 |
| 24,746 |
| 05 |
| 04 Aug 05 |
| PNQS |
| Maxwell AFB |
| 1449 |
| 24,500 |
| 05 |
| 28 Jun 05 |
49,246
| JUBJ |
| Gunter-Annex |
| 401 |
| 5,826 |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| JUBJ |
| Gunter-Annex |
| 403 |
| 15,145 |
| 06 |
Removed from Demo List
| JUBJ |
| Gunter-Annex |
| 820 |
| 5,632 |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| JUBJ |
| Gunter-Annex |
| 835 |
| 228 |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| JUBJ |
| Gunter-Annex |
| 835, UDT |
| 30,000 Gal |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| JUBJ |
| Gunter-Annex |
| 860 |
| 12,657 |
| 06 |
| PNQS |
| Maxwell AFB |
| 514 |
| 6,184 |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| PNQS |
| Maxwell AFB |
| 515 |
| 6,184 |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| PNQS |
| Maxwell AFB |
| 519 |
| 2.325 |
| 06 |
| Jan 06 |
| Added, Demo in Progress |
| PNQS |
| Maxwell AFB |
| 1112 |
| 8,342 |
| 06 |
Move to FY07
| PNQS |
| Maxwell AFB |
| 1413 |
| 24,593 |
| 06 |
Move to FY06
| PNQS |
| Maxwell AFB |
| 1416 |
| 24,593 |
| 06 |
| PNQS |
| Maxwell AFB |
| 1428 |
| 24,973 |
| 06 |
| PNQS |
| Maxwell AFB |
| 1448 |
| 827 |
| 06 |
137,509
| JUBJ |
| Gunter-Annex |
| 868 |
| 15,334 |
| 07 |
| PNQS |
| Maxwell |
| 79 |
| 19,200 |
| 07 |
| PNQS |
| Maxwell |
| 157 |
| 43,613 |
| 07 |
| PNQS |
| Maxwell AFB |
| 1112 |
| 8.342 |
| 07 |
Move from FY06
86,489
5B.1.3. INGRANTS/OUTGRANTS: None
5B.1.4. VALIDATE REAL PROPERTY INVENTORY: Validate current 1187 facilities, 2,444,196 of square feet every five years. Also validate MFH Annex, which has 141 facilities, and 211,398 square feet.
5B.1.5. NAF WORKLOAD DATA (FOR EOY FY05)
| Description |
| Fund 51 |
| Fund 70 |
| Fund 92 |
| # of Cost Centers |
| 105 |
| 10 |
| 3 |
# of Employees
NOTE: Paid on a biweekly basis
| $ Revenues |
| $9,918,285 |
| $15,318,154 |
| $345,951 |
| $ Expenses |
| $9,212,298 |
| $12,481,127 |
| $330,060 |
| # of Cashier Reports Processed |
| 11,498 |
| 730 |
| 360 |
| $ Purchase Made |
| $5,394,189 |
| $1,627,938 |
| $176,844 |
| $ Resale Inventory on Hand (EOY Sep 05) |
| $242,222 |
| $9,808 |
| $16,728 |
Total # ARA Grants: 1
# Checks Written (Excluding Payroll): 168 # of General Ledger Account Codes as Listed in AFMAN 34-214 999 Central cashier receives an average of 36 deposits per day excluding week-ends and holidays
Total Subsidiary General Ledger Accounts balanced monthly: 284 NAF Income and Expense budgets prepared for each cost center on a quarterly basis. 118 NAF-T GLAF reconciliations due to accounts not balanced ~250 per month
Total number of cost centers reported on the NAF Income and Expense Statement and Balance Sheet monthly. 118
5B.1.6. APF WORKLOAD DATA: (FOR FY05)
5B.1.6.1. Number of utility accounts and total direct payments annual for each account: 18 individual utility bills which is a total estimate of 216 direct payments.
5B.1.6.2. Reimbursable Customers for CE Schedule of Refunds and Reimbursements: 34 5B.1.6.3. Annual Dollars amount collected for CE Schedule of Refunds and Reimbursements (By Commodity):
- Water $199,791.03
- Electric $2,533,804.22
- Gas $679,511.65
- Refuse $143,720.98
- Custodial $272,959.47
- Facility Maintenance $404,570.95
- Elevator $7,339.52
- Grease Traps $24,587.08
- Duct Cleaning $13,340.00
- Fire Equipment $1,950.00
5B.1.6.4. Monthly IWIMS rejects: 1 per month 5B.1.6.5. Total Funding Documents (e.g., Fm 9/MORDs) processed in ABSS: 20 initial documents excluding amendments.
5B.1.6.6. Number of Accounting Accounts (PEC/RCCCs/EEICs) Monitored from MicroBas/CRIS (e.g., OBL/ODL/STH): 110 5B.1.6.7. Accounting Adjustments processed with DFAS or base level Comptroller: 24 5B.1.6.8. Number of OLVIMS Reimbursable Customers: 4 Sales Codes 5B.1.6.9. Total monthly dollar amount for OLVIMS reimbursables. $5,872.49 5B.1.6.10. Number of Telephone reimbursable Customers: 13 Sales Codes
5B.1.6.11. Total monthly dollar amount for Telephone Reimbursables: $10,956
5B.1.6.10. Number of CE Work Order # manually updated (incld Obligations): 276 5B.6.11. Facility Projects funded annually (Not including Facility projects funded on BOS contract): $22,636,274 # 161 5B.1.6.12. Unfunded Requirements in support of Financial Plan (FinPlan), Budget Execution Reviews (BERs), and End of Year execution: 10 5B.1.6.13. Number of inputs supporting the Financial Plan to include all data calls (e.g., MFHs program data) from AU/FM and AETC: 25 5B.1.6.14. Support Agreements Reviewed: 38
MAXWELL-GUNTER AFB
RESOURCE MANAGEMENT
5B-3