ESBD_360084_1716312048984_ATTACHMENT E - Bid Worksheet.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Custodial Services
- Solicitation number
- 809-24-0011
- Issued by
- Texas
About this file
This document is a bid worksheet for a custodial services contract opportunity issued by the Texas State Preservation Board (SPB). The SPB is seeking proposals from qualified vendors to provide custodial services at multiple state facilities, including the Texas Capitol, Capitol Extension, Capitol Visitors Center, Bullock Texas State History Museum, and various state office buildings. The bid worksheet provides an example format for submitting pricing information, including details on staffing levels, labor costs, equipment, and other direct and indirect costs. Respondents are instructed to submit a separate bid worksheet for each of the 9 properties and scopes listed in a separate attachment.
The contract will be awarded on a per-square-foot basis for night cleaning services, with an additional price for day porter services. Pricing information requested includes hourly labor rates, burden percentages, general and administrative costs, and equipment costs. Respondents must also provide a list of equipment to be used on the contract. The contract term is not specified, but the worksheet assumes a 24-month equipment depreciation period.
View the file
Other files
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
Sheet1
| Bid Worksheet - For Example Purposes Only | |
| Submit a separate bid worksheet for each of the 9 properties and each scope listed in Attachment D - Compensation and Fees. This bid worksheet is included as an example only of the type of information required. Respondents should use their own format and include the same information shown on the example sheet. | Building Name: |
| Building Square Footage (Full): |
Input your data in the shaded cells. All other cells are calculated.
Be sure to complete the List of Supplied Equipment at the bottom of the page.
Example Contractor
Building Square Footage (Full): 120,000 SF SF
| What will your staffing level be on a square | |||
| footage per hour basis (w/o supervision)? | 4,000 | SF per Hour | SF per Hour |
| How many cleaner hours per night will be used? | 30.0 | Hours | Hours |
| (SF / SF per Hour = Cleaner Hours per Night) |
| How many night supervisor hours per night | |||
| will be utilized? | 4.5 | Hours | Hours |
| How many floor care hours will be utilized | |||
| per night on average? | 2.0 | Hours | Hours |
| How many hours per day will be devoted to the | |||
| account by senior management / ownership? | 1.0 | Hours | Hours |
| (i.e. scheduling, inspections, site visits, ?, etc) |
| What is your firm's total cost for all labor-related | |
| taxes and insurance (burden) on a percentage basis? | 18.0% |
| (i.e.: FICA, FUTA, General Liability, Workman's Comp, etc) |
| What is your average pay rate for cleaners in the | |
| geographical area for this building? | $7.50 |
| (Note: Please use long-term average, not starting rate) |
| What is your pay rate for supervisors in this | |
| geographical area? | $10.00 |
What is your pay rate for floor technicians? $8.75
| What is your firm's overall general & administrative | |
| costs as a percent of revenue? | 15% |
| G&A = all non-direct costs | |
| (i.e. sales, admin, executive, and human resources salaries; rent; utilities; taxes; insurance; association fees; etc.) |
| Nightly Costs | Hours | Pay Rate | Pay Rate | Total Labor Cost per | |
| (Example) | with Burden* | Night with Burden | |||
| Cleaners | 30.0 | $7.25 | $8.56 | $256.80 | |
| Supervisors | 4.5 | $10.00 | $11.80 | $53.10 | |
| Floor Staff | 2.0 | $8.75 | $10.33 | $20.66 | |
| Senior Management per Night | 1.0 | $30.00 | $35.40 | $35.40 | |
| Total | $365.96 |
| Nightly Costs | Hours | Pay Rate | Pay Rate | Total Labor Cost per | |
| (Contractor) | with Burden* | Night with Burden | |||
| Cleaners | $0.00 | $ - 0 | ERROR:#VALUE! | ||
| Supervisors | 0.0 | $0.00 | $ - 0 | $ - 0 | |
| Floor Staff | 0.0 | $0.00 | $ - 0 | $ - 0 | |
| Senior Management per Night | 0.0 | $ - 0 | $ - 0 | ||
| Total Nightly hours | Total | ERROR:#VALUE! |
Bid Calculations Example Contractor
| Monthly Labor Cost | ||
| ($239.36 x 21.67 days = ____________) | $7,930.35 | ERROR:#VALUE! |
| Monthly Non-Consumable Supplies Costs | |
| (Cleaner, dust cloths, vacuum bags, etc.) | $150.00 |
Uniform Costs $25.00
Monthly Equipment Lease or Depreciation Cost $582.04 $0.00
Total Direct Cost $8,687.39 ERROR:#VALUE!
G&A Cost Allocation (for this period)** $1,303.11 ERROR:#VALUE!
Total Cost with G&A $9,990.50 ERROR:#VALUE!
Profit $561.00
TOTAL Night Cleaning $10,551.50 ERROR:#VALUE!
Price per Square Foot - Night Cleaning $0.0879 ERROR:#VALUE!
Day Porter(s) Total Monthly Price $2,400.00
Day & Night Cleaning Total $12,951.50 ERROR:#VALUE!
| *Pay rate with Burden = Pay rate x (1 + burden as percentage) |
| (i.e. If the burden is 18% and rate is $7.50, then total with burden is $7.50 x 1.18 = $8.85) |
| ** Use firm costs as a percentage x direct costs |
| (i.e. If firm costs are 15% then $8,875.71 x .15 = G&A allocation is $1,331.36) |
LIST OF SUPPLIED EQUIPMENT 0
List the number of pieces and cost of the equipment to be used in this building. Also record the interest rate for equipment financing in the appropriate cell. A monthly equipment cost is automatically calculated and inputted in the Bid Worksheet (assumes 24 month equipment depreciation).
| Type of Equipment | Number | Unit Cost | Cost |
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| $0.00 | |||
| Total Cost | $0.00 | ||
| Equipment Cost | $ - 0 | ||
| Loan Term (months) | 24 | ||
| Interest Rate | 0% | ||
| Monthly Allocation | $0.00 |
File details come from the government source that posted it. Updated .