Loading...
HomeMy WebLinkAboutKeolis_SLO_Price Sheets_FINAL_HOLDNOTICE: This workbook is provided as an example and template for PROPOSERS to use when generating price PROPOSALS in response to the CITY's solicitation for Transit Operation and Maintenance Services. The workbook includes formulas and links, and is not password protected. PROPOSERS should take care to ensure that all formulas and links are correct when PROPOSALS are submitted. Price PROPOSALS must be submitted in un-protected executable Excel format with all appropriate formulas and links, to enable complete cost analysis. Password protected price PROPOSALS may be considered non-responsive. Cost Proposal Forms Instructions: 1. Complete Base Cost Proposal Form and the Alternate Cost Proposal Form for all base years. Include all costs associated with fixed and variables required for service delivery. 2. Complete the Base Position Headcount Form and the Alternate Position Headcount Form worksheet for all base years. Indicate the proposed number of staff planned for each position for each year. 3. Complete the Start-up & Transition Costs worksheet. Include all one-time transition and project start-up related costs. Name of Proposing Firm: Authorized Representative Signature: Authorized Representative Title: Date: Budget Elements Year One Year Two Year Three Year Four 7/1/2026-6/30/2027 7/1/2027-6/30/2028 7/1/2028-6/30/2029 7/1/2029-6/30/2030 Administrative Expenses General Management Position Wages 166,750.00$ 171,419.00$ 176,218.73$ 181,152.86$ General Management Position Benefits 47,867.26$ 50,047.98$ 52,374.10$ 54,858.16$ Operations Management Position Wages 327,065.68$ 345,199.54$ 359,740.13$ 372,107.37$ Operations Management Position Benefits 124,728.98$ 133,548.14$ 142,371.47$ 150,998.73$ Other Administrative Position(s) Wages 80,000.00$ 82,240.00$ 84,542.72$ 86,909.92$ Other Administrative Position(s) Benefits 30,163.57$ 31,771.89$ 33,502.30$ 35,365.96$ -$ -$ -$ -$ Facility Utilities and Expenses 61,901.88$ 63,635.11$ 65,416.86$ 67,366.90$ Payroll/IT Services 153,090.50$ 157,719.52$ 162,272.31$ 169,103.87$ Travel 5,000.00$ 5,000.00$ 5,000.00$ 5,000.00$ -$ -$ -$ -$ Non-Revenue Vehicles 48,464.01$ 48,867.20$ 49,069.81$ 49,609.02$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ Office Supplies 6,084.00$ 6,254.35$ 6,429.47$ 6,609.50$ Other Licenses, Permits, Taxes 4,597.23$ 4,782.69$ 4,959.87$ 5,166.27$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 1,055,713.12$ 1,100,485.42$ 1,141,897.78$ 1,184,248.56$ Insurance Materials and Supplies -$ -$ -$ -$ Telecommunications -$ -$ -$ -$ Vehicle Liability Insurance 256,196.39$ 280,712.66$ 307,242.70$ 343,054.18$ General Liability Insurance 39,180.31$ 41,077.71$ 43,017.15$ 45,158.18$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 295,376.71$ 321,790.37$ 350,259.86$ 388,212.36$ Operating Expenses Safety and Training Management Position Wages 100,000.00$ 102,800.00$ 105,678.40$ 108,637.40$ Safety and Training Management Position Benefits 35,436.62$ 37,263.17$ 39,224.87$ 41,333.92$ Bus Operation Position(s) Wages 1,720,700.09$ 1,845,895.30$ 1,973,834.23$ 2,110,658.13$ Bus Operation Position(s) Benefits 752,255.45$ 816,016.16$ 880,234.88$ 971,523.58$ Road Supervision Position(s) Wages 192,095.42$ 205,520.35$ 215,374.78$ 223,434.82$ Road Supervision Position(s) Benefits 111,962.44$ 120,518.23$ 128,832.09$ 136,332.95$ Employee Recruitment and Screening 11,862.17$ 12,187.30$ 12,487.50$ 13,314.61$ Materials and Supplies 18,002.19$ 18,124.71$ 18,201.35$ 18,461.44$ Uniforms 16,150.22$ 16,596.83$ 17,055.94$ 17,968.54$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ Softwares ( 18,404.63$ 18,583.96$ 18,768.31$ 18,957.82$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 2,976,869.23$ 3,193,506.00$ 3,409,692.36$ 3,660,623.19$ 2/19/2026 BASE COST PROPOSAL FORM The below budget breakdown and the other attached materials represent an offer to do work as described in this Proposal. It is understood that this offer shall remain in effect for ninety (90) days from the date set for opening proposals unless withdrawn pursuant to the conditions of the subject RFP. Keolis Transit Services, LLC Chief Operating Officer Maintenance Expenses Maintenance Management Position Wages 120,000.00$ 123,360.00$ 126,814.08$ 130,364.87$ Maintenance Management Position Benefits 40,036.98$ 41,995.05$ 44,092.11$ 46,340.48$ Mechanic/Technician Position(s) Wages 171,355.80$ 176,834.50$ 180,386.27$ 185,437.08$ Mechanic/Technician Position(s) Benefits 61,472.87$ 64,789.00$ 68,146.16$ 71,905.46$ Other Maintenance Staff Position(s) Wages 102,368.40$ 105,641.39$ 107,763.22$ 110,780.59$ Other Maintenance Staff Position(s) Benefits 45,977.47$ 48,823.85$ 51,780.53$ 55,071.80$ Maintenance Parts and Supplies 203,017.84$ 231,853.64$ 251,826.30$ 275,771.43$ Cleaning Supplies 26,104.30$ 28,105.26$ 28,948.41$ 30,492.04$ Lubricants and Fluids 16,611.83$ 17,885.16$ 18,421.72$ 19,404.02$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ Softwares ( 8,998.24$ 9,250.19$ 9,509.19$ 9,775.45$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 795,943.71$ 848,538.04$ 887,687.99$ 935,343.23$ Other Expenses Start-up and Tranisition Costs (Linked to S&T Costs Sheet)115,842.33$ Corporate Overhead and Support 228,226.30$ 243,357.42$ 257,813.71$ 274,654.32$ Management Fee 228,226.30$ 243,357.42$ 257,813.71$ 274,654.32$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ -$ -$ -$ -$ Recruiting & Marketing 14,112.00$ 14,339.14$ 14,572.63$ 14,812.67$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 586,406.92$ 501,053.99$ 530,200.06$ 564,121.31$ Grand Total 5,710,309.69$ 5,965,373.82$ 6,319,738.04$ 6,732,548.65$ Operating and Maintenance Expense 3,772,812.94$ 4,042,044.04$ 4,297,380.34$ 4,595,966.42$ Revenue Vehicle Insurance Expense 295,376.71$ 321,790.37$ 350,259.86$ 388,212.36$ Monthly Fee (Fixed Costs)203,171.98$ 204,173.12$ 213,315.49$ 223,642.76$ Projected Vehicle Service Hours 39,608.8 39,608.8 39,608.8 40,505.7 Vehicle Service Hourly Rate (Variable Costs)75.16$ 80.63$ 86.08$ 90.37$ Total Hourly Rate (Total Costs) 144.17$ 150.61$ 159.55$ 166.21$ Name of Proposing Firm: Authorized Representative Signature: Authorized Representative Title: Date: Budget Elements Year One Year Two Year Three Year Four 7/1/2026-6/30/2027 7/1/2027-6/30/2028 7/1/2028-6/30/2029 7/1/2029-6/30/2030 Administrative Expenses General Management Position Wages 166,750.00$ 171,419.00$ 176,218.73$ 181,152.86$ General Management Position Benefits 47,867.26$ 50,047.98$ 52,374.10$ 54,858.16$ Operations Management Position Wages 327,065.68$ 345,199.54$ 359,740.13$ 372,107.37$ Operations Management Position Benefits 124,728.98$ 133,548.14$ 142,371.47$ 150,998.73$ Other Administrative Position(s) Wages 80,000.00$ 82,240.00$ 84,542.72$ 86,909.92$ Other Administrative Position(s) Benefits 30,163.57$ 31,771.89$ 33,502.30$ 35,365.96$ -$ -$ -$ -$ Facility Utilities and Expenses 64,058.22$ 65,851.82$ 67,695.64$ 69,836.07$ Payroll/IT Services 185,141.90$ 190,936.50$ 198,608.27$ 207,030.12$ Travel 5,000.00$ 5,000.00$ 5,000.00$ 5,000.00$ -$ -$ -$ -$ Non-Revenue Vehicles 50,620.34$ 51,083.91$ 51,348.59$ 52,078.19$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ Office Supplies 6,084.00$ 6,254.35$ 6,429.47$ 6,609.50$ Other Licenses, Permits, Taxes 5,491.16$ 5,740.26$ 5,996.79$ 6,299.52$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 1,092,971.12$ 1,139,093.40$ 1,183,828.22$ 1,228,246.40$ Insurance Materials and Supplies -$ -$ -$ -$ Telecommunications -$ -$ -$ -$ Vehicle Liability Insurance 365,508.37$ 400,551.12$ 438,801.17$ 494,502.71$ General Liability Insurance 42,551.28$ 44,797.16$ 47,165.46$ 49,827.84$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 408,059.65$ 445,348.28$ 485,966.63$ 544,330.55$ Operating Expenses Safety and Training Management Position Wages 100,000.00$ 102,800.00$ 105,678.40$ 108,637.40$ Safety and Training Management Position Benefits 35,436.62$ 37,263.17$ 39,224.87$ 41,333.92$ Bus Operation Position(s) Wages 2,389,851.40$ 2,556,115.48$ 2,737,073.87$ 2,955,219.14$ Bus Operation Position(s) Benefits 1,033,849.37$ 1,120,248.22$ 1,232,982.51$ 1,354,872.82$ Road Supervision Position(s) Wages 256,127.23$ 274,027.13$ 287,166.37$ 297,913.09$ Road Supervision Position(s) Benefits 149,283.25$ 160,690.97$ 171,776.12$ 181,777.26$ Employee Recruitment and Screening 17,202.16$ 17,327.19$ 18,186.85$ 19,069.15$ Materials and Supplies 19,387.57$ 19,523.79$ 19,764.01$ 20,060.36$ Uniforms 24,473.76$ 25,150.63$ 26,275.07$ 27,443.01$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ Softwares ( 18,404.63$ 18,583.96$ 18,768.31$ 18,957.82$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 4,044,015.99$ 4,331,730.53$ 4,656,896.38$ 5,025,283.99$ 2/19/2026 ALTERNATE COST PROPOSAL FORM The below budget breakdown and the other attached materials represent an offer to do work as described in this Proposal. It is understood that this offer shall remain in effect for ninety (90) days from the date set for opening proposals unless withdrawn pursuant to the conditions of the subject RFP. Keolis Transit Services, LLC Chief Operating Officer Maintenance Expenses Maintenance Management Position Wages 120,000.00$ 123,360.00$ 126,814.08$ 130,364.87$ Maintenance Management Position Benefits 40,036.98$ 41,995.05$ 44,092.11$ 46,340.48$ Mechanic/Technician Position(s) Wages 336,035.40$ 346,779.35$ 353,744.49$ 363,649.34$ Mechanic/Technician Position(s) Benefits 121,446.18$ 128,032.99$ 134,708.55$ 142,181.85$ Other Maintenance Staff Position(s) Wages 153,552.60$ 158,462.09$ 161,644.84$ 166,170.89$ Other Maintenance Staff Position(s) Benefits 68,966.20$ 73,235.78$ 77,670.80$ 82,607.70$ Maintenance Parts and Supplies 306,283.23$ 355,409.97$ 386,532.67$ 433,624.12$ Cleaning Supplies 37,800.38$ 40,697.87$ 41,918.81$ 44,573.46$ Lubricants and Fluids 24,054.79$ 25,898.65$ 26,675.60$ 28,364.93$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ Softwares ( 8,998.24$ 9,250.19$ 9,509.19$ 9,775.45$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 1,217,174.00$ 1,303,121.92$ 1,363,311.15$ 1,447,653.10$ Other Expenses Start-up and Tranisition Costs (Linked to S&T Costs Sheet)177,283.92$ Corporate Overhead and Support 302,998.50$ 323,446.34$ 344,504.13$ 369,354.14$ Management Fee 302,998.50$ 323,446.34$ 344,504.13$ 369,354.14$ -$ -$ -$ -$ Other (specify below):-$ -$ -$ -$ -$ -$ -$ -$ Professional Services 14,112.00$ 14,339.14$ 14,572.63$ 14,812.67$ -$ -$ -$ -$ -$ -$ -$ -$ Subtotal 797,392.91$ 661,231.81$ 703,580.90$ 753,520.95$ Grand Total 7,559,613.67$ 7,880,525.94$ 8,393,583.27$ 8,999,034.99$ Operating and Maintenance Expense 5,261,189.99$ 5,634,852.45$ 6,020,207.53$ 6,472,937.09$ Revenue Vehicle Insurance Expense 408,059.65$ 445,348.28$ 485,966.63$ 544,330.55$ Monthly Fee (Fixed Costs)258,961.50$ 258,620.59$ 270,893.36$ 285,785.04$ Projected Vehicle Service Hours 57,355.5 57,355.5 57,355.5 59,211.4 Vehicle Service Hourly Rate (Variable Costs)70.51$ 75.52$ 81.19$ 84.87$ Total Hourly Rate (Total Costs) 131.80$ 137.40$ 146.34$ 151.98$ Base Year One Base Year Two Base Year Three Base Year Four 7/1/2026-6/30/2027 7/1/2027-6/30/2028 7/1/2028-6/30/2029 7/1/2029-6/30/2030 Management General Management 1 1 1 1 Operations Management 1 1 1 1 Maintenance Management 1 1 1 1 Safety and Training Management 1 1 1 1 Other (Specify below): HR Generalist 1 1 1 1 Subtotal 5 5 5 5 Non-Management Bus Operations (Full-time)25 25 25 26 Bus Operations (Part-time) Road Supervision 3 3 3 3 Dispatching 3 3 3 3 Other Administrative Position(s) Mechanic/Technician Position(s)2 2 2 2 Other (Specify below): Utility Workers 2 2 2 2 Subtotal 35 35 35 36 Grand Total 40 40 40 41 BASE POSITION HEADCOUNT FORM Base Year One Base Year Two Base Year Three Base Year Four 7/1/2026-6/30/2027 7/1/2027-6/30/2028 7/1/2028-6/30/2029 7/1/2029-6/30/2030 Management General Management 1 1 1 1 Operations Management 1 1 1 1 Maintenance Management 1 1 1 1 Safety and Training Management 1 1 1 1 Other (Specify below): HR Generalist 1 1 1 1 Subtotal 5 5 5 5 Non-Management Bus Operations (Full-time)35 35 36 37 Bus Operations (Part-time) Road Supervision 4 4 4 4 Dispatching 3 3 3 3 Other Administrative Position(s) Mechanic/Technician Position(s)4 4 4 4 Other (Specify below): Utility Workers 3 3 3 3 Subtotal 49 49 50 51 Grand Total 54 54 55 56 ALTERNATE POSITION HEADCOUNT FORM Item Units $ Each Total Labor 1.0 43,252.01$ 43,252.01$ Equipment 1.0 5,850.79$ 5,850.79$ Hiring Costs 1.0 24,615.13$ 24,615.13$ Software 1.0 10,965.63$ 10,965.63$ Training 1.0 31,158.78$ 31,158.78$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 115,842.33$ Start-up & Transition Costs Total Item Units $ Each Total Labor 1.0 54,017.49$ 54,017.49$ Equipment 1.0 8,922.86$ 8,922.86$ Hiring Costs 1.0 32,602.44$ 32,602.44$ Software 1.0 10,965.63$ 10,965.63$ Training 1.0 70,775.50$ 70,775.50$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 177,283.92$ Start-up & Transition Costs Total