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

Other files attached to STATEWIDE RAIL PLAN RFP, newest first.
File Type Posted
Solicitation Document.pdf PDF
Amendment #1.pdf PDF
5400025555_Amend 2.pdf 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
1Complete 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.
2Total Extended Rate/Cost. This field should automatically calcualte.
3If a resouce type is known, but is not currently filled, you may enter TBD into the name fiield ,
4Once Tab A. Bidding Schedule - Price has been completed, you may move to Tab B. Cost Proposal.
5In the Labor column(s) on Tab B, enter the resource name and the extended rate from the information you entered on Tab A.
6For 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.
7Do not attempt to enter a dollar amount for these tasks: They should automatically calculate.
8Once all resouces have been entered and the estimated hours keyed, you may move on to the Direct Expenses fields.
9Enter 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.
10The various totals on the spreadhseet should calcualte automatically. Please double check all of your entries.
11Once all totals are generated, please save your spreadsheet as Price Proposal_Company Name.
12Enter the total from cell

Tab A. Bidding Schedule-Price

South Carolina State Rail Plan-Hourly Rate Sheet
Personnel/ResourceLabor Category/Project RoleBill Rate/Hour (Base)Overhead RateTotal 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

*LaborPublic InputIIJA Content RequirementsOther Planning and Freight Studies IncorporationAnalysis of Statewide Rail NetworkFuture Needs and Trends AnalysisSoutheast Regional Rail/Southeast Corridor CoalitionRail Crossing/Rail CorridorStrtegies for the Creation of Business/Industrial Development OpportunitiesDashboard and Story MapGrand Total
NameExtended RateHoursDollarsHoursDollarsHoursDollarsHoursDollarsHoursDollarsHoursDollarsHoursDollarsHoursDollarsHoursDollarsHoursDollars
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.000$0.00
Labor Subtotal0$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$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/Price0$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.00
*Insert Additional Rows As Needed

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