2-LRTP RFP PriceTemplate.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
LRTP 2027-2055 Consultant Services
Solicitation number
25-04018JM
Issued by
Utah

About this file

This is a price proposal template spreadsheet for the Utah Transit Authority (UTA) Long Range Transit Plan consultant services project. The template is designed to facilitate cost estimation and project budgeting for consultant support services related to the UTA Moves 2055 Long Range Transit Plan development. The project is scheduled to commence on May 1, 2022, and conclude on December 31, 2023, representing approximately 82 weeks of work. The spreadsheet accommodates up to ten personnel categories with customizable job titles and allows for detailed task-based labor hour scheduling across the project duration.

The pricing structure employs a base rate multiplier of 3.00 to account for overhead and profit, with an additional 1.15 multiplier applied to other direct costs. Personnel rates serve as the foundation for cost estimation, with each category assigned a base rate and corresponding labor charge rate. The template includes provisions for contingency calculations, task-specific cost tracking, and aggregation of direct labor costs, direct charges, and total fees. Bidders are instructed to update only specified blue-highlighted fields with their firm name, owner information, personnel titles, base rates, and labor charge rates to generate comprehensive cost reports for proposal submission.

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

Header

PROJECT MANAGEMENT MODULE HEADER INFORMATION
(Update or change only those items shown in blue on the screen.)FIRMFirm Name
Owner:UTAESTIMATED PERSONNEL RATES:
Personnel CategoryNameBase RateLabor Charge
Project:UTA Long Rang Transit Plan
1Titlename$0.00$0.00
Description:Consultant Support2Titlename$0.00$0.00
3Titlename$0.00$0.00
4Titlename$0.00$0.00
5Titlename$0.00$0.00
6Titlename$0.00$0.00
Project Mgr.:UTA7Titlename$0.00$0.00
8Titlename$0.00$0.00
Start Date:05/01/22[Change as needed]9Titlename$0.00$0.00
4468210Titlename$0.00$0.00
Base Rate Multiplier (OH and profit):3.00[Change as needed]
Other Direct Costs Multiplier:1.15[Change as needed]Note: Personnel rates are the price proposal and used for cost estimation.
Time Period:WeeksFeel free to revise titles as desired.
If more than 10 titles are needed then additional adjustment is required on the Cost Report
Date File Setup:01-May-22
Date (Now):
Time (Now):
Filename:See footer
Beginning Month:5
Beginning Year:2022
End Date:12/31/23
45291

Filename: &F

Task Cost Report

TASK COST REPORT HEADER INFORMATION
(Update or change only those items shown in blue on the screen.)Firm:Firm Name
Owner:UTAESTIMATED PERSONNEL RATES:
Level & Personnel CategoryBase RateLabor Charge
Project:UTA Long Rang Transit Plan
1Title0.00$0.00
Description:Consultant Support2Title0.00$0.00
0.003Title0.00$0.00
0.004Title0.00$0.00
0.005Title0.00$0.00
6Title0.00$0.00
Project Mgr.:UTA7Title0.00$0.00
8Title0.00$0.00
Start Date:44682.009Title0.00$0.00
44682.0010Title0.00$0.00
Base Rate Multiplier:3.00
Other Direct Costs Multiplier:1.15Note: Personnel rates are estimates used for cost estimation.
Time Period:Weeks
Date File Setup:44682.00
Date (Now):11-Mar-22
Time (Now):02:55 PM
Filename:See footer
(Note : Your filename will print out at the lower left corner of the forms.)
TASK COST REPORTFirm NamePersonnel:
Owner:UTA1name6name
Project:UTA Long Rang Transit Plan2name7name
Description:Consultant Support0.003name8name
0.000.004name9name
Project Mgr:UTA5name10name
Start Date:01-May-22
TASKSScheduleLabor Hours By Personnel CategoryOtherOther
WeeksTotalDirectLaborDirectTotal
NoTask Activity12345678910HoursCostsChargesChargesFee
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
0.000000000000$0$0$0$0
Total0.000000000000$0$0$0$0
Contigencyinput as decimal multiplier0.00$0
Total$ - 0

Filename: &F &P of &N UTA Capital Development

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