Okaloosa County BOCC — August 4, 2015 — FY 13 Cost Allocation and Certification

CERTIFICATION OF FY 13 COST ALLOCATION PLAN This is to certify that | have reviewed the cost allocation plan submitted herewith and to the best of my knowledge and belief: (1) All costs included in this proposal of August 4, 2015 to establish cost allocations or billings for the period of October 1, 2012 through September 30, 2013 are allowable in accordance with the requirements of CFR Part 225, Cost Principles for State, Local, and Indian Tribal Governments (OMB Circular A-87), and the Federal awards to which they apply. Unallowable costs have been adjusted for in allocating costs as indicated in the cost allocation plan. (2) All costs included in this proposal are properly allocable to Federal awards on the basis of a beneficial or causal relationship between the expenses incurred and the awards to which they are allocated in accordance with applicable requirements. Further, the same costs have not been claimed as direct costs. Similar types of costs have been accounted for consistently. | declare that the foregoing is true and correct. Government Unit: Okaloosa County Board of County Commissioners Signature: Name of Official: Nathan Boyles Title: Chairman, Okaloosa County Board of County Commissioners Date: 541011 542001 543005 545990 546620 546645 549125 549900 549904 549905 549906 549907 552005 552006 552100 552101 552200 552500 552800 552801 554001 555001 OKALOOSA COUNTY FLEET OPERATIONS ALLOCATION OF SHOP LABOR RATE OCTOBER 2012 through SEPTMBER 2013 SALARIES WAGES RELIEF OVERTIME FICA RETIREMENT LIFE & HEALTH INSURANCE WORKERS' COMP TOTAL MAINTENANCE PERSONNEL COSTS OPERATING EXPENSES CELLULAR PHONES/PAGERS POSTAGE/FREIGHT CHARGES GAS SERVICE INS-OTHER REPAIR/MAINT-FACILITIES REPAIR/MAINT-VEHICLES AUCTION EXPENSES MISCELLANEOUS CHARGES (OLD TIRES) JOB LISTING EXPENSES MOTOR VEHICLE REPORTS BACKGROUND CHECKS RANDOM DRUG CHECKS FLEET SUPPLIES FLEET PARTS AND MATERIALS CLOTHING/WEARING APPAREL PROTECTIVE APPAREL SAFETY SUPPLIES-SAFETY GLASSES TOOLS & SMALL IMPLEMENTS COMPUTER SUPPLIES COMPUTER SOFTWARE SUB/MEMBER(MITHCHELL, CUMMINS, OTHERS) TRAINING/EDUCATIONAL EXP TOTAL MAINTENANCE OPERATING EXPENSES TOTAL MAINTENANCE COSTS Amount $ 650,943.36 $ 6,000.00 $ 27,000.00 S 49,797.60 S 33,960.06 S 158,288.00 S 20,662.36 $6,204.00 $120.00 $5,400.00 $39,710.40 $6,160.00 $110,000.00 $4,000.00 $1,000.00 $60.00 $20.00 $160.00 $300.00 $20,000.00 $851,586.00 $1,600.00 $1,200.00 $1,200.00 $11,000.00 $80.00 $160.00 $2,400.00 $1,200.00 $2,010,211.78 CALCULATION OF MAINTENANCE RATES: TOTAL MAINTENANCE COSTS LESS MISCELLANEOUS REVENUES $2,010,211.78 ($220,176.37) AMOUNT TO BE RECOUPED $1,790,035.41 AMOUNT TO BE RECOUPED $1,790,035.41 Less Sublet Repairs -$110,000.00 Less Parts -$851,586.00 AMOUNT RECOUPED BY SHOP LABOR $828,449.41 Actual Shop Labor Hours Past Year Crestview Shop Hours 9,749.2 Fort Walton Beach Shop Hours 3510.7 Total Hours 13,259.9 Shop Labor Rate Amount to be Recouped divided by Actual Hours $62.48 Rounded Shop Rate $62.00