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

Other files attached to On-Call Environmental Consulting Services, newest first.
File Type Posted
On-Call_Environmental_Consulting_Services_(Addendum_#1_Revision).pdf PDF
26-011-RFP_Pre-Proposal_Meeting_Sign-In_Sheets.pdf PDF
26-011-RFP_Pre-Proposal_Meeting_Agenda.pdf PDF
On-Call_Environmental_Consulting_Services.pdf PDF
26-011-RFP_On-Call_Enviro_Consulting_-_Ad.pdf PDF
26-011-RFP_On-Call_Enviro_Consulting_-_Ad.pdf PDF
KCAB_-_RSVP_Instructional_Guide_for_OpenGov.pdf PDF
KCAB_-_RSVP_Instructional_Guide_for_OpenGov.pdf PDF
26-011-RFP_Environmental_Consulting_Svcs_-_Sample_MA_-_Attachment_D.pdf PDF
26-011-RFP_Environmental_Consulting_Svcs_-_Sample_MA_-_Attachment_D.pdf PDF
26-011-RFP_Consultant_Firm_Staff-hour_Estimate_-_Attachment_C.xlsx XLSX spreadsheet
26-011-RFP_Consultant_Reimbursable_Expenses_Worksheet_-_Attachment_B.xlsx XLSX spreadsheet
26-011-RFP_Sample_Project_Scope_-_Attachment_A.pdf PDF
26-011-RFP_Consultant_Firm_Staff-hour_Estimate_-_Attachment_C.xlsx XLSX spreadsheet
26-011-RFP_Consultant_Reimbursable_Expenses_Worksheet_-_Attachment_B.xlsx XLSX spreadsheet
26-011-RFP_Sample_Project_Scope_-_Attachment_A.pdf PDF
Consultant_Reimbursable_Expenses_Worksheet.xlsx XLSX spreadsheet
Consultant_Firm_Staff-hour_Estimate.xlsx XLSX spreadsheet
Example_Project_Scope.docx DOCX document
Example_Project_Scope.docx DOCX document
Consultant_Firm_Staff-hour_Estimate.xlsx XLSX spreadsheet
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
ClassificationHoursRateCostTotal 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 Total0.00$ - 0
II. Salary & General Overhead
Salary Related Expense$ -
General and Administrative Overhead$ -

Salary & General Overhead Total $ -

III. Other Direct Costs
QuantityRateCost
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
ClassificationHoursRateCostTotal Billable Rate
Employee Classification #1115.00$ 91.23$ 10,491.45$ 264.61
Employee Classification #2550.00$ 74.52$ 40,986.00$ 216.14
Employee Classification #3640.00$ 62.13$ 39,763.20$ 180.21
Employee Classification #4215.00$ 48.79$ 10,489.85$ 141.51
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Direct Labor Total1520.00$ 101,730.50
II. Salary & General Overhead
Salary Related Expense43.21%$ 43,958
General and Administrative Overhead115.76%$ 117,763

Salary & General Overhead Total $ 161,721

III. Other Direct Costs
QuantityRateCost
Local Travel 51 cents per mile [20] trips at [36] miles roundtrip720$ 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 service1$ 300.00$ 300.00
Photography/videos1$ 100.00$ 100.00
Reproduction expenses1$ 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 .