Cost Prosposal Sheet.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Micro Transit Services
Solicitation number
PE-66249-NONST-2025-000000015
Issued by
Lanier County, Georgia

About this file

This document is a cost proposal spreadsheet for a micro-transit services contract opportunity with the City of Valdosta, Georgia. The contract includes providing administrative and operating expenses for a micro-transit service that will serve Lowndes County. The spreadsheet details the proposed first-year annual costs per revenue hour, including salaries, wages, benefits, taxes, insurances, and other administrative and operating expenses. The proposer must complete the cells highlighted in grey, and the spreadsheet includes formulas to calculate subtotals and the final proposed first-year rate. The contract term is July 1, 2024 to June 30, 2026, with potential service hour increases or decreases of up to 30% during the contract period.

The pricing terms include a breakdown of administrative and operating expenses, as well as a profit margin. The proposal must be submitted in response to the City of Valdosta's Request for Proposals (RFP) for Micro-Transit Services. There is no information provided about any set-asides, incumbents, funding sources, or other salient details in the document.

View the file

Other files

File Type Posted
RFP _ 13_23_24 Micro Transit Service FINAL.docx DOCX document
Addenda 2 RFP 13_23_24.docx DOCX document
NTD Reduce Reporting Form July 2022 _ June 20.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

1 Summary

This summary tab will be auto-generated from formulas and information entered into tab "3 Admin & Oper Cost Proposal"
Summary of CBG-WKU Cost Item/DescriptionCombined (CBG-WKU) Annual Cost Per Revenue Hour
Subtotal Proposed Rate Per Revenue Hour - 1st Year - MCI Applicable$ - 0
Subtotal Proposed Rate Per Revenue Hour - 1st Year - Non MCI Applicable$ - 0
Final Proposed Rate Per Revenue Hour - 1st Yr.*:$ - 0
*Includes all admin, operating, capital, and profit expenses

2 Admin & Driver Salary Detail

Those cells highlighted in grey need to be completed by the proposer. Proposer is resonsible for ensuring accurate values throughout. Proposer must use this sheet and this sheet ONLY for all Cost Proposals
SALARY DETAILS
ADMINISTRATIVE/MANAGEMENT DETAILS (best estimate based on local market)
POSITIONNumber of FTE's Dedicated to CBG/WKU Services*F/T OR P/THIRING SALARY RANGEFULL SALARY RANGE
MANAGEMENT
GENERAL MANAGER1
OPERATIONS MANAGER1
SAFETY MANAGER1
Subtotal Management FTE's3
SUPPORT STAFF
ON-ROAD SUPERVISORdetermined by PROPOSER
DISPATCHERSdetermined by PROPOSER
CUSTOMER SERVICE REP/RESERVATIONISTSdetermined by PROPOSER
SCHEDULER(S)determined by PROPOSER
MAINTENANCE MANAGERdetermined by PROPOSER
MECHANICSdetermined by PROPOSER
Other:determined by PROPOSER
Subtotal Support Staff FTE's
Total Management/Support Staff FTE's
*Allocation of FTE's may change as service expands during the timeframe of this contract. Contract rate will be reevaluated at that time as more resources are obtained to implement necessary additional services
OPERATOR SALARY DETAILS
POSITIONNUMBER OF POSITIONS TO FULFILL CBG/WKU SERVICESF/T or P/THIRING SALARY RANGEFULL SALARY RANGE
CDL-Drivers Full Time
NON-CDL Drivers Full Time
CDL-Drivers Part Time
NON-CDL Drivers Part Time

3 Admin & Oper Cost Proposal

