Consultant_Reimbursable_Expenses_Worksheet.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- On-Call Environmental Consulting Services State and local contract opportunity
- Solicitation number
- 26-011-RFP
- Issued by
- Kenton County, Kentucky
About this file
Consultant Reimbursable Expenses Worksheet
This is a consultant reimbursable expenses worksheet template and example developed for the Kenton County Airport Board's On-Call Environmental Consulting Services procurement. The template is designed to calculate total project costs for environmental consulting firms responding to the proxy project scope—an Industrial Waste Management Audit of Cincinnati/Northern Kentucky International Airport. The worksheet captures labor costs across four employee classifications (Senior Consultant, Project Manager, Staff Scientist, and GIS/CADD Technician), salary and general overhead allocations, other direct costs including travel and materials, and a fixed fee calculated as a percentage of direct labor and overhead. The provided example demonstrates a completed cost proposal with direct labor totaling $101,730.50 across 1,520 hours, salary-related expenses of $43,958 (43.21%), general administrative overhead of $117,763 (115.76%), other direct costs of $2,333.60 covering local travel, equipment, supplies, and miscellaneous expenses, a fixed fee of $31,614.18 (12% of labor and overhead), and a total project fee of $297,399.25.
The worksheet establishes specific reimbursable expense parameters aligned with KCAB's policy: local travel at 58.5 cents per mile, airfare with 14-day advance purchase requirements, computer equipment and supplies only if required, office supplies specific to job performance, express mail and postage, photography and videos, reproduction expenses, electronic data systems support, communications services, and parking at the client site. All reimbursable expenses must be itemized with quantities, rates, and calculations. The billable rate formula incorporates the base hourly rate plus percentages for salary-related expenses, general and administrative overhead, and a fixed fee markup to determine the total billable rate for each employee classification. This standardized cost structure ensures transparent pricing evaluation during Phase 2 of KCAB's competitive selection process, where proposed rates and fees account for 20 points of the total evaluation score.
View the file
Other files for this state and local contract opportunity
Show all 21
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Template
| Firm Name: | ||||
| Date: | ||||
| I. Labor Cost | ||||
| Classification | Hours | Rate | Cost | Total Billable Rate (See Calculation Below) |
| Employee Classification #1 | $ - 0 | |||
| Employee Classification #2 | $ - 0 | |||
| Employee Classification #3 | $ - 0 | |||
| Employee Classification #4 | $ - 0 | |||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| Direct Labor Total | 0.00 | $ - 0 |
| II. Salary & General Overhead | |
| Salary Related Expense | $ - |
| General and Administrative Overhead | $ - |
Salary & General Overhead Total $ -
| III. Other Direct Costs | |||
| Quantity | Rate | Cost | |
| Local Travel 58.5 cents per mile [X] trips at [X] miles roundtrip | $ - 0 | ||
| Airfare - 14-day advance purchase (minimum) | $ - 0 | ||
| Computer equipment, maintenance, and supplies (if required) | $ - 0 | ||
| Office supplies on site, specific to job performance (if required) | $ - 0 | ||
| Express mail, postage, messenger service | $ - 0 | ||
| Photography/videos | $ - 0 | ||
| Reproduction expenses | $ - 0 | ||
| Electronic data systems support (if required) | $ - 0 | ||
| Communications services (if required) | $ - 0 | ||
| Parking at client site (If required) | $ - 0 |
Reimbursables Total $ - 0
IV. Fixed Fee: 15% of I + II $ - 0
| Total Fee | $ - 0 | |
| Calculation: | ||
| Billable Rate Formula = Rate+(Rate*Salary%)+(Rate*General and | ||
| Admin Overhead %)+(Rate+Salary+overhead)*Fixed Fee% = Billable Rate |
Example with Figures
| Firm Name: | Rate+(Rate*Salary%)+(Rate*General and Admin Overhead %)+(Rate+Salary+overhead)*Fixed Fee% = Billable Rate | ||||
| Date: | |||||
| I. Labor Cost | |||||
| Classification | Hours | Rate | Cost | Total Billable Rate | |
| Employee Classification #1 | 115.00 | $ 91.23 | $ 10,491.45 | $ 264.61 | |
| Employee Classification #2 | 550.00 | $ 74.52 | $ 40,986.00 | $ 216.14 | |
| Employee Classification #3 | 640.00 | $ 62.13 | $ 39,763.20 | $ 180.21 | |
| Employee Classification #4 | 215.00 | $ 48.79 | $ 10,489.85 | $ 141.51 | |
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| $ - 0 | |||||
| Direct Labor Total | 1520.00 | $ 101,730.50 |
| II. Salary & General Overhead | ||
| Salary Related Expense | 43.21% | $ 43,958 |
| General and Administrative Overhead | 115.76% | $ 117,763 |
Salary & General Overhead Total $ 161,721
| III. Other Direct Costs | |||
| Quantity | Rate | Cost | |
| Local Travel 51 cents per mile [20] trips at [36] miles roundtrip | 720 | $ 0.51 | $ 363.60 |
| Airfare - 14-day advance purchase (minimum) | $ - 0 | ||
| Computer equipment, maintenance, and supplies (if required) | 1 | $ 250.00 | $ 250.00 |
| Office supplies on site, specific to job performance (if required) | 1 | $ 200.00 | $ 200.00 |
| Express mail, postage, messenger service | 1 | $ 300.00 | $ 300.00 |
| Photography/videos | 1 | $ 100.00 | $ 100.00 |
| Reproduction expenses | 1 | $ 1,000.00 | $ 1,000.00 |
| Electronic data systems support (if required) | $ - 0 | ||
| Communications services (if required) | $ - 0 | ||
| Parking at client site (If required) | 15 | $ 8.00 | $ 120.00 |
Reimbursables Total $ 2,333.60
IV. Fixed Fee: 12% of I + II $ 31,614.18
Total Fee $ 297,399.25
File details come from the government source that posted it. Updated .