Okaloosa County BOCC — October 5, 2013 — CAPITAL CONSTRUCTION PROJECTS - Financial Analysis- 10.01.2013 - ppt — reading text

CAPITAL CONSTRUCTION PROJECTS ANALYSIS OF FINANCIAL IMPACT DATA October 1, 2013 RENT REDUCTION SCHEDULE PREVIOUSLY PRESENTED (1) RENT REDUCTION SCHEDULE (2010 FORECAST) MOVING DEPARTMENT 2010 2011 2012 2013 2014 2015 Current DATE BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET Sq. Ft. 12/1/2010 EMERGENCY MANAGEMENT $11,939 $12,297 $12,666 $13,046 $13,437 $13,841 701 12/1/2010 EMREGENCY MEDICAL SERVICE $24,238 $24,965 $25,714 $26,486 $27,280 $28,098 1424 10/1/2011 VETERANS SERVICE $17,801 $18,335 $18,885 $19,452 $20,035 $20,636 1045 12/31/2013 INFORMATION SYSTEMS $47,579 $49,006 $50,477 $51,991 $53,551 $55,157 2399 5/31/2014 SHERIFF'S INVESTIGATIONS $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 10800 5/31/2014 SUPERVISOR OF ELECTIONS $72,316 $74,485 $76,720 $79,022 $81,392 $83,834 4429 12/31/2013 STATE ATTORNEY'S STORAGE $9,264 $9,542 $9,828 $10,123 $10,427 $10,740 N/A 9/30/2014 INSPECTION DEPARTMENT $8,699 $8,960 $9,229 $9,506 $9,791 $10,085 2215 9/30/2014 PLANNING DEPARTMENT $8,285 $8,534 $8,790 $9,053 $9,325 $9,605 inc. above 12/31/2014 BCC OFFICES $55,377 $57,038 $58,749 $60,512 $62,327 $64,197 5100 12/31/2014 COUNTY ADMINISTRATOR $21,110 $21,743 $22,396 $23,067 $23,759 $24,472 2215 7/31/2014 PROPERTY APPRIASER $220,134 $226,738 $233,540 $240,546 $247,763 $255,196 12381 7/31/2014 TAX COLLECTOR $230,020 $236,921 $244,028 $251,349 $258,890 $266,656 12937 TOTAL RENTS WITHOUT MOVES $850,762 $878,345 $904,695 $931,836 $959,791 $962,516 RENTS WITH MOVES $796,784 $822,748 $847,430 $872,853 $611,855 $0 ANNUAL SAVINGS $53,978 $55,597 $57,265 $58,983 $347,936 $962,516 * Fiscal Years 2011 - 2014 assumes a 3% annual increase due to projected CPI FIRST CHART UPDATED WITH CURRENT FIGURES (2) RENT REDUCTION SCHEDULE (2013 FORECAST) MOVING DEPARTMENT 2010 2011 2012 2013 2014 2015 Current DATE BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET Sq. Ft. 12/1/2010 EMERGENCY MANAGEMENT $11,939 $12,297 $12,666 $13,046 $13,437 $13,841 701 12/1/2010 EMREGENCY MEDICAL SERVICE $24,238 $24,965 $25,714 $26,486 $27,280 $28,098 1424 10/1/2011 VETERANS SERVICE $17,801 $18,335 $18,885 $19,452 $20,035 $20,636 1045 12/31/2013 STATE ATTORNEY'S STORAGE $9,264 $9,542 $9,828 $10,123 $10,427 $10,740 1500 12/31/2013 INFORMATION SYSTEMS $47,579 $49,006 $50,477 $51,991 $53,551 $55,157 3045 12/31/2014 SHERIFF'S INVESTIGATIONS $126,000 $126,000 $126,000 $126,000 $126,000 $126,000 10800 9/30/2015 SUPERVISOR OF ELECTIONS $72,316 $74,485 $76,720 $79,022 $81,392 $83,834 4628 9/30/2015 INSPECTION DEPARTMENT $8,699 $8,960 $9,229 $9,506 $9,791 $10,085 2253 9/30/2015 PLANNING DEPARTMENT $8,285 $8,534 $8,790 $9,053 $9,325 $9,605 inc. above 9/30/2015 BCC OFFICES $55,377 $57,038 $58,749 $60,512 $62,327 $64,197 3544 9/30/2015 COUNTY ADMINISTRATOR $21,110 $21,743 $22,396 $23,067 $23,759 $24,472 1351 9/30/2015 PROPERTY APPRIASER $220,134 $226,738 $233,540 $240,546 $247,763 $255,196 12381 9/30/2015 TAX COLLECTOR $230,020 $236,921 $244,028 $251,349 $258,890 $266,656 12937 9/30/2015 CONTRACTS & GRANTS $33,460 $34,464 $34,464 2253 TOTAL RENTS WITHOUT MOVES $850,762 $878,345 $904,695 $931,836 $959,791 $1,002,980 RENTS WITH MOVES $796,784 $822,748 $847,430 $872,853 $611,855 $0 ANNUAL SAVINGS $53,978 $55,597 $57,265 $58,983 $347,936 $1,002,980 * Fiscal Years 2011 - 2014 assumes a 3% annual increase due to projected CPI ** Some leases include utilities *** Moving Dates updated to reflect project start date changing from 09.01.2013 to 03.01.2014 REMOVING THE GREEN AREAS FROM THE CHART (3) RENT REDUCTION SCHEDULE (Moved Units & Prior Years to be Removed from Chart) MOVING DEPARTMENT 2010 2011 2012 2013 2014 2015 Current DATE BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET Sq. Ft. 12/1/2010 EMERGENCY MANAGEMENT $11,939 $12,297 $12,666 $13,046 $13,437 $13,841 701 12/1/2010 EMREGENCY MEDICAL SERVICE $24,238 $24,965 $25,714 $26,486 $27,280 $28,098 1424 10/1/2011 VETERANS SERVICE $17,801 $18,335 $18,885 $19,452 $20,035 $20,636 1045 12/31/2013 STATE ATTORNEY'S STORAGE $9,264 $9,542 $9,828 $10,123 $10,427 $10,740 1500 12/31/2013 INFORMATION SYSTEMS $47,579 $49,006 $50,477 $51,991 $53,551 $55,157 3045 12/31/2014 SHERIFF'S INVESTIGATIONS $126,000 $126,000 $126,000 $126,000 $126,000 $126,000 10800 9/30/2015 SUPERVISOR OF ELECTIONS $72,316 $74,485 $76,720 $79,022 $81,392 $83,834 4628 9/30/2015 INSPECTION DEPARTMENT $8,699 $8,960 $9,229 $9,506 $9,791 $10,085 2253 9/30/2015 PLANNING DEPARTMENT $8,285 $8,534 $8,790 $9,053 $9,325 $9,605 inc. above 9/30/2015 BCC OFFICES $55,377 $57,038 $58,749 $60,512 $62,327 $64,197 3544 9/30/2015 COUNTY ADMINISTRATOR $21,110 $21,743 $22,396 $23,067 $23,759 $24,472 1351 9/30/2015 PROPERTY APPRIASER $220,134 $226,738 $233,540 $240,546 $247,763 $255,196 12381 9/30/2015 TAX COLLECTOR $230,020 $236,921 $244,028 $251,349 $258,890 $266,656 12937 9/30/2015 CONTRACTS & GRANTS $33,460 $34,464 $34,464 2253 TOTAL RENTS WITHOUT MOVES $850,762 $878,345 $904,695 $953,612 $978,441 $1,002,980 RENTS WITH MOVES $796,784 $822,748 $847,430 $894,629 $917,688 $940,405 ANNUAL SAVINGS $53,978 $55,597 $57,265 $58,983 $60,753 $62,575 * Fiscal Years 2011 - 2014 assumes a 3% annual increase due to projected CPI ** Some leases include utilities *** Moving Dates updated to reflect project start date changing from 09.01.2013 to 03.01.2014  LOOKING FORWARD – FY ‘14 (4) RENT REDUCTION SCHEDULE (FY '14 RENT REDUCTIONS ) MOVING DEPARTMENT 2014 UTILITIES 2015 UTILITIES 2016 UTILITIES Sq. Ft. Current DATE BUDGET BUDGET BUDGET Sq. Ft. 12/31/2013 STATE ATTORNEY'S STORAGE $10,427 $2,250 $10,740 $2,475 $11,062 $2,670 1,500 12/31/2014 INFORMATION SYSTEMS $45,223 $6,425 $46,580 $6,851 $47,977 $7,004 3,045 12/31/2014 SHERIFF'S INVESTIGATIONS $126,000 $22,788 $126,000 $24,300 $126,000 $24,840 10,800 9/30/2015 SUPERVISOR OF ELECTIONS $68,733 $9,765 $70,795 $10,413 $72,919 $10,644 4,628 9/30/2015 INSPECTION DEPARTMENT $33,460 $4,754 $34,464 $5,069 $35,498 $5,182 2,253 9/30/2015 PLANNING DEPARTMENT $0 $0 $0 $0 $0 $0 inc. above 9/30/2015 BCC OFFICES $52,634 $7,478 $54,213 $7,974 $55,839 $8,151 3,544 9/30/2015 COUNTY ADMINISTRATOR $20,064 $2,851 $20,666 $3,040 $21,286 $3,107 1,351 9/30/2015 PROPERTY APPRIASER $247,763 $0 $255,196 $0 $262,852 $0 12,381 9/30/2015 TAX COLLECTOR $258,890 $0