This spreadsheet contains locked formulas for all subtotals and totals highlighted in light blue. Those cells highlighted in grey need to be completed by the proposer. Proposer is responsible for ensuring accurate values throughout. Proposer must use this sheet and this sheet ONLY for all Cost Proposals for City of Valdosta (COV) RFP.
ADMINISTRATIVE EXPENSESPROJECTED 1st YEAR Combined COV Revenue Hours: 29,332
TITLE (some of these may not be applicable)COV FIRST YEAR ANNUAL COSTYour Company's FIRST YEAR ANNUAL COSTCOMBINED ANNUAL COST PER REVENUE HOUR
SALARIES AND WAGES - FULL TIME$ - 0Items highlighted in yellow are items not applicable for annual MCI rate adjustments
SALARIES AND WAGES - OVERTIME$ - 0
SALARIES AND WAGES - PART-TIME (BENEFITS)$ - 0
SAL. AND WAGE-TEMPT/PT-TIME (NO BENEFITS)$ - 0
SOCIAL SECURITY CONTRIBUTION$ - 0
RETIREMENT CONTRIBUTION$ - 0
GENERAL FUND$ - 0
SALES TAXES$ - 0
COUNTY SALES TAXES$ - 0
FEDERAL EXCISE TAXES$ - 0
OTHER TAXES$ - 0
OTHER CONTRA ACCOUNTS$ - 0
MEDICAL INSURANCE CONTRIBUTION$ - 0
DISABILITY INSURANCE CONTRIBUTION$ - 0A revenue rate subtotal of MCI and non MCI adjustments needs to be presented below just above the final proposed 1st year rate total
UNEMPLOYMENT COMPENSATION$ - 0
WORKER'S COMPENSATION$ - 0
FLEXIBLE BENEFIT ADMINISTRATION FEE$ - 0
OTHER (PHYSICALS, BONUS, INS, ETC.):$ - 0
ACCOUNTING$ - 0
LEGAL$ - 0
DRUG & ALCOHOL TESTING CONTRACT$ - 0
DRUG & ALCOHOL TESTING TESTS$ - 0
MEDICAL REVIEW OFFICER$ - 0
OTHER - PROFESSIONAL SERVICES (HOUSEKEEPING):$ - 0
UNIFORMS$ - 0
OFFICE SUPPLIES AND MATERIALS$ - 0
COMPUTER SUPPLIES$ - 0
TRAVEL$ - 0
TRAVEL SUBSISTENCE$ - 0
TELEPHONE SERVICE$ - 0
INTERNET SERVICE PROVIDER FEE$ - 0
COMBINED SERVICE FEE$ - 0
POSTAGE$ - 0
OTHER COMMUNICATIONS:$ - 0
ELECTRICITY (if not in building lease agreement)$ - 0
TRASH COLLECTION$ - 0
PRINTING AND REPRODUCTION$ - 0
OTHER PRINTING AND BINDING:$ - 0
REPAIR & MAIN-OFFICE/COMPUTER EQUIPMENT$ - 0
REPAIRS & MAINTENANCE - COMM EQUIPMENT$ - 0
OTHER REPAIRS & MAINTENANCE:$ - 0
COMPUTER PROGRAMMING SERVICES$ - 0
COMPUTER SUPPORT/TECH ASSISTANCE SVS$ - 0
TEMPORARY HELP$ - 0
CLEANING SERVICES$ - 0
TRAINING - EMPLOYEE EDUCATION EXPENSE$ - 0
SECURITY SERVICES$ - 0
OTHER SERVICES (specify):$ - 0
RENT OF BUILDING/OFFICES$ - 0
OTHER RENTAL:$ - 0
LEASE OF COMPUTER HARDWARE$ - 0
LEASE OF COMPUTER SOFTWARE$ - 0
LEASE OF PRODUCTION EQUIPMENT$ - 0
LEASE OF POSTAL METER$ - 0
LEASE OF COMMUNICATION EQUIPMENT$ - 0
LEASE OF OTHER EQUIPMENT:$ - 0
INSURANCE - PROPERTY & GENERALlIABILITY$ - 0
INSURANCE - FIDELITY$ - 0
INSURANCE - PROFESSIONAL LIABILITIES$ - 0
INSURANCE - SPECIAL LIABILITIES$ - 0
CENTRAL SERVICES - INDIRECT COSTS$ - 0
DUES AND SUBSCRIPTIONS$ - 0
OTHER FIXED CHARGES / CURRENT EXPENSES:$ - 0
DEBT SERVICE CHARGES$ - 0
OTHER:$ - 0
OTHER:$ - 0
OTHER:$ - 0
SUBTOTAL ADMIN NON-MCI APPLICABLE EXPENSES$ - 0$ - 0$ - 0
SUBTOTAL ADMIN MCI APPLICABLE EXPENSES$ - 0$ - 0$ - 0
SUBTOTAL ADMINISTRATIVE EXPENSES$ - 0$ - 0$ - 0Total Admin Cost Per Rev/Hr
OPERATING EXPENSESPROJECTED 1st YEAR Combined COV Revenue Hours: 29,332
TITLE (some of these may not be applicable)COV FIRST YEAR ANNUAL COSTYour Company's FIRST YEAR ANNUAL COSTCOMBINED ANNUAL COST PER REVENUE HOUR
SALARIES AND WAGES - FULL TIME DRIVERS$ - 0
SALARIES AND WAGES - OVERTIME$ - 0
SALARIES AND WAGES - PART TIME (BENEFITS) DRIVERS$ - 0
SAL. AND WAGE TEMP-TEMPT/PT-TIME (NO BENEFITS) DRIVER$ - 0
SOCIAL SECURITY CONTRIBUTION$ - 0
RETIREMENT CONTRIBUTION$ - 0
MEDICAL INSURANCE CONTRIBUTION$ - 0
DISABILITY INSURANCE CONTRIBUTION$ - 0
UNEMPLOYMENT COMPENSATION$ - 0
WORKER'S COMPENSATION$ - 0
FLEXIBLE BENEFIT ADMINISTRATION FEE$ - 0
OTHER (PHYSICALS, BONUS, INS, ETC)$ - 0
ACCOUNTING$ - 0
LEGAL$ - 0
MEDICAL REVIEW OFFICER$ - 0
OTHER PROFESSIONAL SERVICES (HOUSEKEEPING):$ - 0
UNIFORMS$ - 0
FIRST AID SUPPLIES (REPLACEMENT)$ - 0
TIRES AND TUBES$ - 0
ASSOCIATED CAPITAL MAINTENANCE$ - 0
LICENSES, TAGS, & FEES$ - 0
VEHICLE CLEANING SUPPLIES$ - 0
HAND TOOLS$ - 0
OTHER VEHICLE SUPPLIES:$ - 0
OFFICE SUPPLIES AND MATERIALS$ - 0
TRAVEL (STAFF TO STATE ROADEO & CONFERENCE)$ - 0
TRAVEL SUBSISTENCE$ - 0
TELEPHONE SERVICE$ - 0
INTERNET SERVICE PROVIDER FEE$ - 0
COMBINED SERVICE FEE IF APPLICABLE$ - 0
POSTAGE$ - 0
OTHER COMMUNICATIONS:$ - 0
ELECTRICITY (IF NOT IN LEASE AGREEMENT)$ - 0
TRASH COLLECTION$ - 0
PRINTING AND REPRODUCTION$ - 0
OTHER PRINTING AND BINDING:$ - 0
REPAIRS & MAINTENANCE - VEHICLES$ - 0
REPAIRS & MAINTENANCE - SHOP EQUIPMENT$ - 0
REPAIR & MAINT-OFFICE - COMM EQUIP$ - 0
REPAIRS & MAINTENANCE - COMM EQUIP$ - 0
OTHER REPAIRS & MAINTENANCE:$ - 0
COMPUTER PROGRAMMING SERVICES$ - 0
COMPUTER SUPPORT/TECH ASSISTANCE SVS$ - 0
LEGAL ADVERTISING$ - 0
LAUNDRY AND DRY CLEANING$ - 0
TEMPORARY HELP$ - 0
HOUSEKEEPING (IF NOT PROVIDED BY IN-HOUSE STAFF)$ - 0
TRAINING - EMPLOYEE EDUCATION EXPENSE*$ - 0
OTHER SERVICES:$ - 0
RENT OF BUILDING/OFFICES$ - 0
OTHER RENTAL:$ - 0
LEASE OF COMPUTER HARDWARE$ - 0
LEASE OF COMPUTER SOFTWARE$ - 0
LEASE OF REPRODUCTION EQUIPMENT$ - 0
LEASE OF POSTAL METER$ - 0
LEASE OF COMMUNICATION EQUIPMENT$ - 0
LEASE OF OTHER EQUIPMENT$ - 0
MAINTENANCE CONTRACTS - COMM EQUIP$ - 0
MAINTENANCE CONTRACTS - OFFICE EQUIP$ - 0
MAINTENANCE CONTRACTS - REPRO EQUIP$ - 0
MAINTENANCE CONTRACTS - VEHICLES$ - 0
MAINTENANCE CONTRACTS - COMPUTER EQUIP$ - 0
MAINTENANCE CONTRACTS - TIRES$ - 0
OTHER SERVICE & MAINTENANCE CONTRACTS (describe):$ - 0
INSURANCE - PROPERTY & GENERAL LIABILITY$ - 0
INSURANCE - VEHICLES$ - 0
INSURANCE - FIDELITY$ - 0
INSURANCE - PROFESSIONAL LIABILITIES$ - 0
INSURANCE - SPECIAL LIABILITIES$ - 0
CENTRAL SERVICES - INDIRECT COSTS$ - 0
DUES AND SUBSCRIPTIONS$ - 0
OTHER FIXED CHARGES:$ - 0
USER SIDE SUBSIDY$ - 0
DEBT SERVICE CHARGES$ - 0
GENERAL FUND$ - 0
CAPITAL RESERVE FUND$ - 0
SALES TAXES$ - 0
COUNTY SALES TAXES$ - 0
FEDERAL EXCISE TAXES$ - 0
OTHER TAXES:$ - 0
SUBTOTAL OPERATING NON-MCI APPLICABLE EXPENSES$ - 0$ - 0$ - 0
SUBTOTAL OPERATING MCI APPLICABLE EXPENSES$ - 0$ - 0$ - 0
SUBTOTAL OPERATING EXPENSES$ - 0$ - 0$ - 0Total Operating Cost Per Rev/Hr
Enter Percent Profit Below
PROFIT COST & PERCENTAGE$ - 0$ - 0$ - 0

SUBTOTAL ADMIN, OPERATING, AND PROFIT $ - 0 $ - 0 $ - 0 Total Cost Per Rev/Hr

Expense Items Invoiced Separately From Revenue Hour RateDescriptionProjected Year 1 Costs Incl. Taxes
City of ValdostaCOV Facility Expenses - lease, utilities, cleaning, and maintenance
Other
Other

SUBTOTAL EXPENSES $ - 0

4 Sliding Cost Matrix

Sliding Cost Matrix Proposal for Revenue Hr Changes:
Scenario for Revenue Hr. Increases Pending COV Action:Estimated Revenue Hours of Service:Revenue Hour RateTotal Contract Year Costs
For period from July 1, 2024 to June 30, 202629,332 baseline$ - 0$ - 0
10% increase over baseline32,265
20% increase over baseline35,198
30% increase over baseline38,132
Scenario for Revenue Hr. Decreases Pending COV Action:Estimated Revenue Hours of Service:Revenue Hour RateTotal Contract Year Costs
For period from July 1, 2024 to June 30, 202629,332 baseline$ - 0$ - 0
10% decrease over baseline26,399
20% decrease over baseline23,466
30% decrease over baseline20,532

File details come from the government source that posted it. Updated .