Att_2_Cost_Worksheet_30611_FTS.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
Fleet Tracking System (DGS/OTA)
Solicitation number
0000030611
Issued by
California

About this file

The provided document is a Cost Worksheet related to a Fleet Tracking System contract opportunity issued by the California Department of General Services (DGS). The contract is for a 5-year term, with the initial year running from the date of DGS approval through May 30, 2025, and subsequent years running annually from May 31 to May 30. The scope of work includes project management, system design, configuration, reporting, data migration, and integration with various other systems. The pricing is structured with separate line items for each year, with the first year priced at a total of $0 and the remaining years priced for the cloud-based software subscription and support.

The related state and local contract opportunity details the release of Addendum #1, which incorporates a Q&A set, changes the bid due date from April 25, 2024, to May 2, 2024, and revises Attachment 1 Exhibit E Requirements. The contract opportunity is for a Fleet Tracking System, and all other requirements, terms, and conditions remain the same. The event is being managed by the California DGS, with Robb Parkinson and Tomasa Lovato as the primary and backup contacts, respectively.

View the file

Other files

File Type Posted
RFQ_30611.docx DOCX document
Att_1_Exhibit_A_-_Fleet_Tracking_System_(FTS)_-_SOW.docx DOCX document
Att_1_Exhibit_D_-__(DED)_and_(DAD)_.docx DOCX document
APP_Cover_Page.doc DOC document
Rev._A_-_Att_1_Exhibit_E_Requirements.xlsx XLSX spreadsheet
Att_1_Exhibit_B_-Budget_Detail.docx DOCX document
Att_1_Exhibit_C_-_Evaluation_Plan.docx DOCX document
Att_1_Exhibit_E_Requirements__30611.xlsx XLSX spreadsheet
Att_3_Narrative_Response.docx DOCX document
Att_4_Work_Auth_form_CDFW.docx DOCX document
QA_Set1.docx DOCX document
RFQ_30611_Addendum_1.docx DOCX document
Show all 12

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

Cost Worksheet Key

PRICING WORKSHEET KEY
COST WORKSHEET TEMPLATE

(Rev 8/30/2022)

Column NameContract Line Item Number (CLIN)
Unit of MeasureManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Proposed Product DescriptionContract Unit Price
DescriptionUnique line item number.Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).Identifies manufacturer's unique identifier for a particular line item.Identifies the manufacturer's name for each line item.Identifies supplier's unique identifier for a particular line item.Informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the specifications (high-level).This is the contractual price for a given line item based on the price that was bid, as relative to the

unit of measure.

END OF SHEET.
END OF SHEET.

Cost Worksheet

Department of General Services - Procurement Division
BU 3600 Event ID 0000030611, Fleet Tracking System
Attachment 2 - Cost Worksheet
Bidder:Blank
Instructions: Refer to Cost language for completion instructions. Bidder must complete the Yellow Input Cells only.
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product DescriptionUnit CostExtension Cost
1-11EachProject Management - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Project Planning = $ Project Management = $$ - 0
1-21EachFleet Tracking System Design - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Detailed Solution Requirements and Outcomes= $ Solution Design Document= $$ - 0
1-31EachFleet Tracking System Configuration - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Onboard Fleet Assets= $ Manage Fleet Assets = $ Manage Funding of Fleet Assets= $ Manage Telematics Devices=$ Manage Fleet Cards= $$ - 0
1-41EachFleet Tracking System Reports - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Monthly Fuel Transactions Validation Report= $ Monthly Fuel Transactions Report= $ Fleet Assets and Fleet Cards Miscellaneous Reports= $$ - 0
1-51EachData Migration from Legacy VTS to Fleet Tracking System - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Prepare for Data Migration= $ Upload VTS Data into Fleet Tracking System= $$ - 0
1-61EachFleet Tracking System Integrations with Other Systems - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Integration with WEX= $ Integration with Geotab= $ Integration with Active Directory= $ Integration with DocuSign= $ Integration with HRMS= $ Integration with CDFW Repositories of FI$Cal Financial Codes= $ Integration with Cherwell (Ivanti) Platform= $$ - 0
1-71EachPre-Production Testing - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025Component Testing= $ Integration Testing= $ User Acceptance Testing= $$ - 0
1-81EachProduction Readiness and Deployment - FY23/24 - Year 1 - Term: Upon DGS Approval Through 5/30/2025User Training= $ Final Data Import Prior to Go-Live= $ Identify and Correct Production Issues= $ Post-implementation Support= $$ - 0
1-91EachCloud Based Software Subscription and Support - FY23/24 - Year 1 - Term: up to twelve (12) months as needed Upon DGS Approval Through 5/30/2025$ - 0
Total Year 1 Cost:$ - 0
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product DescriptionUnit CostExtension Cost
2-11EachCloud Based Software Subscription and Support -FY24/25 - Year 2 - Term: 5/31/2025 - 5/30/2026$ - 0
Total Year 2 Cost:$ - 0
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product DescriptionUnit CostExtension Cost
3-11EachCloud Based Software Subscription and Support -FY25/26 - Year 3 - Term: 5/31/2026 - 5/30/2027$ - 0
Total Year 3 Cost:$ - 0
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product DescriptionUnit CostExtension Cost
4-11EachCloud Based Software Subscription and Support -FY27/28 - Year 4 - Term: 5/15/2027 - 5/14/2028$ - 0
4-11EachCloud Based Software Subscription and Support -FY26/27 - Year 4 - Term: 5/31/2027 - 5/30/2028$ - 0
Total Year 4 Cost:$ - 0
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product DescriptionUnit CostExtension Cost
5-11EachCloud Based Software Subscription and Support -FY27/28 - Year 5 - Term: 5/31/2028 - 5/30/2029$ - 0
Total Year 5 Cost:Unit and Extended Cost must include both shipping and handling costs.$ - 0
Total Cost (Year 1+Year 2+Year 3+Year 4+Year 5):$ - 0

Page &P

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