Okaloosa County BOCC — February 26, 2015 — Agenda Packet — reading text

Total $ 7.65% * - - 2020 hours are allowable, reasonable and Total Personnel Expenses (A+B) - Y Y Y necessary to accomplish tasks 1,3,4 2. Supplies Description Unit Cost $ Quantity Totals $ Fixtures and bulbs * = 0 * = 0 * = 0 Total Supplies - Y Y Y 3. Equipment Description Unit Cost $ Quantity Totals $ * = 0 * = 0 * = 0 Total Equipment 0 4. Travel Per Fare/ Purpose/Destination Days Diem $ Rate $ Mileage Totals $ [ * ] + [ * ] = $ - [ * ] + [ * ] = 0 [ * ] + [ * ] = 0 Total Travel 0 Packet Pg. 44  1.d.a COMMENTS Allowable Reasonable Necessary (Basis for Decision) 5. Contractual Name or Services Fee/Rate $ Hours Totals $ Attachment: I.d. FWC Turtle Lighting Grant (3886 : FWC/FDEP Turtle Friendly Lighting Retrofit Grant (Jim Night time surveys * = 0 Bulbs and fixtures $ 118,320.00 * 1 = $ 118,320.00 * = 0 Total Contractual $ 118,320.00 Y Y Y 6. Miscellaneous Description Unit Cost $ Quantity Totals $ * = 0 * = 0 * = 0 * = 0 * = 0 Total Miscellaneous 0 SUBTOTAL (1 thru 6) 118,320 7. Overhead/Indirect - Base: _____________________________ Rate % Base $ Total $ 0.00% * 0 = 0 8. Total Budget $ 118,320 Y Y Y CERTIFICATION I cetify that the cost for each line item budget category has been evaluated and determined to be allowable, reasonable, and necessary as required by Section 216.3475, Florida Statutes. Documentation is attached evidencing the methodology used and the conclusions reached. Name:________________________________ Signature:____________________________________________________________ Date:___________________________________________________________________________ X Software required, please download from http://www.arx.com Packet Pg. 45  1.d.a X Software required, please download BUDGET INSTRUCTIONS Attachment: I.d. FWC Turtle Lighting Grant (3886 : FWC/FDEP Turtle Friendly Lighting Retrofit Grant (Jim from http://www.arx.com A detailed budget is required for DEP fixed price contracts; however, this form shall also be used for determining the maximum amount needed under cost-reimbursement and fee-schedule contracts and to complete the required cost analysis for non-competitively awarded contracts over the Category II threshold. For fixed price contracts, this budget form is intended to provide the minimum information needed for budget approval. The DEP reserves the right to require additional information when necessary for approval of the fixed price, and also to require that any part of the project be compensated on a cost-reimbursement basis. Attach a separate sheet to provide an explanation of travel, equipment (especially computers), subcontracts, and other supporting information, and when needed for extra space (use same format and show totals on this form). This form should list the total fixed price to be funded by DEP, or the total project budget when the DEP is to pay a percentage of the project total. Breakdowns by task or phase, or other division of work, should be shown on the separate attachment. The use of this particular form is not a requirement for the budget, however any other budget form or format used should provide, at a minimum, the same information and level of detail. This form is requried for completion of the cost analysis. 1 PERSONNEL - A. Salaries - Identify the persons to be compensated for work on this project by name (if known), position, and title. Show the hourly cost and total hours to be charged for each person or position. If more space is needed, use a separate sheet to list individual positions and salaries, and show here the total hours for each title or position. Divide annual salaries by 2080 hours, and nine month academic salaries by 1560 hours, to find the hourly rate. B. Fringe Benefits - Multiply the rate by the total salaries to which fringe benefits apply. If the rate is variable, explain and show calculations on an attachment. 2 SUPPLIES - List expendable supplies by category description, unit costs and quantity. 3 EQUIPMENT - List non-expendable personal property/equipment valued at $1,000 or more by description, unit cost, and quantity. Computers and data-processing equipment should be described in detail in an attached explanation. 4 TRAVEL - List trips by their purpose and/or destination. Unless travel details are included in the Scope of Services, a separate narrative should be attached. Indicate the number of days for each trip and the per diem. Keep in mind the DEP can only pay for travel at the approved State rate (Section 112.061, Florida Statutes). Use "Fare/Rate" for mileage rate and multiply by "Mileage", or for travel fare and leave "Mileage" blank. 5 CONTRACTUAL - Subcontractors should provide the same information required by this budget form, with the following exceptions: (a) when professional services are provided at a pre-existing approved rate or fee shown on the budget; or (b) the subcontract is to be obtained competitively. For either (a) or (b), show an estimated maximum amount and provide an attached explanation as to how it was determined. Contractual services other than fixed price will be compensated by the DEP on a cost-reimbursement basis. 6 MISCELLANEOUS - List expenses not included in any of the above categories. Examples would be printing, copying, postage, communications, etc. Non-expendable equipment valued at less than $1,000 may be listed also. Include only expenses directly related to the project, not expenses of a general nature. 7 OVERHEAD/INDIRECT - Indicate the approved overhead/indirect cost rate, the dollar amount of the base to which it is applied, and the resulting total. Identify the base (cost categories) to which the rate is applied on the line indicated. 8 TOTAL BUDGET - Show the total of categories 1 through 7. COST ANALYSIS INSTRUCTIONS A cost analysis must be completed for any