Pricing Worksheet Revised.xlsx

This is a Pricing Worksheet for the South Carolina Statewide Rail Plan Request for Proposal, prepared for use by bidders responding to the South Carolina contract opportunity. The worksheet consists of two primary tabs designed to capture labor costs and direct expenses associated with project tasks. Tab A requires bidders to enter personnel information including name, labor category/project role, base bill rate per hour, overhead rate, and total extended rate/cost for each resource assigned to the project. Tab B functions as the Cost Proposal section, where bidders allocate labor resources across ten defined project tasks: 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 Strategies for Business/Industrial Development Opportunities, Dashboard and Story Map, and associated categories. For each resource and task combination, bidders must estimate the number of hours to be expended, with dollar amounts calculating automatically based on the extended rates provided in Tab A.

The pricing worksheet accommodates multiple labor resources and includes provisions for direct expense line items such as lodging and other project-related costs. Bidders may add additional lines as needed to capture all anticipated expenses. The spreadsheet is designed with automatic calculation functionality for total extended rates, labor subtotals by task, direct expense subtotals, and grand totals across all tasks and expense categories. Upon completion, bidders must save the spreadsheet using the naming convention "Price Proposal_Company Name" and transfer the total from Tab A's Bidding Schedule-Price to the appropriate summary section. The template currently displays all values at $0.00, indicating it is a blank template ready for completion by prospective contractors.