140R3026R0003_Attachment_13_Excel_Price_Schedule_Template.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Parking & Ticketing Services at Hoover Dam
- Solicitation number
- 140R3026R0003
About this file
This is an Excel pricing template for solicitation 140R3026R0003 for Parking & Ticketing Services at Hoover Dam. The template is designed for offerors to submit pricing for six separate contract line item numbers (CLINs) covering a base year plus five option years, with a total contract period of 5.5 years (base year of 12 months plus four 12-month option years and one 6-month final option year). The pricing structure requires offerors to provide unit prices for four main service categories: On-Site and Reserved Ticket Sales Operations, Parking Operations/Traffic Management/Fee Collection Point Operations, Financial Management, and Parking Guidance System Operation & Maintenance. Each schedule lists the performance period as 12 months except the final option year (CLIN 0060), which is 6 months.
The template includes a Price Schedule Summary worksheet that automatically calculates grand totals for each schedule and provides an aggregate total across all six schedules. Offerors must complete only the yellow-highlighted cells containing unit prices; all other cells contain formulas and must not be modified. The template provides a structured format to ensure consistent pricing submissions across all contract periods and service categories, with all totals currently showing $0 pending offeror input.
View the file
Other files
Show all 20
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
Grand Totals
| Price Schedule Summary |
| Solicitation: |
| 140R3026R0003 |
| Offeror: |
| offeror type name here |
| Grand Total for Schedule 1 - Base Year | $0 |
| Grand Total for Schedule 2 - Option Year 1 | $0 |
| Grand Total for Schedule 3 - Option Year 2 | $0 |
| Grand Total for Schedule 4 - Option Year 3 | $0 |
| Grand Total for Schedule 5 - Option Year 4 | $0 |
| Grand Total for Schedule 6 – 52.217-8 Option to Extend | $0 |
| Total for All Six Schedules | $0 |
Instructions
| 1) Cells that require inputs are highlighted in yellow |
| 2) All cells that are highlighted in yellow must be completed |
| 3) Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells. |
| 4) The required inputs are used to auto calculate the Price Schedule Summary on the "summary" Worksheet. |
| 5) Do not make any changes or modifications to this attachment except for those cells highlighted in yellow |
&"-,Bold"Attachment 13
Sch. 1 Base Year CLIN 0010 Schedule for Parking & Ticketing Services at Hoover Dam
| (Performance Period to be completed at time of award) |
| Schedule 1 – Base Year - CLIN 00010 |
| Item No. | Section of PWS | Description | Quantity | Unit | Unit Price | Amount |
| 1-1 | 6.1 | On-Site and Reserved Ticket Sales Operations | 12 | Months | $ - 0 | $ - 0 |
| 1-2 | 6.2.1 | Parking Operations, Traffic Management and Fee Collection Point Operations | 12 | Months | $ - 0 | $ - 0 |
| 1-3 | 6.5 | Financial Management | 12 | Months | $ - 0 | $ - 0 |
| 1-4 | 6.3 | Parking Guidance System (Operation & Maintenance) | 12 | Months | $ - 0 | $ - 0 |
| 1-5 | 9.2 | Transition Period Preparation | 1 | Lump Sum | $ - 0 | $ - 0 |
| TOTAL FOR PRICE SCHEDULE | $ - 0 |
Sch. 2 Option Year 1 CLIN 0020 Schedule for Parking & Ticketing Services at Hoover Dam
| (Performance Period to be completed at time of award) | ||||||
| Schedule 2 – Option Year 1 - CLIN 00020 | ||||||
| Item No. | Section of PWS | Description | Quantity | Unit | Unit Price | Amount |
| 2-1 | 6.1 | On-Site and Reserved Ticket Sales Operations | 12 | Months | $ - 0 | $ - 0 |
| 2-2 | 6.2.1 | Parking Operations, Traffic Management and Fee Collection Point Operations | 12 | Months | $ - 0 | $ - 0 |
| 2-3 | 6.5 | Financial Management | 12 | Months | $ - 0 | $ - 0 |
| 2-4 | 6.3 | Parking Guidance System (Operation & Maintenance) | 12 | Months | $ - 0 | $ - 0 |
| TOTAL FOR PRICE SCHEDULE | $ - 0 |
Sch. 3 Option Year 2 CLIN 0030 Schedule for Parking & Ticketing Services at Hoover Dam
| (Performance Period to be completed at time of award) | ||||||
| Schedule 3 – Option Year 2 - CLIN 00030 | ||||||
| Item No. | Section of PWS | Description | Quantity | Unit | Unit Price | Amount |
| 3-1 | 6.1 | On-Site and Reserved Ticket Sales Operations | 12 | Months | $ - 0 | $ - 0 |
| 3-2 | 6.2.1 | Parking Operations, Traffic Management and Fee Collection Point Operations | 12 | Months | $ - 0 | $ - 0 |
| 3-3 | 6.5 | Financial Management | 12 | Months | $ - 0 | $ - 0 |
| 3-4 | 6.3 | Parking Guidance System (Operation & Maintenance) | 12 | Months | $ - 0 | $ - 0 |
| TOTAL FOR PRICE SCHEDULE | $ - 0 |
Sch. 4 Option Year 3 CLIN 0040 Schedule for Parking & Ticketing Services at Hoover Dam
| (Performance Period to be completed at time of award) | ||||||
| Schedule 4 – Option Year 3 - CLIN 00040 | ||||||
| Item No. | Section of PWS | Description | Quantity | Unit | Unit Price | Amount |
| 4-1 | 6.1 | On-Site and Reserved Ticket Sales Operations | 12 | Months | $ - 0 | $ - 0 |
| 4-2 | 6.2.1 | Parking Operations, Traffic Management and Fee Collection Point Operations | 12 | Months | $ - 0 | $ - 0 |
| 4-3 | 6.5 | Financial Management | 12 | Months | $ - 0 | $ - 0 |
| 4-4 | 6.3 | Parking Guidance System (Operation & Maintenance) | 12 | Months | $ - 0 | $ - 0 |
| TOTAL FOR PRICE SCHEDULE | $ - 0 |
Sch. 5 Option Year 4 CLIN 0050 Schedule for Parking & Ticketing Services at Hoover Dam
| (Performance Period to be completed at time of award) | ||||||
| Schedule 5 – Option Year 4 - CLIN 00050 | ||||||
| Item No. | Section of PWS | Description | Quantity | Unit | Unit Price | Amount |
| 5-1 | 6.1 | On-Site and Reserved Ticket Sales Operations | 12 | Months | $ - 0 | $ - 0 |
| 5-2 | 6.2.1 | Parking Operations, Traffic Management and Fee Collection Point Operations | 12 | Months | $ - 0 | $ - 0 |
| 5-3 | 6.5 | Financial Management | 12 | Months | $ - 0 | $ - 0 |
| 5-4 | 6.3 | Parking Guidance System (Operation & Maintenance) | 12 | Months | $ - 0 | $ - 0 |
| TOTAL FOR PRICE SCHEDULE | $ - 0 |
Sch. 6 Option Year 5 CLIN 0060 Schedule for Parking & Ticketing Services at Hoover Dam
| (Performance Period to be completed at time of award) | ||||||
| Schedule 6 – Option Year 5 - CLIN 00060 | ||||||
| Item No. | Section of PWS | Description | Quantity | Unit | Unit Price | Amount |
| 6-1 | 6.1 | On-Site and Reserved Ticket Sales Operations | 6 | Months | $ - 0 | $ - 0 |
| 6-2 | 6.2.1 | Parking Operations, Traffic Management and Fee Collection Point Operations | 6 | Months | $ - 0 | $ - 0 |
| 6-3 | 6.5 | Financial Management | 6 | Months | $ - 0 | $ - 0 |
| 6-4 | 6.3 | Parking Guidance System (Operation & Maintenance) | 6 | Months | $ - 0 | $ - 0 |
| TOTAL FOR PRICE SCHEDULE | $ - 0 |
File details come from the government source that posted it. Updated .