Pricing Worksheet.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- STATEWIDE RAIL PLAN RFP State and local contract opportunity
- Solicitation number
- 5400025555
- Issued by
- Richland County, South Carolina
About this file
This is a pricing worksheet for the South Carolina Statewide Rail Plan Update RFP, a planning project managed by the State of South Carolina. The document serves as the cost proposal template that bidders must complete to submit pricing for the contract. The worksheet is designed to capture labor costs associated with multiple project tasks including public input processes, IIJA content requirements, planning and freight studies incorporation, analysis of the statewide rail network, future needs and trends analysis, Southeast regional rail coordination, rail crossing and corridor strategies, business and industrial development opportunities, and dashboard and story map development. Bidders are required to populate the pricing template with personnel information, hourly billing rates, overhead rates, estimated hours by task, and direct expenses to develop a comprehensive cost proposal.
The pricing worksheet operates on an automated calculation system where bidders enter resource names, labor categories, base hourly bill rates, and overhead rates on Tab A, which automatically generates total extended rates. On Tab B, bidders allocate estimated hours for each named resource across the identified project tasks, with dollar amounts calculating automatically based on the rates entered in Tab A. Bidders may also add direct expense line items such as lodging or other project-related costs. The completed spreadsheet must be saved as "Price Proposal_Company Name" and submitted with the total from Tab A. The structure allows for flexible resource allocation across ten distinct project work categories and accommodates additional personnel and expense line items as needed by the bidding firm.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Solicitation Document.pdf | ||
| Amendment #1.pdf | ||
| 5400025555_Amend 2.pdf | ||
| Pricing Worksheet Revised.xlsx | XLSX spreadsheet |
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
INSTRUCTIONS
| INSTRUCTIONS FOR COMPLETING THE PRICING SPREADSHEET | |
| 1 | Complete the items on the Tab A. Bidding Schedule-Price by entering the name, role, Base bill rate, and overhead rate for each resource who will be assigned to the project. |
| 2 | Total Extended Rate/Cost. This field should automatically calcualte. |
| 3 | If a resouce type is known, but is not currently filled, you may enter TBD into the name fiield , |
| 4 | Once Tab A. Bidding Schedule - Price has been completed, you may move to Tab B. Cost Proposal. |
| 5 | In the Labor column(s) on Tab B, enter the resource name and the extended rate from the information you entered on Tab A. |
| 6 | For that each resource entered, you should estimate the number of hours that will be spent on the tasks identified (Line 5) of Tab B. You may add lines to the spreadhseet as needed. |
| 7 | Do not attempt to enter a dollar amount for these tasks: They should automatically calculate. |
| 8 | Once all resouces have been entered and the estimated hours keyed, you may move on to the Direct Expenses fields. |
| 9 | Enter the direct expense description (item name -such as 'Lodging') and estimate the total direct expense cost per task. You may add lines to the spreadsheet as needed. |
| 10 | The various totals on the spreadhseet should calcualte automatically. Please double check all of your entries. |
| 11 | Once all totals are generated, please save your spreadsheet as Price Proposal_Company Name. |
| 12 | Enter the total from cell |
Tab A. Bidding Schedule-Price
| South Carolina State Rail Plan-Hourly Rate Sheet | ||||
| Personnel/Resource | Labor Category/Project Role | Bill Rate/Hour (Base) | Overhead Rate | Total Extended Rate/Cost |
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 | ||||
| $ - 0 |
Tab B. Cost Proposal South Carolina Statewide Rail Plan Update-Cost Proposal
| *Labor | Public Input | IIJA Content Requirements | Other Planning and Freight Studies Incorporation | Analysis of Statewide Rail Network | Future Needs and Trends Analysis | Southeast Regional Rail/Southeast Corridor Coalition | Rail Crossing/Rail Corridor | Strtegies for the Creation of Business/Industrial Development Opportunities | Dashboard and Story Map | Grand Total | |||||||||||
| Name | Extended Rate | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars | Hours | Dollars |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0 | $0.00 | |||||||||||
| Labor Subtotal | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |
| *Direct Expenses | |||||||||||||||||||||
| (Item Name) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| (Item Name) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| (Item Name) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| (Item Name) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Direct Expenses Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total Hours/Price | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| *Insert Additional Rows As Needed |
File details come from the government source that posted it. Updated .